private void ListBookings_FormClosed(object sender, FormClosedEventArgs e)
{
if (bookingsListView.SelectedItems.Count == 0)
{
objectWelcomeForm.Show();
}
}
/// <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>
/// 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());
}
}
private void Booking_FormClosed(object sender, FormClosedEventArgs e)
{
//Show the hidden Welcome form on closing this form
objWelcomeForm.Show();
}