public JsonResult AddUpdatePersonOnBoardMessageImplementation(PersonOnBoardMessageImplementationModel model) { if (ModelState.IsValid) { return(Json(PersonOnBoardMessageImplementationService.Instance.SavePersonOnBoardMessageImplementation(model, GetUserInfo().iUserId))); } else { return(Json(new { Status = false, Message = string.Join(",", ModelState.Values.SelectMany(z => z.Errors).Select(z => z.ErrorMessage)) })); } }
//save PersonOnBoardMessageImplementation public object SavePersonOnBoardMessageImplementation(PersonOnBoardMessageImplementationModel model, int iUserId) { try { using (var db = new SeaManifestEntities()) { var data = db.tblPersonOnBoardMessageImplementationMaps.Where(z => z.iPersonOnBoardId == model.iPersonOnBoardId).SingleOrDefault(); if (data != null) { data.iMessageImplementationId = model.iMessageImplementationId; data.dPersonOnBaordSeqNo = model.dPersonOnBaordSeqNo; data.sPersonDetailsPersonTypeCdd = model.sPersonDetailsPersonTypeCdd; data.sPersonDetailsPersonFamilyName = model.sPersonDetailsPersonFamilyName; data.sPersonDetailsPersonGivenName = model.sPersonDetailsPersonGivenName; data.sPersonDetailsPersonNationalityCdd = model.sPersonDetailsPersonNationalityCdd; data.dPersonDetailsPassengersInTransitIndicator = model.dPersonDetailsPassengersInTransitIndicator; data.sPersonDetailsCrewMemberRankOrRatingName = model.sPersonDetailsCrewMemberRankOrRatingName; data.sPersonDetailsCrewMemberRankOrRatingCdd = model.sPersonDetailsCrewMemberRankOrRatingCdd; data.sPersonDetailsPassangerPartOfEmbarkTnCdd = model.sPersonDetailsPassangerPartOfEmbarkTnCdd; data.sPersonDetailsPassangerPartOfEmbarkTnName = model.sPersonDetailsPassangerPartOfEmbarkTnName; data.sPersonDetailsPassangerPartOfDsmbarkTnCdd = model.sPersonDetailsPassangerPartOfDsmbarkTnCdd; data.sPersonDetailsPassangerPartOfDsmbarkTnName = model.sPersonDetailsPassangerPartOfDsmbarkTnName; data.sPersonDetailsPersonGenderCdd = model.sPersonDetailsPersonGenderCdd; data.dtPersonDetailsPersonDateOfBirth = model.dtPersonDetailsPersonDateOfBirth.ToDate(); data.sPersonDetailsPersonPlaceOfBirthName = model.sPersonDetailsPersonPlaceOfBirthName; data.sPersonDetailsPersonCountryOfBirthCdd = model.sPersonDetailsPersonCountryOfBirthCdd; data.dtPersonIdDocExpiryDate = model.dtPersonIdDocExpiryDate.ToDate(); data.sPersonIdOrTravelDocIssuingNationCdd = model.sPersonIdOrTravelDocIssuingNationCdd; data.sPersonIdOrTravelDocNo = model.sPersonIdOrTravelDocNo; data.sPersonIdOrTravelDocTypeCdd = model.sPersonIdOrTravelDocTypeCdd; data.sVisaDetailsPersonVisa = model.sVisaDetailsPersonVisa; data.sVisaDetailsPNRNo = model.sVisaDetailsPNRNo; data.iActionBy = iUserId; data.dtActionDate = DateTime.Now; db.Entry(data).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { data = new tblPersonOnBoardMessageImplementationMap { iMessageImplementationId = model.iMessageImplementationId, dPersonOnBaordSeqNo = model.dPersonOnBaordSeqNo, sPersonDetailsPersonTypeCdd = model.sPersonDetailsPersonTypeCdd, sPersonDetailsPersonFamilyName = model.sPersonDetailsPersonFamilyName, sPersonDetailsPersonGivenName = model.sPersonDetailsPersonGivenName, sPersonDetailsPersonNationalityCdd = model.sPersonDetailsPersonNationalityCdd, dPersonDetailsPassengersInTransitIndicator = model.dPersonDetailsPassengersInTransitIndicator, sPersonDetailsCrewMemberRankOrRatingName = model.sPersonDetailsCrewMemberRankOrRatingName, sPersonDetailsCrewMemberRankOrRatingCdd = model.sPersonDetailsCrewMemberRankOrRatingCdd, sPersonDetailsPassangerPartOfEmbarkTnCdd = model.sPersonDetailsPassangerPartOfEmbarkTnCdd, sPersonDetailsPassangerPartOfEmbarkTnName = model.sPersonDetailsPassangerPartOfEmbarkTnName, sPersonDetailsPassangerPartOfDsmbarkTnCdd = model.sPersonDetailsPassangerPartOfDsmbarkTnCdd, sPersonDetailsPassangerPartOfDsmbarkTnName = model.sPersonDetailsPassangerPartOfDsmbarkTnName, sPersonDetailsPersonGenderCdd = model.sPersonDetailsPersonGenderCdd, dtPersonDetailsPersonDateOfBirth = model.dtPersonDetailsPersonDateOfBirth.ToDate(), sPersonDetailsPersonPlaceOfBirthName = model.sPersonDetailsPersonPlaceOfBirthName, sPersonDetailsPersonCountryOfBirthCdd = model.sPersonDetailsPersonCountryOfBirthCdd, dtPersonIdDocExpiryDate = model.dtPersonIdDocExpiryDate.ToDate(), sPersonIdOrTravelDocIssuingNationCdd = model.sPersonIdOrTravelDocIssuingNationCdd, sPersonIdOrTravelDocNo = model.sPersonIdOrTravelDocNo, sPersonIdOrTravelDocTypeCdd = model.sPersonIdOrTravelDocTypeCdd, sVisaDetailsPersonVisa = model.sVisaDetailsPersonVisa, sVisaDetailsPNRNo = model.sVisaDetailsPNRNo, iActionBy = iUserId, dtActionDate = DateTime.Now, }; db.tblPersonOnBoardMessageImplementationMaps.Add(data); db.SaveChanges(); } return(new { Status = true, Message = "Person On Board saved successfully!" }); } } catch (Exception) { return(new { Status = false, Message = "Something went wrong" }); } }