// bring user to alterbookingform
private void ViewBookingButton_Click(object sender, EventArgs e)
{
AlterBookingForm alterbookingForm = new AlterBookingForm();
alterbookingForm.Show();
this.Close();
}
private void CreateAccountButton_Click(object sender, EventArgs e)
{
//opening connection to database if not already open
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
//store textboxes text to global variables
nameText = CreateFirstNameTextBox.Text + " " + CreateLastNameTextBox.Text;
companyNameText = CreateCompanyTextBox.Text;
emailText = CreateEmailTextBox.Text;
userName = CreateUserNameTextBox.Text;
if (CreatePasswordTextBox.Text == ConfirmPasswordTextBox.Text)
{
password = CreatePasswordTextBox.Text;
if (CreateFirstNameTextBox.Text != "" && CreateLastNameTextBox.Text != "" && CreateEmailTextBox.Text != "" && CreateUserNameTextBox.Text != "" && password != "")
{
try
{
string query = "INSERT INTO UserTable (Name, CompanyName, Email, UserName, Password) VALUES ('" + CreateFirstNameTextBox.Text + " " + CreateLastNameTextBox.Text + "', '" + CreateCompanyTextBox.Text + "', '" + CreateEmailTextBox.Text + "', '" + userName + "', '" + password + "')";
SqlCommand command = new SqlCommand(query, conn);
command.ExecuteNonQuery();
//Jump to AlterBookingForm
AlterBookingForm alterBookingForm = new AlterBookingForm();
alterBookingForm.Show();
this.Hide();
}
catch (SqlException)
{
MessageTextBox.Text = "User name invlad or used already";
}
}
}
else
{
MessageTextBox.Text = "Password does not match password confirm please try again";
}
conn.Close();
}
// grabs all of users information and displays it on the alter booking form
private void LoginButton_Click(object sender, EventArgs e)
{
//opening connection to database if not already open
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
// variables for comaring user to database
string compareUserName = "";
string comparePassword = "";
// grabing user information and storing it a DataTable
string getUserName = "******" + UserNameTextBox.Text + "'";
SqlCommand command1 = new SqlCommand(getUserName, conn);
SqlDataAdapter adapter1 = new SqlDataAdapter(command1);
DataTable dataTable1 = new DataTable();
dataTable1.Columns.Add("UserName", typeof(string));
dataTable1.Columns.Add("Password", typeof(string));
dataTable1.Columns.Add("Name", typeof(string));
dataTable1.Columns.Add("Email", typeof(string));
dataTable1.Columns.Add("CompanyName", typeof(string));
adapter1.Fill(dataTable1);
//storing user information in variables
try
{
compareUserName = Convert.ToString(dataTable1.Rows[0][0]);
comparePassword = Convert.ToString(dataTable1.Rows[0][1]);
}
catch (IndexOutOfRangeException)
{
MessageTextBox.Text = "User name or password do not match records please try again";
}
// checking if login information matches data table
if (UserNameTextBox.Text == compareUserName && PasswordTextBox.Text == comparePassword)
{
// storing user information in global variables
userName = Convert.ToString(dataTable1.Rows[0][0]);
password = Convert.ToString(dataTable1.Rows[0][1]);
nameText = Convert.ToString(dataTable1.Rows[0][2]);
emailText = Convert.ToString(dataTable1.Rows[0][3]);
companyNameText = Convert.ToString(dataTable1.Rows[0][4]);
//Jump to AlterBookingForm
AlterBookingForm alterBookingForm = new AlterBookingForm();
alterBookingForm.Show();
// hiding form incase user wants to logout
this.Hide();
conn.Close();
}
// if information does match records in database
else
{
MessageTextBox.Text = "User name or password do not match records please try again";
}
}