using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Collections.Generic;
using nmsADO;
using nmsLogin;
using nmsSetup;

namespace nmsLogin
{
    public class clsDLlogin
    {//---------------------------------
        clsBLado ADO = new clsBLado();
        clsPRPadoBL ADOprp = new clsPRPadoBL();
        clsPRPadoDL ADOprpDL = new clsPRPadoDL();
        //-----------------------------------
        clsprpADO objadoprp = new clsprpADO();
        clsADO objado = new clsADO();
        public List<PRPSetup> MainMenu(PRPSetup prp)
        {
            ADOprpDL.ArrayPram = new SqlParameter[1];
            ADOprpDL.ArrayPram[0] = new SqlParameter("@empID", prp.AssociateId);

            ADOprpDL.SPName = "spMainUrl";
            ADO.ReaderWithProceduresandParam(ADOprpDL);
            PRPSetup obj;
            List<PRPSetup> lst = new List<PRPSetup>();
            if (ADOprpDL.Dr.HasRows)
            {
                while (ADOprpDL.Dr.Read())
                {
                    obj = new PRPSetup();
                    obj.urlId = ADOprpDL.Dr["urlId"].ToString();
                    obj.urlName = ADOprpDL.Dr["urlName"].ToString();
                    obj.urlPath = ADOprpDL.Dr["urlPath"].ToString();
                    obj.urlPrntId = ADOprpDL.Dr["urlprntId"].ToString();
                    lst.Add(obj);
                }
            }
            ADO.ReaderClose(ADOprpDL);
            return lst;

        }

        public List<PRPSetup> BindMenuNode(PRPSetup prp)
        {

            ADOprpDL.ArrayPram = new SqlParameter[2];
            ADOprpDL.ArrayPram[0] = new SqlParameter("@prntId", prp.urlPrntId);
            ADOprpDL.ArrayPram[1] = new SqlParameter("@empID", prp.AssociateId);
            ADOprpDL.SPName = "spMainUrlByPrntId";
            ADO.ReaderWithProceduresandParam(ADOprpDL);
            PRPSetup obj;
            List<PRPSetup> lst = new List<PRPSetup>();
            if (ADOprpDL.Dr.HasRows)
            {
                while (ADOprpDL.Dr.Read())
                {
                    obj = new PRPSetup();
                    obj.urlId = ADOprpDL.Dr["urlId"].ToString();
                    obj.urlName = ADOprpDL.Dr["urlName"].ToString();
                    obj.urlPath = ADOprpDL.Dr["urlPath"].ToString();
                    obj.urlPrntId = ADOprpDL.Dr["urlprntId"].ToString();
                    lst.Add(obj);
                }
            }

            ADO.ReaderClose(ADOprpDL);
            return lst;

        }

        public DataTable BindMainNodeById(PRPSetup objprp)
        {
            ADOprpDL = new clsPRPadoDL();
            ADOprpDL.ArrayPram = new SqlParameter[2];
            ADOprpDL.ArrayPram[0] = new SqlParameter("@prntId", objprp.urlPrntId);
            ADOprpDL.ArrayPram[1] = new SqlParameter("@empID", objprp.AssociateId);
            ADOprpDL.SPName = "spMainUrlByPrntId";
            return ADO.DataTableWithProceduresAndParam(ADOprpDL);
        }

        public List<prpUrl> BindMenuNodeALL(PRPSetup prp)
        {

            ADOprpDL.ArrayPram = new SqlParameter[1];
            ADOprpDL.ArrayPram[0] = new SqlParameter("@empID", prp.AssociateId);
            ADOprpDL.SPName = "spMainUrlByempId";
            ADO.ReaderWithProceduresandParam(ADOprpDL);
            prpUrl obj;
            List<prpUrl> lst = new List<prpUrl>();
            if (ADOprpDL.Dr.HasRows)
            {
                while (ADOprpDL.Dr.Read())
                {
                    obj = new prpUrl();
                    obj.urlId = ADOprpDL.Dr["urlId"].ToString();
                    obj.urlPath = ADOprpDL.Dr["urlPath"].ToString();

                    lst.Add(obj);
                }
            }

            ADO.ReaderClose(ADOprpDL);
            return lst;

        }


        public string CheckLogin(prpLogin objprp)
        {
            ADOprpDL.ArrayPram = new SqlParameter[3];
            ADOprpDL.ArrayPram[0] = new SqlParameter("@LoginName", objprp.loginName);
            ADOprpDL.ArrayPram[1] = new SqlParameter("@password", objprp.loginPassword);
            ADOprpDL.ArrayPram[2] = new SqlParameter("@IPaddress", objprp.IPaddress);
            ADOprpDL.SPName = "spCheckBranchLogin";
            return ADO.ScalarQueryWithProceduresandParam(ADOprpDL);

        }


        public string CheckLogin1(prpLogin objprp)
        {
            ADOprpDL.ArrayPram = new SqlParameter[3];
            ADOprpDL.ArrayPram[0] = new SqlParameter("@LoginName", objprp.loginName);
            ADOprpDL.ArrayPram[1] = new SqlParameter("@password", objprp.loginPassword);
            ADOprpDL.ArrayPram[2] = new SqlParameter("@IPaddress", objprp.IPaddress);
            ADOprpDL.SPName = "studentLogin";
            return ADO.ScalarQueryWithProceduresandParam(ADOprpDL);

        }
        //----------Web Login------------------//
        public string CheckWebLogin(prpLogin objprp)
        {
            ADOprpDL.ArrayPram = new SqlParameter[3];
            ADOprpDL.ArrayPram[0] = new SqlParameter("@LoginName", objprp.loginName);
            ADOprpDL.ArrayPram[1] = new SqlParameter("@password", objprp.loginPassword);
            ADOprpDL.ArrayPram[2] = new SqlParameter("@IPaddress", objprp.IPaddress);
            ADOprpDL.SPName = "studentWebLogin";
            return ADO.ScalarQueryWithProceduresandParam(ADOprpDL);

        }


        public string ShowWalletBalance(prpLogin objprp)
        {
            ADOprpDL.ArrayPram = new SqlParameter[1];
            ADOprpDL.ArrayPram[0] = new SqlParameter("@branchid", objprp.branchId);
            ADOprpDL.SPName = "ShowWalletBalance";
            return ADO.ScalarQueryWithProceduresandParam(ADOprpDL);

        }
    }


}