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));
}
private DataTable GetOnHireHistory(bool showColumnsOnly, int locationId, string equipment)
{
// database call
var TANK_usp_sel_EquipmentOnHireHistory_spParams = new TANK_usp_sel_EquipmentOnHireHistory_spParams();
TANK_usp_sel_EquipmentOnHireHistory_spParams.LocationID = locationId;
TANK_usp_sel_EquipmentOnHireHistory_spParams.EquipmentAn = equipment;
DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_sel_EquipmentOnHireHistory", TANK_usp_sel_EquipmentOnHireHistory_spParams);
data.Columns["OnHireHistoryID"].SetOrdinal(13);
if (showColumnsOnly)
{
data.Clear();
}
@ViewBag.TotalOnHireHistory = data.Rows.Count;
return(data);
}
