public ListBookings(Welcome welcomeForm, OdbcConnection odbcConnection, HashSet<BookingInformation> bookings)
: this()
{
objectWelcomeForm = welcomeForm;
objectOdbcConnection = odbcConnection;
bookingsListView.Columns.Add("Guest ID");
bookingsListView.Columns.Add("First Name");
bookingsListView.Columns.Add("Last Name");
bookingsListView.Columns.Add("Phone");
bookingsListView.Columns.Add("CheckIn Date");
bookingsListView.Columns.Add("CheckOut Date");
bookingsListView.Columns.Add("Room Number");
bookingsListView.Columns.Add("Booking Status");
bookingsListView.Columns[0].Width = 100;
bookingsListView.Columns[1].Width = 125;
bookingsListView.Columns[2].Width = 125;
bookingsListView.Columns[3].Width = 100;
bookingsListView.Columns[4].Width = 80;
bookingsListView.Columns[5].Width = 80;
bookingsListView.Columns[6].Width = 80;
bookingsListView.Columns[7].Width = 100;
//bookingsListBox.Items.Add(lv);
for(int i= 0; i<bookings.Count; i++)
{
string[] listColumns = new string[8];
listColumns[0] = bookings.ElementAt(i).bookedGuest.guestId;
listColumns[1] = bookings.ElementAt(i).bookedGuest.firstName;
listColumns[2] = bookings.ElementAt(i).bookedGuest.lastName;
listColumns[3] = bookings.ElementAt(i).bookedGuest.phone;
listColumns[4] = bookings.ElementAt(i).checkInDate.ToShortDateString();
listColumns[5] = bookings.ElementAt(i).checkOutDate.ToShortDateString();
listColumns[6] = bookings.ElementAt(i).bookedRoom.roomNumber;
listColumns[7] = bookings.ElementAt(i).status;
ListViewItem li = new ListViewItem(listColumns);
if (i % 2 == 0)
{
li.BackColor = Color.Gainsboro;
}
bookingsListView.Items.Add(li);
}
}
/// <summary>
/// Establish a DSN connection with HotelReservationSystem database using
/// ODBCConnection class and validate userID and Password. If a user is
/// authorized, it logon the user to the Welcome page of the HotelReservationSystem
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void logonButton_Click(object sender, EventArgs e)
{
try
{
//Establish connection with database using OdbcConnection class
OdbcConnection objectOdbcConnection = new OdbcConnection(CONNECTION_STRING);
objectOdbcConnection.Open();
//Create an OdbcCommand object using CreateCommand of the OdbcConnection object
OdbcCommand objectOdbcCommand = objectOdbcConnection.CreateCommand();
objectOdbcCommand.CommandText = "SELECT * FROM USERS WHERE userId = ? and password= ?";
objectOdbcCommand.Parameters.Add("userid", OdbcType.NVarChar).Value = userIDTextBox.Text;
objectOdbcCommand.Parameters.Add("pasword", OdbcType.NVarChar).Value = passwordTextBox.Text;
OdbcDataReader dbReader = objectOdbcCommand.ExecuteReader();
dbReader.Read();
if (dbReader.HasRows)
{
//This is a valid userId/password, show the welcome page
Welcome objectWelcomeForm;
objectWelcomeForm = new Welcome();
objectWelcomeForm.Show();
this.Hide();
dbReader.Close();
objectOdbcCommand.Dispose();
objectOdbcConnection.Close();
return;
}
//The user id or password is not valid
dbReader.Close();
objectOdbcCommand.Dispose();
objectOdbcConnection.Dispose();
objectOdbcConnection.Close();
MessageBox.Show("Please enter a valid user and password");
}
catch (Exception exp)
{
MessageBox.Show("An exception in the code: \n" + exp.Message.ToString());
}
}
/// <summary>
/// Overloaded Constructor:
/// This constructor will accept object of Welcome class, an opened
/// OdbcConnection and BookingInformation object as input. When this
/// form is closed, it uses the Welcome object passed on via this
/// constructor to "show" the hidden Welcome form back to the user.
/// </summary>
/// <param name="welcomeForm">WlecomeForm</param>
/// <param name="odbcConnection">OdbcConnection</param>
/// <param name="bookingInformation">BookingInformation</param>
public Booking(Welcome welcomeForm,
OdbcConnection odbcConnection,
BookingInformation bookingInformation)
: this()
{
objWelcomeForm = welcomeForm;
objectOdbcConnection = odbcConnection;
objectBookingInformation = bookingInformation;
}