Stream OncallReport(string mrfid, string applicants)
{
DataTable dt = new Contracts.sp_print_contractDataTable();
foreach (var applicant in applicants.Split(','))
{
foreach (var i in db.sp_print_contract(mrfid, applicant))
{
dt.Rows.Add(i.surname, i.firstname, i.middleinitial, i.address, i.ProjectName, i.BusinessUnit, i.Classification, i.position_name, i.company_name, i.branch, i.officeaddress);
}
}
var BusinessUnit = mrfid.Split('-')[0];
var report = new ReportDocument();
if (BusinessUnit == "CSI")
{
report = new Corestaff.OnCall.OncallCorestaffA();
}
else if (BusinessUnit == "TOPSERVE")
{
report = new Oncall.OncallA();
}
else if (BusinessUnit == "IWSC")
{
report = new IWSC.Oncall.OnCallIWSCA();
}
report.SetDataSource(dt);
return(report.ExportToStream(ExportFormatType.WordForWindows));
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
OnCallIWSCA rpt = new OnCallIWSCA();
rpt.Site = this.Site;
return(rpt);
}