public ActionResult OPCancelledBillByDept()
{
var viewModel = new AuditReportsIPCancelledByDept()
{
StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
BillType = Enumerations.AuditReport_IpCancelledByDept.CASH
};
return(View(viewModel));
}
public ActionResult OPCancelledBillByDept(AuditReportsIPCancelledByDept param)
{
var vm = param;
if (Request.IsAjaxRequest())
{
ReportViewerVm reportVM = new ReportViewerVm();
ReportViewer reportViewer = new ReportViewer();
string reportDocPath = "";
DataTable reportData = new DataTable();
int billtypeId;
billtypeId = 0;
if (vm.BillType == Enumerations.AuditReport_IpCancelledByDept.CHARGE)
{
billtypeId = 1;
}
if (vm.BillType == Enumerations.AuditReport_IpCancelledByDept.BOTH)
{
billtypeId = 2;
}
reportData = auditDB.getOPCancelledBillByDept(vm.StartDate, vm.EndDate.AddDays(1), billtypeId);
reportDocPath = @"\Areas\ManagementReports\Reports\AuditReports\getOPCancelledBillByDept.rdl";
if (reportData.Rows.Count == 0)
{
return(Content(Errors.ReportContent("NO RECORDS FOUND")));
}
reportViewer.ProcessingMode = ProcessingMode.Local;
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + reportDocPath;
ReportDataSource datasourceItem = new ReportDataSource("DataSet1", reportData);
reportViewer.LocalReport.DataSources.Add(datasourceItem);
reportViewer.LocalReport.SetParameters(new ReportParameter("stdate", vm.StartDate.ToShortDateString()));
reportViewer.LocalReport.SetParameters(new ReportParameter("endate", vm.EndDate.ToShortDateString()));
reportViewer.LocalReport.SetParameters(new ReportParameter("branch", Global.OrganizationDetails.Name + " - " + Global.OrganizationDetails.City.ToUpper()));
reportViewer.SizeToReportContent = true;
reportViewer.Height = Unit.Percentage(100);
reportViewer.Width = Unit.Percentage(100);
reportViewer.ShowPrintButton = true;
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));
}
return(View());
}
