private void setDateAsFinancialYear() { DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear(); dtp_StartDate.Text = dtFiancialYear.Rows[0]["startyear"].ToString(); dtp_EndDate.Text = dtFiancialYear.Rows[0]["endyear"].ToString(); }
private void MonthlyIntrest() { dgv_InterestDetail.Rows.Clear(); DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear(); DataTable openingData = new DataTable(); try { DataTable dtCashDetails = new DataTable(); dtCashDetails.Columns.Add(); dtCashDetails.Columns.Add(); double sumOpeningData = Convert.ToDouble(_objGirviCommon.getBhandwalWithLastDate(dtFiancialYear.Rows[0]["startyear"].ToString())); double sumdtInterest = 0; int j = 0; int rowGrid = 0; int month = Convert.ToInt32(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).Month); for (int i = 0; i <= (Convert.ToDateTime(dtFiancialYear.Rows[0]["endyear"].ToString()) - Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString())).TotalDays + 1; i++) { string Date = Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).ToShortDateString(); double dtInterest = _objGirviCommon.getInterestTotal(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).ToShortDateString().ToString()); int monthdate = Convert.ToInt32(Convert.ToDateTime(Date).Month); if (month == 13) { month = 1; } if (month == monthdate) { sumdtInterest += dtInterest; } else { string strMonthName = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(month); dgv_InterestDetail.Rows.Add(strMonthName, sumdtInterest); month++; sumdtInterest = 0; sumdtInterest = _objGirviCommon.getInterestTotal(Date); rowGrid++; } j++; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bttn_Show_Click(object sender, EventArgs e) { DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear(); for (int i = 0; i <= (Convert.ToDateTime(dtp_EndDate.Text) - Convert.ToDateTime(dtp_StartDate.Text)).TotalDays + 1; i++) { string Date = Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(i).ToShortDateString(); foreach (DataRow dtr in _objBalanceSheet.getallCreditDetailsOnDate(Date).Rows) { dgv_record.Rows.Add(Date, dtr["Credit"], "", dtr["FromAccount"]); } foreach (DataRow dtr in _objBalanceSheet.getallDebitDetailsOnDate(Date).Rows) { dgv_record.Rows.Add(Date, "", dtr["Debit"], dtr["FromAccount"]); } } }
private void setDateAsFinancialYear() { try { ClsFinancialYear _objFinancialYear = new ClsFinancialYear(); DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear(); dtp_StartDate.Text = dtFiancialYear.Rows[0]["startyear"].ToString(); dtp_EndDate.Text = dtFiancialYear.Rows[0]["endyear"].ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void ProfitLoss() { ClsFinancialYear _objFinancialYear = new ClsFinancialYear(); DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear(); dgv_Expence.Rows.Clear(); dgv_Income.Rows.Clear(); double InterestTotal = _objGirviCommon.getTotalInterestBySelectectedFinancialYear(dtFiancialYear.Rows[0]["startyear"].ToString(), dtFiancialYear.Rows[0]["endyear"].ToString()); dgv_Income.Rows.Add(); dgv_Income.Rows[dgv_Income.RowCount - 1].Cells["DiParticular"].Value = "Interest Receipts"; dgv_Income.Rows[dgv_Income.RowCount - 1].Cells["DiAmount"].Value = InterestTotal; foreach (DataRow dr in _objga.getTrialBalanceDatewise("Direct Income", dtFiancialYear.Rows[0]["startyear"].ToString(), dtFiancialYear.Rows[0]["endyear"].ToString()).Rows) { dgv_Income.Rows.Add(); dgv_Income.Rows[dgv_Income.RowCount - 1].Cells["DiParticular"].Value = _objga.getallAccountLedgerDetailsByLedgerId(dr["LedgerId"].ToString()).Rows[0]["Name"]; dgv_Income.Rows[dgv_Income.RowCount - 1].Cells["DiAmount"].Value = dr["debit"]; } foreach (DataRow dr in _objga.getTrialBalanceDatewise("Direct Expenses", dtFiancialYear.Rows[0]["startyear"].ToString(), dtFiancialYear.Rows[0]["endyear"].ToString()).Rows) { dgv_Expence.Rows.Add(); dgv_Expence.Rows[dgv_Expence.RowCount - 1].Cells["DeParticular"].Value = _objga.getallAccountLedgerDetailsByLedgerId(dr["LedgerId"].ToString()).Rows[0]["Name"]; dgv_Expence.Rows[dgv_Expence.RowCount - 1].Cells["DeAmount"].Value = dr["credit"]; } double Income = _objCommon.sumGridViewColumn(dgv_Income, "DiAmount"); double Expenes = _objCommon.sumGridViewColumn(dgv_Expence, "DeAmount"); double NetProfit = Income - Expenes; dgv_Expence.Rows.Add(); dgv_Expence.Rows[dgv_Expence.RowCount - 1].Cells["DeParticular"].Value = "Net Profit for the year transferred to capital account"; dgv_Expence.Rows[dgv_Expence.RowCount - 1].Cells["DeAmount"].Value = NetProfit; lbl_TotalExpences.Text = Income.ToString(); lbl_TotalIncome.Text = _objCommon.sumGridViewColumn(dgv_Expence, "DeAmount").ToString(); }
/// <summary> /// Form Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frmBalanceSheet_Load(object sender, EventArgs e) { DataTable dtFinancialYear = _objFinancialYear.getSelectedFinancialYear(); if (dtFinancialYear.Rows.Count > 0) { txtFromDate.Text = dtFinancialYear.Rows[0]["startyear"].ToString(); txtTodate.Text = dtFinancialYear.Rows[0]["endyear"].ToString(); } try { FillGrid(); isFormLoad = true; isFormLoad = false; } catch (Exception ex) { MessageBox.Show("BS :8" + ex.Message, "ShopIn", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void bttn_ViewRecord_Click(object sender, EventArgs e) { dgv_CashDetail.Rows.Clear(); DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear(); DataTable openingData = new DataTable(); try { DataTable dtCashDetails = new DataTable(); dtCashDetails.Columns.Add(); dtCashDetails.Columns.Add(); dtCashDetails.Columns.Add(); dtCashDetails.Columns.Add(); dtCashDetails.Columns.Add(); dtCashDetails.Columns.Add(); dtCashDetails.Columns.Add(); dtCashDetails.Columns.Add(); //openingData = _objGirviCommon.getOpeningLedger("Cash-In-Hand"); openingData = _objGirviCommon.getOpeningBhandwal();//(dtFiancialYear.Rows[0]["StartDate"].ToString()); //double sumOpeningData = _objCommon.sumDataTableColumn(openingData, "openingBal"); double sumOpeningData = Convert.ToDouble(_objGirviCommon.getBhandwalWithLastDate(dtFiancialYear.Rows[0]["startyear"].ToString())); // Convert.ToDouble(openingData.Rows[0]["Bhandval"].ToString()); int count = 0; if (dtCashDetails.Rows.Count == 0) { if (openingData.Rows.Count == 0) { count = 0; } else { dtCashDetails.Rows.Add(openingData.Rows[0]["Date"].ToString(), "", "", "", "", "", sumOpeningData.ToString()); count = 1; } } if (count == 1) { double sumdtAddGirvi = 0, sumdtReleaseGirvi = 0, sumdtInterest = 0, sumdtAddAmount = 0, sumdtAmountGiven = 0; int j = 0; int rowGrid = 0; int month = Convert.ToInt32(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).Month); for (int i = 0; i <= (Convert.ToDateTime(dtFiancialYear.Rows[0]["endyear"].ToString()) - Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString())).TotalDays + 1; i++) { //if (Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).Day.ToString() == "2") //{ // j--; //} //string day = Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).Day.ToString(); string Date = Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).ToShortDateString(); //double dtAddGirvi = _objGirviCommon.getAddgirviondate(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).ToShortDateString().ToString()); double dtAddGirvi = _objGirviCommon.getAddgirviondate(Date); double dtAmountGiven = _objGirviCommon.getamountaddtotal(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).ToShortDateString().ToString()); double dtAddAmount = _objGirviCommon.getexpenseTotal(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).ToShortDateString().ToString()); double dtReleaseGirvi = _objGirviCommon.getAddreleaseondate(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).ToShortDateString().ToString()); double dtInterest = _objGirviCommon.getInterestTotal(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).ToShortDateString().ToString()); double previousvalue = Convert.ToDouble(dtCashDetails.Rows[(i + 1) - 1][6].ToString()); dtCashDetails.Rows.Add(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).AddDays(j).ToShortDateString(), dtAddGirvi, dtReleaseGirvi, dtInterest, dtAddAmount, dtAmountGiven, (previousvalue + Convert.ToDouble(dtAddGirvi) - Convert.ToDouble(dtReleaseGirvi)).ToString()); double final = previousvalue + Convert.ToDouble(dtAddGirvi) + Convert.ToDouble(dtAddAmount) + Convert.ToDouble(dtReleaseGirvi) + Convert.ToDouble(dtInterest); int monthdate = Convert.ToInt32(Convert.ToDateTime(Date).Month); if (month == 13) { month = 1; } if (month == monthdate) { sumdtAddGirvi += dtAddGirvi; sumdtInterest += dtInterest; sumdtReleaseGirvi += dtReleaseGirvi; sumdtAddAmount += dtAddAmount; sumdtAmountGiven += dtAmountGiven; } else { double previous_value = 0; string strMonthName = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(month); if (rowGrid == 0) { previous_value = sumOpeningData; } else { string dgv = dgv_CashDetail.Rows[rowGrid - 1].Cells["OpeningValue"].Value.ToString(); previous_value = Convert.ToDouble(dgv_CashDetail.Rows[rowGrid - 1].Cells["OpeningValue"].Value.ToString()); } dgv_CashDetail.Rows.Add(strMonthName, previous_value, sumdtAddGirvi, sumdtAddGirvi + previous_value, sumdtReleaseGirvi, previousvalue, sumdtInterest, sumdtAddAmount, sumdtAmountGiven); month++; sumdtAddGirvi = 0; sumdtInterest = 0; sumdtReleaseGirvi = 0; sumdtAddAmount = 0; sumdtAddGirvi = _objGirviCommon.getAddgirviondate(Date); sumdtAddAmount = _objGirviCommon.getexpenseTotal(Date); sumdtAmountGiven = _objGirviCommon.getamountaddtotal(Date); sumdtReleaseGirvi = _objGirviCommon.getAddreleaseondate(Date); sumdtInterest = _objGirviCommon.getInterestTotal(Date); rowGrid++; } j++; } } else { MessageBox.Show("Opening Balance is not entered"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FillGrids() { DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear(); dgv_GirviDetail.Rows.Clear(); dgv_PaymentDetail.Rows.Clear(); if (true)//pusad { if (txt_KhatawaniNo.Text == "") { //err_khatawanino.Visible = true; } else { totalloanamountsum = 0; DataTable girvi_data = _objGirviAdd.getGirviDetailsByKhatawaniInterest(txt_KhatawaniNo.Text); int j = 0; for (int i = 0; i < girvi_data.Rows.Count; i++) { int girvi_no = Convert.ToInt32(girvi_data.Rows[i]["GirviRecordNo"]); string pagenumber = _objGirviCommon.getPageNumber(girvi_data.Rows[i]["Date_of_deposit"].ToString()); // string mobileno = _objGirviAdd.getCustomerMaster(girvi_data.Rows[i]["Contact_No"].ToString()).Rows[0]["Contact_No"].ToString(); string Dateofrelease = _objKhatawaniGiviRecord.getDateofrelease(girvi_no); string str = _objKhatawaniGiviRecord.getgirviitem(girvi_no.ToString()) + " व्याज: दि." + girvi_data.Rows[i]["Date_of_deposit"] + "ते दि." + Dateofrelease; string interest = _objKhatawaniGiviRecord.getreleaseinterest(girvi_no); int resultless = 0; if (Dateofrelease != "") { resultless = DateTime.Compare(Convert.ToDateTime(Dateofrelease), Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString())); } if (resultless >= 0) { dgv_GirviDetail.Rows.Add(girvi_data.Rows[i]["receipt_no"].ToString(), girvi_data.Rows[i]["Amount"].ToString() + "\n " + interest, girvi_data.Rows[i]["Date_of_deposit"].ToString(), pagenumber, str.Trim()); totalloanamountsum = totalloanamountsum + (Convert.ToDouble(girvi_data.Rows[i]["Amount"].ToString()));//lalit remove interest if (girvi_data.Rows[i]["Status"].ToString() == "Release") { dgv_GirviDetail.Rows[j].DefaultCellStyle.BackColor = Color.Red; dgv_GirviDetail.Rows[j].DefaultCellStyle.ForeColor = Color.White; } j++; } } txt_LoanAmount.Text = totalloanamountsum.ToString(); totalpaidsum = 0; DataTable paid = _objKhatawaniGiviRecord.getgirvivaluesByFinancialYear(txt_KhatawaniNo.Text, dtFiancialYear.Rows[0]["startyear"].ToString(), dtFiancialYear.Rows[0]["endyear"].ToString()); if (paid.Rows.Count > 0) { for (int i = 0; i < paid.Rows.Count; i++) { string str; if (rbt_Marathi.Checked == true) { str = paid.Rows[i]["AmountDeposit"].ToString() + " दि. " + paid.Rows[i]["dateOfRelease"].ToString() + " चे मुद्दल, " + paid.Rows[i]["Interest_Amount"].ToString() + " व्याज बद्दल"; } else { str = paid.Rows[i]["AmountDeposit"].ToString() + " दि." + paid.Rows[i]["dateOfRelease"].ToString() + " चे मुद्दल, " + paid.Rows[i]["Interest_Amount"].ToString() + " व्याज बद्दल"; } string pagenumber = _objGirviCommon.getPageNumber(paid.Rows[i]["dateOfRelease"].ToString()); dgv_PaymentDetail.Rows.Add(paid.Rows[i]["pavtino"].ToString(), paid.Rows[i]["AmountDeposit"].ToString(), paid.Rows[i]["dateOfRelease"].ToString(), pagenumber, str); totalpaidsum = totalpaidsum + (Convert.ToDouble(paid.Rows[i]["AmountDeposit"].ToString())); } } txt_PaidAmount.Text = totalpaidsum.ToString(); txt_AccountBalance.Text = (Convert.ToDouble(txt_LoanAmount.Text) - Convert.ToDouble(txt_PaidAmount.Text)).ToString(); } if (dgv_GirviDetail.Rows.Count > 0) { dgv_GirviDetail.Rows[0].Selected = false; } if (dgv_PaymentDetail.Rows.Count > 0) { dgv_PaymentDetail.Rows[0].Selected = false; } } else { } }
public void khatawaniBook() { DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear(); if (oPrintersetting.ShowDialog() == DialogResult.OK) { for (int j = 0; j < dgv_KhatawaniDetail.Rows.Count; j++) { if (Convert.ToBoolean(dgv_KhatawaniDetail.Rows[j].Cells["chk"].Value) == true) { double totalloanamountsum = 0; DataTable girvi_data = _objGirviAdd.getGirviDetailsByKhatawaniInterest(dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString()); DataTable dtGirviDetailsKhatwani = new DataTable(); dtGirviDetailsKhatwani.Columns.Add("RecieptNoNave"); dtGirviDetailsKhatwani.Columns.Add("AmountPaidNave"); dtGirviDetailsKhatwani.Columns.Add("DateOfDepositNave"); dtGirviDetailsKhatwani.Columns.Add("PageNoNave"); dtGirviDetailsKhatwani.Columns.Add("DiscriptionNave"); for (int i = 0; i < girvi_data.Rows.Count; i++) { int girvi_no = Convert.ToInt32(girvi_data.Rows[i]["GirviRecordNo"]); string pagenumber = _objGirviCommon.getPageNumber(girvi_data.Rows[i]["Date_of_deposit"].ToString()); string Dateofrelease = _objKhatawaniGiviRecord.getDateofrelease(girvi_no); string str = _objKhatawaniGiviRecord.getgirviitem(girvi_no.ToString()) + " व्याज: दि." + girvi_data.Rows[i]["Date_of_deposit"] + "ते दि." + Dateofrelease; string interest = _objKhatawaniGiviRecord.getreleaseinterest(girvi_no); dtGirviDetailsKhatwani.Rows.Add(girvi_data.Rows[i]["receipt_no"].ToString(), girvi_data.Rows[i]["Amount"].ToString() + "\n " + interest, girvi_data.Rows[i]["Date_of_deposit"].ToString(), pagenumber, str.Trim()); totalloanamountsum = totalloanamountsum + (Convert.ToDouble(girvi_data.Rows[i]["Amount"].ToString()));//lalit remove interest } double totalpaidsum = 0; DataTable dtGirviReleaseKhatwani = new DataTable(); DataTable dtGirvirelease = _objKhatawaniGiviRecord.getgirvivaluesByFinancialYear(dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString(), dtFiancialYear.Rows[0]["startyear"].ToString(), dtFiancialYear.Rows[0]["endyear"].ToString()); dtGirviReleaseKhatwani.Columns.Add("RecieptNoJama"); dtGirviReleaseKhatwani.Columns.Add("AmountPaidJama"); dtGirviReleaseKhatwani.Columns.Add("DateJama"); dtGirviReleaseKhatwani.Columns.Add("PageNoJama"); dtGirviReleaseKhatwani.Columns.Add("DiscriptionJama"); if (dtGirvirelease.Rows.Count > 0) { for (int i = 0; i < dtGirvirelease.Rows.Count; i++) { string str; if (rbt_Marathi.Checked == true) { str = dtGirvirelease.Rows[i]["AmountDeposit"].ToString() + " दि. " + dtGirvirelease.Rows[i]["dateOfRelease"].ToString() + " चे मुद्दल, " + dtGirvirelease.Rows[i]["Interest_Amount"].ToString() + " व्याज बद्दल"; } else { str = dtGirvirelease.Rows[i]["AmountDeposit"].ToString() + " दि." + dtGirvirelease.Rows[i]["dateOfRelease"].ToString() + " चे मुद्दल, " + dtGirvirelease.Rows[i]["Interest_Amount"].ToString() + " व्याज बद्दल"; } string pagenumber = _objGirviCommon.getPageNumber(dtGirvirelease.Rows[i]["dateOfRelease"].ToString()); dtGirviReleaseKhatwani.Rows.Add(dtGirvirelease.Rows[i]["pavtino"].ToString(), dtGirvirelease.Rows[i]["AmountDeposit"].ToString(), dtGirvirelease.Rows[i]["dateOfRelease"].ToString(), pagenumber, str); totalpaidsum = totalpaidsum + (Convert.ToDouble(dtGirvirelease.Rows[i]["AmountDeposit"].ToString())); } } totalpaidsum.ToString(); DataTable dtMerge = _objCommon.mergeTwoDataGrid(dtGirviDetailsKhatwani, dtGirviReleaseKhatwani); CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new CrystalReport.frm_ReportViewer(); SendDataMulti _obj = new SendDataMulti(_objfrm_ReportViewer.ReceiveDataInterestRecordMultiPrint); if (rbt_PrintTrue.Checked == true) { _obj(dtMerge, dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString(), totalloanamountsum.ToString(), totalpaidsum.ToString(), oPrintersetting.PrinterName, true); } else { _obj(dtMerge, dgv_KhatawaniDetail.Rows[j].Cells["KhatawaniNo"].Value.ToString(), totalloanamountsum.ToString(), totalpaidsum.ToString(), oPrintersetting.PrinterName, false); } } } } }
public void FillGrid() { dgv_assets.Rows.Clear(); dgv_liabilities.Rows.Clear(); ClsFinancialYear _objFinancialYear = new ClsFinancialYear(); DataTable dtFiancialYear = _objFinancialYear.getSelectedFinancialYear(); string startdate = dtFiancialYear.Rows[0]["startyear"].ToString(); string enddate = dtFiancialYear.Rows[0]["endyear"].ToString(); DataTable dtNetProfitForPreviousYears = _objBalanceSheet.getValuesFromProfitLossExceptCurrentFinancialYear(); DataTable dtNetProfitForCurrent = _objBalanceSheet.getValuesFromProfitLossTillCurrentFinancialYear(); //////////////////////////////////LIABILITIES////////////////////////////////////// #region LIABILITIES ///Capital Account/// #region Capital Account dgv_liabilities.Rows.Add("I. PROPRIETOR CAPITAL ACCOUNT"); dgv_liabilities.Columns[0].Width = 400; dgv_liabilities.Rows[dgv_liabilities.Rows.Count - 1].DefaultCellStyle.Font = new System.Drawing.Font("Arial", 10, FontStyle.Underline); DataTable dtCapitalAccDetails = new DataTable(); dtCapitalAccDetails.Columns.Add("LedgerName"); dtCapitalAccDetails.Columns.Add("TotalCredit"); dtCapitalAccDetails.Columns.Add("TotalDebit"); dtCapitalAccDetails.Columns.Add("FinalAmount"); DataTable dtAccLedger = _objBalanceSheet.getAcountLedgerFromgroup("Capital Account"); for (int i = 0; i < dtAccLedger.Rows.Count; i++) { DataTable dtCashFlow = _objBalanceSheet.getBalanceCashflow(dtAccLedger.Rows[i]["name"].ToString(), enddate); double sumTotalCredit = _objCommon.sumDataTableColumn(dtCashFlow, "debit"); double sumTotalDebit = _objCommon.sumDataTableColumn(dtCashFlow, "credit"); dtCapitalAccDetails.Rows.Add(dtAccLedger.Rows[i]["name"].ToString(), sumTotalCredit, sumTotalDebit, sumTotalCredit - sumTotalDebit); dgv_liabilities.Rows.Add(dtAccLedger.Rows[i]["name"].ToString(), sumTotalCredit - sumTotalDebit); } dgv_liabilities.Rows.Add("NetProfit Last year", Convert.ToDouble(dtNetProfitForPreviousYears.Rows[0]["NetProfit"])); dgv_liabilities.Rows.Add("Add: Net Profit for the year", dtNetProfitForCurrent.Rows[0]["NetProfit"], _objCommon.sumDataTableColumn(dtCapitalAccDetails, "FinalAmount") + Convert.ToDouble(dtNetProfitForPreviousYears.Rows[0]["NetProfit"]) + Convert.ToDouble(dtNetProfitForCurrent.Rows[0]["NetProfit"])); dgv_liabilities.Rows.Add(); #endregion DataTable dtLiabilitiesGroups = _objBalanceSheet.getAcountFromNature("Liabilities"); foreach (DataRow dtr in dtLiabilitiesGroups.Rows) { DataTable dtAccLedgerLoans = _objBalanceSheet.getAcountLedgerFromgroup(dtr["Under"].ToString()); if (dtAccLedgerLoans.Rows.Count > 0) { dgv_liabilities.Rows.Add(dtr["Under"]); dgv_liabilities.Rows[dgv_liabilities.Rows.Count - 1].DefaultCellStyle.Font = new System.Drawing.Font("Arial", 10, FontStyle.Underline); for (int i = 0; i < dtAccLedgerLoans.Rows.Count; i++) { DataTable dtCashFlow = _objBalanceSheet.getBalanceCashflow(dtAccLedgerLoans.Rows[i]["name"].ToString(), enddate); double sumTotalCredit = _objCommon.sumDataTableColumn(dtCashFlow, "debit"); double sumTotalDebit = _objCommon.sumDataTableColumn(dtCashFlow, "credit"); dtCapitalAccDetails.Rows.Add(dtAccLedgerLoans.Rows[i]["name"].ToString(), sumTotalCredit, sumTotalDebit, sumTotalCredit - sumTotalDebit); if ((sumTotalCredit - sumTotalDebit) > 0) { dgv_liabilities.Rows.Add(dtAccLedgerLoans.Rows[i]["name"].ToString(), "", sumTotalCredit - sumTotalDebit); } } } } #endregion ////////////////////////////////////ASSETS///////////////////////////////////////// #region ASSETS string CashInHand = _objGirviCommon.getCashInHand(enddate); string GahaniKhata = _objGirviCommon.getBhandwalWithLastDate(enddate); dgv_assets.Rows.Add("I. GAHANI KHATA", GahaniKhata); dgv_assets.Rows.Add(); dgv_assets.Rows.Add("II. CASH IN HAND", CashInHand); DataTable dtAssetsGroups = _objBalanceSheet.getAcountFromNature("Assets"); foreach (DataRow dtr in dtAssetsGroups.Rows) { DataTable dtAccLedgerassets = _objBalanceSheet.getAcountLedgerFromgroup(dtr["Under"].ToString()); if (dtAccLedgerassets.Rows.Count > 0) { dgv_assets.Rows.Add(dtr["Under"]); dgv_assets.Rows[dgv_assets.Rows.Count - 1].DefaultCellStyle.Font = new System.Drawing.Font("Arial", 10, FontStyle.Underline); for (int i = 0; i < dtAccLedgerassets.Rows.Count; i++) { DataTable dtCashFlow = _objBalanceSheet.getBalanceCashflow(dtAccLedgerassets.Rows[i]["name"].ToString(), enddate); double sumTotalCredit = _objCommon.sumDataTableColumn(dtCashFlow, "credit"); double sumTotalDebit = _objCommon.sumDataTableColumn(dtCashFlow, "debit"); if ((sumTotalCredit - sumTotalDebit) != 0) { dgv_assets.Rows.Add(dtAccLedgerassets.Rows[i]["name"].ToString(), sumTotalCredit - sumTotalDebit); } } } } #endregion lbl_TotalAssets.Text = _objCommon.sumGridViewColumn(dgv_assets, "AmountAssets").ToString(); lbl_TotalLiabilities.Text = _objCommon.sumGridViewColumn(dgv_liabilities, "Amount2Liabilities").ToString(); dgv_liabilities.CellBorderStyle = DataGridViewCellBorderStyle.None; dgv_assets.CellBorderStyle = DataGridViewCellBorderStyle.None; }