public JsonResult AddUpdateItineraryHouseCargo(ItineraryHouseCargoModel model) { if (ModelState.IsValid) { return(Json(ItineraryHouseCargoService.Instance.SaveItineraryHouseHouseCargo(model, GetUserInfo().iUserId))); } else { return(Json(new { Status = false, Message = string.Join(",", ModelState.Values.SelectMany(z => z.Errors).Select(z => z.ErrorMessage)) })); } }
//save ItemDeatilsHouseCargo public object SaveItineraryHouseHouseCargo(ItineraryHouseCargoModel model, int iUserId) { try { using (var db = new SeaManifestEntities()) { var data = db.tblItineraryHouseCargoMaps.Where(z => z.iItineraryId == model.iItineraryId).SingleOrDefault(); if (data != null) { data.iMasterConsignmentId = model.iMasterConsignmentId ?? 0; data.iHouseCargoDescId = model.iHouseCargoDescId; data.dPortOfCallSequenceNo = model.dPortOfCallSequenceNo; data.sPortOfCallCd = model.sPortOfCallCd; data.sPortOfCallName = model.sPortOfCallName; data.sNextPortOfCallCdd = model.sNextPortOfCallCdd; data.sNextPortOfCallName = model.sNextPortOfCallName; data.sModeOfTransport = model.sModeOfTransport; data.iActionBy = iUserId; data.dtActionDate = DateTime.Now; db.Entry(data).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { data = new tblItineraryHouseCargoMap { iMasterConsignmentId = model.iMasterConsignmentId ?? 0, iHouseCargoDescId = model.iHouseCargoDescId, dPortOfCallSequenceNo = model.dPortOfCallSequenceNo, sPortOfCallCd = model.sPortOfCallCd, sPortOfCallName = model.sPortOfCallName, sNextPortOfCallCdd = model.sNextPortOfCallCdd, sNextPortOfCallName = model.sNextPortOfCallName, sModeOfTransport = model.sModeOfTransport, iActionBy = iUserId, dtActionDate = DateTime.Now, }; db.tblItineraryHouseCargoMaps.Add(data); db.SaveChanges(); } return(new { Status = true, Message = "Itinerary saved successfully!" }); } } catch (Exception) { return(new { Status = false, Message = "Something went wrong" }); } }