public BookingMainPage()
{
InitializeComponent();
listBox1.SelectionMode = SelectionMode.Single;
OracleConnection oc = CommonMethods.GetConnection();
oc.Open();
OracleCommand ocmd = oc.CreateCommand();
ocmd.CommandText = String.Format("select BOOKING_ID, IDENTIFIER, IDENTIFIER2, TYPE from BOOKING where END_PERSOON = '{0}'",
CommonMethods.loginUser.id);
OracleDataReader odr = ocmd.ExecuteReader();
if (odr.HasRows)
{
while (odr.Read())
{
ClientBooking book = new ClientBooking();
book.bookingid = Decimal.ToInt32((decimal)odr[0]);
book.bookingidentifier = (string)odr[1];
if (!(odr[2] is System.DBNull))
book.bookingidentifier2 = (string)odr[2];
else
book.bookingidentifier2 = "";
book.bookingtype = (string)odr[3];
bookList.Add(book);
listBox1.Items.Add("[" + book.bookingtype + "] " + book.bookingidentifier);
}
listBox1.SelectedIndex = 0;
}
oc.Close();
}
public BookingTransportInfo(ClientBooking b)
{
InitializeComponent();
this.cb = b;
tb_bid.Text = cb.bookingidentifier;
tb_tid.Text = cb.bookingidentifier2;
}
public BookingHotelInfo(ClientBooking b)
{
InitializeComponent();
using (HotelControlClient hcs = new HotelControlClient())
{
hotelBooking hb = hcs.GetBookingInformation(Int32.Parse(b.bookingidentifier));
tb_v_dat.Text = hb.startdate.ToString("dd MM yyyy");
tb_t_dat.Text = hb.endDate.ToString("dd MM yyyy");
foreach (room r in hb.bookedRooms)
listBox1.Items.Add("Kamer: " + r.roomNumber);
}
}
public BookingAttractionInfo(ClientBooking b)
{
InitializeComponent();
this.cb = b;
using (AttractionServiceClient asc = new AttractionServiceClient())
{
AttractieServiceOnline.Person person = asc.getPerson(CommonMethods.loginUser.name, CommonMethods.loginUser.lastname);
foreach (AttractieServiceOnline.Booking book in person.Booking)
{
if (book.Id == Int32.Parse(cb.bookingidentifier))
{
tb_Attractie.Text = book.Ticket.Name;
tb_Ticket.Text = book.Ticket.Attraction.Name;
tb_AttractionDescription.Text = book.Ticket.Attraction.Description;
}
}
}
}
public BookingFlightInfo(ClientBooking b)
{
InitializeComponent();
this.cb = b;
using (FlightServiceClient fsc = new FlightServiceClient())
{
this.book = fsc.getBooking(Int32.Parse(b.bookingidentifier2), Int32.Parse(b.bookingidentifier));
this.fl = fsc.getFlight(book.flightID);
}
tb_v_land.Text = fl.departureCountry;
tb_v_stad.Text = fl.departureCity;
tb_v_vliegveld.Text = fl.departureAirport;
tb_a_land.Text = fl.arrivalCountry;
tb_a_stad.Text = fl.arrivalCity;
tb_a_vliegveld.Text = fl.arrivalAirport;
tb_klasse.Text = book.classs;
tb_personen.Text = book.numOfPersons + "";
tb_dat.Text = fl.departureDate.ToString("dd-MM-yyyy");
}