/// <summary> /// on combobox account group text changing /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmbAccountGroup_TextChanged(object sender, EventArgs e) { try { if (isLoad) { int index = cmbAccountGroup.SelectedIndex; string strinr = cmbAccountGroup.Text.ToString(); int dec = cmbAccountGroup.SelectedIndex; int inRowcount = dgvMultipleAccountLedger.RowCount; AccountGroupSP spAccountGroup = new AccountGroupSP(); string strNature; strNature = spAccountGroup.MultipleAccountLedgerCrOrDr(cmbAccountGroup.Text); for (int i = 0; i < inRowcount; i++) { if (strNature == "Assets" || strNature == "Income") { dgvMultipleAccountLedger.Rows[i].Cells["dgvcmbDebitOrCredit"].Value = "Cr"; } else if (strNature == "Expenses" || strNature == "Liabilities") { dgvMultipleAccountLedger.Rows[i].Cells["dgvcmbDebitOrCredit"].Value = "Dr"; } } } } catch (Exception ex) { formMDI.infoError.ErrorString = "MAL12:" + ex.Message; } }
/// <summary> /// Function to call from CashFlow for current asset grid fill /// </summary> public void CashOutflowCurrentAssetGridFill() { decimal decBalanceTotal = 0; try { AccountGroupSP spAccountGroup = new AccountGroupSP(); DataTable dtbl = new DataTable(); dtbl = spAccountGroup.CashOutflowCurrentAssetAccountGroupWiseReportViewAll(decAccountGroupId, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text)); dgvAccountGroupWiseReport.DataSource = dtbl; if (dtbl.Rows.Count > 0) { for (int i = 0; i < dgvAccountGroupWiseReport.RowCount; i++) { decBalanceTotal += Convert.ToDecimal(dgvAccountGroupWiseReport.Rows[i].Cells["balance1"].Value.ToString()); } } if (decBalanceTotal < 0) { decBalanceTotal = -1 * decBalanceTotal; lblBalanceTotal.Text = decBalanceTotal.ToString() + "Cr"; } else { lblBalanceTotal.Text = decBalanceTotal.ToString() + "Dr"; } } catch (Exception ex) { formMDI.infoError.ErrorString = "AGWREP11:" + ex.Message; } }
/// <summary> /// Function to print report /// </summary> /// <param name="fromDate"></param> /// <param name="toDate"></param> public void Print(DateTime fromDate, DateTime toDate) { try { FinancialStatementSP spFinance = new FinancialStatementSP(); AccountGroupSP spAccountGroup = new AccountGroupSP(); DataSet dsAccountGroup = new DataSet(); DataTable dtblAccountGroup = spAccountGroup.AccountGroupReportFill(fromDate, toDate); string strSum = lblBalanceTotal.Text; DataTable dtblSum = new DataTable(); dtblSum.Columns.Add("Sum", typeof(string)); DataRow dr = dtblSum.NewRow(); dr[0] = strSum; dtblSum.Rows.InsertAt(dr, 0); DataTable dtblCompany = spFinance.FundFlowReportPrintCompany(1); dsAccountGroup.Tables.Add(dtblAccountGroup); dsAccountGroup.Tables.Add(dtblCompany); dsAccountGroup.Tables.Add(dtblSum); frmReport frmReport = new frmReport(); frmReport.MdiParent = formMDI.MDIObj; frmReport.AccountGroup(dsAccountGroup); } catch (Exception ex) { formMDI.infoError.ErrorString = "AGR1:" + ex.Message; } }
/// <summary> /// Function to fill the report in grid /// </summary> public void GridFill() { decimal decBalanceTotal = 0; try { AccountGroupSP spAccountGroup = new AccountGroupSP(); DataTable dtbl = new DataTable(); dtbl = spAccountGroup.AccountGroupWiseReportViewAll(decAccountGroupId, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text)); if (decAccountGroupId == 6) { FinancialStatementSP spFinace = new FinancialStatementSP(); CalculationMethod(); decimal dcOpeninggStock = spFinace.StockValueGetOnDate(PublicVariables._dtFromDate, calculationMethod, true, true); dcOpeninggStock = Math.Round(dcOpeninggStock, PublicVariables._inNoOfDecimalPlaces); int inRowCount = dtbl.Rows.Count; DataRow dr = dtbl.NewRow(); dr["SlNo"] = inRowCount + 1; dr["accountGroupId"] = -2; dr["ledgerId"] = 0; dr["name"] = "Opening Stock"; if (dcOpeninggStock >= 0) { dr["OpeningBalance"] = dcOpeninggStock + "Dr"; dr["Balance"] = dcOpeninggStock + "Dr"; } else { dr["OpeningBalance"] = dcOpeninggStock + "Cr"; dr["Balance"] = dcOpeninggStock + "Cr"; } dr["debit"] = Math.Round(Convert.ToDecimal(0.00000), PublicVariables._inNoOfDecimalPlaces).ToString() + ".00"; dr["credit"] = Math.Round(Convert.ToDecimal(0.00000), PublicVariables._inNoOfDecimalPlaces).ToString() + ".00"; dr["balance1"] = dcOpeninggStock; dtbl.Rows.InsertAt(dr, inRowCount); } dgvAccountGroupWiseReport.DataSource = dtbl; if (dtbl.Rows.Count > 0) { for (int i = 0; i < dgvAccountGroupWiseReport.RowCount; i++) { decBalanceTotal += Convert.ToDecimal(dgvAccountGroupWiseReport.Rows[i].Cells["balance1"].Value.ToString()); } } if (decBalanceTotal < 0) { decBalanceTotal = -1 * decBalanceTotal; lblBalanceTotal.Text = decBalanceTotal.ToString() + "Cr"; } else { lblBalanceTotal.Text = decBalanceTotal.ToString() + "Dr"; } } catch (Exception ex) { formMDI.infoError.ErrorString = "AGWREP2:" + ex.Message; } }
/// <summary> /// Function to fill accountgroup combobox /// </summary> /// <param name="cmbAccountGroup"></param> public void AccountGroupComboFill(ComboBox cmbAccountGroup) { try { cmbAccountGroup.Enabled = true; AccountGroupSP spAccountGroup = new AccountGroupSP(); spAccountGroup.BillAllocationAccountGroupFill(cmbAccountGroup, true); } catch (Exception ex) { formMDI.infoError.ErrorString = "BA2:" + ex.Message; } }
/// <summary> /// Function to delete account group /// </summary> public void Delete() { try { if (isDefault == true) { Messages.InformationMessage("Can't delete build in account group"); } //else if (PublicVariables.isMessageDelete) //{ else if (Messages.DeleteConfirmation()) { AccountGroupInfo InfoAccountGroup = new AccountGroupInfo(); AccountGroupSP spAccountGroup = new AccountGroupSP(); if ((spAccountGroup.AccountGroupReferenceDelete(decAccountGroupIdForEdit) == -1)) { Messages.ReferenceExistsMessage(); } else { Messages.DeletedMessage(); btnSave.Text = "Save"; btnDelete.Enabled = false; Clear(); } } //} //else //{ // AccountGroupInfo InfoAccountGroup = new AccountGroupInfo(); // AccountGroupSP spAccountGroup = new AccountGroupSP(); // if ((spAccountGroup.AccountGroupReferenceDelete(decAccountGroupIdForEdit) == -1)) // { // Messages.ReferenceExistsMessage(); // } // else // { // Messages.DeletedMessage(); // btnSave.Text = "Save"; // btnDelete.Enabled = false; // Clear(); // } //} } catch (Exception ex) { formMDI.infoError.ErrorString = "AG7:" + ex.Message; } }
/// <summary> /// Function to fill ledgers as TreeMode /// </summary> /// <param name="tn"></param> public void FillTree(TreeNode tn) { try { DataTable dtb = new DataTable(); AccountGroupSP spAccountGroup = new AccountGroupSP(); dtb = spAccountGroup.AccountGroupViewAllByGroupUnder(Convert.ToDecimal(tn.Name)); AccountLedgerSP ledgerSP = new AccountLedgerSP(); if (dtb.Rows.Count > 0) { foreach (DataRow dr in dtb.Rows) { tn.Nodes.Add(dr["accountGroupId"].ToString(), dr["accountGroupName"].ToString()); tn.ExpandAll(); if (tn.LastNode != null) { tn.LastNode.ForeColor = Color.Red; } else { tn.LastNode.ForeColor = Color.Blue; } } foreach (TreeNode tn1 in tn.Nodes) { FillTree(tn1); DataTable dtb1 = ledgerSP.AccountLedgerViewAllByLedgerName(Convert.ToDecimal(tn1.Name)); foreach (DataRow dr in dtb1.Rows) { tn1.Nodes.Add(dr["ledgerId"].ToString(), dr["ledgerName"].ToString()); tn1.ExpandAll(); if (tn1.LastNode != null) { tn1.LastNode.ForeColor = Color.Blue; } else { tn.LastNode.ForeColor = Color.Red; } } } } } catch (Exception ex) { formMDI.infoError.ErrorString = "COA1:" + ex.Message; } }
private void cmbGroupUnder_SelectedIndexChanged(object sender, EventArgs e) { try { if (cmbGroupUnder.SelectedValue != null && cmbGroupUnder.SelectedValue.ToString() != "System.Data.DataRowView") { decimal decAccountGroupId = Convert.ToDecimal(cmbGroupUnder.SelectedValue.ToString()); AccountGroupSP spAccountGroup = new AccountGroupSP(); AccountGroupInfo infoAccountGroup = new AccountGroupInfo(); infoAccountGroup = spAccountGroup.AccountGroupView(decAccountGroupId); string strNature = infoAccountGroup.Nature; string strIsAffectGrossProfit = infoAccountGroup.AffectGrossProfit; // string strNature = spAccountGroup.AccountGroupNatureUnderGroup(decAccountGroupId); if (strNature != "NA") { cmbNature.Text = strNature; if (infoAccountGroup.AffectGrossProfit == "1") { cmbAffectGrossProfit.SelectedIndex = 0; } else { cmbAffectGrossProfit.SelectedIndex = 1; } cmbNature.Enabled = false; cmbAffectGrossProfit.Enabled = false; } else { cmbNature.Enabled = true; cmbAffectGrossProfit.Enabled = true; } } } catch (Exception ex) { formMDI.infoError.ErrorString = "AG24:" + ex.Message; } //if (txtAccountGroupName.Text != null && txtAccountGroupName.Text != string.Empty) //{ //} //else //{ // cmbNature.Enabled = true; //} }
/// <summary> /// Function to fill account group combo /// </summary> public void GroupUnderComboFill() { try { AccountGroupSP spAccountGroup = new AccountGroupSP(); DataTable dtblEmployeeCode = new DataTable(); dtblEmployeeCode = spAccountGroup.AccountGroupViewAllComboFill(); cmbGroupUnder.DataSource = dtblEmployeeCode; cmbGroupUnder.ValueMember = "accountGroupId"; cmbGroupUnder.DisplayMember = "accountGroupName"; } catch (Exception ex) { formMDI.infoError.ErrorString = "AG2:" + ex.Message; } }
/// <summary> /// Function to fill master grid /// </summary> public void GridFill() { try { DataTable dtblAccountName = new DataTable(); AccountGroupSP spAccountGroup = new AccountGroupSP(); if (cmbGroupUnderSearch.Text.Trim() == string.Empty) { cmbGroupUnderSearch.Text = "All"; } dtblAccountName = spAccountGroup.AccountGroupSearch(txtAccountGroupNameSearch.Text.Trim(), cmbGroupUnderSearch.Text); dgvAccountGroup.DataSource = dtblAccountName; } catch (Exception ex) { formMDI.infoError.ErrorString = "AG1:" + ex.Message; } }
/// <summary> /// Function to fill the report in grid for fundflow /// </summary> /// <param name="decCS"></param> public void GridFillForFundFlow(decimal decCS) { decimal decBalanceTotal = 0; try { AccountGroupSP spAccountGroup = new AccountGroupSP(); DataTable dtbl = new DataTable(); dtbl = spAccountGroup.AccountGroupWiseReportViewAll(decAccountGroupId, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text)); DataRow drow = dtbl.NewRow(); decimal decCsop = 0; drow[1] = -2; drow[2] = 0; drow[3] = "Closing Stock"; drow[4] = decCsop.ToString() + ".00Dr"; drow[5] = decCS; drow[6] = "0.00"; drow[7] = decCS.ToString() + "Dr"; drow[8] = decCS.ToString(); dtbl.Rows.InsertAt(drow, dtbl.Rows.Count); dgvAccountGroupWiseReport.DataSource = dtbl; if (dtbl.Rows.Count > 0) { for (int i = 0; i < dgvAccountGroupWiseReport.RowCount; i++) { decBalanceTotal += Convert.ToDecimal(dgvAccountGroupWiseReport.Rows[i].Cells["balance1"].Value.ToString()); } } if (decBalanceTotal < 0) { decBalanceTotal = -1 * decBalanceTotal; lblBalanceTotal.Text = decBalanceTotal.ToString() + "Cr"; } else { lblBalanceTotal.Text = decBalanceTotal.ToString() + "Dr"; } } catch (Exception ex) { formMDI.infoError.ErrorString = "AGWREP3:" + ex.Message; } }
/// <summary> /// Function to fill account group combo for Search /// </summary> public void GroupUnderSearchComboFill() { try { AccountGroupSP spAccountGroup = new AccountGroupSP(); DataTable dtblEmployeeCode = new DataTable(); dtblEmployeeCode = spAccountGroup.AccountGroupViewAllComboFill(); DataRow dr = dtblEmployeeCode.NewRow(); dr[1] = "All"; dtblEmployeeCode.Rows.InsertAt(dr, 0); cmbGroupUnderSearch.DataSource = dtblEmployeeCode; cmbGroupUnderSearch.ValueMember = "accountGroupId"; cmbGroupUnderSearch.DisplayMember = "accountGroupName"; } catch (Exception ex) { formMDI.infoError.ErrorString = "AG3:" + ex.Message; } }
/// <summary> /// Function to fill the accountgroup combo box /// </summary> public void AccountGroupComboFill() { try { AccountGroupSP spAccountGroup = new AccountGroupSP(); DataTable dtblAccountGroup = new DataTable(); dtblAccountGroup = spAccountGroup.AccountGroupViewAllComboFillForAccountLedger(); DataRow dr = dtblAccountGroup.NewRow(); dr["accountGroupName"] = "All"; dr["accountGroupId"] = -1; dtblAccountGroup.Rows.InsertAt(dr, 0); cmbAccountGroup.DataSource = dtblAccountGroup; cmbAccountGroup.ValueMember = "accountGroupId"; cmbAccountGroup.DisplayMember = "accountGroupName"; } catch (Exception ex) { formMDI.infoError.ErrorString = "ALREP2:" + ex.Message; } }
/// <summary> /// On print button click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPrint_Click(object sender, EventArgs e) { try { if (dgvCashOrBank.Rows.Count > 0) { AccountGroupSP spAccountGroup = new AccountGroupSP(); DataSet dsCashBankBook = spAccountGroup.CashBankBookPrinting(1, this.dtpFromDate.Value, this.dtpToDate.Value, true); frmReport frmReport = new frmReport(); frmReport.MdiParent = formMDI.MDIObj; frmReport.CashBankBookPrinting(dsCashBankBook); } else { Messages.InformationMessage("No data found"); } } catch (Exception ex) { formMDI.infoError.ErrorString = "CBBOOK9:" + ex.Message; } }
/// <summary> /// Form Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frmChartOfAccount_Load(object sender, EventArgs e) { try { dtblItems.Columns.Add("name"); dtblItems.Columns.Add("type"); AccountGroupSP spAccountGroup = new AccountGroupSP(); DataTable dtbl = new DataTable(); dtbl = spAccountGroup.AccountGroupViewAllByGroupUnder(-1); foreach (DataRow dr in dtbl.Rows) { tvChartOfAccount.Nodes.Add(dr["accountGroupId"].ToString(), dr["accountGroupName"].ToString()); } foreach (TreeNode tn1 in tvChartOfAccount.Nodes) { FillTree(tn1); } } catch (Exception ex) { formMDI.infoError.ErrorString = "COA3:" + ex.Message; } }
/// <summary> /// Function to check existance of account group in DataBase /// </summary> /// <returns></returns> public bool CheckExistanceOfGroupName() { bool isExist = false; try { //Check whether a group name already exist in DB AccountGroupSP spAccountGroup = new AccountGroupSP(); isExist = spAccountGroup.AccountGroupCheckExistence(txtAccountGroupName.Text.Trim(), 0); if (isExist) { if (txtAccountGroupName.Text.ToLower() == strAccountGroupName.ToLower()) { isExist = false; } } } catch (Exception ex) { formMDI.infoError.ErrorString = "AG5:" + ex.Message; } return(isExist); }
/// <summary> /// on grid opening balance textbox keypress /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvtxtOpeningBalance_KeyPress(object sender, KeyPressEventArgs e) { AccountGroupSP spAccountGroup = new AccountGroupSP(); try { if (dgvMultipleAccountLedger.CurrentCell != null) { if (dgvMultipleAccountLedger.Columns[dgvMultipleAccountLedger.CurrentCell.ColumnIndex].Name == "dgvtxtOpeningBalance") { Common.DecimalValidation(sender, e, false); } if (dgvMultipleAccountLedger.Columns[dgvMultipleAccountLedger.CurrentCell.ColumnIndex].Name == "dgvtxtLedgerName") { if (dgvMultipleAccountLedger.Columns["dgvtxtLedgerName"].Index == 1) { string strNature; strNature = spAccountGroup.MultipleAccountLedgerCrOrDr(cmbAccountGroup.Text); if (strNature == "Assets" || strNature == "Income") { dgvMultipleAccountLedger.Rows[dgvMultipleAccountLedger.CurrentRow.Index].Cells["dgvcmbDebitOrCredit"].Value = "Cr"; } else if (strNature == "Expenses" || strNature == "Liabilities") { dgvMultipleAccountLedger.Rows[dgvMultipleAccountLedger.CurrentRow.Index].Cells["dgvcmbDebitOrCredit"].Value = "Dr"; } } } } } catch (Exception ex) { formMDI.infoError.ErrorString = "MAL17:" + ex.Message; } }
/// <summary> /// Function to save and edit account group /// </summary> public void SaveOrEdit() { try { strAccountGroupName = btnSave.Text == "Save" ? string.Empty : strAccountGroupName; if (CheckExistanceOfGroupName() == false) { if (txtAccountGroupName.Text.Trim() == string.Empty) { Messages.InformationMessage("Enter account group name"); txtAccountGroupName.Focus(); } else if (cmbGroupUnder.SelectedIndex == -1) { Messages.InformationMessage("Select under"); cmbGroupUnder.Focus(); } else if (cmbNature.SelectedIndex == -1) { Messages.InformationMessage("Select nature"); cmbNature.Focus(); } else { AccountGroupInfo infoAccountGroup = new AccountGroupInfo(); AccountGroupSP spAccountGroup = new AccountGroupSP(); infoAccountGroup.AccountGroupName = txtAccountGroupName.Text.Trim(); infoAccountGroup.GroupUnder = Convert.ToDecimal(cmbGroupUnder.SelectedValue.ToString()); infoAccountGroup.Nature = cmbNature.SelectedItem.ToString(); if (cmbAffectGrossProfit.SelectedIndex == -1) { infoAccountGroup.AffectGrossProfit = "No"; } else { infoAccountGroup.AffectGrossProfit = cmbAffectGrossProfit.SelectedItem.ToString(); } infoAccountGroup.IsDefault = false; infoAccountGroup.Narration = txtNarration.Text.Trim(); infoAccountGroup.Extra1 = string.Empty; infoAccountGroup.Extra2 = string.Empty; if (btnSave.Text == "Save") { if (Messages.SaveConfirmation()) { decAccountGroupId = spAccountGroup.AccountGroupAddWithIdentity(infoAccountGroup); Messages.SavedMessage(); decIdForOtherForms = decAccountGroupId; if (frmAccountLedgerobj != null) { this.Close(); } GridFill(); Clear(); } } else { if (isDefault == true) { Messages.InformationMessage("Can't update build in account group"); } else if (txtAccountGroupName.Text.Trim().ToLower() != cmbGroupUnder.Text.ToLower()) { if (Messages.UpdateConfirmation()) { infoAccountGroup.AccountGroupId = decAccountGroupIdForEdit; if (spAccountGroup.AccountGroupUpdate(infoAccountGroup)) { Messages.UpdatedMessage(); } GridFill(); Clear(); } } else { Messages.InformationMessage(" Can't save under same group"); } } } } else { Messages.InformationMessage(" Account group already exist"); txtAccountGroupName.Focus(); } } catch (Exception ex) { formMDI.infoError.ErrorString = "AG6:" + ex.Message; } }
/// <summary> /// Fills to control on cell double click in Datagridview /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvAccountGroup_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex != -1) { AccountGroupInfo InfoAccountGroup = new AccountGroupInfo(); AccountGroupSP spAccountGroup = new AccountGroupSP(); InfoAccountGroup = spAccountGroup.AccountGroupViewForUpdate(Convert.ToDecimal(dgvAccountGroup.CurrentRow.Cells["dgvtxtAccountGroupId"].Value.ToString())); bool Isdefault = InfoAccountGroup.IsDefault; txtAccountGroupName.Text = InfoAccountGroup.AccountGroupName; cmbGroupUnder.SelectedValue = InfoAccountGroup.GroupUnder.ToString(); decimal decAccountGroupId = Convert.ToDecimal(cmbGroupUnder.SelectedValue.ToString()); string strNature = spAccountGroup.AccountGroupNatureUnderGroup(decAccountGroupId); if (strNature != "NA") { cmbNature.Text = InfoAccountGroup.Nature; cmbNature.Enabled = false; } else { cmbNature.Text = InfoAccountGroup.Nature; cmbNature.Enabled = true; } if (Isdefault) { decimal decAffectGrossProfit = Convert.ToDecimal(InfoAccountGroup.AffectGrossProfit); if (decAffectGrossProfit == 0) { cmbAffectGrossProfit.Text = "No"; } else { cmbAffectGrossProfit.Text = "Yes"; } } else { cmbAffectGrossProfit.Text = InfoAccountGroup.AffectGrossProfit; } txtNarration.Text = InfoAccountGroup.Narration; btnSave.Text = "Update"; txtAccountGroupName.Focus(); btnDelete.Enabled = true; strAccountGroupName = InfoAccountGroup.AccountGroupName; decAccountGroupIdForEdit = Convert.ToDecimal(dgvAccountGroup.CurrentRow.Cells["dgvtxtAccountGroupId"].Value.ToString()); inId = Convert.ToInt32(InfoAccountGroup.AccountGroupId.ToString()); isDefault = Convert.ToBoolean(InfoAccountGroup.IsDefault); if (isDefault == true && strNature != "NA") { txtAccountGroupName.Enabled = false; cmbAffectGrossProfit.Enabled = false; cmbGroupUnder.Enabled = false; cmbNature.Enabled = false; } else { if (strNature == "NA") { txtAccountGroupName.Enabled = true; cmbAffectGrossProfit.Enabled = true; cmbGroupUnder.Enabled = true; cmbNature.Enabled = true; } } if (isDefault == false) { if (spAccountGroup.AccountGroupCheckExistenceOfUnderGroup(Convert.ToDecimal(inId.ToString())) == false) { cmbAffectGrossProfit.Enabled = false; cmbGroupUnder.Enabled = false; cmbNature.Enabled = false; } else { if (strNature == "NA") { cmbAffectGrossProfit.Enabled = true; cmbGroupUnder.Enabled = true; cmbNature.Enabled = true; } } } } } catch (Exception ex) { formMDI.infoError.ErrorString = "AG15:" + ex.Message; } }
/// <summary> /// Function to fill the report in grid /// </summary> public void AccountGroupGridFill() { decimal decBalanceTotal = 0; DateTime dtmFromDate = DateTime.Now; DateTime dtmToDate = DateTime.Now; AccountGroupSP spAccountGroup = new AccountGroupSP(); DataTable dtbl = new DataTable(); try { if (txtFromDate.Text != string.Empty) { dtmFromDate = Convert.ToDateTime(txtFromDate.Text); } if (txtToDate.Text != string.Empty) { dtmToDate = Convert.ToDateTime(txtToDate.Text); } dtbl = spAccountGroup.AccountGroupReportFill(dtmFromDate, dtmToDate); for (int i = 0; i < dtbl.Rows.Count; i++) { if (Convert.ToDecimal(dtbl.Rows[i]["accountGroupId"].ToString()) == 6) { FinancialStatementSP spFinace = new FinancialStatementSP(); CalculationMethod(); decimal dcOpeninggStock = spFinace.StockValueGetOnDate(PublicVariables._dtFromDate, calculationMethod, true, true); dcOpeninggStock = Math.Round(dcOpeninggStock, PublicVariables._inNoOfDecimalPlaces); decimal decOpBalance = Convert.ToDecimal(dtbl.Rows[i]["OpBalance"].ToString()) + dcOpeninggStock; decimal decClosing = Convert.ToDecimal(dtbl.Rows[i]["balance1"].ToString()) + dcOpeninggStock; if (decOpBalance >= 0) { dtbl.Rows[i]["OpeningBalance"] = decOpBalance.ToString() + "Dr"; } else { dtbl.Rows[i]["OpeningBalance"] = decOpBalance.ToString() + "Cr"; } if (decClosing >= 0) { dtbl.Rows[i]["balance"] = decClosing.ToString() + "Dr"; } else { dtbl.Rows[i]["balance"] = decClosing.ToString() + "Cr"; } dtbl.Rows[i]["balance1"] = decClosing.ToString(); } } dgvAccountGroupReport.DataSource = dtbl; if (dgvAccountGroupReport.RowCount > 0) { for (int i = 0; i < dgvAccountGroupReport.RowCount; i++) { decBalanceTotal = decBalanceTotal + Convert.ToDecimal(dgvAccountGroupReport.Rows[i].Cells["dgvtxtBalance1"].Value.ToString()); } } if (decBalanceTotal < 0) { decBalanceTotal = -1 * decBalanceTotal; lblBalanceTotal.Text = decBalanceTotal.ToString() + "Cr"; } else { lblBalanceTotal.Text = decBalanceTotal.ToString() + "Dr";; } } catch (Exception ex) { formMDI.infoError.ErrorString = "AGR4:" + ex.Message; } }