public void BindAccountGroup(int intGroup) { try { ApplicationResult objResult = new ApplicationResult(); RptPnLBL objRptPnLbl = new RptPnLBL(); objResult = objRptPnLbl.AccountGroup_Select_ByGroupNature(intGroup); if (intGroup == 1) { gvIncome.DataSource = objResult.resultDT; gvIncome.DataBind(); } else if (intGroup == 2) { gvExpense.DataSource = objResult.resultDT; gvExpense.DataBind(); } } catch (Exception ex) { Logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void btnGo_OnClick(object sender, EventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); RptPnLBL objRptPnLbl = new RptPnLBL(); DataTable dtResultExpense = new DataTable(); dtResultExpense.Columns.Add("AccountGroupID", typeof(int)); dtResultExpense.Columns.Add("AccountName", typeof(string)); dtResultExpense.Columns.Add("Debit", typeof(string)); dtResultExpense.Columns.Add("Priority", typeof(int)); int intPriority = 0; int intAccountGroupID = 0; for (int i = 0; i < gvExpense.Rows.Count; i++) { TextBox txtSequence = (TextBox)gvExpense.Rows[i].FindControl("txtSequence1"); intPriority = Convert.ToInt32(txtSequence.Text); intAccountGroupID = Convert.ToInt32(gvExpense.Rows[i].Cells[0].Text); objResult = objRptPnLbl.ReportPnL_ExpenseGroup(txtToDate.Text, Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()), intAccountGroupID); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { for (int k = 0; k < objResult.resultDT.Rows.Count; k++) { dtResultExpense.Rows.Add(Convert.ToInt32(objResult.resultDT.Rows[k]["AccountGroupID"].ToString()), objResult.resultDT.Rows[k]["AccountName"].ToString(), objResult.resultDT.Rows[k]["Debit"].ToString(), intPriority); } } } } DataTable dtMainExpense = new DataTable(); dtMainExpense.Columns.Add("AccountGroupID", typeof(int)); dtMainExpense.Columns.Add("AccountName", typeof(string)); dtMainExpense.Columns.Add("Debit", typeof(string)); for (int r = 1; r <= gvExpense.Rows.Count; r++) { DataRow[] rows = dtResultExpense.Select("Priority = " + r); if (rows.Length > 0) { DataTable dt = rows.CopyToDataTable(); for (int s = 0; s < dt.Rows.Count; s++) { dtMainExpense.Rows.Add(Convert.ToInt32(dt.Rows[s]["AccountGroupID"].ToString()), dt.Rows[s]["AccountName"].ToString(), dt.Rows[s]["Debit"].ToString()); } } } DataTable dtResultIncome = new DataTable(); dtResultIncome.Columns.Add("AccountGroupID", typeof(int)); dtResultIncome.Columns.Add("AccountName", typeof(string)); dtResultIncome.Columns.Add("Debit", typeof(string)); dtResultIncome.Columns.Add("Priority", typeof(int)); ApplicationResult objResult1 = new ApplicationResult(); int intPriority1 = 0; int intAccountGroupID1 = 0; for (int i1 = 0; i1 < gvIncome.Rows.Count; i1++) { TextBox txtSequence1 = (TextBox)gvIncome.Rows[i1].FindControl("txtSequence"); intPriority1 = Convert.ToInt32(txtSequence1.Text); intAccountGroupID1 = Convert.ToInt32(gvIncome.Rows[i1].Cells[0].Text); objResult1 = objRptPnLbl.ReportPnL_IncomeGroup(txtToDate.Text, Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()), intAccountGroupID1); if (objResult1 != null) { if (objResult1.resultDT.Rows.Count > 0) { for (int k1 = 0; k1 < objResult1.resultDT.Rows.Count; k1++) { dtResultIncome.Rows.Add(Convert.ToInt32(objResult1.resultDT.Rows[k1]["AccountGroupID"].ToString()), objResult1.resultDT.Rows[k1]["AccountName"].ToString(), objResult1.resultDT.Rows[k1]["Debit"].ToString(), intPriority1); } } } } DataTable dtMainIncome = new DataTable(); dtMainIncome.Columns.Add("AccountGroupID", typeof(int)); dtMainIncome.Columns.Add("AccountName", typeof(string)); dtMainIncome.Columns.Add("Debit", typeof(string)); for (int t = 1; t <= gvIncome.Rows.Count; t++) { DataRow[] rows1 = dtResultIncome.Select("Priority = " + t); if (rows1.Length > 0) { DataTable dt1 = rows1.CopyToDataTable(); for (int u = 0; u < dt1.Rows.Count; u++) { dtMainIncome.Rows.Add(Convert.ToInt32(dt1.Rows[u]["AccountGroupID"].ToString()), dt1.Rows[u]["AccountName"].ToString(), dt1.Rows[u]["Debit"].ToString()); } } } double dblTotalIncome = 0.00, dblTotalExpense = 0.00, dblNetProfit = 0.00; ApplicationResult objNetResult = new ApplicationResult(); objNetResult = objRptPnLbl.ReportPnL_NetResult(txtToDate.Text, Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString())); if (objNetResult != null) { if (objNetResult.resultDT.Rows.Count > 0) { if (objNetResult.resultDT.Rows[0]["Income"].ToString() != "") { dblTotalIncome = Convert.ToDouble(objNetResult.resultDT.Rows[0]["Income"].ToString()); } if (objNetResult.resultDT.Rows[0]["Expense"].ToString() != "") { dblTotalExpense = Convert.ToDouble(objNetResult.resultDT.Rows[0]["Expense"].ToString()); } if (objNetResult.resultDT.Rows[0]["NetProfit"].ToString() != "") { dblNetProfit = Convert.ToDouble(objNetResult.resultDT.Rows[0]["NetProfit"].ToString()); } int intdtMainExpenseCount = dtMainExpense.Rows.Count; int intdtMainIncomeCount = dtMainIncome.Rows.Count; if (dblNetProfit > 0.00) { intdtMainExpenseCount += 2; dtMainExpense.Rows.Add(1, "<b>Net Profit</b>", "<b style='float: right;'>" + objNetResult.resultDT.Rows[0]["NetProfit"].ToString() + "</b>"); } else if (dblNetProfit < 0.00) { intdtMainIncomeCount += 2; dtMainIncome.Rows.Add(1, "<b>Net Loss</b>", "<b style='float: right;'>" + objNetResult.resultDT.Rows[0]["NetProfit"].ToString() + "</b>"); } int dtDiff = 0; if (intdtMainExpenseCount > intdtMainIncomeCount) { dtDiff = intdtMainExpenseCount - intdtMainIncomeCount; for (int intdtexp = 0; intdtexp < dtDiff; intdtexp++) { if (intdtexp == (dtDiff - 1)) { if (dblNetProfit > 0.00) { dtMainIncome.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Income"].ToString() + "</u></b>"); dtMainExpense.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Income"].ToString() + "</u></b>"); } else if (dblNetProfit < 0.00) { dtMainIncome.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Expense"].ToString() + "</u></b>"); dtMainExpense.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Expense"].ToString() + "</u></b>"); } else { dtMainIncome.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Expense"].ToString() + "</u></b>"); dtMainExpense.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Expense"].ToString() + "</u></b>"); } } else { dtMainIncome.Rows.Add(0, "", ""); } } } else if (intdtMainIncomeCount > intdtMainExpenseCount) { dtDiff = intdtMainIncomeCount - intdtMainExpenseCount; for (int intdtinc = 0; intdtinc < dtDiff; intdtinc++) { if (intdtinc == (dtDiff - 1)) { //dtMainExpense.Rows.Add(0, "", "<b style='float: right;'><u>" + (Math.Round(dblTotalIncome, 2).ToString()) + "</u></b>"); //dtMainIncome.Rows.Add(0, "", "<b style='float: right;'><u>" + (Math.Round(dblTotalIncome, 2).ToString()) + "</u></b>"); if (dblNetProfit > 0.00) { dtMainIncome.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Income"].ToString() + "</u></b>"); dtMainExpense.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Income"].ToString() + "</u></b>"); } else if (dblNetProfit < 0.00) { dtMainIncome.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Expense"].ToString() + "</u></b>"); dtMainExpense.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Expense"].ToString() + "</u></b>"); } else { dtMainIncome.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Expense"].ToString() + "</u></b>"); dtMainExpense.Rows.Add(0, "", "<b style='float: right;'><u>" + objNetResult.resultDT.Rows[0]["Expense"].ToString() + "</u></b>"); } } else { dtMainExpense.Rows.Add(0, "", ""); } } } } } ViewState["gvExpense"] = dtMainExpense; ViewState["gvIncome"] = dtMainIncome; ApplicationResult objIncExpResult = new ApplicationResult(); objIncExpResult = objRptPnLbl.ReportPnL_BasicInfo(Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()), txtToDate.Text, "Income & Expenditure Account for the year ended"); dlIncomeExpenditureAccount.DataSource = objIncExpResult.resultDT; dlIncomeExpenditureAccount.DataBind(); PanelVisibility(2); } catch (Exception ex) { Logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }