public ActionResult HRPayrollEmployee() { var viewModel = new OtherReportsDateTimeOnly() { 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 EvaluationMonitor() { var viewModel = new OtherReportsDateTimeOnly() { 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 MagcardEmployee() { var viewModel = new OtherReportsDateTimeOnly() { StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day), EndDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day), DepartmentList = departmentDb.getAllHRCategory() }; return(View(viewModel)); }
public ActionResult MagcardEmployee(OtherReportsDateTimeOnly param) { var vm = param; string deptidArray = Request.Form["DepartmentIdArray"]; string DepartmentIdArraytext = Request.Form["DepartmentIdArraytext"]; DepartmentIdArraytext = DepartmentIdArraytext.Substring(1); var DeptId = "0"; if (deptidArray.Contains("0") || deptidArray == null || deptidArray == "") { DeptId = "0"; } else { DeptId = deptidArray; } if (Request.IsAjaxRequest()) { ReportViewerVm reportVM = new ReportViewerVm(); ReportViewer reportViewer = new ReportViewer(); string reportDocPath = ""; DataTable reportData = new DataTable(); reportData = helpdeskDB.getMagcard(vm.StartDate, vm.EndDate.AddDays(1), DeptId, "[MCRS].[Helpdesk_DutyRosterMissingWithHRCategory]"); reportDocPath = @"\Areas\ManagementReports\Reports\HelpDeskReports\HelpDeskMissingDutyRosterReport.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("sdate", vm.StartDate.ToString("MMMM-yyyy"))); reportViewer.LocalReport.SetParameters(new ReportParameter("endate", vm.EndDate.ToString("MMMM-yyyy"))); reportViewer.LocalReport.SetParameters(new ReportParameter("catname", DepartmentIdArraytext)); 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 ExpireIqama() { var viewModel = new OtherReportsDateTimeOnly() { 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 ExpireIqama(OtherReportsDateTimeOnly param) { //SP_Get_Iquama_Epiry Report_EmployeebyExpiringIquama.rpt var vm = param; if (Request.IsAjaxRequest()) { ReportViewerVm reportVM = new ReportViewerVm(); ReportViewer reportViewer = new ReportViewer(); string reportDocPath = ""; DataTable reportData = new DataTable(); reportData = OtherReportDB.getStartEndDateandSP(vm.StartDate, vm.EndDate.AddDays(1), "[MCRS].[PersonnelReports_GetIqamaExpiry]"); reportDocPath = @"\Areas\ManagementReports\Reports\PersonnelReports\PersonnelReports_GetIqamaExpiry.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(); }
public ActionResult EvaluationMonitor(OtherReportsDateTimeOnly param) { //SP_OP_GeneralExpensesReport Report_EmployeeIndividualEvaluation var vm = param; if (Request.IsAjaxRequest()) { var clickEmpId = Request.Form["ClickEmployeeId"]; ReportViewerVm reportVM = new ReportViewerVm(); ReportViewer reportViewer = new ReportViewer(); string reportDocPath = ""; DataTable reportData = new DataTable(); if (clickEmpId == "0") { reportData = OtherReportDB.getEvalMonitr(vm.StartDate, vm.EndDate.AddDays(1)); reportDocPath = @"\Areas\ManagementReports\Reports\HumanResourcesReports\HRD_GetEvaluationMonitor.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", param.StartDate.ToShortDateString())); reportViewer.LocalReport.SetParameters(new ReportParameter("enDate", param.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)); } else { reportData = OtherReportDB.getIndividualEmplEvaluation(clickEmpId); reportDocPath = @"\Areas\ManagementReports\Reports\HumanResourcesReports\HRD_GetEvaluationMonitorIndividual.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", param.StartDate.ToShortDateString())); reportViewer.LocalReport.SetParameters(new ReportParameter("enDate", param.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()); }