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