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); }
private void populateCombo() { strValues = Session["CompanyID"].ToString() + chr.ToString(); strValues += Session["FinYrID"].ToString() + chr.ToString(); strValues += Session["BranchID"].ToString() + chr.ToString(); strValues += Session["DataFlow"].ToString(); gf.BindAjaxDropDownColumnsBySP(ddlLedger, "spSelect_MstGeneralLedgerFull", strValues); ddlLedger.Items.Insert(0, li); }
protected void LoadDropdown() { char chr = Convert.ToChar(130); string strValues = ""; // A/c group population strValues = "" + chr.ToString() + "Main Group"; genObj.BindAjaxDropDownColumnsBySP(ddlGroup, "spSelect_MstAccountsGroup", strValues); ddlGroup.Items.Insert(0, li); }
protected void LoadDropdown() { strParams = Session["CompanyId"].ToString() + chr.ToString(); strParams += Session["FinYrID"].ToString() + chr.ToString(); strParams += Session["BranchID"].ToString() + chr.ToString(); strParams += Session["DataFlow"].ToString(); gf.BindAjaxDropDownColumnsBySP(ddlLedger, "spSelect_MstGeneralLedgerBNKandCASH", strParams); ddlLedger.Items.Insert(0, li); gf.BindAjaxDropDownColumnsBySP(ddlLedgerSearch, "spSelect_MstGeneralLedgerBNKandCASH", strParams); ddlLedgerSearch.Items.Insert(0, liSearch); gf.BindAjaxDropDownColumnsBySP(ddlParentLedger, "spSelect_MstGeneralLedgerBNKandCASH", strParams); ddlParentLedger.Items.Insert(0, li); gf.BindAjaxDropDownColumnsBySP(ddlParentLedgerSearch, "spSelect_MstGeneralLedgerBNKandCASH", strParams); ddlParentLedgerSearch.Items.Insert(0, liSearch); }
protected void PopulatePage() { ddlUnderGroup.Items.Clear(); strValues = GroupID.ToString() + chr.ToString() + ""; DataSet ds = genObj.ExecuteSelectSP("spSelect_MstAccountsGroup", strValues); txtGroupName.Text = ds.Tables[0].Rows[0]["GroupName"].ToString(); ddlGroupType.SelectedValue = ds.Tables[0].Rows[0]["GroupType"].ToString(); if (ddlGroupType.SelectedValue == "Sub Group") { strValues = "" + chr.ToString() + "Main Group"; genObj.BindAjaxDropDownColumnsBySP(ddlUnderGroup, "spSelect_MstAccountsGroup", strValues); ddlUnderGroup.Items.Insert(0, li); if (ds.Tables[0].Rows[0]["GroupID_FK"].ToString() == "") { ddlUnderGroup.SelectedValue = "0"; } else { ddlUnderGroup.SelectedValue = ds.Tables[0].Rows[0]["GroupID_FK"].ToString(); } } else if (ddlGroupType.SelectedValue == "Main Group") { ddlUnderGroup.Items.Insert(0, li); } LoadFirstAccountType(); ddlFirstAccountType.SelectedValue = ds.Tables[0].Rows[0]["ActType1"].ToString(); LoadSecondAccountType(); ddlSecondAccountType.SelectedValue = ds.Tables[0].Rows[0]["ActType2"].ToString(); LoadThirdAccountType(); ddlThirdAccountType.SelectedValue = ds.Tables[0].Rows[0]["ActType3"].ToString(); btnSave.Text = "Update"; Message.Show = false; }
private void populateCombo() { char chr = Convert.ToChar(130); string strValues = ""; strParams = Session["CompanyID"].ToString() + chr.ToString(); strParams += Session["FinYrID"].ToString() + chr.ToString(); strParams += Session["BranchID"].ToString() + chr.ToString(); strParams += ""; strKarigarParams = strParams + chr.ToString() + "LedgerType" + chr.ToString() + Session["DataFlow"].ToString(); gf.BindAjaxDropDownColumnsBySP(ddlLedger, "spSelect_MstGeneralLedgerALL", strKarigarParams); ddlLedger.Items.Insert(0, li); }
protected void LoadLedger() { clsGeneralFunctions gf = new clsGeneralFunctions(); string strValues = ""; char chr = Convert.ToChar(130); ListItem li = new ListItem("Select", "0"); strValues = Session["CompanyID"].ToString() + chr.ToString(); strValues += Session["FinYrID"].ToString() + chr.ToString(); strValues += Session["BranchID"].ToString() + chr.ToString(); strValues += Session["DataFlow"].ToString(); gf.BindAjaxDropDownColumnsBySP(ddlLedger, "spSelect_MstGeneralLedgerFull", strValues); ddlLedger.Items.Insert(0, li); }
protected void Page_Load(object sender, EventArgs e) { if ((Session["UserId"] == null) && (Session["SuperAdmin"] == null)) { Response.Redirect("../Login.aspx"); } if (!IsPostBack) { char chr = Convert.ToChar(130); ViewState["SortOrder"] = " ASC"; string strValues = ""; ViewState["ID"] = 0; PopulateGrid("LedgerName", SortDirection.Ascending, strFilter); // A/c group population in search Tab ddlGroupVw.Items.Clear(); strValues = Session["CompanyID"].ToString() + chr.ToString() + "" + chr.ToString() + "Main Group"; genObj.BindAjaxDropDownColumnsBySP(ddlGroupVw, "spSelect_MstAccountsGroup", strValues); ddlGroupVw.Items.Insert(0, new ListItem("Select", "0")); ddlGroupVw.SelectedValue = "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); }