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<TISP_RecordImage, Guid>, ITispRecordImageRepository
    {
        public TispRecordImageRepository(InspectionDbContext dbContext) : base(dbContext)
        {

        }
        public Task<int> 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);

        }
    }
}