public ActionResult GetReportData(string ReportType) { var dataQueries = new DataQueries(); ViewBag.ReportType = ReportType; IEnumerable<MediaViewEditResult> results; //For Report based on Report Type selection switch (ReportType) { case "MediaNotSubmitted": results = dataQueries.GetMediaNotSubmittedReportRecords(null); return PartialView("_mediaNotSubmitted", results); case "MediaNotConfirmed": results = dataQueries.GetMediaNotSubmittedReportRecords(null); return PartialView("_mediaNotConfirmed", results); case "MediaNotReceived": results = dataQueries.GetMediaNotSubmittedReportRecords(null); return PartialView("_mediaNotReceived", results); case "MediaNotForwarded": results = dataQueries.GetMediaNotSubmittedReportRecords(null); return PartialView("_mediaNotForwarded", results); default: return PartialView(); } }
public ActionResult Export(string ReportType) { Response.AddHeader("Content-Type", "application/vnd.ms-excel"); var dataQueries = new DataQueries(); IEnumerable<MediaViewEditResult> results; ViewBag.ReportType = ReportType; switch (ReportType) { case "MediaNotSubmitted": results = dataQueries.GetMediaNotSubmittedReportRecords("Yes"); return PartialView("_export", results); case "MediaNotConfirmed": results = dataQueries.GetMediaNotSubmittedReportRecords("Yes"); return PartialView("_export", results); case "MediaNotReceived": results = dataQueries.GetMediaNotSubmittedReportRecords("Yes"); return PartialView("_export", results); case "MediaNotForwarded": results = dataQueries.GetMediaNotSubmittedReportRecords("Yes"); return PartialView("_export", results); default: return PartialView(); } }