//save ItemDeatilsMasterConsignment public object SaveItemDetailssMasterConsignment(ItemDetailsMasterConsignmentModel model, int iUserId) { try { using (var db = new SeaManifestEntities()) { var data = db.tblItemDetailsMasterConsignmentMaps.Where(z => z.iItemsDetailsId == model.iItemsDetailsId).SingleOrDefault(); if (data != null) { data.iMasterConsignmentId = model.iMasterConsignmentId ?? 0; data.iMessageImplementationId = model.iMessageImplementationId; 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 tblItemDetailsMasterConsignmentMap { iMasterConsignmentId = model.iMasterConsignmentId ?? 0, iMessageImplementationId = model.iMessageImplementationId, 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.tblItemDetailsMasterConsignmentMaps.Add(data); db.SaveChanges(); } return(new { Status = true, Message = "Item Details saved successfully!" }); } } catch (Exception) { return(new { Status = false, Message = "Something went wrong" }); } }
public bool Validate(ItemDetailsMasterConsignmentModel model, out string Messages) { Messages = string.Empty; bool valid = true; using (var db = new SeaManifestEntities()) { if (db.tblItemDetailsMasterConsignmentMaps.Any(z => z.iMasterConsignmentId == model.iMasterConsignmentId && z.dCargoItemSequenceNo == model.dCargoItemSequenceNo && z.iItemsDetailsId != model.iItemsDetailsId)) { valid = false; Messages = "Cargo Item Sequence no already exists."; } } return(valid); }