public static void UpdateReservation(Reservation r)
{
CUResortEntities DB = new CUResortEntities();
DB.Entry(r).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
}
public static void UpdateGuest(Person p)
{
CUResortEntities DB = new CUResortEntities();
DB.Entry(p).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 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();
}
