public ActionResult CompanyProfLogs()
{
var viewModel = new AuditReportIPChargeBilledReport()
{
StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
CategoryList = categoryDB.getCategoriesWithId(),
IsConsultation = false,
TypeIPList = new List <KeyValuePair <int, string> > {
new KeyValuePair <int, string>(0, "In-Patient"),
new KeyValuePair <int, string>(1, "Out-Patient"),
},
TypeGradeList = new List <KeyValuePair <int, string> > {
new KeyValuePair <int, string>(0, "Grade"),
new KeyValuePair <int, string>(1, "Company"),
},
LevelList = new List <KeyValuePair <int, string> > {
new KeyValuePair <int, string>(0, "Service"),
new KeyValuePair <int, string>(1, "Department")
},
LevelOPList = new List <KeyValuePair <int, string> > {
new KeyValuePair <int, string>(0, "Grade"),
new KeyValuePair <int, string>(1, "Service"),
new KeyValuePair <int, string>(2, "Department")
},
SubCategoryList = new List <KeyValuePair <int, string> > {
new KeyValuePair <int, string>(0, "Deductible"),
new KeyValuePair <int, string>(1, "Discount"),
new KeyValuePair <int, string>(2, "Markup")
}
};
return(View(viewModel));
}
public ActionResult SummaryBillPercentage()
{
var viewModel = new AuditReportIPChargeBilledReport()
{
StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
DoctorList = employeeDB.getAllDoctosbyID(),
ServiceList = categoryDB.getIPBServices(),
CategoryList = categoryDB.getCategoriesWithId(),
};
return(View(viewModel));
}
public ActionResult OPBilledReport(AuditReportIPChargeBilledReport param)
{
var vm = param;
if (Request.IsAjaxRequest())
{
ReportViewerVm reportVM = new ReportViewerVm();
ReportViewer reportViewer = new ReportViewer();
string reportDocPath = "";
DataTable reportData = new DataTable();
int withDoc = 1;
//if (vm.DocOrNone == true)
//{ withDoc = 0; }
reportData = auditDB.getOPBillCharge(vm.StartDate, vm.EndDate.AddDays(1), vm.DoctorId, vm.ServiceId, vm.CategoryId, vm.CompanyId, vm.AccountType, vm.ChargedORBilled);
reportDocPath = @"\Areas\ManagementReports\Reports\AuditReports\AuditReport_OPBilledReport.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("startdate", vm.StartDate.ToShortDateString()));
reportViewer.LocalReport.SetParameters(new ReportParameter("enddate", 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());
}
public ActionResult OPBilledReport()
{
var viewModel = new AuditReportIPChargeBilledReport()
{
StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
DoctorList = employeeDB.getAllDoctosbyID(),
ServiceList = categoryDB.getOPBServices(),
CategoryList = categoryDB.getCategoriesWithId(),
ChargeTypeList = new List <KeyValuePair <int, string> > {
new KeyValuePair <int, string>(0, "Currently-In"),
new KeyValuePair <int, string>(1, "Discharged"),
},
AccountTypeList = new List <KeyValuePair <int, string> > {
new KeyValuePair <int, string>(0, "Charge"),
new KeyValuePair <int, string>(1, "Cash")
}
};
return(View(viewModel));
}
public ActionResult CompanyProfLogs(AuditReportIPChargeBilledReport param)
{
var vm = param;
if (Request.IsAjaxRequest())
{
ReportViewerVm reportVM = new ReportViewerVm();
ReportViewer reportViewer = new ReportViewer();
string reportDocPath = "";
DataTable reportData = new DataTable();
if (vm.IsConsultation)
{
//Gia_Audit_GradeConsultation getGradeConsultation
reportData = auditDB.getGradeConsultation(vm.StartDate, vm.EndDate.AddDays(1), vm.CategoryId, vm.TypeGradeId);
}
else
{
if (vm.TypeIPId == 0)
{
if (vm.LevelId == 0)
{
reportData = auditDB.getCompanyProfileLogs(vm.StartDate, vm.EndDate.AddDays(1), vm.CategoryId, vm.SubCategoryId, "[MCRS].[AuditReport_IpCompanyService]");
//ViewReport("Gia_Audit_IPCompanyServiceNew '" & FormatDatePlus(dtpSDate.Value, "DD_MMM_YYYY") & "','" & FormatDatePlus(DateAdd(DateInterval.Day, 1, dtpEdate.Value), "DD_MMM_YYYY") & "','" & DirectCast(cboCategory.SelectedItem, ValueDescriptionPair).Value() & "'," & cboSubLevel.SelectedIndex)
}
else if (vm.LevelId == 1)
{
reportData = auditDB.getCompanyProfileLogs(vm.StartDate, vm.EndDate.AddDays(1), vm.CategoryId, vm.SubCategoryId, "[MCRS].[AuditReports_IpCompanyDepartment]");
//ViewReport("Gia_Audit_IPCompanyDepartmentNew '" & FormatDatePlus(dtpSDate.Value, "DD_MMM_YYYY") & "','" & FormatDatePlus(DateAdd(DateInterval.Day, 1, dtpEdate.Value), "DD_MMM_YYYY") & "','" & DirectCast(cboCategory.SelectedItem, ValueDescriptionPair).Value() & "'," & cboSubLevel.SelectedIndex)
}
else if (vm.LevelId == 2)
{
reportData = auditDB.getCompanyProfileLogs(vm.StartDate, vm.EndDate.AddDays(1), vm.CategoryId, vm.SubCategoryId, "[MCRS].[AuditReport_IpCompanyItem]");
//ViewReport("Gia_Audit_IPCompanyItemNew '" & FormatDatePlus(dtpSDate.Value, "DD_MMM_YYYY") & "','" & FormatDatePlus(DateAdd(DateInterval.Day, 1, dtpEdate.Value), "DD_MMM_YYYY") & "','" & DirectCast(cboCategory.SelectedItem, ValueDescriptionPair).Value() & "'," & cboSubLevel.SelectedIndex)
}
}
if (vm.TypeIPId == 1)
{
if (vm.LevelOPId == 0)
{
reportData = auditDB.getCompanyProfileLogs(vm.StartDate, vm.EndDate.AddDays(1), vm.CategoryId, vm.SubCategoryId, "[MCRS].[AuditReport_OPCompanyGrade]");
//ViewReport("Gia_Audit_OPCompanyGradeNew '" & FormatDatePlus(dtpSDate.Value, "DD_MMM_YYYY") & "','" & FormatDatePlus(DateAdd(DateInterval.Day, 1, dtpEdate.Value), "DD_MMM_YYYY") & "','" & DirectCast(cboCategory.SelectedItem, ValueDescriptionPair).Value() & "'," & cboSubLevel.SelectedIndex)
}
else if (vm.LevelOPId == 1)
{
reportData = auditDB.getCompanyProfileLogs(vm.StartDate, vm.EndDate.AddDays(1), vm.CategoryId, vm.SubCategoryId, "[MCRS].[AuditReports_OPCompanyDepartment]");
}
else if (vm.LevelOPId == 2)
{
reportData = auditDB.getCompanyProfileLogs(vm.StartDate, vm.EndDate.AddDays(1), vm.CategoryId, vm.SubCategoryId, "[MCRS].[AuditReport_OPCompanyItem]");
}
}
}
reportDocPath = @"\Areas\ManagementReports\Reports\AuditReports\AuditReport_CompanyProfLogs.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);
if (vm.IsConsultation)
{
reportViewer.LocalReport.SetParameters(new ReportParameter("label", Request.Form["TypeName"] + " Level Consultation (" + Request.Form["CategoryName"] + ") - "));
}
else
{
reportViewer.LocalReport.SetParameters(new ReportParameter("label", Request.Form["TypeName"] + " Level " + Request.Form["SubCategoryName"] + " (" + Request.Form["CategoryName"] + ") - " + Request.Form["LevelName"]));
}
reportViewer.LocalReport.SetParameters(new ReportParameter("startdate", vm.StartDate.ToString("dd-MMM-yyyy")));
reportViewer.LocalReport.SetParameters(new ReportParameter("enddate", vm.EndDate.ToString("dd-MMM-yyyy")));
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());
}
