public ActionResult Index(int?page = 1) { PopulateSecurityExtended(); int securityProfileId = SecurityExtended.SecurityProfileId; var permissionList = _sharedFunctions.GetSecuritySettings(securityProfileId, (int)SecurityCatEnum.RequireCleaning, null); ViewBag.AccessDispatch = false; foreach (var permission in permissionList) { if (permission.PrivilegeDS == "Dispatch") { ViewBag.AccessDispatch = (permission.GrantedFL == 1); } } // database call var TANK_usp_rpt_RequiresCleaning_spParams = new TANK_usp_rpt_RequiresCleaning_spParams() { InstallID = 1, LocationID = SecurityExtended.LocationId ?? 0 }; DataTable dataTable = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_rpt_RequiresCleaning", TANK_usp_rpt_RequiresCleaning_spParams); dataTable.Columns["EquipmentID"].SetOrdinal(8); //# database call @ViewBag.TotalRecords = dataTable.Rows.Count; return(View(dataTable)); }
// // GET: /RequireCleaning/ public ActionResult Index(int?page = 1) { // database call var TANK_usp_rpt_RequiresCleaning_spParams = new TANK_usp_rpt_RequiresCleaning_spParams() { //TODO: re-factor it later from hard coded InstallID = 1, LocationID = 1 }; DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_rpt_RequiresCleaning", TANK_usp_rpt_RequiresCleaning_spParams); //# database call @ViewBag.TotalRecords = data.Rows.Count; return(View(data)); }
public ActionResult ViewInExcel() { PopulateSecurityExtended(); // database call var TANK_usp_rpt_RequiresCleaning_spParams = new TANK_usp_rpt_RequiresCleaning_spParams() { //TODO: re-factor it later from hard coded InstallID = 1, LocationID = SecurityExtended.LocationId.Value }; DataTable dataTable = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_rpt_RequiresCleaning", TANK_usp_rpt_RequiresCleaning_spParams); dataTable.Columns["EquipmentID"].SetOrdinal(8); //# database call _sharedFunctions.LoadExcel(dataTable); return(RedirectToAction("Index")); }