/// <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 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>
/// 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 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);
}
}
public static List <Option> GetAllOptions()
{
//Access the database
TicketSystemContext db = new TicketSystemContext();
//Get all of the attractions
List <Option> options = (from o in db.Options
orderby o.OptionsId
select o).ToList();
return(options);
}
/// <summary>
/// Retrieves all attractions from the database
/// </summary>
/// <returns></returns>
public static List <Attraction> GetAllAttractions()
{
//Access the database
TicketSystemContext db = new TicketSystemContext();
//Get all of the attractions
List <Attraction> attractions = (from a in db.Attractions
orderby a.AttractionName
select a).ToList();
return(attractions);
}
/// <summary>
/// Retrieves all time slots from the database
/// </summary>
/// <returns></returns>
public static List <TimeSlot> GetAllTimeSlots()
{
//Access the database
TicketSystemContext db = new TicketSystemContext();
//Get all of the time slots
List <TimeSlot> timeSlots = (from t in db.TimeSlots
orderby t.TimeSlotId
select t).ToList();
return(timeSlots);
}
