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);
}
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"));
}
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"));
}
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();
}
}
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);
}
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);
}
private void PopulateCombo()
{
strValues = "1" + chr.ToString() + "";
genObj.BindDropDownColumnsBySP(ddlFirstAccountType, "spSelect_MstAccountsGroupType", strValues);
ddlFirstAccountType.SelectedValue = "0";
}