public ActionResult ExportManpowerStatusReport(ManpowerStatusReportViewModel i)
{
ExportReport export = new ExportReport();
var sr = export.ExportManpowerReport(i);
return(File(sr.ToArray(), "application/vnd.ms-excel", "Manpower Status Report " + Convert.ToDateTime(i.DateFrom).ToString("MM-dd-yy") + "-" + Convert.ToDateTime(i.DateTo).ToString("MM-dd-yy") + ".xls"));
}
public MemoryStream ExportManpowerReport(ManpowerStatusReportViewModel model)
{
var dt = ManpowerStatusReportTemplate();
var list = model.ManpowerStatusReport();
//if (Searchby == "Yearly")
//{
// list = (from m in list where Convert.ToDateTime(m.DateRequested).Year == year && m.Classification.Contains(classification) && (m.am_1_id.Contains(accountmanger) || m.am_2_id.Contains(accountmanger)) select m).ToList();
//}
//else if (Searchby == "Monthly")
//{
// list = (from m in list where Convert.ToDateTime(m.DateRequested).ToString("MM") == Monthly.ToString() && m.Classification.Contains(classification) && (m.am_1_id.Contains(accountmanger) || m.am_2_id.Contains(accountmanger)) select m).ToList();
//}
//else if (Searchby == "Daily")
//{
// list = (from m in list where (m.DateRequested >= datefrom && m.DateRequested <= dateto) && m.Classification.Contains(classification) && (m.am_1_id.Contains(accountmanger) || m.am_2_id.Contains(accountmanger)) select m).ToList();
//}
foreach (var i in list)
{
dt.Rows.Add(i.mrfid, i.DateRequested, i.company_name, i.Establishment, i.industry_name, i.position_name, i.SkillType, i.account_manager_1, i.Coodinator_name,
i.Classification, i.RequiredNumber, i.agingdays, i.Recruiter_Name, i.cancelled_requirement, i.closed, i.Pending, i.Passon, i.Invited, i.Shortlist,
i.for_requirement, i.variance, i.status, i.Remarks);
}
wb.Worksheets.Add(dt);
wb.SaveAs(ms);
return(ms);
}
public ActionResult _ManpowerStatus(ManpowerStatusReportViewModel i, string orderby = "asc")
{
i.OrderBy = orderby;
return(View(i));
}
