private void fnOpeningBalance(int intTrustMID, int intSchoolMID, int intLedgerID, string strToDate)
{
try
{
ApplicationResult objResult = new ApplicationResult();
GeneralLedgerBL objGLedgerBL = new GeneralLedgerBL();
if (Convert.ToString(intLedgerID) != "")
{
divlblBalance.Visible = true;
objResult = objGLedgerBL.Select_OpeningBalanceForAccounting(intTrustMID, intSchoolMID, intLedgerID, strToDate);
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
lblCurrentBalance.Text = objResult.resultDT.Rows[0][0].ToString();
}
else
{
lblCurrentBalance.Text = "0";
}
}
}
else
{
divlblBalance.Visible = false;
}
}
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>");
}
}
public static string LoadBalance(int intTrustMID, int intSchoolID, int intLedgerID, string strToDate)
{
try
{
#region Bind Balance
ApplicationResult objResult = new ApplicationResult();
GeneralLedgerBL objGLedgerBL = new GeneralLedgerBL();
objResult = objGLedgerBL.Select_OpeningBalanceForAccounting(intTrustMID, intSchoolID, intLedgerID, strToDate);
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
for (int i = 0; i < objResult.resultDT.Rows.Count; i++)
{
}
}
}
string res = "";
res = DataSetToJSON(objResult.resultDT);
return(res);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
public void BindGrid()
{
try
{
GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL();
GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO();
ApplicationResult objResultSelectAll = new ApplicationResult();
objResultSelectAll = objGeneralLedgerBL.GeneralLedger_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelectAll != null)
{
DataTable dtSelectAll = new DataTable();
dtSelectAll = objResultSelectAll.resultDT;
if (dtSelectAll.Rows.Count > 0)
{
gvGeneralLedger.DataSource = dtSelectAll;
gvGeneralLedger.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 gvGeneralLedger_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL();
GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO();
ApplicationResult objResultSelect = new ApplicationResult();
ApplicationResult objResultDelete = new ApplicationResult();
ViewState["LedgerID"] = e.CommandArgument.ToString();
if (e.CommandName.ToString() == "Edit1")
{
objResultSelect = objGeneralLedgerBL.GeneralLedger_Select(Convert.ToInt32(ViewState["LedgerID"].ToString()), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelect != null)
{
DataTable dtResult = objResultSelect.resultDT;
if (dtResult.Rows.Count > 0)
{
BindAccountGroup();
txtAccountName.Text = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_ACCOUNTNAME].ToString();
ddlAccountGroup.SelectedValue = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_ACCOUNTGROUPID].ToString();
txtOpeningBalance.Text = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_OPENINGBALANCE].ToString();
if (dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_BALANCETYPE].ToString() != "")
{
ddlBalanceType.SelectedValue = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_BALANCETYPE].ToString();
}
txtDescription.Text = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_DESCRIPTION].ToString();
PanelVisibility(2);
ViewState["Mode"] = "Edit";
}
}
}
else if (e.CommandName.ToString() == "Delete1")
{
objResultDelete = objGeneralLedgerBL.GeneralLedger_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.USERID]), DateTime.UtcNow.AddHours(5.5).ToString(), "Ledger");
if (objResultDelete.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>");
PanelVisibility(1);
BindGrid();
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You cannot delete this record because it is in used.');</script>");
}
}
}
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>");
}
}
public void BindReport()
{
var objGeneralLedgerBl = new GeneralLedgerBL();
var objResult = objGeneralLedgerBl.Select_TrialBalanceReport(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), txtFromDate.Text, txtToDate.Text);
if (objResult.resultDT.Rows.Count > 0)
{
gvTrialBalanceReport.DataSource = objResult.resultDT;
gvTrialBalanceReport.DataBind();
lblHeading.Text = "<b>Trial Balance </b><br/>" + txtFromDate.Text + " To " + txtToDate.Text;
}
}
public void BindParameterGrid()
{
ApplicationResult objrResult = new ApplicationResult();
GeneralLedgerBL objGeneralLedgerBl = new GeneralLedgerBL();
objrResult =
objGeneralLedgerBl.Select_GeneralLedgers(
Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()),
Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()));
if (objrResult != null)
{
gvParameter.DataSource = objrResult.resultDT;
gvParameter.DataBind();
}
}
public void BindAccountGroup()
{
GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL();
GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO();
ApplicationResult objResultSelectAll = new ApplicationResult();
DropDownList ddlAccountName = new DropDownList();
objResultSelectAll = objGeneralLedgerBL.GeneralLedger_SelectAll_JournalEntry(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelectAll != null)
{
DataTable dtSelectAll = new DataTable();
dtSelectAll = objResultSelectAll.resultDT;
for (int i = 0; i < gvPaymentsEntry.Rows.Count; i++)
{
ddlAccountName = (DropDownList)gvPaymentsEntry.Rows[i].Cells[0].FindControl("ddlAccountName");
if (ddlAccountName != null)
{
objControl.BindDropDown_ListBox(dtSelectAll, ddlAccountName, "AccountName", "LedgerID");
ddlAccountName.Items.Insert(0, new ListItem("", "-1"));
}
}
}
}
protected void ddlReceiptMode_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
divlblBalance.Visible = false;
if (ddlReceiptMode.SelectedValue != "")
{
GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL();
GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO();
ApplicationResult objResultSelect = new ApplicationResult();
DataTable dtSelect = new DataTable();
if (ddlReceiptMode.SelectedValue == "Cash")
{
txtChequeNo.Text = "";
txtChequeNo.Enabled = false;
ddlGeneralLedger.ClearSelection();
objResultSelect = objGeneralLedgerBL.GeneralLedger_Select_Receipt_Payment(1, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelect != null)
{
dtSelect = objResultSelect.resultDT;
objControl.BindDropDown_ListBox(dtSelect, ddlGeneralLedger, "AccountName", "LedgerID");
ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", ""));
}
}
else if (ddlReceiptMode.SelectedValue == "Bank")
{
txtChequeNo.Text = "";
txtChequeNo.Enabled = true;
ddlGeneralLedger.ClearSelection();
objResultSelect = objGeneralLedgerBL.GeneralLedger_Select_Receipt_Payment(2, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelect != null)
{
dtSelect = objResultSelect.resultDT;
objControl.BindDropDown_ListBox(dtSelect, ddlGeneralLedger, "AccountName", "LedgerID");
ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", ""));
}
}
else
{
txtChequeNo.Text = "";
txtChequeNo.Enabled = true;
ddlGeneralLedger.ClearSelection();
objResultSelect = objGeneralLedgerBL.GeneralLedger_Select_Receipt_Payment(3, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelect != null)
{
dtSelect = objResultSelect.resultDT;
objControl.BindDropDown_ListBox(dtSelect, ddlGeneralLedger, "AccountName", "LedgerID");
ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", ""));
}
}
}
else
{
ddlGeneralLedger.Items.Clear();
ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", ""));
}
}
catch (Exception ex)
{
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
try
{
var objGeneralLedgerBl = new GeneralLedgerBL();
int intIsNarration;
if (chkNarration.Checked)
{
intIsNarration = 1;
//var bfield = new BoundField { HeaderText = "Narration", DataField = "Description" };
//bfield.HeaderStyle.Width = new Unit("30%");
//bfield.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
//bfield.HeaderStyle.VerticalAlign = VerticalAlign.Top;
//bfield.ItemStyle.Width = new Unit("30%");
//bfield.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
//bfield.ItemStyle.VerticalAlign = VerticalAlign.Top;
//bfield.ItemStyle.Wrap = false;
//gvCashBankReport.Columns.Add(bfield);
}
else
{
intIsNarration = 0;
}
var objResult = objGeneralLedgerBl.GeneralLedger_Select_Rpt_CashBankBook(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ddlGeneralLedger.SelectedValue), ddlType.SelectedValue, txtFromDate.Text, txtToDate.Text, intIsNarration);
if (objResult != null)
{
//var dsresult = objResult.resutlDS;
//foreach (DataRow dr in dsresult.Tables[1].Rows)
//{
// if (dsresult.Tables[0].Rows.Count>0)
// dsresult.Tables[0].Rows.Add(dr.ItemArray);
//}
//double dbCrAmt = 0, dbDrAmt = 0;
//if (dsresult.Tables[0].Rows.Count > 0)
//{
// if (dsresult.Tables[0].Rows[0]["Debit"].ToString() == "" || dsresult.Tables[0].Rows[0]["Debit"].ToString() == "0" || dsresult.Tables[0].Rows[0]["Debit"] == null)
// {
// if (dsresult.Tables[0].Rows[0]["Credit"].ToString() == "" || dsresult.Tables[0].Rows[0]["Credit"] == null)
// {
// }
// else
// {
// dbCrAmt = Convert.ToInt32(dsresult.Tables[0].Rows[0]["Credit"]);
// }
// dbDrAmt = 0;
// }
// else
// {
// if (dsresult.Tables[0].Rows[0]["Debit"].ToString() == "" || dsresult.Tables[0].Rows[0]["Debit"] == null)
// {
// }
// else
// {
// dbDrAmt = Convert.ToDouble(dsresult.Tables[0].Rows[0]["Debit"]);
// }
// dbCrAmt = 0;
// }
//}
//if (dsresult.Tables[2].Rows.Count > 0)
//{
// if (dsresult.Tables[2].Rows[0][6].ToString() == "" || dsresult.Tables[2].Rows[0][6].ToString() == "0" || dsresult.Tables[2].Rows[0][6] == null)
// dbDrAmt += 0;
// else
// dbDrAmt += Convert.ToDouble(dsresult.Tables[2].Rows[0][6]);
// if (dsresult.Tables[2].Rows[0][7].ToString() == "" || dsresult.Tables[2].Rows[0][7].ToString() == "0" || dsresult.Tables[2].Rows[0][7] == null)
// dbCrAmt += 0;
// else
// dbCrAmt += Convert.ToDouble(dsresult.Tables[2].Rows[0][7]);
//}
//if (dsresult.Tables[1].Rows.Count > 0)
//{
// if (dbDrAmt > dbCrAmt)
// {
// //lblClosing.Text = "Cr. " + (dbDrAmt - dbCrAmt);
// // ReSharper disable once UnusedVariable
// foreach (DataRow row in dsresult.Tables[2].Rows)
// {
// dsresult.Tables[2].Rows[0][6] = 0;
// dsresult.Tables[2].Rows[0][7] = (dbDrAmt - dbCrAmt);
// }
// }
// else if (dbDrAmt < dbCrAmt)
// {
// //lblClosing.Text = "Dr. " + (dbCrAmt - dbDrAmt);
// // ReSharper disable once UnusedVariable
// foreach (DataRow row in dsresult.Tables[2].Rows)
// {
// dsresult.Tables[2].Rows[0][6] = (dbCrAmt - dbDrAmt);
// dsresult.Tables[2].Rows[0][7] = 0;
// }
// }
// else
// {
// //lblClosing.Text = "0";
// dsresult.Tables[2].Rows[0][6] = 0;
// dsresult.Tables[2].Rows[0][7] = 0;
// }
// btnExportExcel.Visible = true;
//}
//else
//{
// if (dsresult.Tables[0].Rows[0]["Debit"].ToString() == "" || dsresult.Tables[0].Rows[0]["Debit"].ToString() == "0" || dsresult.Tables[0].Rows[0]["Debit"] == null)
// {
// //lblClosing.Text = "Cr. " + dsresult.Tables[0].Rows[0]["Credit"];
// // ReSharper disable once UnusedVariable
// foreach (DataRow row in dsresult.Tables[2].Rows)
// {
// dsresult.Tables[2].Rows[0][6] = 0;
// dsresult.Tables[2].Rows[0][7] = dsresult.Tables[0].Rows[0]["Credit"];
// }
// }
// else
// {
// //lblClosing.Text = "Dr. " + dsresult.Tables[0].Rows[0]["Debit"];
// // ReSharper disable once UnusedVariable
// foreach (DataRow row in dsresult.Tables[2].Rows)
// {
// dsresult.Tables[2].Rows[0][6] = dsresult.Tables[0].Rows[0]["Debit"];
// dsresult.Tables[2].Rows[0][7] = 0;
// }
// }
// btnExportExcel.Visible = false;
//}
//foreach (DataRow dr in dsresult.Tables[2].Rows)
//{
// if (dsresult.Tables[0].Rows.Count > 0)
// dsresult.Tables[0].Rows.Add(dr.ItemArray);
//}
gvCashBankReport.DataSource = objResult.resultDT;
gvCashBankReport.DataBind();
PanelVisibility(2);
//var strName = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]) == 0 ? Session[ApplicationSession.TRUSTNAME].ToString() : Session[ApplicationSession.SCHOOLNAME].ToString();
lblHeading.Text = "<b>Cash/Bank Book of " + ddlGeneralLedger.SelectedItem.Text + "</b><br/>" + txtFromDate.Text + " To " + txtToDate.Text;
}
}
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 ddlReceiptMode_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlReceiptMode.SelectedValue != "")
{
var objGeneralLedgerBl = new GeneralLedgerBL();
ApplicationResult objResultSelect;
DataTable dtSelect;
switch (ddlReceiptMode.SelectedValue)
{
case "Cash":
ddlGeneralLedger.ClearSelection();
objResultSelect = objGeneralLedgerBl.GeneralLedger_Select_Receipt_Payment(1, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelect == null)
{
return;
}
dtSelect = objResultSelect.resultDT;
_objControl.BindDropDown_ListBox(dtSelect, ddlGeneralLedger, "AccountName", "LedgerID");
ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", ""));
break;
case "Bank":
ddlGeneralLedger.ClearSelection();
objResultSelect = objGeneralLedgerBl.GeneralLedger_Select_Receipt_Payment(2, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelect == null)
{
return;
}
dtSelect = objResultSelect.resultDT;
_objControl.BindDropDown_ListBox(dtSelect, ddlGeneralLedger, "AccountName", "LedgerID");
ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", ""));
break;
default:
ddlGeneralLedger.ClearSelection();
objResultSelect = objGeneralLedgerBl.GeneralLedger_Select_Receipt_Payment(3, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResultSelect == null)
{
return;
}
dtSelect = objResultSelect.resultDT;
_objControl.BindDropDown_ListBox(dtSelect, ddlGeneralLedger, "AccountName", "LedgerID");
ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", ""));
break;
}
}
else
{
ddlGeneralLedger.Items.Clear();
ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", ""));
}
}
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 btnSave_Click(object sender, EventArgs e)
{
try
{
GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL();
GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO();
ApplicationResult objResultValidate = new ApplicationResult();
int intLedgerID = 0;
objGeneralLedgerBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objGeneralLedgerBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objGeneralLedgerBO.AccountName = txtAccountName.Text;
objGeneralLedgerBO.AccountGroupID = Convert.ToInt32(ddlAccountGroup.SelectedValue);
if (txtOpeningBalance.Text.Length > 0)
{
objGeneralLedgerBO.OpeningBalance = Convert.ToDouble(txtOpeningBalance.Text);
}
if (ddlBalanceType.SelectedValue != "")
{
objGeneralLedgerBO.BalanceType = ddlBalanceType.SelectedValue;
}
objGeneralLedgerBO.Description = txtDescription.Text;
objGeneralLedgerBO.CreatedDate = System.DateTime.UtcNow.AddHours(5.5).ToString();
objGeneralLedgerBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objGeneralLedgerBO.IsDeleted = 0;
objGeneralLedgerBO.LastModifideDate = System.DateTime.UtcNow.AddHours(5.5).ToString();
objGeneralLedgerBO.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
//Code For Validate Department Name
if (ViewState["Mode"].ToString() == "Save")
{
intLedgerID = -1;
}
else if (ViewState["Mode"].ToString() == "Edit")
{
intLedgerID = Convert.ToInt32(ViewState["LedgerID"].ToString());
objGeneralLedgerBO.LedgerID = Convert.ToInt32(ViewState["LedgerID"].ToString());
}
objResultValidate = objGeneralLedgerBL.GeneralLedger_ValidateName(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), txtAccountName.Text, intLedgerID);
if (objResultValidate != null)
{
DataTable dtValidate = new DataTable();
dtValidate = objResultValidate.resultDT;
if (dtValidate.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Ledger name already exist.');</script>");
}
else
{
if (ViewState["Mode"].ToString() == "Save")
{
ApplicationResult objResultSave = new ApplicationResult();
objResultSave = objGeneralLedgerBL.GeneralLedger_Insert(objGeneralLedgerBO, Convert.ToInt32(Session[ApplicationSession.FINANCIALYEAR]));
if (objResultSave.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved successfully.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
ApplicationResult objResultUpdate = new ApplicationResult();
objResultUpdate = objGeneralLedgerBL.GeneralLedger_Update(objGeneralLedgerBO, Session[ApplicationSession.ACCOUNTFROMDATE].ToString());
if (objResultUpdate.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>");
}
}
ClearAll();
BindGrid();
PanelVisibility(1);
}
}
}
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_Click(object sender, EventArgs e)
{
try
{
//var objGeneralLedgerBl = new GeneralLedgerBL();
//int intIsNarration;
//if (chkNarration.Checked)
//{
// intIsNarration = 1;
// var bfield = new BoundField { HeaderText = "Narration", DataField = "Description" };
// bfield.HeaderStyle.Width = new Unit("30%");
// bfield.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
// bfield.HeaderStyle.VerticalAlign = VerticalAlign.Top;
// bfield.ItemStyle.Width = new Unit("30%");
// bfield.ItemStyle.HorizontalAlign = HorizontalAlign.Left;
// bfield.ItemStyle.VerticalAlign = VerticalAlign.Top;
// bfield.ItemStyle.Wrap = false;
// gvGeneralLedgerReport.Columns.Add(bfield);
//}
//else
// intIsNarration = 0;
//var objResult = objGeneralLedgerBl.GeneralLedgerReport(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ddlGeneralLedger.SelectedValue), txtFromDate.Text, txtToDate.Text, intIsNarration);
//if (objResult != null)
//{
// var dsresult = objResult.resutlDS;
// foreach (DataRow dr in dsresult.Tables[1].Rows)
// {
// if (dsresult.Tables[0].Rows.Count > 0)
// dsresult.Tables[0].Rows.Add(dr.ItemArray);
// }
// double dbCrAmt = 0, dbDrAmt = 0;
// if (dsresult.Tables[0].Rows.Count > 0)
// {
// if (dsresult.Tables[0].Rows[0]["Debit"].ToString() == "" || dsresult.Tables[0].Rows[0]["Debit"].ToString() == "0" || dsresult.Tables[0].Rows[0]["Debit"] == null)
// {
// if (dsresult.Tables[0].Rows[0]["Credit"].ToString() == "" || dsresult.Tables[0].Rows[0]["Credit"] == null)
// {
// }
// else
// {
// dbCrAmt = Convert.ToInt32(dsresult.Tables[0].Rows[0]["Credit"]);
// }
// dbDrAmt = 0;
// }
// else
// {
// if (dsresult.Tables[0].Rows[0]["Debit"].ToString() == "" || dsresult.Tables[0].Rows[0]["Debit"] == null)
// {
// }
// else
// {
// dbDrAmt = Convert.ToDouble(dsresult.Tables[0].Rows[0]["Debit"]);
// }
// dbCrAmt = 0;
// }
// }
// if (dsresult.Tables[2].Rows.Count > 0)
// {
// if (dsresult.Tables[2].Rows[0][6].ToString() == "" || dsresult.Tables[2].Rows[0][6].ToString() == "0" || dsresult.Tables[2].Rows[0][6] == null)
// dbDrAmt += 0;
// else
// dbDrAmt += Convert.ToDouble(dsresult.Tables[2].Rows[0][6]);
// if (dsresult.Tables[2].Rows[0][7].ToString() == "" || dsresult.Tables[2].Rows[0][7].ToString() == "0" || dsresult.Tables[2].Rows[0][7] == null)
// dbCrAmt += 0;
// else
// dbCrAmt += Convert.ToDouble(dsresult.Tables[2].Rows[0][7]);
// }
// if (dsresult.Tables[1].Rows.Count > 0)
// {
// if (dbDrAmt > dbCrAmt)
// {
// //lblClosing.Text = "Cr. " + (dbDrAmt - dbCrAmt);
// // ReSharper disable once UnusedVariable
// foreach (DataRow row in dsresult.Tables[2].Rows)
// {
// dsresult.Tables[2].Rows[0][6] = 0;
// dsresult.Tables[2].Rows[0][7] = (dbDrAmt - dbCrAmt);
// }
// }
// else if (dbDrAmt < dbCrAmt)
// {
// //lblClosing.Text = "Dr. " + (dbCrAmt - dbDrAmt);
// // ReSharper disable once UnusedVariable
// foreach (DataRow row in dsresult.Tables[2].Rows)
// {
// dsresult.Tables[2].Rows[0][6] = (dbCrAmt - dbDrAmt);
// dsresult.Tables[2].Rows[0][7] = 0;
// }
// }
// else
// {
// //lblClosing.Text = "0";
// dsresult.Tables[2].Rows[0][6] = 0;
// dsresult.Tables[2].Rows[0][7] = 0;
// }
// btnExportExcel.Visible = true;
// }
// else
// {
// if (dsresult.Tables[0].Rows[0]["Debit"].ToString() == "" || dsresult.Tables[0].Rows[0]["Debit"].ToString() == "0" || dsresult.Tables[0].Rows[0]["Debit"] == null)
// {
// //lblClosing.Text = "Cr. " + dsresult.Tables[0].Rows[0]["Credit"];
// // ReSharper disable once UnusedVariable
// foreach (DataRow row in dsresult.Tables[2].Rows)
// {
// dsresult.Tables[2].Rows[0][6] = 0;
// dsresult.Tables[2].Rows[0][7] = dsresult.Tables[0].Rows[0]["Credit"];
// }
// }
// else
// {
// //lblClosing.Text = "Dr. " + dsresult.Tables[0].Rows[0]["Debit"];
// // ReSharper disable once UnusedVariable
// foreach (DataRow row in dsresult.Tables[2].Rows)
// {
// dsresult.Tables[2].Rows[0][6] = dsresult.Tables[0].Rows[0]["Debit"];
// dsresult.Tables[2].Rows[0][7] = 0;
// }
// }
// btnExportExcel.Visible = false;
// }
// foreach (DataRow dr in dsresult.Tables[2].Rows)
// {
// if (dsresult.Tables[0].Rows.Count > 0)
// dsresult.Tables[0].Rows.Add(dr.ItemArray);
// }
ApplicationResult objResult = new ApplicationResult();
GeneralLedgerBL objGeneralLedgerbl = new GeneralLedgerBL();
string strChk = string.Empty;
int intCheck = 0;
if (chkNarration.Checked == true)
{
intCheck = 1;
}
else
{
intCheck = 0;
}
int intvalidate = 0;
string strMainTable = string.Empty, strSubTable = string.Empty, strGeneralLedger = string.Empty;
for (int i = 0; i < gvParameter.Rows.Count; i++)
{
CheckBox chkGeneralLedger = (CheckBox)gvParameter.Rows[i].FindControl("chk");
if (chkGeneralLedger.Checked == true)
{
objResult = objGeneralLedgerbl.GeneralLedgerReport(Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()), Convert.ToInt32(gvParameter.Rows[i].Cells[0].Text), txtFromDate.Text, txtToDate.Text, intCheck);
if (objResult != null)
{
strMainTable =
"<table style='vertical-align: top; width: 900px; font-family: Verdana; border: thin solid #000000; font-size: 11px; text-align: center;'>" +
"<tr>" +
"<td style='text-align: center; width: 100%;' colspan='6'>" +
"<b>VIDYUT BOARD VIDYALAYA<br/>" +
"General Ledger : " + gvParameter.Rows[i].Cells[2].Text + "<br/>" +
txtFromDate.Text + " to " + txtToDate.Text +
"</b>" +
"</td>" +
"</tr>" +
"<tr>" +
"<td style='text-align: center; width: 100%; height: 25px;' colspan='6'>" +
"</td>" +
"</tr>" +
"<tr>" +
"<td style='text-align: center; width: 10%; border: thin solid #000000;'>" +
"<b>Date</b>" +
"</td>" +
"<td style='text-align: center; width: 50%; border: thin solid #000000;'>" +
"<b>Particulars</b>" +
"</td>" +
"<td style='text-align: center; width: 10%; border: thin solid #000000;'>" +
"<b>Voucher Type</b>" +
"</td>" +
"<td style='text-align: center; width: 10%; border: thin solid #000000;'>" +
"<b>Voucher No</b>" +
"</td>" +
"<td style='text-align: center; width: 10%; border: thin solid #000000;'>" +
"<b>Debit</b>" +
"</td>" +
"<td style='text-align: center; width: 10%; border: thin solid #000000;'>" +
"<b>Credit</b>" +
"</td>" +
"</tr>";
for (int j = 0; j < objResult.resultDT.Rows.Count; j++)
{
string strDebit = objResult.resultDT.Rows[j]["Debit"].ToString();
if (strDebit == "0.00")
{
strDebit = "";
}
string strCredit = objResult.resultDT.Rows[j]["Credit"].ToString();
if (strCredit == "0.00")
{
strCredit = "";
}
strSubTable += "<tr>" +
"<td style='text-align: left; width: 10%; border: thin solid #000000; height: 100%; vertical-align: top;'>" +
objResult.resultDT.Rows[j]["OperationDate"].ToString() +
"</td>" +
"<td style='text-align: left; width: 50%; border: thin solid #000000; height: 100%; vertical-align: top;'>" +
objResult.resultDT.Rows[j]["Particulars"].ToString() +
"</td>" +
"<td style='text-align: left; width: 10%; border: thin solid #000000; height: 100%; vertical-align: top;'>" +
objResult.resultDT.Rows[j]["VoucherType"].ToString() +
"</td>" +
"<td style='text-align: left; width: 10%; border: thin solid #000000; height: 100%; vertical-align: top;'>" +
objResult.resultDT.Rows[j]["VoucherNo"].ToString() +
"</td>" +
"<td style='text-align: right; width: 10%; border: thin solid #000000; height: 100%; vertical-align: top;'>" +
strDebit +
"</td>" +
"<td style='text-align: right; width: 10%; border: thin solid #000000; height: 100%; vertical-align: top;'>" +
strCredit +
"</td>" +
"</tr>";
}
}
}
else
{
intvalidate = intvalidate + 1;
}
strGeneralLedger += strMainTable + strSubTable;
//break;
strMainTable = "";
strSubTable = "";
}
if (gvParameter.Rows.Count == intvalidate)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Atleast select one Account Name.');</script>");
}
else
{
Response.Clear();
Response.Buffer = true;
string Pattern = "[^a-zA-Z0-9 ]";
//Regex oRegex = new Regex(Pattern, RegexOptions.IgnoreCase);
//MatchCollection matches = oRegex.Matches(ddlProject.SelectedItem.ToString());
//string strFileName = oRegex.Replace(ddlProject.SelectedItem.ToString(), "");
//strFileName = System.Text.RegularExpressions.Regex.Replace(strFileName, @"\s+", " ");
//strFileName = strFileName.Replace(" ", "-");
Response.AddHeader("content-disposition",
"attachment;filename=General_Ledger_Report_" + "From_" + txtFromDate.Text + "_To_" +
txtToDate.Text + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
string content = "<div align='center' style='font-family:verdana;font-size:13px'>" +
strGeneralLedger + "</div>";
Response.Output.Write(content);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Flush();
Response.End();
//objResult = objGeneralLedgerbl.GeneralLedgerReport(Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()), strChk, txtFromDate.Text, txtToDate.Text, intCheck);
//gvGeneralLedgerReport.DataSource = objResult.resultDT;
//gvGeneralLedgerReport.DataBind();
PanelVisibility(2);
//var strName = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]) == 0 ? Session[ApplicationSession.TRUSTNAME].ToString() : Session[ApplicationSession.SCHOOLNAME].ToString();
//lblHeading.Text = "<b>General Ledgers: </b><br/>" + txtFromDate.Text + " To " + txtToDate.Text;
//}
}
}
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>");
}
}
