public DataSet CashFlow(DateTime strfromDate, DateTime strtoDate) { DataSet dset = new DataSet(); try { dset = spFinancialStatement.CashFlow(strfromDate, strtoDate); } catch (Exception ex) { MessageBox.Show("FS16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(dset); }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { if (!isFormLoad) { DateValidation objValidation = new DateValidation(); objValidation.DateValidationFunction(txtFromDate); if (txtFromDate.Text == string.Empty) { txtFromDate.Text = PublicVariables._dtFromDate.ToString("dd-MMM-yyyy"); } objValidation.DateValidationFunction(txttoDate); if (txttoDate.Text == string.Empty) { txttoDate.Text = PublicVariables._dtToDate.ToString("dd-MMM-yyyy"); } DateTime strFromDate = DateTime.Parse(txtFromDate.Text.ToString()); DateTime strTodate = DateTime.Parse(txttoDate.Text.ToString()); FinancialStatementSP spFinancial = new FinancialStatementSP(); DataSet dsetFinancial = new DataSet(); SettingsInfo InfoSettings = new SettingsInfo(); SettingsSP SpSettings = new SettingsSP(); dsetFinancial = spFinancial.CashFlow(strFromDate, strTodate); DataTable dtbl = new DataTable(); Font newFont = new Font(dgvCashflow.Font, FontStyle.Bold); CurrencyInfo InfoCurrency = new CurrencyInfo(); CurrencySP SpCurrency = new CurrencySP(); InfoCurrency = SpCurrency.CurrencyView(1); int inDecimalPlaces = InfoCurrency.NoOfDecimalPlaces; dgvCashflow.Rows.Clear(); for (int i = 0; i < 8; i++) { dtbl = dsetFinancial.Tables[i]; foreach (DataRow rw in dtbl.Rows) { dgvCashflow.Rows.Add(); dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtParticulars"].Value = rw["accountGroupName"].ToString(); dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtinflow"].Value = rw["Balance"].ToString(); dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtID1"].Value = rw["accountGroupId"].ToString(); } } //-------------------------------Calculating TotalInflow----------------------------------------- decimal dcTotalInflow = 0m; if (dtbl.Rows.Count > 0) { for (int i = 0; i < dgvCashflow.Rows.Count; i++) { decimal dcTotalIn = decimal.Parse(dgvCashflow.Rows[i].Cells["dgvtxtinflow"].Value.ToString()); dcTotalInflow += dcTotalIn; } dcTotInflow = dcTotalInflow; } //-----------------Outflow------------------------------ int index = 0; for (int i = 8; i < 15; i++) { dtbl = new DataTable(); dtbl = dsetFinancial.Tables[i]; foreach (DataRow rw in dtbl.Rows) { if (index < dgvCashflow.Rows.Count) { dgvCashflow.Rows[index].Cells["dgvtxtParticulars1"].Value = rw["accountGroupName1"].ToString(); dgvCashflow.Rows[index].Cells["dgvtxtoutflow"].Value = rw["Balance1"].ToString(); dgvCashflow.Rows[index].Cells["dgvtxtID2"].Value = rw["accountGroupId"].ToString(); } else { dgvCashflow.Rows.Add(); dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtParticulars1"].Value = rw["accountGroupName1"].ToString(); dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtoutflow"].Value = rw["Balance1"].ToString(); dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtID2"].Value = rw["accountGroupId"].ToString(); } index++; } } //-------------------------------Calculating TotalOutflow----------------------------------------- decimal dcTotalOutflow = 0m; if (dtbl.Rows.Count > 0) { for (int i = 0; i < dgvCashflow.Rows.Count - 1; i++) { decimal dcTotalIn = decimal.Parse(dgvCashflow.Rows[i].Cells["dgvtxtoutflow"].Value.ToString()); dcTotalOutflow += dcTotalIn; } dcTotOutflow = dcTotalOutflow; } dgvCashflow.Rows.Add(); dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtinflow"].Value = "_______________________"; dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtoutflow"].Value = "_______________________"; dgvCashflow.Rows.Add(); dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].DefaultCellStyle.Font = newFont; dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtParticulars"].Value = "Total"; dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtParticulars1"].Value = "Total"; dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtinflow"].Value = Math.Round((dcTotalInflow), inDecimalPlaces); dgvCashflow.Rows[dgvCashflow.Rows.Count - 1].Cells["dgvtxtoutflow"].Value = Math.Round((dcTotalOutflow), inDecimalPlaces); if (dgvCashflow.Columns.Count > 0) { dgvCashflow.Columns["dgvtxtinflow"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; dgvCashflow.Columns["dgvtxtoutflow"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } if (inCurrenRowIndex >= 0 && dgvCashflow.Rows.Count > 0 && inCurrenRowIndex < dgvCashflow.Rows.Count) { if (dgvCashflow.Rows[inCurrenRowIndex].Cells[inCurentcolIndex].Visible) { dgvCashflow.CurrentCell = dgvCashflow.Rows[inCurrenRowIndex].Cells[inCurentcolIndex]; } if (dgvCashflow.CurrentCell != null && dgvCashflow.CurrentCell.Visible) { dgvCashflow.CurrentCell.Selected = true; } } inCurrenRowIndex = 0; } } catch (Exception ex) { MessageBox.Show("CF:01" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }