private void PopulateAllDropDowns()
        {
            strParams  = Session["CompanyId"].ToString() + chr.ToString();
            strParams += Session["FinYrID"].ToString() + chr.ToString();
            strParams += Session["BranchID"].ToString() + chr.ToString();
            strParams += Session["DataFlow"].ToString();

            gf.BindAjaxDropDownColumnsBySP(ddlSourceLedger, "spSelect_MstGeneralLedgerBNKandCASH", strParams);
            ddlSourceLedger.Items.Insert(0, li);

            gf.BindDropDownColumnsBySP(ddlLedgerVw, "spSelect_MstGeneralLedgerBNKandCASH", strParams);
            ddlLedgerVw.Items.Insert(0, li);

            DataView dv = new DataView(gf.GetDropDownColumnsBySP("spSelect_MstGeneralLedgerFull", strParams));

            dv.RowFilter = "LedgerType NOT IN ('BNK', 'CASH')";

            if (dv != null)
            {
                ddlLedg.DataSource = dv;
                ddlLedg.DataBind();
            }
            ddlLedg.Items.Insert(0, li);

            strParams  = Session["CompanyId"].ToString().Trim() + chr.ToString();
            strParams += "";
            gf.BindDropDownColumnsBySP(ddlCostCentre, "spSelect_MstCostCenter", strParams);
            ddlCostCentre.Items.Insert(0, li);
        }
 protected void GetCostCenterDetails()
 {
     strParams  = Session["CompanyId"].ToString().Trim() + chr.ToString();
     strParams += "";
     gf.BindDropDownColumnsBySP(ddlcostcntr, "spSelect_MstCostCenter", strParams);
     ddlcostcntr.Items.Insert(0, li);
 }
Ejemplo n.º 3
0
        private void LoadCashBankLedger()
        {
            strParams  = Session["CompanyId"].ToString() + chr.ToString();
            strParams += Session["FinYrID"].ToString() + chr.ToString();
            strParams += Session["BranchID"].ToString() + chr.ToString();
            strParams += Session["DataFlow"].ToString();

            gf.BindDropDownColumnsBySP(ddlCashBankLedger, "spSelect_MstGeneralLedgerBNKandCASH", strParams);

            //if (!Session["UserType"].ToString().Equals("Admin"))
            //{
            //    string strPaymentLedgerIds = System.Configuration.ConfigurationManager.AppSettings["PAYMENT_LEDGER_ID"].Trim();
            //    List<ListItem> lstItem = new List<ListItem>();

            //    foreach (ListItem li in ddlCashBankLedger.Items)
            //    {
            //        if (!strPaymentLedgerIds.Split(',').Contains(li.Value))
            //        {
            //            lstItem.Add(li);
            //        }
            //    }

            //    foreach (ListItem li in lstItem)
            //    {
            //        ddlCashBankLedger.Items.Remove(li);
            //    }
            //}
            ddlCashBankLedger.Items.Insert(0, new ListItem("Select Ledger", "0"));
        }
Ejemplo n.º 4
0
        private void LoadCostCenter()
        {
            string strParams = Session["CompanyId"].ToString().Trim() + chr.ToString();

            strParams += "";
            gf.BindDropDownColumnsBySP(ddlCostCenter, "spSelect_MstCostCenter", strParams);
            ddlCostCenter.Items.Insert(0, li);
        }
        private void LoadCashBankLedger()
        {
            strParams  = Session["CompanyId"].ToString() + chr.ToString();
            strParams += Session["FinYrID"].ToString() + chr.ToString();
            strParams += Session["BranchID"].ToString() + chr.ToString();
            strParams += Session["DataFlow"].ToString();

            gf.BindDropDownColumnsBySP(ddlCashBankLedger, "spSelect_MstGeneralLedgerBNKandCASH", strParams);
            ddlCashBankLedger.Items.Insert(0, new ListItem("Select Ledger", "0"));
        }
Ejemplo n.º 6
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if ((Session["UserId"] == null) && (Session["SuperAdmin"] == null))
     {
         Response.Redirect("../Login.aspx");
     }
     if (!IsPostBack)
     {
         genObj.BindDropDownColumnsBySP(ddlFinancialYear, "spSelect_MstFinancialYear", "");
         ddlFinancialYear.SelectedValue = Session["FinYrID"].ToString();
     }
 }
Ejemplo n.º 7
0
        protected void LoadDropdown()
        {
            strValues = "" + chr.ToString() + "Main Group";
            genObj.BindAjaxDropDownColumnsBySP(ddlGroup, "spSelect_MstAccountsGroup", strValues);
            ddlGroup.Items.Insert(0, li);

            //Bank Name population
            strValues = "Bank Name";
            genObj.BindDropDownColumnsBySP(ddlBankName, "spSelect_MstGeneralItem", strValues);
            ddlBankName.Items.Insert(0, li);

            //Employee population
            BusinessLayer.Common.Employee ObjEmployee = new BusinessLayer.Common.Employee();
            DataView dv = new DataView(ObjEmployee.GetAll("", ""));

            dv.RowFilter = "CompanyId = " + Session["CompanyID"].ToString() + " and CompanyId is not null";

            ddlOperatedBy.DataSource = dv;
            ddlOperatedBy.DataBind();
            ddlOperatedBy.Items.Insert(0, li);
        }
Ejemplo n.º 8
0
        private void BindGroupName()
        {
            char   chr       = Convert.ToChar(130);
            string strValues = "";

            // A/c group population
            strValues = "" + chr.ToString() + "Main Group";
            gf.BindDropDownColumnsBySP(ddlGroupName, "spSelect_MstAccountsGroup", strValues);
            ddlGroupName.Items.Insert(0, li);

            //BusinessLayer.Accounts.RPTTrialBalance ObjAccounts = new BusinessLayer.Accounts.RPTTrialBalance();
            //int GroupTypeLevel = 2;
            //DataTable DT = ObjAccounts.GroupTypeGetAll(GroupTypeLevel);
            //if (DT != null)
            //{
            //    ddlGroupName.DataSource = DT;
            //    ddlGroupName.DataValueField = "GroupTypeID";
            //    ddlGroupName.DataTextField = "GroupType";
            //    ddlGroupName.DataBind();
            //}
            //ddlGroupName.Items.Insert(0, li);
        }
Ejemplo n.º 9
0
 private void PopulateCombo()
 {
     strValues = "1" + chr.ToString() + "";
     genObj.BindDropDownColumnsBySP(ddlFirstAccountType, "spSelect_MstAccountsGroupType", strValues);
     ddlFirstAccountType.SelectedValue = "0";
 }