public JsonResult AddUpdateTransportEquipmentMessageImplementation(TransportEquipmentMessageImplementationModel model)
{
if (ModelState.IsValid)
{
return(Json(TransportEquipmentMessageImplementationService.Instance.SaveTransportEquipmentMessageImplementation(model, GetUserInfo().iUserId)));
}
else
{
return(Json(new { Status = false, Message = string.Join(",", ModelState.Values.SelectMany(z => z.Errors).Select(z => z.ErrorMessage)) }));
}
}
//save TransportEquipmentMessageImplementation
public object SaveTransportEquipmentMessageImplementation(TransportEquipmentMessageImplementationModel model, int iUserId)
{
try
{
using (var db = new SeaManifestEntities())
{
var data = db.tblVoyageTransporterEquipmentMessageImplementationMaps.Where(z => z.iVoyageTransportId == model.iTransporterEquipmentId).SingleOrDefault();
if (data != null)
{
data.iMessageImplementationId = model.iMessageImplementationId;
data.iEquipmentSequenceNo = model.iEquipmentSequenceNo;
data.sEquipmentId = model.sEquipmentId;
data.sEquipmentType = model.sEquipmentType;
data.sEquipmentSize = model.sEquipmentSize;
data.sEquipmentLoadStatus = model.sEquipmentLoadStatus;
data.sAdditionalEquipmentHold = model.sAdditionalEquipmentHold;
data.dtEventDate = model.sEventDate.ToDate();
data.sEquipmentSealType = model.sEquipmentSealType;
data.sEquipmentSealNo = model.sEquipmentSealNo;
data.sOtherEquipmentId = model.sOtherEquipmentId;
data.sSOCFlag = model.sSOCFlag;
data.sContainerAgentCode = model.sContainerAgentCd;
data.dContainerWeight = model.dContainerWeight;
data.dTotalNoOfPackages = model.dTotalNoOfPackages;
data.sEquipmentStatus = model.sEquipmentStatus;
data.sFinalLocation = model.sFinalLocation;
data.sStoragePositionCoded = model.sStoragePositionCoded;
data.iActionBy = iUserId;
data.dtActionDate = DateTime.Now;
db.Entry(data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
data = new tblVoyageTransporterEquipmentMessageImplementationMap
{
iMessageImplementationId = model.iMessageImplementationId,
iEquipmentSequenceNo = model.iEquipmentSequenceNo,
sEquipmentId = model.sEquipmentId,
sEquipmentType = model.sEquipmentType,
sEquipmentSize = model.sEquipmentSize,
sEquipmentLoadStatus = model.sEquipmentLoadStatus,
sAdditionalEquipmentHold = model.sAdditionalEquipmentHold,
dtEventDate = model.sEventDate.ToDate(),
sEquipmentSealType = model.sEquipmentSealType,
sEquipmentSealNo = model.sEquipmentSealNo,
sOtherEquipmentId = model.sOtherEquipmentId,
sSOCFlag = model.sSOCFlag,
sContainerAgentCode = model.sContainerAgentCd,
dContainerWeight = model.dContainerWeight,
dTotalNoOfPackages = model.dTotalNoOfPackages,
sEquipmentStatus = model.sEquipmentStatus,
sFinalLocation = model.sFinalLocation,
sStoragePositionCoded = model.sStoragePositionCoded,
iActionBy = iUserId,
dtActionDate = DateTime.Now,
};
db.tblVoyageTransporterEquipmentMessageImplementationMaps.Add(data);
db.SaveChanges();
}
return(new { Status = true, Message = "Transport Equipment saved successfully!" });
}
}
catch (Exception)
{
return(new { Status = false, Message = "Something went wrong" });
}
}
