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();
            }
        }