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 TdevDevSpotRepository : RepositoryBase<TDEV_DevSpot, Guid>, ITdevDevSpotRepository
    {
        public TdevDevSpotRepository(InspectionDbContext DbContext) : base(DbContext)
        {

        }
        public Task<int> DeleteByDevIdAsync(string devId)
        {
            MySqlConnector.MySqlParameter[] parameters = new[] { new MySqlConnector.MySqlParameter("devId", devId) };
            int result = EntityFrameworkCoreExtensions.ExecuteSqlNoQuery(DbContext.Database, "DELETE from TDEV_DevSpot WHERE C_DevStoreCode = @devId", parameters);
            return Task.FromResult(result);
        }

    }
}