public virtual int Fill(CloudAccountDA.ReportInvoiceDetailsDataTable dataTable, int?CompanyID, int?ClientID, string Status, DateTime?FromDate, DateTime?ToDate)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if (CompanyID.HasValue)
{
this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
if (ClientID.HasValue)
{
this.Adapter.SelectCommand.Parameters[2].Value = ClientID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value;
}
if (Status == null)
{
this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[3].Value = Status;
}
if (FromDate.HasValue)
{
this.Adapter.SelectCommand.Parameters[4].Value = FromDate.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[4].Value = DBNull.Value;
}
if (ToDate.HasValue)
{
this.Adapter.SelectCommand.Parameters[5].Value = ToDate.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[5].Value = DBNull.Value;
}
if (this.ClearBeforeFill)
{
dataTable.Clear();
}
return(this.Adapter.Fill(dataTable));
}
private void BindGrid()
{
DateTime?dtFromDate = new DateTime?();
DateTime?dtToDate = new DateTime?();
string sStatus = (string)null;
if (this.txtDateFrom.Text.Trim().Length > 0)
{
dtFromDate = new DateTime?(DateTime.Parse(this.txtDateFrom.Text.Trim()));
}
if (this.txtDateTo.Text.Trim().Length > 0)
{
dtToDate = new DateTime?(DateTime.Parse(this.txtDateTo.Text.Trim()));
}
if (this.ddlStatus.SelectedIndex > 0)
{
sStatus = this.ddlStatus.SelectedItem.Value;
}
if (this.ddlClient.SelectedIndex > 0)
{
string s = this.ddlClient.SelectedItem.Value;
if (string.IsNullOrEmpty(s))
{
return;
}
this.objReportInvoiceDetailsDT = this.objReportInvoiceDetailsBll.GetData(int.Parse(this.hfCompanyID.Value), int.Parse(s), sStatus, dtFromDate, dtToDate);
Label label = new Label()
{
Text = this.ddlClient.SelectedItem.Text
};
label.Font.Bold = true;
this.divGrids.Controls.Add((Control)label);
this.divGrids.Controls.Add((Control) new LiteralControl("<br />"));
GridView gridView1 = new GridView();
gridView1.DataSource = (object)this.objReportInvoiceDetailsDT;
gridView1.CssClass = "reportTable table table-responsive";
gridView1.Width = Unit.Percentage(100.0);
gridView1.GridLines = GridLines.None;
gridView1.EmptyDataText = "No invoice available in this search values.";
GridView gridView2 = gridView1;
gridView2.HeaderStyle.BackColor = ColorTranslator.FromHtml("#0083E0");
gridView2.HeaderStyle.ForeColor = Color.White;
gridView2.RowDataBound += new GridViewRowEventHandler(this.gv_RowDataBound);
gridView2.DataBind();
this.divGrids.Controls.Add((Control)gridView2);
InvoiceDetailsReport.MergeRows(gridView2);
this.divGrids.Controls.Add((Control) new LiteralControl("<br />"));
}
else
{
this.ddlClient.DataBind();
foreach (ListItem listItem in this.ddlClient.Items)
{
if (!string.IsNullOrEmpty(listItem.Value))
{
this.objReportInvoiceDetailsDT = this.objReportInvoiceDetailsBll.GetData(int.Parse(this.hfCompanyID.Value), int.Parse(listItem.Value), sStatus, dtFromDate, dtToDate);
Label label = new Label()
{
Text = listItem.Text
};
label.Font.Bold = true;
this.divGrids.Controls.Add((Control)label);
this.divGrids.Controls.Add((Control) new LiteralControl("<br />"));
GridView gridView1 = new GridView();
gridView1.DataSource = (object)this.objReportInvoiceDetailsDT;
gridView1.CssClass = "reportTable table table-responsive";
gridView1.Width = Unit.Percentage(100.0);
gridView1.GridLines = GridLines.None;
gridView1.EmptyDataText = "No invoice available in this search values.";
GridView gridView2 = gridView1;
gridView2.HeaderStyle.BackColor = ColorTranslator.FromHtml("#0083E0");
gridView2.HeaderStyle.ForeColor = Color.White;
gridView2.RowDataBound += new GridViewRowEventHandler(this.gv_RowDataBound);
gridView2.DataBind();
InvoiceDetailsReport.MergeRows(gridView2);
this.divGrids.Controls.Add((Control)gridView2);
this.divGrids.Controls.Add((Control) new LiteralControl("<br />"));
}
}
}
}
