using Ropin.Inspection.Model.Entities;
using Ropin.Inspection.Model.ViewModel;
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 TispContentGroupItemRepository : RepositoryBase<TISP_ContentGroupItem, Guid>, ITispContentGroupItemRepository
    {
        public TispContentGroupItemRepository(InspectionDbContext dbContext) : base(dbContext)
        {

        }
        public Task<IEnumerable<TispContentGroupItemViewModel>> GetContentGroupItemByGroupIdAsync(Guid groupId)
        {
            MySqlConnector.MySqlParameter[] parameters = new[] { new MySqlConnector.MySqlParameter("groupId", groupId) };
            string sql = "SELECT A.*,B.C_Name AS C_GroupName,C.C_Name AS C_ContentName from TISP_ContentGroupItem A LEFT JOIN TISP_ContentGroup B ON B.G_ID = A.G_ContentGroupCode LEFT JOIN TISP_Content C ON C.C_ID = A.G_ContentCode WHERE A.G_ContentGroupCode = @groupId";
            IEnumerable<TispContentGroupItemViewModel> itemlist = EntityFrameworkCoreExtensions.GetList<TispContentGroupItemViewModel>(DbContext.Database, sql, parameters);
            return Task.FromResult(itemlist);
        }

        public Task<int> DeleteByGroupIdAsync(Guid groupId)
        {
            MySqlConnector.MySqlParameter[] parameters = new[] { new MySqlConnector.MySqlParameter("groupId", groupId) };
            int result = EntityFrameworkCoreExtensions.ExecuteSqlNoQuery(DbContext.Database, "DELETE from TISP_ContentGroupItem WHERE G_ContentGroupCode = @groupId", parameters);
            return Task.FromResult(result);
        }
    }
}