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