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