private void BtnFilterOption_Click(object sender, EventArgs e)
{
FilterRptDayBook frm = new FilterRptDayBook();
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog();
BindReport(frm);
}
private void AfterLoading(object sender, EventArgs e)
{
this.Activated -= AfterLoading;
FilterRptDayBook frm = new FilterRptDayBook();
frm.ShowDialog();
BindReport(frm);
}
private void BindReport(FilterRptDayBook frm)
{
//DataTable dtTerm = new DataTable();
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());
}
bool isNarrationShow = (frm.ChkNarration.Checked == true) ? true : false;
ds = _objRptAllLedger.DayBookDateWise(FromDate, ToDate, ClsGlobal.BranchId, ClsGlobal.CompanyUnitId, isNarrationShow);
Grid.DataSource = ds.Tables[0];
Grid.Columns["Date"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Voucher No"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Particulars"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Dr Amount"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Cr Amount"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Dr Amount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Cr Amount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
int i = 0;
foreach (DataGridViewRow row in Grid.Rows)
{
if (row.Cells["IsBold"].Value.ToString() == "Y" || row.Cells["Particulars"].Value.ToString() == "Total :" || row.Cells["Particulars"].Value.ToString() == "Day Total :" || row.Cells["Voucher No"].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["Particulars"].Value.ToString() == "Total :" || row.Cells["Particulars"].Value.ToString() == "Day Total :")
{
Grid.Rows[row.Index].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
}
if (row.Cells["Voucher No"].Value.ToString() == "Narr :")
{
Grid.Rows[i].Cells[1].Style.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Rows[row.Index].DefaultCellStyle.Font = new Font("Arial", 8f, FontStyle.Italic);
}
}
i++;
}
Grid.Columns["IsBold"].Visible = false;
Grid.Columns.Cast <DataGridViewColumn>().ToList().ForEach(f => f.SortMode = DataGridViewColumnSortMode.NotSortable);
}
frm.Dispose();
}