Exemple #1
0
        public ActionResult EquipmentBreakdownReport(MaintenanceReportsEquipmentBreakdown maintenanceReportsBreakdown)
        {
            var vm = maintenanceReportsBreakdown;

            if (Request.IsAjaxRequest())
            {
                //sama
                ReportViewerVm reportVM      = new ReportViewerVm();
                ReportViewer   reportViewer  = new ReportViewer();
                string         reportDocPath = "";

                DataTable reportData = new DataTable();

                // AS per Sir Jericho Table doesnt exist. mcrs made a mdf file that we dont have. so skip this module for now.
                //               Select a.FA_ITEM_NO,b.FA_ITEM_DESCRIPTION,d.DEPT_NAME,
                //case when a.status = 0 then 'Pending/On-Going' when a.status = 1 then 'Completed' else 'Closed' end ItemStatus,
                //a.JR_NO,a.DIAGNOSIS,a.REQ_DATE,a.IMPORTANCE,a.STATUS,a.WORK_TYPE_ID,a.EMP_NO,a.USER_ID
                //--,case when nvl(b.critical,0) = 1 then 'Critical' else 'Non-Critical' end ItemType
                //from MNT_WORK_REQUEST a
                //left join syn_equipment_master_sgh4 b on a.FA_ITEM_NO = b.FA_ITEM_NO
                //left join employee c on a.emp_no = c.emp_no
                //left join depart_ment d on c.department = d.department
                //where a.JR_NO <> 0
            }
            return(View());
        }
Exemple #2
0
        public ActionResult EquipmentBreakdownReport()
        {
            var viewModel = new MaintenanceReportsEquipmentBreakdown()
            {
                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.getAllDepartment(),
                checkboxInDate = "0"
            };

            return(View(viewModel));
        }