protected void lbView_Click(object sender, EventArgs e)
{
if (ddlArea.SelectedIndex > 0)
{
this.rvWorkSchedule.ProcessingMode = ProcessingMode.Local;
ISSA.Pages.Reports.DataSet1 DS_Report = new ISSA.Pages.Reports.DataSet1();
DS_Report.EnforceConstraints = false;
ISSA.Pages.Reports.DataSet1TableAdapters.TA_RPT_WorkScheduleTableAdapter Rpt_TableAdapter = new ISSA.Pages.Reports.DataSet1TableAdapters.TA_RPT_WorkScheduleTableAdapter();
Rpt_TableAdapter.Fill(DS_Report.TA_RPT_WorkSchedule, ddlYear.SelectedValue, ddlMonth.SelectedValue, Convert.ToByte(ddlArea.SelectedValue), ddlShift.SelectedValue);
if (DS_Report.TA_RPT_WorkSchedule.Rows.Count > 0)
{
ISSA.Pages.Reports.DataSet1.dtParametersDataTable dtParam = new ISSA.Pages.Reports.DataSet1.dtParametersDataTable();
DataRow dr = dtParam.NewRow();
dr["ParamOne"] = ddlMonth.SelectedItem.Text + ", " + ddlYear.SelectedValue;
dr["ParamTwo"] = ddlArea.SelectedItem.Text;
if (ddlShift.SelectedIndex == 0)
{
dr["ParamThree"] = "All";
}
else
{
dr["ParamThree"] = ddlShift.SelectedItem.Text;
}
dr["User"] = MISC.getUserName().ToUpper();;
dr["Date"] = DateTime.Now;
dtParam.Rows.Add(dr);
Microsoft.Reporting.WebForms.ReportDataSource RpDs1 = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.ReportDataSource RpDsParameters = new Microsoft.Reporting.WebForms.ReportDataSource();
RpDs1.Name = "TA_RPT_WorkSchedule";
RpDs1.Value = DS_Report.TA_RPT_WorkSchedule;
RpDsParameters.Name = "dtParameters";
RpDsParameters.Value = dtParam;
rvWorkSchedule.LocalReport.ReportPath = "Pages/Reports/rpt_WorkSchedule.rdlc";
rvWorkSchedule.LocalReport.DataSources.Clear();
rvWorkSchedule.LocalReport.DataSources.Add(RpDs1);
rvWorkSchedule.LocalReport.DataSources.Add(RpDsParameters);
rvWorkSchedule.LocalReport.Refresh();
rvWorkSchedule.Visible = true;
rvWorkSchedule.ShowReportBody = true;
mpeViewWorkSchedule.Show();
}
else
{
ShowMessage("No record found for selected parameters. Schedule may not have been created.", MessageType.Info);
mpeViewWorkSchedule.Hide();
}
}
else
{
ShowMessage("Area is required", MessageType.Warning);
//mpeViewWorkSchedule.Hide();
}
}
protected void generateWorkSchedule()
{
this.rvWorkSchedule.ProcessingMode = ProcessingMode.Local;
ISSA.Pages.Reports.DataSet1 DS_Report = new ISSA.Pages.Reports.DataSet1();
DS_Report.EnforceConstraints = false;
ISSA.Pages.Reports.DataSet1TableAdapters.TA_RPT_WorkScheduleTableAdapter Rpt_TableAdapter = new ISSA.Pages.Reports.DataSet1TableAdapters.TA_RPT_WorkScheduleTableAdapter();
Rpt_TableAdapter.Fill(DS_Report.TA_RPT_WorkSchedule, ddlYear.SelectedValue, ddlMonth.SelectedValue, Convert.ToByte(ddlArea.SelectedValue), ddlShift.SelectedValue);
ISSA.Pages.Reports.DataSet1.dtParametersDataTable dtParam = new ISSA.Pages.Reports.DataSet1.dtParametersDataTable();
DataRow dr = dtParam.NewRow();
dr["ParamOne"] = ddlMonth.SelectedItem.Text + ", " + ddlYear.SelectedValue;
dr["ParamTwo"] = ddlArea.SelectedItem.Text;
if (ddlShift.SelectedIndex == 0)
{
dr["ParamThree"] = "All";
}
else
{
dr["ParamThree"] = ddlShift.SelectedItem.Text;
}
dr["User"] = loggedInUser;
dr["Date"] = DateTime.Now;
dtParam.Rows.Add(dr);
Microsoft.Reporting.WebForms.ReportDataSource RpDs1 = new Microsoft.Reporting.WebForms.ReportDataSource();
Microsoft.Reporting.WebForms.ReportDataSource RpDsParameters = new Microsoft.Reporting.WebForms.ReportDataSource();
RpDs1.Name = "TA_RPT_WorkSchedule";
RpDs1.Value = DS_Report.TA_RPT_WorkSchedule;
RpDsParameters.Name = "dtParameters";
RpDsParameters.Value = dtParam;
this.rvWorkSchedule.LocalReport.ReportPath = "Pages/Reports/rpt_WorkSchedule.rdlc";
this.rvWorkSchedule.LocalReport.DataSources.Clear();
this.rvWorkSchedule.LocalReport.DataSources.Add(RpDs1);
this.rvWorkSchedule.LocalReport.DataSources.Add(RpDsParameters);
this.rvWorkSchedule.LocalReport.Refresh();
this.rvWorkSchedule.Visible = true;
this.rvWorkSchedule.ShowReportBody = true;
}