//[OutputCache(Duration = 3600, VaryByParam = "none")]
public ActionResult Index()
{
PopulateSecurityExtended();
int securityProfileId = SecurityExtended.SecurityProfileId;
var permissionList = _sharedFunctions.GetSecuritySettings(securityProfileId, (int)SecurityCatEnum.RequireService, null);
ViewBag.AccessDispatch = false;
ViewBag.EditTestDates = false;
foreach (var permission in permissionList)
{
if (permission.PrivilegeDS == "Dispatch")
{
ViewBag.AccessDispatch = (permission.GrantedFL == 1);
}
else if (permission.PrivilegeDS == "Edit Test Dates")
{
ViewBag.EditTestDates = (permission.GrantedFL == 1);
}
}
// database call
var TANK_usp_rpt_RequiresMaint_spParams = new TANK_usp_rpt_RequiresMaint_spParams()
{
LocationID = SecurityExtended.LocationId ?? 0
};
DataTable dataTable = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_rpt_RequiresMaint", TANK_usp_rpt_RequiresMaint_spParams);
dataTable.Columns["EquipmentID"].SetOrdinal(9);
//# database call
@ViewBag.TotalRecords = dataTable.Rows.Count;
return(View(dataTable));
}
//
// GET: /RequireService/
public ActionResult Index()
{
// database call
var TANK_usp_rpt_RequiresMaint_spParams = new TANK_usp_rpt_RequiresMaint_spParams()
{
//TODO: re-factor it later from hard coded
LocationID = 1
};
DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_rpt_RequiresMaint", TANK_usp_rpt_RequiresMaint_spParams);
//# database call
@ViewBag.TotalRecords = data.Rows.Count;
return(View(data));
}
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"));
}