public Trip(TRIP trip) { ID = trip.TRIP_ID; Description = trip.DESCRIPTION; Title = trip.TITTLE; thumnailPath = trip.THUMNAIL; StartDate = (DateTime)trip.TOGODATE; EndDate = (DateTime)trip.RETURNDATE; isDone = (bool)trip.ISDONE; }
public static int AddNewTrip(Trip newTrip) { TRIP newTripCreated = DatabaseEntity.Entity.DB.TRIPs.Add(newTrip.ToTrip()); if (newTripCreated == null) { return(-1); } DatabaseEntity.Entity.DB.SaveChanges(); return(newTripCreated.TRIP_ID); }
public static void UpdateTripInfo(Trip updatedItem) { TRIP item = new TRIP() { TRIP_ID = updatedItem.ID, DESCRIPTION = updatedItem.Description, TITTLE = updatedItem.Title, THUMNAIL = updatedItem.ThumnailPath, TOGODATE = updatedItem.StartDate, RETURNDATE = updatedItem.EndDate, ISDONE = (bool?)updatedItem.IsDone }; var entity = DatabaseEntity.Entity.DB.TRIPs.Find(item.TRIP_ID); if (entity == null) { return; } DatabaseEntity.Entity.DB.Entry(entity).CurrentValues.SetValues(item); DatabaseEntity.Entity.DB.SaveChanges(); }
public static Trip GetTripByID(int tripID) { TRIP trip = DatabaseEntity.Entity.DB.TRIPs.SingleOrDefault(x => x.TRIP_ID == tripID); return(new Trip(trip)); }