using Ropin.Inspection.Model; using Ropin.Inspection.Model.Entities; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace Ropin.Inspection.Repository { public class TmtnDevOpsRecordAppRepository : RepositoryBase, ITmtnDevOpsRecordAppRepository { public TmtnDevOpsRecordAppRepository(InspectionDbContext dbContext) : base(dbContext) { } public Task DeleteByRecordItemIdAsync(Guid recordItemId) { MySqlConnector.MySqlParameter[] parameters = new[] { new MySqlConnector.MySqlParameter("Id", recordItemId) }; int result = EntityFrameworkCoreExtensions.ExecuteSqlNoQuery(DbContext.Database, "DELETE from TMTN_DevOpsRecordApp WHERE C_DevOpsRecordCode = @Id", parameters); return Task.FromResult(result); } } }