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