using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using FrameworkDAL.DTO.RoleVsMenu;
using FrameworkDAL.Query.RoleVsMenu;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.QueryExecutor;

namespace FrameworkDAL.CustomCode.RoleVsMenu
{
    public class RoleVsMenuDAL : IRoleVsMenuDAL
    {
        private readonly IQueryExecutor _queryExecutor;

        public RoleVsMenuDAL(IQueryExecutor queryExecutor)
        {
            _queryExecutor = queryExecutor;
        }
        public async Task<string> DeleteRoleVsMenu(int RoleId, int ModuleId, LoginDTO LoginDTO)
        {
            try
            {
                string ssql = "DELETE FROM MROLEVSMENU WHERE ROLEID='" + RoleId + "' AND MENUID IN(SELECT DISTINCT MENUID FROM MMODULEVSMENU WHERE MODULEID='" + ModuleId + "' )";
                return ssql;
            }
            catch (Exception)
            {
                throw;
            }
        }

        public async Task<string> DeleteRoleVsMenuForRole(int RoleId, LoginDTO LoginDTO)
        {
            try
            {
                string ssql = "DELETE FROM MROLEVSMENU WHERE ROLEID='" + RoleId + "'";
                return ssql;
            }
            catch (Exception)
            {
                throw;
            }
        }

        public async Task<string> DeleteRoleVsMenuForMenu(int RoleId, int MenuId, LoginDTO LoginDTO)
        {
            try
            {
                string ssql = "DELETE FROM MROLEVSMENU WHERE ROLEID=" + RoleId + " AND MENUID = " + MenuId;
                return ssql;
            }
            catch (Exception)
            {
                throw;
            }
        }

        public async Task<List<RoleVsMenuDTO>> GetExistingForModule(int RoleId, int ModuleId, LoginDTO LoginDTO)
        {
            var result = await _queryExecutor.QueryAsync<RoleVsMenuDTO>(
                LoginDTO, RoleVsMenuQB.GET_EXISTING_ROLEVSMENU_FOR_MODULE, new { RoleId, ModuleId });
            return result.ToList();
        }

        public async Task<List<RoleVsMenuDTO>> GetExistingForMenuIds(int RoleId, IEnumerable<int> MenuIds, LoginDTO LoginDTO)
        {
            var ids = MenuIds.ToList();
            if (ids.Count == 0)
                return new List<RoleVsMenuDTO>();

            var result = await _queryExecutor.QueryAsync<RoleVsMenuDTO>(
                LoginDTO, RoleVsMenuQB.GET_EXISTING_ROLEVSMENU_FOR_MENUIDS, new { RoleId, MenuIds = ids });
            return result.ToList();
        }

        public async Task<int> SaveRoleVsMenu(IEnumerable<RoleVsMenuDTO>RoleVsMenuDTOs , LoginDTO LoginDTO)
        {
            try
            {
                string Sql = RoleVsMenuQB.SAVE_ROLEVSMENU;
                return await _queryExecutor.BulkInsertAsync(LoginDTO, Sql, RoleVsMenuDTOs);

            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <summary>
        /// GetRoleVsMenu
        /// </summary>
        /// <param name="RoleId"></param>
        /// <param name="ModuleId"></param>
        /// <param name="LoginDTO"></param>
        /// <returns></returns>
        public async Task<List<RoleVsMenuDTO>> GetRoleVsMenu(int RoleId, int ModuleId, LoginDTO LoginDTO)
        {  
            try
            { 
                string Sql = "";
                Sql = RoleVsMenuQB.GET_ROLE_VS_MENU;

                var parameter = new
                {
                    roleid = RoleId,
                    moduleid = ModuleId
                };

                List<RoleVsMenuDTO> RoleVsMenuDTOs = (await _queryExecutor.QueryAsync<RoleVsMenuDTO>(LoginDTO, Sql, parameter)).ToList();

                List<RoleVsMenuDTO> MenusRoleVsMenuDTOs = new List<RoleVsMenuDTO>();
                {
                    string SqlMenufromrole1 = "";
                    SqlMenufromrole1 = RoleVsMenuQB.GET_MENU_FROM_MODULEMENU;
                    if (RoleId == -1799999978 && LoginDTO.DatabaseName.ToLower() == "uscdevsys")
                    {
                    }
                    else
                    {
                        SqlMenufromrole1 = SqlMenufromrole1 + " and menuset.ClientId=" + LoginDTO.ClientId;

                    } 
                    var parameters = new
                    {
                        roleid = RoleId,
                        moduleid = ModuleId
                    };
                    MenusRoleVsMenuDTOs = (await _queryExecutor.QueryAsync<RoleVsMenuDTO>(LoginDTO, SqlMenufromrole1, parameters)).ToList();

                }
                for (int j = 0; j < MenusRoleVsMenuDTOs.Count; j++)
                {
                    MenusRoleVsMenuDTOs[j].RoleVsMenuAllow = "222222";
                    RoleVsMenuDTOs.Add(MenusRoleVsMenuDTOs[j]);
                }
                //GenericLazy.Commit();
                return RoleVsMenuDTOs;
            }
            catch (Exception)
            {
                throw;
            }
        }
    }
}