public ActionResult Index(DispatchTankModel postModel)
{
if (!ModelState.IsValid)
{
//return appropriate validation messages
return(View(postModel));
}
return(View(postModel));
}
// GET: Dispatch
public ActionResult Index(string equipmentAn, int?dispatchId, string mode)
{
PopulateSecurityExtended();
int securityProfileId = SecurityExtended.SecurityProfileId;
var permissionList = _sharedFunctions.GetSecuritySettings(securityProfileId, (int)SecurityCatEnum.DispatchScreen, null);
ViewBag.AllowDeleteDispatch = false;
ViewBag.AllowAddProduct = false;
ViewBag.AllowAddInvoice = false;
foreach (var permission in permissionList)
{
if (permission.PrivilegeDS == "Delete Dispatch")
{
ViewBag.AllowDeleteDispatch = (permission.GrantedFL == 1);
}
else if (permission.PrivilegeDS == "Add Product")
{
ViewBag.AllowAddProduct = (permission.GrantedFL == 1);
}
else if (permission.PrivilegeDS == "Add Invoice")
{
ViewBag.AllowAddInvoice = (permission.GrantedFL == 1);
}
}
LoadDispatchTankDropdowns();
TempData["EquipmentAN"] = ViewBag.EquipmentAN = equipmentAn;
var postModel = new DispatchTankModel();
postModel.intDispatchId = dispatchId;
if (dispatchId.HasValue)
{
LoadDispatch(dispatchId.Value, postModel);
}
return(View(postModel));
}
private void LoadDispatch(int dispatchId, DispatchTankModel postModel)
{
postModel.LoadDispatchData = 1;
// database call
var TANK_usp_sel_Dispatch_spParams = new TANK_usp_sel_Dispatch_spParams()
{
DispatchID = dispatchId
};
DataTable dataTable = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_sel_Dispatch", TANK_usp_sel_Dispatch_spParams);
postModel.intDispatchId = dispatchId;
postModel.EquipmentAN = dataTable.Rows[0]["EquipmentAN"].ToString();
postModel.EquipmentID = dataTable.Rows[0]["EquipmentId"] != null ? (int)dataTable.Rows[0]["EquipmentId"] : 0;
postModel.ChargeCodeAN = dataTable.Rows[0]["ChargeCodeAN"].ToString();
postModel.ChargeCodeID = dataTable.Rows[0]["ChargeCodeID"] != null ? (int)dataTable.Rows[0]["EquipmentId"] : 0;
postModel.LoadStatusTypeCD = dataTable.Rows[0]["LoadStatusTypeCD"] != null ? (Int16?)dataTable.Rows[0]["LoadStatusTypeCD"] : 0;
postModel.ChargeBlockLocationID = !string.IsNullOrEmpty(dataTable.Rows[0]["ChargeBlockLocationID"].ToString()) ? (Int32?)dataTable.Rows[0]["ChargeBlockLocationID"] : 0;
postModel.ChargeBlockLocationDS = dataTable.Rows[0]["ChargeBlockLocationDS"].ToString();
postModel.bolIsReloadFL = (Boolean)dataTable.Rows[0]["ReloadFL"];
postModel.WasteClassTypeCD = !string.IsNullOrEmpty(dataTable.Rows[0]["WasteClassTypeCD"].ToString()) ? (Int32?)dataTable.Rows[0]["WasteClassTypeCD"] : 0;
postModel.WasteClassTypeDS = dataTable.Rows[0]["WasteClassTypeDS"].ToString();
postModel.DispatchReasonTypeCD = !string.IsNullOrEmpty(dataTable.Rows[0]["DispatchReasonTypeCD"].ToString()) ? (Int16?)dataTable.Rows[0]["DispatchReasonTypeCD"] : 0;
postModel.DispatchReasonTypeDS = dataTable.Rows[0]["DispatchReasonTypeDS"].ToString();
postModel.AdditionalDispatchReasonTypeCD = !string.IsNullOrEmpty(dataTable.Rows[0]["AdditionalDispatchReasonTypeCD"].ToString()) ? (Int16?)dataTable.Rows[0]["AdditionalDispatchReasonTypeCD"] : 0;
postModel.AdditionalDispatchReasonTypeDS = dataTable.Rows[0]["AdditionalDispatchReasonTypeDS"].ToString();
postModel.strProNumberAN = dataTable.Rows[0]["ProNumberAN"].ToString();
postModel.dblCallOutHoursAMT = !string.IsNullOrEmpty(dataTable.Rows[0]["CallOutHoursAMT"].ToString()) ? (decimal?)dataTable.Rows[0]["CallOutHoursAMT"] : null;
postModel.sintCraneLiftAmt = !string.IsNullOrEmpty(dataTable.Rows[0]["CraneLiftAmt"].ToString()) ? (Int16?)dataTable.Rows[0]["CraneLiftAmt"] : null;
//dispatch start date
postModel.dtmDispatchStart = !string.IsNullOrEmpty(dataTable.Rows[0]["DispatchDt"].ToString())
? (DateTime?)Convert.ToDateTime(dataTable.Rows[0]["DispatchDt"])
: null;
var start = !string.IsNullOrEmpty(dataTable.Rows[0]["Start"].ToString())
? (TimeSpan?)TimeSpan.Parse(dataTable.Rows[0]["Start"].ToString())
: null;
if (postModel.dtmDispatchStart.HasValue && start.HasValue)
{
postModel.dtmDispatchStart = postModel.dtmDispatchStart.Value.Add(start.Value);
}
//disptach end date
postModel.dtmDispatchEnd = !string.IsNullOrEmpty(dataTable.Rows[0]["DeliveryDt"].ToString())
? (DateTime?)Convert.ToDateTime(dataTable.Rows[0]["DeliveryDt"])
: null;
var end = !string.IsNullOrEmpty(dataTable.Rows[0]["End"].ToString())
? (TimeSpan?)TimeSpan.Parse(dataTable.Rows[0]["End"].ToString())
: null;
if (postModel.dtmDispatchEnd.HasValue && end.HasValue)
{
postModel.dtmDispatchEnd = postModel.dtmDispatchEnd.Value.Add(end.Value);
}
//dtmScheduledDelivery
postModel.dtmScheduledDelivery = !string.IsNullOrEmpty(dataTable.Rows[0]["ScheduledDeliveryDT"].ToString())
? (DateTime?)Convert.ToDateTime(dataTable.Rows[0]["ScheduledDeliveryDT"])
: null;
var deliveryTime = !string.IsNullOrEmpty(dataTable.Rows[0]["ScheduledDeliveryTime"].ToString())
? (TimeSpan?)TimeSpan.Parse(dataTable.Rows[0]["ScheduledDeliveryTime"].ToString())
: null;
if (postModel.dtmScheduledDelivery.HasValue && deliveryTime.HasValue)
{
postModel.dtmScheduledDelivery = postModel.dtmScheduledDelivery.Value.Add(deliveryTime.Value);
}
postModel.strShipmentAN = dataTable.Rows[0]["ShipmentAN"].ToString();
postModel.FittingCD = !string.IsNullOrEmpty(dataTable.Rows[0]["FittingCD"].ToString()) ? (int?)dataTable.Rows[0]["FittingCD"] : null;
postModel.ContactID = postModel.FittingCD = !string.IsNullOrEmpty(dataTable.Rows[0]["ContactID"].ToString()) ? (int?)dataTable.Rows[0]["ContactID"] : null;
postModel.Contact = dataTable.Rows[0]["Contact"].ToString();
postModel.strComments = dataTable.Rows[0]["CommentsAN"].ToString();
//# database call
}
public ActionResult Index(DispatchTankModel postModel, String ChassisID, String ProductID, String DriverID, String LoadStatusTypeCD)
{
PopulateSecurityExtended();
LoadDispatchTankDropdowns();
if (!ModelState.IsValid)
{
if (TempData["EquipmentAN"] != null)
{
TempData["EquipmentAN"] = ViewBag.EquipmentAN = TempData["EquipmentAN"].ToString();
}
//return appropriate validation messages
return(View(postModel));
}
//todo: re-factor it as required
TANK_usp_insupd_DispatchTank_spParams objDispatchTankParams = new TANK_usp_insupd_DispatchTank_spParams();
if (postModel.intDispatchId != null && postModel.intDispatchId > 0)
{
objDispatchTankParams.DispatchID = postModel.intDispatchId;
}
objDispatchTankParams.LocationID = SecurityExtended.LocationId.Value;
objDispatchTankParams.EquipmentID = postModel.intEquipmentId;
if (ChassisID.Trim().Length > 0)
{
objDispatchTankParams.ChassisEquipmentID = Convert.ToInt32(ChassisID);
}
if (postModel.sintLoadStatusTypeId != null && postModel.sintLoadStatusTypeId > 0)
{
objDispatchTankParams.LoadStatusTypeCD = postModel.sintLoadStatusTypeId;
}
if (ProductID.Trim().Length > 0)
{
objDispatchTankParams.ProductID = Convert.ToInt16(ProductID);
}
if (postModel.sintDispatchReasonTypeId != null && postModel.sintDispatchReasonTypeId > 0)
{
objDispatchTankParams.DispatchReasonTypeCd = postModel.sintDispatchReasonTypeId;
}
if (postModel.sintAdditionalDispatchReasonTypeId != null && postModel.sintAdditionalDispatchReasonTypeId > 0)
{
objDispatchTankParams.AdditionalDispatchReasonTypeCD = postModel.sintAdditionalDispatchReasonTypeId;
}
objDispatchTankParams.FromLocationID = postModel.intLocationFrom;
objDispatchTankParams.ToLocationID = postModel.intLocationTo;
objDispatchTankParams.ShipmentAN = postModel.strShipmentAN;
if (DriverID.Trim().Length > 0)
{
objDispatchTankParams.DriverID = Convert.ToInt32(DriverID);
}
if (postModel.dtmDispatchStart != null && postModel.dtmDispatchStart.Value != DateTime.MinValue)
{
objDispatchTankParams.DispatchStartDT = postModel.dtmDispatchStart;
}
if (postModel.dtmDispatchEnd != null && postModel.dtmDispatchEnd.Value != DateTime.MinValue)
{
objDispatchTankParams.DispatchEndDT = postModel.dtmDispatchEnd;
}
if (postModel.dtmScheduledDelivery != null && postModel.dtmScheduledDelivery.Value != DateTime.MinValue)
{
objDispatchTankParams.ScheduledDeliveryDT = postModel.dtmScheduledDelivery;
}
if (postModel.intContactId != null && postModel.intContactId > 0)
{
objDispatchTankParams.ContactID = postModel.intContactId;
}
if (postModel.intChargeCode != null && postModel.intChargeCode > 0)
{
objDispatchTankParams.ChargeCodeID = postModel.intChargeCode;
}
if (postModel.intChargeBlockLocationId != null && postModel.intChargeBlockLocationId > 0)
{
objDispatchTankParams.ChargeBlockLocationID = postModel.intChargeBlockLocationId;
}
if (postModel.sintCraneLiftAmt != null && postModel.sintCraneLiftAmt > 0)
{
objDispatchTankParams.CraneLiftAmt = postModel.sintCraneLiftAmt;
}
if (postModel.intFittingId != null && postModel.intFittingId > 0)
{
objDispatchTankParams.FittingCD = postModel.intFittingId;
}
objDispatchTankParams.PlannedFL = postModel.bolIsPlannedFL;
objDispatchTankParams.ProNumberAN = postModel.strProNumberAN;
objDispatchTankParams.CommentsAn = postModel.strComments;
if (postModel.dblCallOutHoursAMT != null && postModel.dblCallOutHoursAMT > 0)
{
objDispatchTankParams.CallOutHoursAMT = postModel.dblCallOutHoursAMT.Value;
}
if (postModel.intWasteClassTypeId != null && postModel.intWasteClassTypeId > 0)
{
objDispatchTankParams.WasteClassTypeCD = postModel.intWasteClassTypeId;
}
objDispatchTankParams.ReloadFL = postModel.bolIsReloadFL;
objDispatchTankParams.CleaningApprovedFL = postModel.bolIsCleaningApprovedFL;
objDispatchTankParams.WPNAN = postModel.strWPNAN;
objDispatchTankParams.UpdateUserAN = SecurityExtended.UserName;
_utilityService.ExecStoredProcedureWithoutResults("TANK_usp_insupd_Dispatch", objDispatchTankParams);
Success("Dispatch Tank Saved Successfully.");
//return appropriate message
return(View(postModel));
}
