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