private void BtnFilterOption_Click(object sender, EventArgs e)
{
FilterRptSalesRegister frm = new FilterRptSalesRegister();
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog();
BindReport(frm);
}
private void AfterLoading(object sender, EventArgs e)
{
this.Activated -= AfterLoading;
FilterRptSalesRegister frm = new FilterRptSalesRegister();
frm.ShowDialog();
BindReport(frm);
}
private void BindReport(FilterRptSalesRegister 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());
}
if (frm.ChkDetails.Checked == true && frm.ChkHorizontal.Checked == true) //------ DETAILS WITH HORIZONTAL DATE WISE ----------
{
ds = _objRptSalesRegister.SalesOrderRegisterDetailsHorizontalDateWise(FromDate, ToDate, ClsGlobal.BranchId, ClsGlobal.CompanyUnitId);
dtTerm = ds.Tables[1];
Grid.DataSource = ds.Tables[0];
Grid.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Rate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Basic Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Net Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Date"].Width = 75;
Grid.Columns["Qty"].Width = 100;
Grid.Columns["Rate"].Width = 90;
Grid.Columns["Basic Amt"].Width = 90;
Grid.Columns["Net Amt"].Width = 90;
Grid.Columns["Particular"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
foreach (DataColumn col1 in dtTerm.Columns)
{
Grid.Columns[col1.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns[col1.ColumnName].Width = 90;
}
foreach (DataGridViewRow row in Grid.Rows)
{
if (row.Cells["Particular"].Value.ToString() == "Total :" || row.Cells["Particular"].Value.ToString() == "Grand Total :")
{
Grid.Rows[row.Index].Cells[1].Style.Alignment = DataGridViewContentAlignment.BottomRight;
}
}
}
else if (frm.ChkDetails.Checked == true) //------ DETAILS WITH VERTICLE DATE WISE ----------
{
ds = _objRptSalesRegister.SalesOrderRegisterDetailsVerticleDateWise(FromDate, ToDate, ClsGlobal.BranchId, ClsGlobal.CompanyUnitId);
dtTerm = ds.Tables[1];
Grid.DataSource = ds.Tables[0];
Grid.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Rate"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Basic Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Date"].Width = 75;
Grid.Columns["Qty"].Width = 100;
Grid.Columns["Rate"].Width = 90;
Grid.Columns["Basic Amt"].Width = 90;
Grid.Columns["Particular"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
foreach (DataGridViewRow row in Grid.Rows)
{
if (row.Cells["Particular"].Value.ToString() == "Total :" || row.Cells["Particular"].Value.ToString() == "Grand Total :")
{
Grid.Rows[row.Index].Cells[1].Style.Alignment = DataGridViewContentAlignment.BottomRight;
}
foreach (DataColumn col1 in dtTerm.Columns)
{
if (row.Cells["Particular"].Value.ToString() == col1.ColumnName)
{
Grid.Rows[row.Index].Cells[1].Style.Alignment = DataGridViewContentAlignment.BottomRight;
}
}
}
}
else //--------------- SUMMARY DATE WISE ----------------
{
ds = _objRptSalesRegister.SalesOrderRegisterSummaryDateWise(FromDate, ToDate, ClsGlobal.BranchId, ClsGlobal.CompanyUnitId);
if (ds.Tables.Count > 1)
{
dtTerm = ds.Tables[1].Copy();
}
Grid.DataSource = ds.Tables[0];
Grid.Columns["Voucher No"].Width = 80;
Grid.Columns["Date"].Width = 75;
Grid.Columns["Miti"].Width = 75;
Grid.Columns["Customer Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
Grid.Columns["Qty"].Width = 70;
Grid.Columns["Basic Amt"].Width = 90;
Grid.Columns["Net Amt"].Width = 90;
Grid.Columns["Qty"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Basic Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns["Net Amt"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
foreach (DataColumn col1 in dtTerm.Columns)
{
Grid.Columns[col1.ColumnName].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
Grid.Columns[col1.ColumnName].Width = 90;
}
Grid.Columns["Miti"].Visible = false;
//if (frm.ChkOrderNo.Checked == false)
//{
// Grid.Columns["OrderNo"].Visible = false;
//}
Grid.Rows[Grid.Rows.Count - 1].Cells[3].Style.Alignment = DataGridViewContentAlignment.MiddleRight;
}
Grid.Columns.Cast <DataGridViewColumn>().ToList().ForEach(f => f.SortMode = DataGridViewColumnSortMode.NotSortable);
Grid.Columns["IsBold"].Visible = false;
foreach (DataGridViewRow row in Grid.Rows)
{
if (row.Cells["IsBold"].Value.ToString() == "Y")
{
Grid.Rows[row.Index].DefaultCellStyle.Font = new Font("Arial", 8f, FontStyle.Bold);
}
}
}
frm.Dispose();
}
