public bool UpdateIsActive(int VesselVoyageId, bool isActive) { bool isSave = true; try { vv = db.VesselVoyage.Find(VesselVoyageId); vv.IsActiveTrip = isActive; db.VesselVoyage.Attach(vv); db.Entry(vv).Property(p => p.IsActiveTrip).IsModified = true; db.SaveChanges(); } catch (Exception ex) { string msg = ex.ToString(); isSave = false; } return(isSave); }
public bool Delete(int Id) { bool isSaved = true; try { using (WTCCeresEntities d = new WTCCeresEntities()) { vv = d.VesselVoyage.Find(Id); d.VesselVoyage.Remove(vv); d.SaveChanges(); } } catch (Exception ex) { string msg = ex.ToString(); isSaved = false; } return(isSaved); }
public bool Update(int VesselTripId, string VoyageNumber, string ERD, string LRD, string ETA, string ETD, string PortCity, string PortCountry, bool IsActiveTrip, int VesselVoyageStatusId, int VesselId, int PortId) { bool isSave = true; try { using (WTCCeresEntities db = new WTCCeresEntities()) { vv = db.VesselVoyage.Find(VesselTripId); vv.VesselVoyageId = VesselTripId; vv.VoyageNumber = VoyageNumber; if (!String.IsNullOrEmpty(ERD)) { vv.ERD = Convert.ToDateTime(ERD); } else { vv.ERD = null; } if (!String.IsNullOrEmpty(LRD)) { vv.LRD = Convert.ToDateTime(LRD); } else { vv.LRD = null; } if (!String.IsNullOrEmpty(ETA)) { vv.ETA = Convert.ToDateTime(ETA); } else { vv.ETA = null; } if (!String.IsNullOrEmpty(ETD)) { vv.ETD = Convert.ToDateTime(ETD); } else { vv.ETD = null; } vv.PortCity = PortCity; vv.PortCountry = PortCountry; vv.IsActiveTrip = IsActiveTrip; vv.VesselVoyageStatusId = VesselVoyageStatusId; vv.VesselId = VesselId; vv.PortId = PortId; db.VesselVoyage.AddOrUpdate(vv); db.SaveChanges(); } } catch (Exception ex) { string msg = ex.ToString(); isSave = false; } return(isSave); }