/// <summary> /// Function to fill ledger details corresponding to ledger /// </summary> public void LedgerDetailsView() { try { dgvLedgerDetails.Rows.Clear(); DataSet dsLedgerDetails = SpAccountLedger.LedgerDetailsFillCorrespondingToledgerId(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text), decLedgerIdForGridFill); foreach (DataTable dtblOpening in dsLedgerDetails.Tables) { if (dtblOpening.TableName == "Table") { foreach (DataRow drOpening in dtblOpening.Rows) { dgvLedgerDetails.Rows.Add(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtVoucherType"].Value = "Opening"; dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtDate"].Value = txtFromDate.Text; dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtCredit"].Value = drOpening.ItemArray[2].ToString(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtDebit"].Value = drOpening.ItemArray[3].ToString(); } } if (dtblOpening.TableName == "Table1") { foreach (DataRow drLedgerDetails in dtblOpening.Rows) { dgvLedgerDetails.Rows.Add(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtLedgerId"].Value = drLedgerDetails.ItemArray[0].ToString(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtVoucherTypeId"].Value = drLedgerDetails.ItemArray[2].ToString(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxttypeofVoucher"].Value = drLedgerDetails.ItemArray[3].ToString(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtMasterId"].Value = drLedgerDetails.ItemArray[4].ToString(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtVoucherType"].Value = drLedgerDetails.ItemArray[5].ToString(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtDate"].Value = drLedgerDetails.ItemArray[6].ToString(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtDebit"].Value = drLedgerDetails.ItemArray[7].ToString(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtCredit"].Value = drLedgerDetails.ItemArray[8].ToString(); dgvLedgerDetails.Rows[dgvLedgerDetails.Rows.Count - 1].Cells["dgvtxtpos"].Value = drLedgerDetails.ItemArray[9].ToString(); } } } string strBalance = string.Empty; if (dgvLedgerDetails.Rows.Count > 0) { for (int i = 0; i < dgvLedgerDetails.Rows.Count; i++) { strBalance = CalculateBalance(i, decimal.Parse(dgvLedgerDetails.Rows[i].Cells["dgvtxtDebit"].Value.ToString()), decimal.Parse(dgvLedgerDetails.Rows[i].Cells["dgvtxtCredit"].Value.ToString()), strBalance); dgvLedgerDetails.Rows[i].Cells["dgvtxtBalance"].Value = strBalance; } } SerialNo(); } catch (Exception ex) { formMDI.infoError.ErrorString = "LEDDET2:" + ex.Message; } }
public DataSet LedgerDetailsFillCorrespondingToledgerId(DateTime dtFromDate, DateTime dtToDate, decimal decLedgerId) { DataSet dsLedgerDetails = new DataSet(); try { dsLedgerDetails = spAccountLedger.LedgerDetailsFillCorrespondingToledgerId(dtFromDate, dtToDate, decLedgerId); } catch (Exception ex) { MessageBox.Show("AL10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(dsLedgerDetails); }