private void getCurrentUserPurchasedTours(string username) //returns a list of current user's PREVIOUSLY BOOKED TOURS for COMBOBOX
{
List <string> currentUserTourIDs = new List <string>();
DataTable bookingTable = db.getDataTable("select * from tblBooking");
int size = bookingTable.Rows.Count;
for (int i = 0; i < size; i++)
{
DataRow row = bookingTable.Rows[i];
if (row["Username"].ToString() == username)
{
ErrorTextBlock1.Visibility = Visibility.Hidden;
comboBoxTourID.IsHitTestVisible = true;
comboBoxTourID.Cursor = Cursors.Hand;
hasPurchasedTour = true;
if (!currentUserTourIDs.Contains(row["TourID"].ToString()))
{
currentUserTourIDs.Add(row["TourID"].ToString());
}
}
}
if (currentUserTourIDs != null)
{
foreach (string tourID in currentUserTourIDs)
{
comboBoxTourID.Items.Add(tourID); //add tours to combobox if user has purchased any
}
}
}
private string validateEmailInput()
{
string Email = "";
string EmailTxt = txtBoxEmail.Text.Trim().ToLower();
if (EmailTxt != email)
{
if (EmailTxt.Contains("*") || !(EmailTxt.Contains("@")) || !(EmailTxt.Contains(".com")) || EmailTxt.Contains(" ") || string.IsNullOrEmpty(EmailTxt))
{
txtBlockEmailError1.Visibility = Visibility.Visible;
txtBlockEmailError2.Visibility = Visibility.Hidden;
txtBlockEmailMsg.Visibility = Visibility.Hidden;
txtBoxEmail.Text = "e.g. [email protected]";
txtBoxEmail.Foreground = Brushes.DarkGray;
Email = "";
}
else
{
txtBlockEmailError1.Visibility = Visibility.Hidden;
txtBlockEmailError2.Visibility = Visibility.Hidden;
txtBlockEmailMsg.Visibility = Visibility.Visible;
Email = EmailTxt;
}
//Email Validation
DataTable customerTable = db.getDataTable("select * from tblCustomer");
for (int i = 0; i < customerTable.Rows.Count; i++)
{
DataRow row = customerTable.Rows[i];
if (row["Email"].ToString() == EmailTxt)
{
txtBlockEmailError1.Visibility = Visibility.Hidden;
txtBlockEmailError2.Visibility = Visibility.Visible;
txtBlockEmailMsg.Visibility = Visibility.Hidden;
txtBoxEmail.Text = "e.g. [email protected]";
txtBoxEmail.Foreground = Brushes.DarkGray;
Email = "";
}
}
}
else if (EmailTxt == email)
{
Email = EmailTxt;
}
return(Email);
}
// GETS NO. OF SLOTS LEFT (of the MAXIMUM 15 slots) for the specific tourID on the selected tour date
private int getNoOfSlotsLeft(string date)
{
int NoOfSlotsLeft = 15;
DataTable bookingsForTour = db.getDataTable("SELECT * FROM tblBooking");
for (int i = 0; i < bookingsForTour.Rows.Count; i++)
{
DataRow row = bookingsForTour.Rows[i];
if (row["TourID"].ToString() == tourID)
{
if (row["SelectedTourStartDate"].ToString() == date)
{
NoOfSlotsLeft = NoOfSlotsLeft - int.Parse(row["PeopleQty"].ToString());
}
}
}
return(NoOfSlotsLeft);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
double totalCost = 0;
DataTable bookingTable = db.getDataTable("select * from tblBooking where BookingID = '" + bookingID + "'");
for (int i = 0; i < bookingTable.Rows.Count; i++)
{
DataRow row = bookingTable.Rows[i];
txtBoxBookingID.Text = row["BookingID"].ToString();
username = row["Username"].ToString();
bookingDate.Text = Convert.ToDateTime(row["BookingDate"].ToString()).ToShortDateString();
bookingTime.Text = Convert.ToDateTime(row["BookingTime"].ToString()).ToShortTimeString();
Customer c = new Customer(username);
Customer cust = (Customer)c.getCustomerRow(username);
custName.Text = cust.getCustomerDetail(username, 0) + " " + cust.getCustomerDetail(username, 1);
email.Text = cust.getCustomerDetail(username, 2);
contact.Text = cust.getCustomerDetail(username, 3);
totalCost += double.Parse(row["Subtotal"].ToString());
TourCollection tc = new TourCollection();
Tour tour = tc.getTour(row["TourID"].ToString());
TextBlock tourID = new TextBlock();
tourID.Text = string.Format("({0}) TourID : ", (i + 1));
tourID.FontWeight = FontWeights.Bold;
TextBlock tourIDValue = new TextBlock();
tourIDValue.Text = row["TourID"].ToString();
TextBlock tourQty = new TextBlock();
tourQty.Text = "No. Of People : ";
tourQty.FontWeight = FontWeights.Bold;
TextBlock qtyValue = new TextBlock();
qtyValue.Text = row["PeopleQty"].ToString();
TextBlock tourDate = new TextBlock();
tourDate.Text = "Selected Tour Date : ";
tourDate.FontWeight = FontWeights.Bold;
TextBlock dateRange = new TextBlock();
dateRange.Text = row["SelectedTourStartDate"].ToString() + " - " + row["SelectedTourEndDate"].ToString();
TextBlock flight = new TextBlock();
flight.Text = "Flight Choice : ";
flight.FontWeight = FontWeights.Bold;
TextBlock flightSelection = new TextBlock();
flightSelection.Text = row["FlightSelection"].ToString();
TextBlock fTicket = new TextBlock();
fTicket.Text = "No. Of Tickets : ";
fTicket.FontWeight = FontWeights.Bold;
TextBlock ticketQty = new TextBlock();
ticketQty.Text = row["TicketQty"].ToString();
TextBlock room = new TextBlock();
room.Text = "Room Choice : ";
room.FontWeight = FontWeights.Bold;
TextBlock roomSelection = new TextBlock();
roomSelection.Text = row["RoomSelection"].ToString();
TextBlock roomType = new TextBlock();
roomType.Text = "Room Type : ";
roomType.FontWeight = FontWeights.Bold;
TextBlock roomValue = new TextBlock();
roomValue.Text = string.Format("Single x {0}, Double x {1}", row["SingleRmQty"].ToString(), row["DoubleRmQty"].ToString());
TextBlock tourPrice = new TextBlock();
tourPrice.Text = "Total Tour Price : ";
tourPrice.FontWeight = FontWeights.Bold;
TextBlock tourPriceValue = new TextBlock();
tourPriceValue.Text = (int.Parse(row["PeopleQty"].ToString()) * tour.TourPrice).ToString("c2");
TextBlock flightPrice = new TextBlock();
flightPrice.Text = "Flight Price : ";
flightPrice.FontWeight = FontWeights.Bold;
TextBlock flightPriceValue = new TextBlock();
flightPriceValue.Text = "$" + row["CalculatedFlightPrice"].ToString();
TextBlock roomPrice = new TextBlock();
roomPrice.Text = "Room Price : ";
roomPrice.FontWeight = FontWeights.Bold;
TextBlock roomPriceValue = new TextBlock();
roomPriceValue.Text = "$" + row["CalculatedRoomPrice"].ToString();
TextBlock addon = new TextBlock();
addon.Text = "Add-on : ";
addon.FontWeight = FontWeights.Bold;
TextBlock addonSelection = new TextBlock();
addonSelection.Text = row["AddOnSelection"].ToString();
TextBlock subTotal = new TextBlock();
subTotal.Text = "Subtotal : ";
subTotal.FontWeight = FontWeights.Bold;
TextBlock subValue = new TextBlock();
subValue.Text = "$" + row["Subtotal"].ToString();
StackPanel tourPanel = new StackPanel();
tourPanel.Margin = new Thickness(10, 10, 0, 0);
tourPanel.Orientation = Orientation.Horizontal;
tourPanel.Children.Add(tourID);
tourPanel.Children.Add(tourIDValue);
StackPanel qty = new StackPanel();
qty.Margin = new Thickness(27, 20, 0, 0);
qty.Orientation = Orientation.Horizontal;
qty.Children.Add(tourQty);
qty.Children.Add(qtyValue);
StackPanel selectedDate = new StackPanel();
selectedDate.Margin = new Thickness(27, 20, 0, 0);
selectedDate.Orientation = Orientation.Horizontal;
selectedDate.Children.Add(tourDate);
selectedDate.Children.Add(dateRange);
StackPanel flightChoice = new StackPanel();
flightChoice.Margin = new Thickness(27, 0, 0, 0);
flightChoice.Orientation = Orientation.Horizontal;
flightChoice.Children.Add(flight);
flightChoice.Children.Add(flightSelection);
StackPanel flightTicket = new StackPanel();
flightTicket.Margin = new Thickness(27, 0, 0, 0);
flightTicket.Orientation = Orientation.Horizontal;
flightTicket.Children.Add(fTicket);
flightTicket.Children.Add(ticketQty);
StackPanel roomChoice = new StackPanel();
roomChoice.Margin = new Thickness(27, 0, 0, 0);
roomChoice.Orientation = Orientation.Horizontal;
roomChoice.Children.Add(room);
roomChoice.Children.Add(roomSelection);
StackPanel rmType = new StackPanel();
rmType.Margin = new Thickness(27, 0, 0, 0);
rmType.Orientation = Orientation.Horizontal;
rmType.Children.Add(roomType);
rmType.Children.Add(roomValue);
StackPanel totalTour = new StackPanel();
totalTour.Margin = new Thickness(27, 0, 0, 0);
totalTour.Orientation = Orientation.Horizontal;
totalTour.Children.Add(tourPrice);
totalTour.Children.Add(tourPriceValue);
StackPanel totalFlight = new StackPanel();
totalFlight.Margin = new Thickness(27, 0, 0, 0);
totalFlight.Orientation = Orientation.Horizontal;
totalFlight.Children.Add(flightPrice);
totalFlight.Children.Add(flightPriceValue);
StackPanel totalRoom = new StackPanel();
totalRoom.Margin = new Thickness(27, 0, 0, 0);
totalRoom.Orientation = Orientation.Horizontal;
totalRoom.Children.Add(roomPrice);
totalRoom.Children.Add(roomPriceValue);
StackPanel subTotal1 = new StackPanel();
subTotal1.Margin = new Thickness(27, 0, 0, 0);
subTotal1.Orientation = Orientation.Horizontal;
subTotal1.Children.Add(subTotal);
subTotal1.Children.Add(subValue);
StackPanel addons = new StackPanel();
addons.Margin = new Thickness(27, 0, 0, 0);
addons.Orientation = Orientation.Horizontal;
addons.Children.Add(addon);
addons.Children.Add(addonSelection);
Line divider = new Line();
divider.X1 = 10;
divider.X2 = 460;
SolidColorBrush Gray = new SolidColorBrush();
Gray.Color = Colors.DarkGray;
divider.Stroke = Gray;
divider.Margin = new Thickness(0, 20, 0, 0);
mainContent.Children.Add(tourPanel);
mainContent.Children.Add(qty);
mainContent.Children.Add(selectedDate);
mainContent.Children.Add(flightChoice);
mainContent.Children.Add(flightTicket);
mainContent.Children.Add(roomChoice);
mainContent.Children.Add(rmType);
mainContent.Children.Add(addons);
mainContent.Children.Add(totalTour);
mainContent.Children.Add(totalFlight);
mainContent.Children.Add(totalRoom);
mainContent.Children.Add(subTotal1);
mainContent.Children.Add(divider);
}
TotalCost.Text = totalCost.ToString("c2");
}