public bool Validate(ItemDetailsHouseCargoModel model, out string Messages) { Messages = string.Empty; bool valid = true; using (var db = new SeaManifestEntities()) { if (db.tblItemDetailsHouseCargoMaps.Any(z => z.iHouseCargoDescId == model.iHouseCargoDescId && z.dCargoItemSequenceNo == model.dCargoItemSequenceNo && z.iItemsDetailsId != model.iItemsDetailsId)) { valid = false; Messages = "Cargo Item Sequence no already exists."; } } return(valid); }
//save ItemDeatilsHouseCargo public object SaveItemDetailssHouseCargo(ItemDetailsHouseCargoModel model, int iUserId) { try { using (var db = new SeaManifestEntities()) { var data = db.tblItemDetailsHouseCargoMaps.Where(z => z.iItemsDetailsId == model.iItemsDetailsId).SingleOrDefault(); if (data != null) { data.iHouseCargoDescId = model.iHouseCargoDescId ?? 0; data.iMasterConsignmentId = model.iMasterConsignmentId; data.dCargoItemSequenceNo = model.dCargoItemSequenceNo; data.sHsCd = model.sHsCd; data.sCargoItemDesc = model.sCargoItemDesc; data.sUnoCd = model.sUnoCd; data.sIMDGCd = model.sIMDGCd; data.dNoOfPakages = model.dNoOfPakages; data.sTypesOfPackages = model.sTypesOfPackages; data.iActionBy = iUserId; data.dtActionDate = DateTime.Now; db.Entry(data).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { data = new tblItemDetailsHouseCargoMap { iHouseCargoDescId = model.iHouseCargoDescId ?? 0, iMasterConsignmentId = model.iMasterConsignmentId, dCargoItemSequenceNo = model.dCargoItemSequenceNo, sHsCd = model.sHsCd, sCargoItemDesc = model.sCargoItemDesc, sUnoCd = model.sUnoCd, sIMDGCd = model.sIMDGCd, dNoOfPakages = model.dNoOfPakages, sTypesOfPackages = model.sTypesOfPackages, iActionBy = iUserId, dtActionDate = DateTime.Now, }; db.tblItemDetailsHouseCargoMaps.Add(data); db.SaveChanges(); } return(new { Status = true, Message = "Item Details saved successfully!" }); } } catch (Exception) { return(new { Status = false, Message = "Something went wrong" }); } }