public List<Hashtable> get(int CustomerID)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.Customers
where a.DiscountID == CustomerID
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("CustomerID", item.CustomerID);
data.Add("Firstname", item.Firstname);
data.Add("Insertion", item.Insertion);
data.Add("Lastname", item.Lastname);
data.Add("Date_Of_Birth", item.Date_Of_Birth);
data.Add("Sex", item.Sex);
data.Add("Zipcode", item.Zipcode);
data.Add("Street", item.Street);
data.Add("Street_Number", item.Street_Number);
data.Add("Email", item.Email);
data.Add("Password", item.Password);
lijst.Add(data);
}
return lijst;
}
public List<Hashtable> get(int MovieID)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.Movies
where a.MovieID == MovieID
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("MovieID", item.MovieID);
data.Add("Title", item.Title);
data.Add("Description", item.Description);
data.Add("Director", item.Director);
data.Add("Poster", item.Poster);
data.Add("Trailer", item.Trailer);
data.Add("Genre", item.Genre);
data.Add("Duration", item.Duration);
lijst.Add(data);
}
return lijst;
}
public List<Hashtable> get(int RoomID)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.Rooms
where a.RoomID == RoomID
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("RoomID", item.RoomID);
data.Add("SeatsPerRow", item.SeatsPerRow);
data.Add("Rows", item.Rows);
lijst.Add(data);
}
return lijst;
}
public List<Hashtable> get(int DiscountID)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.Discounts
where a.DiscountID == DiscountID
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("DiscountID", item.DiscountID);
data.Add("Title", item.Title);
data.Add("Description", item.Description);
data.Add("Discount", item.Discount);
lijst.Add(data);
}
return lijst;
}
public List<Hashtable> get(int OrderID)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.Orders
where a.OrderID == OrderID
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("OrderID", item.OrderID);
data.Add("ShowID", item.ShowID);
data.Add("TotalPrice", item.TotalPrice;
data.Add("Status", item.Status);
lijst.Add(data);
}
return lijst;
}
public List<Hashtable> get(int LookWiserID)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.LookWisers
where a.LookWiserID == LookWiserID
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("LookWiserID", item.LookWiserID);
data.Add("Title", item.Title);
data.Add("Pictogram", item.Pictogram);
data.Add("Description", item.Description);
lijst.Add(data);
}
return lijst;
}
public List<Hashtable> get(int ReservationID)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.Reservations
where a.ReservationID == ReservationID
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("ReservationID", item.ReservationID);
data.Add("CustomerID", item.CustomerID);
data.Add("OrderID", item.OrderID);
data.Add("ReservationTime", item.ReservationTime);
lijst.Add(data);
}
return lijst;
}
public List<Hashtable> get(int TicketID)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.Tickets
where a.TicketID == TicketID
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("TicketID", item.TicketID);
data.Add("SeatNr", item.SeatNr);
data.Add("Price", item.Price);
data.Add("DiscountID", item.DiscountID);
data.Add("OrderID", item.OrderID);
lijst.Add(data);
}
return lijst;
}
public List<Hashtable> get(int ShowID)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.Shows
where a.ShowID == ShowID
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("ShowID", item.ShowID);
data.Add("RoomID", item.RoomID);
data.Add("MovieID", item.MovieID);
data.Add("Time", item.Time);
data.Add("SeatType", item.SeatType);
data.Add("TicketPrice", item.TicketPrice);
lijst.Add(data);
}
return lijst;
}
public List<Hashtable> get(int DiscountCode)
{
DatabaseDataContext db = new DatabaseDataContext();
var qry = from a in db.Coupons
where a.DiscountCode == DiscountCode
select a;
List<Hashtable> lijst = new List<Hashtable>();
foreach (var item in qry)
{
Hashtable data = new Hashtable();
data.Add("DiscountCode", item.DiscountCode);
data.Add("OrderID", item.OrderID);
data.Add("CustomerID", item.CustomerID);
data.Add("Discount", item.Discount);
data.Add("Multiple_Use", item.Multiple_Use);
data.Add("Activated", item.Activated);
lijst.Add(data);
}
return lijst;
}
