public ActionResult DailyPerformanceActualVsBudget(SalesPromotionDailyPerformanceActBudget viewModel) { if (ModelState.IsValid) { if (Request.IsAjaxRequest()) { //var data = _clPolyClinicDB.getOPProcedureStatistics(viewModel.StartDate, viewModel.EndDate.AddDays(1)); // connncection in ReportDoc.SetDatabaseLogon("sghit", "SGHIT", "130.1.2.223", "BI") var data = SalesPromoDB.getDailyActualvsBudget(Request.Form["startdate"], viewModel.EndDate.AddDays(1), viewModel.BranchId); if (data.Rows.Count > 0) { ReportViewerVm reportVM = new ReportViewerVm(); ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; if (viewModel.BranchId == "SGH_JEDDAH") { reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\SalesPromotion\SPIncomeHostorical.rdl"; } else if (viewModel.BranchId == "BYDEPARTMENT") { reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\SalesPromotion\SPIncomeHostorical_Dept.rdl"; } else { reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Areas\ManagementReports\Reports\SalesPromotion\SPIncomeHostorical_Doc.rdl"; } reportViewer.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", data)); reportViewer.LocalReport.SetParameters(new ReportParameter("stDate", viewModel.StartDate.ToShortDateString())); reportViewer.LocalReport.SetParameters(new ReportParameter("enDate", viewModel.StartDate.AddDays(1).ToShortDateString())); reportViewer.LocalReport.SetParameters(new ReportParameter("branch", Global.OrganizationDetails.Name + " - " + Global.OrganizationDetails.City.ToUpper())); reportViewer.SizeToReportContent = true; reportViewer.Width = Unit.Percentage(100); reportViewer.Height = Unit.Percentage(100); reportVM.ReportViewer = reportViewer; System.Web.HttpContext.Current.Session[Global.ReportViewerSessionName] = reportViewer; System.Web.HttpContext.Current.Session[Global.PdfUriSessionName] = Common.Helper.getApplicationUri("Preview", "Print", null); return(PartialView("~/Views/Shared/_reportViewer.cshtml", reportVM)); } else { return(Content(Errors.ReportContent("NO RECORDS FOUND"))); } } } return(View()); }
public ActionResult DailyPerformanceActualVsBudget() { var viewModel = new SalesPromotionDailyPerformanceActBudget() { StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1), EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day), ReportTypeList = new List <KeyValuePair <SalesPromotion_ReportType, string> >() { new KeyValuePair <SalesPromotion_ReportType, string>(SalesPromotion_ReportType.BYDEPT, "BYDEPT"), new KeyValuePair <SalesPromotion_ReportType, string>(SalesPromotion_ReportType.BYDOCTOR, "BYDOCTOR"), //new KeyValuePair<ReportType, string>(SalesPromotion_ReportType.LINEGRAPH, "Line Graph") }, ReportType = SalesPromotion_ReportType.BYDEPT, BranchId = Bi_Site.SGH_JEDDAH.ToString(), }; return(View(viewModel)); }