public bool AddNewHardware(Tbl_Hardware tu)
{
try
{
if (tu.Request_ID != 0)
{
// user already exists
Tbl_Hardware ToBeUpdatedHardware = _context.Tbl_Hardware.First(x => x.Request_ID == tu.Request_ID);
ToBeUpdatedHardware.Amount = tu.Amount;
ToBeUpdatedHardware.CustomerConnector = tu.CustomerConnector;
ToBeUpdatedHardware.Description = tu.Description;
ToBeUpdatedHardware.Hardware_ID = tu.Hardware_ID;
ToBeUpdatedHardware.LastUpdateDate = tu.LastUpdateDate;
ToBeUpdatedHardware.LastUpdateTime = tu.LastUpdateTime;
ToBeUpdatedHardware.LastUpdateUser_ID = tu.LastUpdateUser_ID;
ToBeUpdatedHardware.RequestDate = tu.RequestDate;
ToBeUpdatedHardware.Customer_ID = tu.Customer_ID;
ToBeUpdatedHardware.Status = tu.Status;
ToBeUpdatedHardware.DeliveryDate = tu.DeliveryDate;
ToBeUpdatedHardware.DeliveryDescription = tu.DeliveryDescription;
ToBeUpdatedHardware.DeliveryDeviceSerialNumber = tu.DeliveryDeviceSerialNumber;
}
else
{
Tbl_Hardware ToBeInsertedHardware = new Tbl_Hardware();
ToBeInsertedHardware.Amount = tu.Amount;
ToBeInsertedHardware.CustomerConnector = tu.CustomerConnector;
ToBeInsertedHardware.Description = tu.Description;
ToBeInsertedHardware.Hardware_ID = tu.Hardware_ID;
ToBeInsertedHardware.LastUpdateDate = tu.LastUpdateDate;
ToBeInsertedHardware.LastUpdateTime = tu.LastUpdateTime;
ToBeInsertedHardware.LastUpdateUser_ID = tu.LastUpdateUser_ID;
ToBeInsertedHardware.RequestDate = tu.RequestDate;
ToBeInsertedHardware.Customer_ID = tu.Customer_ID;
ToBeInsertedHardware.Status = 0;
ToBeInsertedHardware.DeliveryDate = tu.DeliveryDate;
ToBeInsertedHardware.DeliveryDescription = tu.DeliveryDescription;
ToBeInsertedHardware.DeliveryDeviceSerialNumber = tu.DeliveryDeviceSerialNumber;
_context.Tbl_Hardware.Add(ToBeInsertedHardware);
}
if (_context.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult SubmitHardware(DataSourceRequest command, HardwareListModel model)
{
HttpSessionStateBase session = HttpContext.Session;
try
{
if (false) // field validation
{
var gridModel = new DataSourceResult
{
ExtraData = new HardwareListModel
{
Message = Message.InvalidCharacter,
},
Total = 1
};
return Json(gridModel);
}
Tbl_Hardware tu = new Tbl_Hardware();
tu.Request_ID = model.Request_ID;
tu.CustomerConnector = model.CustomerConnector;
tu.Customer_ID = model.Customer_ID;
tu.Description = model.Description;
tu.Hardware_ID = model.Hardware_ID;
tu.RequestDate = model.RequestDate;
if (model.Check_Delivery && !model.Check_Revocation)
tu.Status = 1;
else if (!model.Check_Delivery && model.Check_Revocation)
tu.Status = 2;
else
tu.Status = 0;
tu.DeliveryDate = model.DeliveryDate;
tu.DeliveryDescription = model.DeliveryDescription;
tu.DeliveryDeviceSerialNumber = model.DeliveryDeviceSerialNumber;
tu.Amount = model.Amount;
tu.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]);
tu.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd");
tu.LastUpdateTime = DateTime.Now.ToString("HH:mm");
if (_hardwareService.AddNewHardware(tu))
{
var gridModel = new DataSourceResult
{
ExtraData = new HardwareListModel
{
Message = Message.OperationSuccessful,
MessageColor = "green"
},
Total = 1
};
return Json(gridModel);
}
else
{
var gridModel = new DataSourceResult
{
ExtraData = new HardwareListModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red"
},
Total = 1
};
return Json(gridModel);
}
}
catch (Exception ex)
{
var gridModel = new DataSourceResult
{
ExtraData = new HardwareListModel
{
Message = Message.OperationUnsuccessful,
MessageColor = "red"
},
Total = 1
};
return Json(gridModel);
}
//return "";
}
