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