public ActionResult ViewInExcel() { PopulateSecurityExtended(); // database call var TANK_usp_rpt_RequiresMaint_spParams = new TANK_usp_rpt_RequiresMaint_spParams() { //TODO: re-factor it later from hard coded LocationID = SecurityExtended.LocationId.Value }; DataTable dataTable = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_rpt_RequiresMaint", TANK_usp_rpt_RequiresMaint_spParams); //# database call _sharedFunctions.LoadExcel(dataTable); return(RedirectToAction("Index")); }
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")); }