//
// GET: /TankSearch/
public ActionResult Index()
{
LoadTankSearchDropdowns();
TankSearchPostModel postModel;
DataTable data;
var TANK_usp_rpt_TankSearch_spParams = new TANK_usp_rpt_TankSearch_spParams();
if (TempData["postModel"] != null)
{
postModel = (TankSearchPostModel)TempData["postModel"];
TANK_usp_rpt_TankSearch_spParams.LocationID = 1;
if (postModel.TankNumber != null && postModel.TankNumber.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.EquipmentAN = postModel.TankNumber;
}
if (postModel.Chassis != null && postModel.Chassis.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ChassisEquipmentAN = postModel.Chassis;
}
if (postModel.Product != null && postModel.Product.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ProductDS = postModel.Product.Trim().Replace("%", "[%]");
}
if (postModel.LoadStatus != null && postModel.LoadStatus.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.LoadStatusTypeCD = postModel.LoadStatus;
}
if (postModel.LocationFromCode != null && postModel.LocationFromCode > 0)
{
TANK_usp_rpt_TankSearch_spParams.FromSubLocationID = postModel.LocationFromCode;
//TANK_usp_rpt_TankSearch_spParams.FromSubLocationDS = postModel.LocationFrom;
}
if (postModel.LocationToCode != null && postModel.LocationToCode > 0)
{
TANK_usp_rpt_TankSearch_spParams.SubLocationID = postModel.LocationToCode;
//TANK_usp_rpt_TankSearch_spParams.SubLocationDS = postModel.LocationTo;
}
if (postModel.ChargeNbr != null && postModel.ChargeNbr.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ChargeCodeAN = postModel.ChargeNbr;
}
if (postModel.ShipmentNbr != null && postModel.ShipmentNbr.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ShipmentAN = postModel.ShipmentNbr;
}
if (postModel.ChargeBlockOnHire != null && postModel.ChargeBlockOnHire.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ChargeBlockLocationAN = postModel.ChargeBlockOnHire;
}
if (postModel.ServiceType != null && postModel.ServiceType.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ServiceTypeDS = postModel.ServiceType;
}
if (postModel.DedicatedProduct != null && postModel.DedicatedProduct.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.DedicatedProductDS = postModel.DedicatedProduct;
}
if (postModel.DispatchReason != null && postModel.DispatchReason != null)
{
TANK_usp_rpt_TankSearch_spParams.DispatchReasonTypeCD = postModel.DispatchReason;
}
if (postModel.chkLastMove != null && postModel.chkLastMove)
{
TANK_usp_rpt_TankSearch_spParams.SearchLastMoveOnlyFL = postModel.chkLastMove;
}
}
else
{
//todo: re-factor it later, and search using postModel listed above
TANK_usp_rpt_TankSearch_spParams.LocationID = 1;
TANK_usp_rpt_TankSearch_spParams.EquipmentAN = "LT 1029";
}
// database call
data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_rpt_TankSearch", TANK_usp_rpt_TankSearch_spParams);
//# database call
@ViewBag.TotalRecords = data.Rows.Count;
return(View(data));
}
//
// GET: /TankSearch/
public ActionResult Index()
{
PopulateSecurityExtended();
int securityProfileId = SecurityExtended.SecurityProfileId;
var permissionList = _sharedFunctions.GetSecuritySettings(securityProfileId, (int)SecurityCatEnum.TankSearch, null);
ViewBag.AccessDispatch = false;
ViewBag.AllowPrep = false;
foreach (var permission in permissionList)
{
if (permission.PrivilegeDS == "Dispatch")
{
ViewBag.AccessDispatch = (permission.GrantedFL == 1);
}
else if (permission.PrivilegeDS == "Prep")
{
ViewBag.AllowPrep = (permission.GrantedFL == 1);
}
}
LoadTankSearchDropdowns();
TankSearchPostModel postModel;
var dataTable = new DataTable();
var TANK_usp_rpt_TankSearch_spParams = new TANK_usp_rpt_TankSearch_spParams();
if (TempData["postModel"] != null)
{
postModel = (TankSearchPostModel)TempData["postModel"];
TANK_usp_rpt_TankSearch_spParams.LocationID = SecurityExtended.LocationId.Value;
if (postModel.TankNumber != null && postModel.TankNumber.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.EquipmentAN = postModel.TankNumber;
}
if (postModel.Chassis != null && postModel.Chassis.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ChassisEquipmentAN = postModel.Chassis;
}
if (postModel.Product != null && postModel.Product.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ProductDS = postModel.Product.Trim().Replace("%", "[%]");
}
if (postModel.LoadStatus != null && postModel.LoadStatus.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.LoadStatusTypeCD = postModel.LoadStatus;
}
if (postModel.LocationFromCode != null && postModel.LocationFromCode > 0)
{
TANK_usp_rpt_TankSearch_spParams.FromSubLocationID = postModel.LocationFromCode;
TANK_usp_rpt_TankSearch_spParams.FromSubLocationDS = "";
}
if (postModel.LocationToCode != null && postModel.LocationToCode > 0)
{
TANK_usp_rpt_TankSearch_spParams.SubLocationID = postModel.LocationToCode;
TANK_usp_rpt_TankSearch_spParams.SubLocationDS = "";
}
if (postModel.ChargeNbr != null && postModel.ChargeNbr.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ChargeCodeAN = postModel.ChargeNbr;
}
if (postModel.ShipmentNbr != null && postModel.ShipmentNbr.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ShipmentAN = postModel.ShipmentNbr;
}
if (postModel.ChargeBlockOnHire != null && postModel.ChargeBlockOnHire.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ChargeBlockLocationAN = postModel.ChargeBlockOnHire;
}
if (postModel.ServiceType != null && postModel.ServiceType.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.ServiceTypeDS = postModel.ServiceType;
}
if (postModel.DedicatedProduct != null && postModel.DedicatedProduct.Trim().Length > 0)
{
TANK_usp_rpt_TankSearch_spParams.DedicatedProductDS = postModel.DedicatedProduct;
}
if (postModel.DispatchReason != null && postModel.DispatchReason != null)
{
TANK_usp_rpt_TankSearch_spParams.DispatchReasonTypeCD = postModel.DispatchReason;
}
if (postModel.chkLastMove != null && postModel.chkLastMove)
{
TANK_usp_rpt_TankSearch_spParams.SearchLastMoveOnlyFL = postModel.chkLastMove;
}
// database call
dataTable = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_rpt_TankSearch", TANK_usp_rpt_TankSearch_spParams);
//# database call
}
@ViewBag.TotalRecords = dataTable.Rows.Count;
return(View(dataTable));
}
