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