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