protected void Page_Load(object sender, EventArgs e) { if (Session["UserId"] == null) { Response.Redirect("../Login.aspx"); } if (!IsPostBack) { ViewState["ID"] = 0; genObj.BindGridViewSP(gdFinancialYr, "spSelect_MstFinancialYear_New", ""); Message.Show = false; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserId"] == null) { Response.Redirect("../Login.aspx"); } if (!IsPostBack) { ResetControls(); string strValues = ""; strValues = Session["CompanyId"].ToString(); strValues += chr.ToString() + ""; genObj.BindGridViewSP(gvCostCenter, "spSelect_MstCostCenter", strValues); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserId"] == null) { Response.Redirect("../Login.aspx"); } if (!IsPostBack) { ViewState["ID"] = 0; PopulateCombo(); strValues = "3" + chr.ToString() + "" + chr.ToString() + ""; genObj.BindGridViewSP(dgvGroupType, "spSelect_MstAccountsGroupType_ForAccountsGroupType", strValues); Message.Show = false; } }
private void PopulateGrid(string strSortExpression, SortDirection sortDir, string strFilter) { char chr = Convert.ToChar(130); if (strFilter == "null" || strFilter == null) { strFilter = ""; } string strValues = ""; strValues = Session["CompanyID"].ToString(); strValues += chr.ToString() + Session["FinYrID"].ToString(); strValues += chr.ToString() + Session["BranchID"].ToString(); strValues += chr.ToString() + "" + chr.ToString() + "" + chr.ToString() + Session["DataFlow"].ToString(); genObj.BindGridViewSP(gdGenLedger, "spSelect_MstGeneralLedgerALL", strValues, strFilter); if (gdGenLedger.DataSource != null) { Session[clsGlobalVariable.sesReportPageHeader] = strPrepareRPTHeader; Session[clsGlobalVariable.sesReportPageFooter] = strPrepareRPTFooter; Session[clsGlobalVariable.sesReportGrid] = gdGenLedger; Session[clsGlobalVariable.sesReportTitle] = "General Ledger"; btnPrint.Attributes["onclick"] = "window.open('RPTShowGrid.aspx');"; } }
private void PopulateGrid() { strValues = Session["CompanyID"].ToString(); strValues += chr.ToString() + Session["FinYrID"].ToString(); strValues += chr.ToString() + Session["BranchID"].ToString(); strValues += chr.ToString() + "" + chr.ToString() + Session["DataFlow"].ToString(); genObj.BindGridViewSP(gdBankAccount, "spSelect_MstBankAccount", strValues); }
private void PopulateGrid() { if (Session["CompanyID"].ToString() == "3") { strValues = "" + chr.ToString(); } else { strValues = Session["CompanyID"].ToString() + chr.ToString(); } strValues += Session["BranchID"].ToString() + chr.ToString(); strValues += Session["FinYrID"].ToString() + chr.ToString(); strValues += txtfrmdate.Text.Trim() + " 00:00:00" + chr.ToString(); strValues += txtToDate.Text.Trim() + " 23:59:59"; //if (Session["CompanyID"].ToString() == "3") // strValues2 = "" + chr.ToString(); //else // strValues2 = Session["CompanyID"].ToString() + chr.ToString(); //strValues2 += Session["BranchID"].ToString() + chr.ToString(); //strValues2 += Session["FinYrID"].ToString() + chr.ToString(); //if (txtfrmdate.Text.Length > 0) // strValues2 += txtfrmdate.Text.Trim() + " 00:00:00" + chr.ToString(); //else // strValues2 += txtfrmdate.Text.Trim() + chr.ToString(); //if (txtToDate.Text.Length > 0) // strValues2 += txtToDate.Text.Trim() + " 23:59:59"; //else // strValues2 += txtToDate.Text.Trim(); genObj.BindGridViewSP(gvPL, "sp_ProfitLoss", strValues); genObj.BindGridViewSP(gvBalanceSheet, "sp_BalanceSheet", strValues); //ltrPLHeading.Text = @"<b>Income & Expenditure Statement</b><br /><br />" + txtfrmdate.Text.Trim() + " to " + txtToDate.Text.Trim(); //ltrBalanceSheetHeading.Text = @"<b>Balance Sheet</b><br /><br />" + txtfrmdate.Text.Trim() + " to " + txtToDate.Text.Trim(); }
private void PopulateHeaderGrid() { strParams = Session["CompanyId"].ToString().Trim(); strParams += chr.ToString() + Session["FinYrID"].ToString().Trim(); strParams += chr.ToString() + Session["BranchId"].ToString().Trim(); strParams += chr.ToString() + Session["DataFlow"].ToString().Trim(); string strHParams = strParams + chr.ToString() + ""; gf.BindGridViewSP(grdvwtrnsctnsearch, "spSelect_TrnContraVoucherHeader", strHParams, PrepareSearchFilter()); }
private void PopulateGrid() { strValues = "" + chr.ToString() + ""; strFilter = ""; if (txtSearchVal.Text.Trim().Length > 0) { strFilter = "GroupName Like '" + txtSearchVal.Text + "%'"; } genObj.BindGridViewSP(gdAccountGr, "spSelect_MstAccountsGroup", strValues, strFilter); }
private void PopulateHeaderGrid(string strSortExpression, string sortDir) { //For Search strParams = Session["CompanyId"].ToString().Trim(); strParams += chr.ToString() + Session["FinYrID"].ToString().Trim(); strParams += chr.ToString() + Session["BranchId"].ToString().Trim(); strParams += chr.ToString() + Session["DataFlow"].ToString().Trim(); string strHParams = strParams + chr.ToString() + ""; //strHParams += ""; gf.BindGridViewSP(grdvwtrnsctnsearch, "spSelect_TrnVoucherHeaderDetails", strHParams, PrepareSearchFilter(), strSortExpression, sortDir); }
private void PopulateHeaderGrid(string strSortExpression, string sortDir) { strParams = Session["CompanyId"].ToString() + chr.ToString(); strParams += Session["FinYrID"].ToString() + chr.ToString(); strParams += Session["BranchID"].ToString() + chr.ToString(); strParams += Session["DataFlow"].ToString(); string strHParams = strParams + chr.ToString(); strHParams += ""; strSortExpression = "VoucherDate"; sortDir = "Desc"; gf.BindGridViewSP(gvCBVView, "spSelect_TrnCashBankVoucher", strHParams, PrepareSearchFilter(), strSortExpression, sortDir); }
private void PopulateHeaderGrid() { strParams = Session["CompanyID"].ToString() + chr.ToString(); strParams += Session["BranchID"].ToString() + chr.ToString(); strParams += Session["DataFlow"].ToString(); gf.BindGridViewSP(gvBRView, "spSelect_TrnBankReconsiliation", strParams, PrepareSearchFilter()); if (gvBRView.DataSource != null) { if (gvBRView.Rows.Count > 0) { btnExportExcel.Visible = true; } } }
protected void PopulateGrid(string strFilter) { char chr = Convert.ToChar(130); if (strFilter == "null" || strFilter == null) { strFilter = ""; } string strValues = ""; strValues = Session["CompanyId"].ToString(); strValues += chr.ToString() + Session["FinYrID"].ToString(); strValues += chr.ToString() + Session["BranchID"].ToString(); strValues += chr.ToString() + "" + chr.ToString() + "" + chr.ToString() + Session["DataFlow"].ToString(); genObj.BindGridViewSP(gdGenLedger, "spSelect_MstGeneralLedger", strValues, strFilter); }