public void ApplyFilter()
{
// Build Filter String
// Find Shunt List For Particular Client
DateTime today = DateTime.UtcNow;
today = today.Subtract(today.TimeOfDay);
Facade.Job facJob = new Facade.Job();
DataSet dsShuntList = facJob.GetShuntListForClient(Convert.ToInt32(cboClient.Value), today);
grdDailyShuntList.DataSource = dsShuntList;
grdDailyShuntList.DataBind();
}
private void GetShuntListData()
{
DateTime shuntListDate = dteShuntListDate.SelectedDate.Value;
shuntListDate = shuntListDate.Subtract(shuntListDate.TimeOfDay);
Facade.Job facJob = new Facade.Job();
int identityId = Convert.ToInt32(cboClient.SelectedValue);
DataSet dsShuntList = facJob.GetShuntListForClient(identityId, shuntListDate);
if (dsShuntList.Tables[0].Rows.Count > 0)
{
// Configure the report settings collection
NameValueCollection reportParams = new NameValueCollection();
reportParams.Add("Client", cboClient.Text);
reportParams.Add("IdentityId", cboClient.SelectedValue);
reportParams.Add("Date", shuntListDate.ToString("dd/MM/yy"));
// Configure the Session variables used to pass data to the report
Session[Orchestrator.Globals.Constants.ReportTypeSessionVariable] = eReportType.ShuntList;
Session[Orchestrator.Globals.Constants.ReportDataSessionTableVariable] = dsShuntList;
Session[Orchestrator.Globals.Constants.ReportDataSessionSortVariable] = String.Empty;
Session[Orchestrator.Globals.Constants.ReportDataMemberSessionVariable] = "Table";
Session[Orchestrator.Globals.Constants.ReportParamsSessionVariable] = reportParams;
// Set the identity ID property of the report viewer.
reportViewer.IdentityId = identityId;
// Show the user control
reportViewer.Visible = true;
}
else
{
lblError.Text = "No jobs found for client " + cboClient.Text;
lblError.Visible = true;
}
}