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