private void BtnFilterOption_Click(object sender, EventArgs e)
{
FilterRptAllLedger frm = new FilterRptAllLedger();
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog();
BindReport(frm);
}
private void AfterLoading(object sender, EventArgs e)
{
this.Activated -= AfterLoading;
FilterRptAllLedger frm = new FilterRptAllLedger();
frm.ShowDialog();
BindReport(frm);
}
private void BindReport(FilterRptAllLedger frm)
{
DataSet ds = new DataSet();
if (frm.ButtonAction == "OK")
{
DataTable NullDt = new DataTable();
Grid.DataSource = NullDt;
DateTime FromDate = new DateTime();
DateTime ToDate = new DateTime();
if (ClsGlobal.DateType == "D")
{
FromDate = Convert.ToDateTime(frm.TxtFromDate.Text);
ToDate = Convert.ToDateTime(frm.TxtToDate.Text);
}
else
{
FromDate = Convert.ToDateTime(frm.TxtFromDate.Tag.ToString());
ToDate = Convert.ToDateTime(frm.TxtToDate.Tag.ToString());
}
if (frm.ChkDetails.Checked == true) //--------------- DETAILS LEDGER WISE ----------------
{
bool isNarrationShow = (frm.ChkNarration.Checked == true) ? true : false;
ds = _objRptAllLedger.AllLedgerDetailsLedgerWise(FromDate, ToDate, ClsGlobal.BranchId, ClsGlobal.CompanyUnitId, isNarrationShow, frm._LedgerId);
Grid.DataSource = ds.Tables[0];
//Grid.Columns["Voucher No"].Width = 80;
Grid.Columns["Date"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Particular/Ledger"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Dr Amount"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Cr Amount"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Balance"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Dr Amount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Cr Amount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Balance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
int i = 0;
foreach (DataGridViewRow row in Grid.Rows)
{
if (row.Cells["IsBold"].Value.ToString() == "Y" || row.Cells["Particular/Ledger"].Value.ToString() == "Periodic Total :" || row.Cells["Particular/Ledger"].Value.ToString() == "A/C Total :" || row.Cells["Particular/Ledger"].Value.ToString() == "Grand Opening Total :" || row.Cells["Particular/Ledger"].Value.ToString() == "Grand Periodic Total :" || row.Cells["Particular/Ledger"].Value.ToString() == "Grand Total :" || row.Cells["Date"].Value.ToString() == "Narr :")
{
if (row.Cells["IsBold"].Value.ToString() == "Y")
{
Grid.Rows[row.Index].DefaultCellStyle.Font = new Font("Arial", 8f, FontStyle.Bold);
}
if (row.Cells["Particular/Ledger"].Value.ToString() == "Periodic Total :" || row.Cells["Particular/Ledger"].Value.ToString() == "A/C Total :" || row.Cells["Particular/Ledger"].Value.ToString() == "Grand Opening Total :" || row.Cells["Particular/Ledger"].Value.ToString() == "Grand Periodic Total :" || row.Cells["Particular/Ledger"].Value.ToString() == "Grand Total :")
{
Grid.Rows[row.Index].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
if (row.Cells["Date"].Value.ToString() == "Narr :")
{
Grid.Rows[i].Cells[0].Style.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Rows[row.Index].DefaultCellStyle.Font = new Font("Arial", 8f, FontStyle.Italic);
}
}
i++;
}
}
else //--------------- SUMMARY LEDGER WISE ----------------
{
ds = _objRptAllLedger.AllLedgerSummaryLedgerWise(FromDate, ToDate, ClsGlobal.BranchId, ClsGlobal.CompanyUnitId, frm._LedgerId);
Grid.DataSource = ds.Tables[0];
//Grid.Columns["Voucher No"].Width = 80;
Grid.Columns["Code"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Description"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["O Dr"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["O Cr"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["P Dr"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["P Cr"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Balance"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["C Dr"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["C Cr"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["O Dr"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["O Cr"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["P Dr"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["P Cr"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Balance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["C Dr"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["C Cr"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
foreach (DataGridViewRow row in Grid.Rows)
{
if (row.Cells["IsBold"].Value.ToString() == "Y" || row.Cells["Description"].Value.ToString() == "Total :")
{
Grid.Rows[row.Index].DefaultCellStyle.Font = new Font("Arial", 8f, FontStyle.Bold);
if (row.Cells["Description"].Value.ToString() == "Total :")
{
Grid.Rows[row.Index].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
}
}
}
Grid.Columns["IsBold"].Visible = false;
Grid.Columns.Cast <DataGridViewColumn>().ToList().ForEach(f => f.SortMode = DataGridViewColumnSortMode.NotSortable);
}
frm.Dispose();
}