using Ropin.Inspection.Model.Entities; using Ropin.Inspection.Repository.Interface; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace Ropin.Inspection.Repository { public class TispRecordImageRepository : RepositoryBase, ITispRecordImageRepository { public TispRecordImageRepository(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 TISP_RecordImage WHERE C_RecordItemCode = @Id", parameters); return Task.FromResult(result); } } }