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