/// <summary>
/// Deletes the selected attraction from the database
/// </summary>
/// <param name="a"></param>
public static void Delete(Attraction a)
{
using (var context = new TicketSystemContext())
{
context.Attractions.Add(a);
context.Entry(a).State = EntityState.Deleted;
context.SaveChanges();
}
}
/// <summary>
/// Deletes a selected existing option from the database
/// </summary>
/// <param name="o"></param>
public static void Delete(Option o)
{
using (var context = new TicketSystemContext())
{
context.Options.Add(o);
context.Entry(o).State = EntityState.Deleted;
context.SaveChanges();
}
}
/// <summary>
/// Adds an option setting to the database
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static Option Add(Option o)
{
using (var context = new TicketSystemContext())
{
context.Options.Add(o);
context.SaveChanges();
return(o);
}
}
/// <summary>
/// Adds an attraction to the database
/// </summary>
/// <param name="a"></param>
/// <returns></returns>
public static Attraction Add(Attraction a)
{
using (var context = new TicketSystemContext())
{
context.Attractions.Add(a);
context.SaveChanges();
return(a);
}
}
/// <summary>
/// Deletes the selected/existing time slot from the database
/// </summary>
/// <param name="t"></param>
public static void Delete(TimeSlot t)
{
using (var context = new TicketSystemContext())
{
context.TimeSlots.Add(t);
context.Entry(t).State = EntityState.Deleted;
context.SaveChanges();
}
}
/// <summary>
/// Adds a time slot to the database
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public static TimeSlot Add(TimeSlot t)
{
using (var context = new TicketSystemContext())
{
context.TimeSlots.Add(t);
context.SaveChanges();
return(t);
}
}
/// <summary>
/// Updates an existing option from the database
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static Option Update(Option o)
{
using (var context = new TicketSystemContext())
{
context.Options.Attach(o);
context.Entry(o).State = EntityState.Modified;
context.SaveChanges();
return(o);
}
}
/// <summary>
/// Updates an existing attraction selected by the user from the database
/// </summary>
/// <param name="a"></param>
/// <returns></returns>
public static Attraction Update(Attraction a)
{
using (var context = new TicketSystemContext())
{
context.Attractions.Attach(a);
context.Entry(a).State = EntityState.Modified;
context.SaveChanges();
return(a);
}
}
/// <summary>
/// Updates a selected/existing time slot
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public static TimeSlot Update(TimeSlot t)
{
using (var context = new TicketSystemContext())
{
context.TimeSlots.Attach(t);
context.Entry(t).State = EntityState.Modified;
context.SaveChanges();
return(t);
}
}
