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