public ActionResult Export(string ReportType) { Response.AddHeader("Content-Type", "application/vnd.ms-excel"); var dataQueries = new DataQueries(); IEnumerable<RecallViewEditResult> results; IEnumerable<DPSViewEditResult> resultsDPS; ViewBag.ReportType = ReportType; switch (ReportType) { case "RecallsUpload": results = dataQueries.GetRecallsUploadReportRecords("Yes"); return PartialView("_export", results); case "RecallsNotClosed": results = dataQueries.GetRecallsNotClosedReportRecords("Yes"); return PartialView("_export", results); case "RecallsNoNoteSent": results = dataQueries.GetRecallsNoNoteSentReportRecords("Yes"); return PartialView("_export", results); case "RecallsNotUploaded": results = dataQueries.GetRecallsNotUploadedReportRecords("Yes"); return PartialView("_export", results); case "AddSellerCheck": results = dataQueries.GetAddSellerCheckReportRecords("Yes"); return PartialView("_export", results); case "RecallsReceivable": results = dataQueries.GetRecallsReceivableReportRecords("Yes", "RecallsReceivable"); return PartialView("_export", results); case "RecallsInvoiceLookup": results = dataQueries.GetRecallsReceivableReportRecords("Yes", "RecallsInvoiceLookup"); return PartialView("_export", results); case "RecallsSellerCheckLookup": results = dataQueries.GetRecallsReceivableReportRecords("Yes", "RecallsSellerCheckLookup"); return PartialView("_export", results); case "RecallsPayable": results = dataQueries.GetRecallsReceivableReportRecords("Yes", "RecallsPayable"); return PartialView("_export", results); case "RecallsPaidByOurCheck": results = dataQueries.GetRecallsReceivableReportRecords("Yes", "RecallsPaidByOurCheck"); return PartialView("_export", results); case "DPSCheckDetail": resultsDPS = dataQueries.GetDPSReportRecords("Yes", "DPSCheckDetail"); return PartialView("_exportDPS", resultsDPS); case "DPSPayable": resultsDPS = dataQueries.GetDPSReportRecords("Yes", "DPSPayable"); return PartialView("_exportDPS", resultsDPS); case "DPSPaidByOurCheck": resultsDPS = dataQueries.GetDPSReportRecords("Yes", "DPSPaidByOurCheck"); return PartialView("_exportDPS", resultsDPS); default: return PartialView(); } }
public ActionResult GetReportData(string ReportType) { var dataQueries = new DataQueries(); ViewBag.ReportType = ReportType; IEnumerable<RecallViewEditResult> results; IEnumerable<DPSViewEditResult> resultsDPS; //For Report based on Report Type selection switch (ReportType) { case "RecallsUpload": results = dataQueries.GetRecallsUploadReportRecords(null); return PartialView("_recallsUpload", results); case "RecallsNotClosed": results = dataQueries.GetRecallsNotClosedReportRecords(null); return PartialView("_recallsNotClosed", results); case "RecallsNoNoteSent": results = dataQueries.GetRecallsNoNoteSentReportRecords(null); return PartialView("_recallsNoNoteSent", results); case "RecallsNotUploaded": results = dataQueries.GetRecallsNotUploadedReportRecords(null); return PartialView("_recallsNotUploaded", results); case "AddSellerCheck": results = dataQueries.GetAddSellerCheckReportRecords(null); return PartialView("_addSellerCheck", results); case "RecallsReceivable": results = dataQueries.GetRecallsReceivableReportRecords(null, "RecallsReceivable"); return PartialView("_recallsReceivable", results); case "RecallsInvoiceLookup": results = dataQueries.GetRecallsReceivableReportRecords(null, "RecallsInvoiceLookup"); return PartialView("_recallsInvoiceLookup", results); case "RecallsSellerCheckLookup": results = dataQueries.GetRecallsReceivableReportRecords(null, "RecallsSellerCheckLookup"); return PartialView("_recallsSellerCheckLookup", results); case "RecallsPayable": results = dataQueries.GetRecallsReceivableReportRecords(null, "RecallsPayable"); return PartialView("_recallsPayable", results); case "RecallsPaidByOurCheck": results = dataQueries.GetRecallsReceivableReportRecords(null, "RecallsPaidByOurCheck"); return PartialView("_recallsPaidByOurCheck", results); case "DPSCheckDetail": resultsDPS = dataQueries.GetDPSReportRecords(null, "DPSCheckDetail"); return PartialView("_dpsCheckDetails", resultsDPS); case "DPSPayable": resultsDPS = dataQueries.GetDPSReportRecords(null, "DPSPayable"); return PartialView("_dpsPayable", resultsDPS); case "DPSPaidByOurCheck": resultsDPS = dataQueries.GetDPSReportRecords(null, "DPSPaidByOurCheck"); return PartialView("_dpsPaidByOurCheck", resultsDPS); // default: return PartialView(); } }