public void RegisterUser(AdminAccount model) { using (HFContext context = new HFContext()) { context.AdminAccounts.Add(model); context.SaveChanges(); } }
public Tour GetWalkByID(int Id) { using (HFContext context = new HFContext()) { Tour tour = context.Tours.SingleOrDefault(t => t.ID == Id); return(tour); } }
public void UpdateTour(Tour tour) { using (HFContext context = new HFContext()) { context.Entry(tour).State = EntityState.Modified; context.SaveChanges(); } }
public void UpdateJazz(Jazz e) { using (HFContext context = new HFContext()) { context.Entry(e).State = EntityState.Modified; context.SaveChanges(); } }
public void Remove(Jazz e) { using (HFContext context = new HFContext()) { context.Events.Remove(e); context.SaveChanges(); } }
public void CreateJazz(Jazz e) { using (HFContext context = new HFContext()) { context.Events.Add(e); context.SaveChanges(); } }
public void Remove(Tour e) { using (HFContext context = new HFContext()) { context.Tours.Remove(e); context.SaveChanges(); } }
public void CreateTour(Tour walk) { using (HFContext context = new HFContext()) { context.Tours.Add(walk); context.SaveChanges(); } }
public RestaurantSitting GetRestaurantSessionByID(int id) { using (HFContext context = new HFContext()) { var restaurantSession = context.RestaurantSessions.SingleOrDefault(j => j.ID == id); return(restaurantSession); } }
//Returns the passe-partout for the whole weekend public Jazz GetPassePartoutWeekend() { Jazz jazz; using (HFContext context = new HFContext()) { jazz = context.Jazzs.SingleOrDefault(j => j.Name.Contains("Passe-Partout for all Jazz Events")); return(jazz); } }
//gets one jazz event according to an id public Jazz GetJazzByID(int ID) { Jazz jazz; using (HFContext context = new HFContext()) { jazz = context.Jazzs.SingleOrDefault(j => j.ID == ID); return(jazz); } }
//gets all jazz events for a given day /*Because a deleted event or events in three halls at the same day can cause problems with * filtering in two columns they are not filtered in two columns*/ public List <Jazz> GetJazzActsByDay(DateTime date) { IEnumerable <Jazz> Jazzs; using (HFContext context = new HFContext()) { Jazzs = context.Jazzs.Where(j => j.Date == date).OrderBy(j => j.StartTime); return(RemovePassPartout(Jazzs.ToList())); } }
//gets all jazz events public List <Jazz> GetAll() { IEnumerable <Jazz> Jazzs; using (HFContext context = new HFContext()) { Jazzs = context.Jazzs.AsEnumerable(); return(Jazzs.ToList()); } }
public Venue GetVenueByID(int Id) { Venue venue; using (HFContext context = new HFContext()) { venue = context.Venues.SingleOrDefault(v => v.ID == Id); return(venue); } }
public List <OrderItem> getOrderItemsByOrderID(int id) { IEnumerable <OrderItem> orderItems; using (HFContext context = new HFContext()) { orderItems = context.OrderItems.Where(o => o.OrderID == id); return(orderItems.ToList()); } }
public AdminAccount GetAccount(string userName, string password) { using (HFContext context = new HFContext()) { AdminAccount account; account = context.AdminAccounts.SingleOrDefault(a => a.UserName == userName && a.Password == password); return(account); } }
public Event GetEventByID(int ID) { using (HFContext database = new HFContext()) { Event eventByID; eventByID = database.Events.SingleOrDefault(e => e.ID == ID); return(eventByID); } }
//Returns the passe-partout for a single day public Jazz GetPassePartoutDay(DateTime date) { IEnumerable <Jazz> Jazzs; using (HFContext context = new HFContext()) { Jazzs = context.Jazzs.Where(j => j.Name.Contains("passe-partout")); Jazz jazz = Jazzs.SingleOrDefault(j => j.Date == date && !j.Name.Contains("Passe-Partout for all Jazz Events")); return(jazz); } }
public List <Tour> GetAll() { IEnumerable <Tour> Tours; using (HFContext context = new HFContext()) { Tours = context.Tours.AsEnumerable(); if (Tours == null) { Console.WriteLine("empty"); } return(Tours.ToList()); } }
//gets the summarys of what jazzs play on a day public List <JazzDaySummary> GetDaySummarys() { IEnumerable <Jazz> jazzs; List <Jazz> jazzList; List <JazzDaySummary> summarys = new List <JazzDaySummary>(); using (HFContext context = new HFContext()) { jazzs = context.Jazzs.AsEnumerable(); jazzs.OrderBy(j => j.Date); Console.WriteLine(jazzs); if (jazzs is string)//probeer try catch met exception { return(null); } jazzList = jazzs.ToList(); //pass-partout's are not needed jazzList = RemovePassPartout(jazzList); DateTime day = jazzList.Last().Date; foreach (Jazz jazz in jazzList) { if (day != jazz.Date) { day = jazz.Date; summarys.Add(new JazzDaySummary(jazz.IMGString, jazz.Date.DayOfWeek.ToString(), jazz.Date, jazz.LocationName, jazz.Band)); } else { summarys.Last().AddBand(jazz.Band); } } return(summarys); } }
public List <List <OrderTourViewModel> > GetTourViewModels() { const string recordType = "tour"; IEnumerable <Tour> tours; List <Tour> tourList; List <List <OrderTourViewModel> > OrderTours = new List <List <OrderTourViewModel> >(); using (HFContext context = new HFContext()) { tours = context.Tours.AsEnumerable(); tours.OrderBy(t => t.Date) .ThenBy(t => t.StartTime); tourList = tours.ToList(); if (tours == null) { return(null); } DateTime day = tourList.Last().Date; DateTime time = tourList.Last().StartTime; foreach (var tour in tourList) { if (day != tour.Date) { day = tour.Date; List <OrderTourViewModel> DayList = new List <OrderTourViewModel>(); OrderTours.Add(DayList); if (time != tour.StartTime) { time = tour.StartTime; DayList.Add (new OrderTourViewModel ( tour.Date, tour.StartTime, tour.Language + " Guide: " + tour.GuideName, tour.GuideName, new OrderItem(), new OrderItem() ) ); } else { DayList.Last().LanguageList.Add(tour.Language + " Guide: " + tour.GuideName); } } else { if (time != tour.StartTime) { time = tour.StartTime; OrderTours.Last().Add (new OrderTourViewModel ( tour.Date, tour.StartTime, tour.Language + " Guide: " + tour.GuideName, tour.GuideName, new OrderItem(), new OrderItem() ) ); } else { OrderTours.Last().Last().LanguageList.Add(tour.Language + " Guide: " + tour.GuideName); } } } return(OrderTours); } }