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"));
}