public static void UpdateGuest(Person p) { CUResortEntities DB = new CUResortEntities(); DB.Entry(p).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); }
public static void UpdateReservation(Reservation r) { CUResortEntities DB = new CUResortEntities(); DB.Entry(r).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); }
public static void AddGuest(Person p) { CUResortEntities DB = new CUResortEntities(); DB.People.Add(p); DB.SaveChanges(); }
public static List <Reservation> GetReservations() { // ordered by Date Reserved CUResortEntities DB = new CUResortEntities(); return(DB.Reservations.OrderBy(x => x.DateReserved).ToList()); }
public static void DeleteGuest(int ID) { CUResortEntities DB = new CUResortEntities(); Person p = DB.People.Find(ID); DB.People.Remove(p); DB.SaveChanges(); }
public static void DeleteReservation(int ID) { CUResortEntities DB = new CUResortEntities(); Reservation r = DB.Reservations.Find(ID); DB.Reservations.Remove(r); DB.SaveChanges(); }
public static void AddReservation(Reservation r) { CUResortEntities DB = new CUResortEntities(); if (r.DateReserved == null) { r.DateReserved = DateTime.Now; } DB.Reservations.Add(r); DB.SaveChanges(); }
public static List <Person> GetGuests() { CUResortEntities DB = new CUResortEntities(); return(DB.People.OrderBy(x => x.LNAME).ToList()); }
public static int CountGuestReservations(int GuestID) { CUResortEntities DB = new CUResortEntities(); return(DB.Reservations.Where(x => x.GID == GuestID).Count()); }
public static Reservation GetReservationByID(int ID) { CUResortEntities DB = new CUResortEntities(); return(DB.Reservations.Find(ID)); }
public static Person GetPersonByID(int ID) { CUResortEntities DB = new CUResortEntities(); return(DB.People.Find(ID)); }
public static List <Room> GetRooms() { CUResortEntities DB = new CUResortEntities(); return(DB.Rooms.ToList()); }
public static List <Anemity> GetAnemities() { CUResortEntities DB = new CUResortEntities(); return(DB.Anemities.OrderBy(x => x.Description).ToList()); }