using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using AdminDAL.DTO.AdvanceRights;
using AdminDAL.DTO.BIZTransactionType;
using AdminDAL.Query.AdvanceRights;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.QueryExecutor;

namespace AdminDAL.CustomCode.AdvanceRights
{
    public class AdvanceRightsDAL : IAdvanceRightsDAL
    {
        private readonly IQueryExecutor _queryExecutor;

        public AdvanceRightsDAL(IQueryExecutor queryExecutor)
        {
            _queryExecutor = queryExecutor;
        }
        public async Task<bool> DeleteAdvanceRights(int BIZTransactionClassId, LoginDTO LoginDTO)
        {
            try
            {
                string Sql; 
                Sql = "DELETE FROM MADVANCERIGHTS WHERE BIZTRANSACTIONID in(SELECT BIZTRANSACTIONID  FROM MBIZTRANSACTION where BIZTRANSACTIONSUBCLASSID in(SELECT BIZTRANSACTIONSUBCLASSID FROM MBIZTRANSACTIONSUBCLASS WHERE BIZTRANSACTIONCLASSID ='" + BIZTransactionClassId + "'))";
                await _queryExecutor.ExecuteAsync(LoginDTO, Sql);
                return true;
            }
            catch (Exception)
            {
                throw;
            } 
        }

        //public List<AdvanceRightsDTO> GetAdvanceRights(int BIZTransactionClassId, int UserId, LoginDTO LoginDTO)
        //{ 
        //    try
        //    { 
        //        List<AdvanceRightsDTO> AdvanceRightsDTOs = new List<AdvanceRightsDTO>();
        //        string Sql = " ";
        //        Sql = AdvanceRightsQB.GET_BIZTRANSACTION;
        //        String[] paramNames = { "bizclassid" };
        //        Object[] values = { BIZTransactionClassId };
        //        Sql = CommonFunctionFrameDAL.ChangedByNamedParam(Sql, paramNames, values);
        //        IList<BIZTransactionPicklistDTO> BIZTransactionPicklistDTOs = GenericLazy.ExceuteSelectQuery<BIZTransactionPicklistDTO>(Sql, LoginDTO, -1, -1);
        //        if (BIZTransactionPicklistDTOs.Count > 0)
        //        {
        //            for (int r = 0; r < BIZTransactionPicklistDTOs.Count; r++)
        //            {
        //                string Hql = " ";
        //                Hql = AdvanceRightsQB.GET_ADVANCERIGHTS;
        //                String[] paramName = { "biztransactionid", "userid" };
        //                Object[] value = { BIZTransactionPicklistDTOs[r].Id, UserId };
        //                Hql = CommonFunctionFrameDAL.ChangedByNamedParam(Hql, paramName, value);
        //                Hql = Hql + " and advancerights.OU.Id=" + LoginDTO.WorkOUId;
        //                IList<Unisoft.AdminDAL.Poco.AdvanceRights> AdvanceRightss = GenericLazy.GetGenericCriteriaLoadQuery<Unisoft.AdminDAL.Poco.AdvanceRights>(Hql, LoginDTO, -1, -1);

        //                if (AdvanceRightss.Count > 0)
        //                {
        //                    for (int j = 0; j < AdvanceRightss.Count; j++)
        //                    {
        //                        AdvanceRightsDTO AdvanceRightsDTO = new AdvanceRightsDTO();
        //                        AdvanceRightsDTO = CommonFunctionFrameDAL.GenericConversionPocoToDTo<AdvanceRightsDTO>(AdvanceRightss[j]);
        //                        AdvanceRightsDTOs.Add(AdvanceRightsDTO);
        //                    }
        //                }
        //                else
        //                {
        //                    AdvanceRightsDTO AdvanceRightsDTO = new AdvanceRightsDTO();
        //                    AdvanceRightsDTO.BIZTransactionId = BIZTransactionPicklistDTOs[r].Id;
        //                    AdvanceRightsDTO.BIZTransactionCode = BIZTransactionPicklistDTOs[r].Code;
        //                    AdvanceRightsDTO.BIZTransactionName = BIZTransactionPicklistDTOs[r].Name;
        //                    AdvanceRightsDTOs.Add(AdvanceRightsDTO);
        //                }
        //            }

        //        }
        //        return AdvanceRightsDTOs;
        //    }
        //    catch (Exception)
        //    {
        //        throw;
        //    }
        //}

        public async Task<IEnumerable<AdvanceRightsDTO>> GetAdvanceUserRights(int MenuId, int BizTransactionClassId, int BIZTransactionTypeId, LoginDTO LoginDTO)
        {
            try
            {
                string Sql = AdvanceRightsQB.GET_ADVANCE_USER_RIGHTS;
                var parameter = new
                {
                    ouid = LoginDTO.WorkOUId,
                    userid = LoginDTO.UserId,
                    menuid = MenuId,
                    biztransactionclassid = BizTransactionClassId,
                    biztransactiontypeid = BIZTransactionTypeId
                }; 
                IEnumerable<AdvanceRightsDTO> AdvanceRightsDTOs = await _queryExecutor.QueryAsync<AdvanceRightsDTO>(LoginDTO,Sql,parameter);
                return AdvanceRightsDTOs;
            }
            catch (Exception)
            {
                throw;
            }
        }


        //public List<Unisoft.FrameworkDAL.DTO.City.CityPicklistDTO> GetOUCity(int OuId, LoginDTO LoginDTO)
        //{
        //    IGenericLazyLoadingFrameDAL GenericLazy = null;
        //    ICommonFunctionFrameDAL CommonFunctionFrameDAL = new CommonFunctionFrameDAL();
        //    try
        //    {

        //        GenericLazy = new GenericNhibernateLazyLoadingFrameDAL(LoginDTO, false, true);
        //        string Hql = " ";
        //        Hql = AdvanceRightsQueryBuilder.GET_LOGIN_OU_CITY;
        //        String[] paramNames = { "ouid" };
        //        Object[] values = { OuId };
        //        Hql = CommonFunctionFrameDAL.ChangedByNamedParam(Hql, paramNames, values);
        //        List<Unisoft.FrameworkDAL.DTO.City.CityPicklistDTO> CityPicklistDTOs = (List<Unisoft.FrameworkDAL.DTO.City.CityPicklistDTO>)GenericLazy.ExceuteSelectQuery<Unisoft.FrameworkDAL.DTO.City.CityPicklistDTO>(Hql, LoginDTO, -1, -1);
        //        GenericLazy.CloseConnection();

        //        return CityPicklistDTOs;
        //    }
        //    catch (Exception Error)
        //    {
        //        if (GenericLazy != null)
        //        {
        //            GenericLazy.CloseConnection();
        //        }
        //        throw Error;
        //    }
        //    finally
        //    {
        //        GenericLazy = null;
        //        CommonFunctionFrameDAL = null;
        //    }
        //}
    }
}