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);
}
