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());
}