public ActionResult SaveHistory(EquipmentOnHireHistoryPostModel model)
{
PopulateSecurityExtended();
LoadAddHistoryDropdowns();
if (!ModelState.IsValid)
{
return(View(model));
}
//database call
var TANK_usp_insupd_EquipmentOnHireHistory_spParams = new TANK_usp_insupd_EquipmentOnHireHistory_spParams();
#region add
if (!model.OnHireHistoryID.HasValue || (model.OnHireHistoryID.Value == 0))
{
TANK_usp_insupd_EquipmentOnHireHistory_spParams = new TANK_usp_insupd_EquipmentOnHireHistory_spParams()
{
LocationID = SecurityExtended.LocationId.Value,
OnHireHistoryID = model.OnHireHistoryID,
EquipmentAN = model.EquipmentAN.Left(10),
ChargeCodeAn = model.ChargeCodeAn,
ShipmentAN = model.ShipmentAN,
OnHireFL = model.OnHireFL,
OnHireReasonTypeCD = model.OnHireReasonTypeCD,
StatusDt = model.StatusDt.Value,
UpdateUserAn = SecurityExtended.UserName
};
}
#endregion add
#region Edit
if (model.OnHireHistoryID.HasValue && (model.OnHireHistoryID.Value > 0))
{
TANK_usp_insupd_EquipmentOnHireHistory_spParams = new TANK_usp_insupd_EquipmentOnHireHistory_spParams()
{
LocationID = SecurityExtended.LocationId.Value,
OnHireHistoryID = model.OnHireHistoryID,
EquipmentAN = model.EquipmentAN.Left(10),
ChargeCodeAn = model.ChargeCodeAn,
ShipmentAN = model.ShipmentAN,
OnHireFL = model.OnHireFL,
OnHireReasonTypeCD = model.OnHireReasonTypeCD,
StatusDt = model.StatusDt.Value,
UpdateUserAn = SecurityExtended.UserName
};
}
#endregion edit
_utilityService.ExecStoredProcedureWithoutResults("TANK_usp_insupd_EquipmentOnHireHistory", TANK_usp_insupd_EquipmentOnHireHistory_spParams);
//database call
Success("Changes Saved Successfully.");
return(RedirectToAction("Index"));
}
public ActionResult SaveHistory(int?onHireHistoryID)
{
LoadAddHistoryDropdowns();
PopulateSecurityExtended();
// database call
var TANK_usp_sel_EquipmentOnHireHistory_spParams = new TANK_usp_sel_EquipmentOnHireHistory_spParams();
TANK_usp_sel_EquipmentOnHireHistory_spParams.OnHireHistoryID = onHireHistoryID;
var data = _utilityService.ExecStoredProcedureWithResults <TANK_usp_sel_EquipmentOnHireHistory_spResults>("TANK_usp_sel_EquipmentOnHireHistory", TANK_usp_sel_EquipmentOnHireHistory_spParams).ToList();
//database call
var viewModel = new EquipmentOnHireHistoryPostModel();
if (data.Any())
{
var tankHistory = data.FirstOrDefault();
viewModel.OnHireHistoryID = tankHistory.OnHireHistoryID;
viewModel.EquipmentAN = tankHistory.EquipmentAN;
viewModel.ShipmentAN = tankHistory.ShipmentAn;
viewModel.StatusDt = Convert.ToDateTime(tankHistory.StatusDt).Add(TimeSpan.Parse(tankHistory.StatusTime));
viewModel.OnHireFL = tankHistory.OnHireFl;
viewModel.OnHireReasonTypeCDEdit = tankHistory.OnHireReasonTypeCD;
viewModel.ChargeCodeAn = tankHistory.ChargeCodeAn;
viewModel.ChargeCodeID = tankHistory.ChargeCodeID;
}
return(View(viewModel));
}
