public Booking(Customer Customer, Hotel Hotel, String At, int Duration, int RoomNr, int NumAdults, int NumChilds) { this.Customer = Customer; this.Hotel = Hotel; this.At = At; this.Duration = Duration; this.RoomNr = RoomNr; this.NumAdults = NumAdults; this.NumChilds = NumChilds; }
public List<Booking> ListBookingsByHid(int hid) { List<Booking> list = new List<Booking>(); SqlCommand command = new SqlCommand("SELECT customer.email, customer.name, customer.adr, customer.tel," + " booking.at, booking.duration, booking.roomNr, booking.numAdults, booking.numChilds," + " hotel.hid, hotel.name, hotel.adr" + " FROM booking JOIN hotel on(hotel.hid = booking.in_hotel_hid) JOIN customer on(customer.email = booking.by_customer_email)" + " WHERE hotel.hid = @hid", con); command.Parameters.AddWithValue("@hid", hid); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Customer c = new Customer( (String)reader["email"], (String)reader["name"], (String)reader["adr"], (Decimal)reader["tel"] ); c.ToolTip = "Email: " + (String)reader["email"] + " | Count: " + GetCustomerBookingsCount((String)reader["email"], hid); Booking b = new Booking( c, new Hotel( (int)reader[9], (String)reader[10], (String)reader[11] ), (String)reader[4], (int)reader[5], (int)reader[6], (int)reader[7], (int)reader[8] ); list.Add(b); } reader.Close(); return list; }