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<TMTN_DevOpsRecordApp, string>, ITmtnDevOpsRecordAppRepository
    {
        public TmtnDevOpsRecordAppRepository(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 TMTN_DevOpsRecordApp WHERE C_DevOpsRecordCode = @Id", parameters);
            return Task.FromResult(result);
        }
        
    }
}