public ActionResult ListEmployeeByCategory(PRListOfEmployees param)
{
var vm = param;
if (Request.IsAjaxRequest())
{
ReportViewerVm reportVM = new ReportViewerVm();
ReportViewer reportViewer = new ReportViewer();
string reportDocPath = "";
DataTable reportData = new DataTable();
if (vm.HrId == 0)
{
reportData = personneldb.getEmployeebyCatALL(vm.CategoryId, vm.DeptId, vm.StartDate, vm.EndDate.AddDays(1), vm.GenderId, vm.NationalityId);
if (vm.IsWithSalary)
{
reportDocPath = @"\Areas\ManagementReports\Reports\PersonnelReports\PR_EmployeeByCatALL.rdl";
}
else
{
reportDocPath = @"\Areas\ManagementReports\Reports\PersonnelReports\PR_EmployeeByCatALL_NoSalary.rdl";
}
}
else
{
reportData = personneldb.getEmployeebyCat(vm.HrId, vm.DeptId, vm.StartDate, vm.EndDate.AddDays(1), vm.GenderId, vm.NationalityId);
if (vm.IsWithSalary)
{
reportDocPath = @"\Areas\ManagementReports\Reports\PersonnelReports\PR_EmployeeByCat.rdl";
}
else
{
reportDocPath = @"\Areas\ManagementReports\Reports\PersonnelReports\PR_EmployeeByCat_NoSalary.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());
}
public ActionResult PerformanceEvaluationMapping()
{
var viewModel = new PRListOfEmployees()
{
EmployeeList = empDb.getHREmployeeDetails(),
DepartmentList = empDb.getHRdepartmentDetails()
};
return(View(viewModel));
}
public ActionResult PerformanceEvaluationMapping(PRListOfEmployees param)
{
var vm = param;
var json = Request.Form["SelectedEmpId"];
if (Request.IsAjaxRequest())
{
humanresourcesdb.getSavePerformanceEvalMapping(json, vm.DeptId);
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
public ActionResult PassportDetailsReport()
{
var viewModel = new PRListOfEmployees()
{
StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
};
return View(viewModel);
}
public ActionResult ListEmployeeByCategory()
{
var viewModel = new PRListOfEmployees()
{
StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
HrList = personneldb.getAllHrCategory(),
NationalityList = _clPatientStatisticsDB.GetNationality(),
//GenderList = sexdb.getSex()
};
return(View(viewModel));
}
public ActionResult StaffDocMonitoring()
{
var viewModel = new PRListOfEmployees()
{
StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
StaffDepartmentList = departmentDb.getAllDepartment(),
};
return View(viewModel);
}
public ActionResult PassportDetailsReport(PRListOfEmployees param)
{
var vm = param;
if (Request.IsAjaxRequest())
{
ReportViewerVm reportVM = new ReportViewerVm();
ReportViewer reportViewer = new ReportViewer();
string reportDocPath = "";
DataTable reportData = new DataTable();
// ViewReport("SP_GetEmployeebyCategoryAllwithPassport " & xcat & "," & xdeptcat & ",'" & FormatDatePlus(stDate.Value, "DD_MMM_YYYY") & "','" & FormatDatePlus(enDate.Value, "DD_MMM_YYYY") & "'," & CType(cboGender.SelectedItem, ValueDescriptionPair).Value())
//Report_PassportDetailList
reportData = personneldb.getEmployeePassportDetail( vm.DeptId, vm.StartDate, vm.EndDate.AddDays(1), vm.GenderId);
reportDocPath = @"\Areas\ManagementReports\Reports\PersonnelReports\getEmployeePassportDetail.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 = this.DynamicReportHeader(reportViewer, "DataSet2");
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();
}
