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