private void button1_Click(object sender, EventArgs e)
{
CustomerGuide CG = new CustomerGuide();
CG.Show();
this.Close();
}
private void buttonGoBack_Click(object sender, EventArgs e)
{
CustomerGuide yolo = new CustomerGuide();
yolo.Show();
this.Close();
}
private void buttonVisitor_Click(object sender, EventArgs e)
{
CustomerGuide caccess = new CustomerGuide();
caccess.Show();
this.Hide();
}
private void buttonConfirm_Click(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter("SELECT reservedUsername FROM Reservations WHERE reservedUsername = '******' ", constring);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count >= 1)
{
MessageBox.Show("Username already exists");
}
else
{
constring.Open();
string cmdstring = "INSERT INTO Reservations(reservedFirstName, reservedLastName, reservedAddress, reservedEmailAddress, reservedPhoneNumber, reservedTotalRooms, reservedTotalAdults, reservedTotalChildren, reservedPreference1, reservedPreference2, reservedDepartureDate, reservedArrivalDate, questionsComments, reservedUsername, reservedPassword)";
string values = " VALUES('" + textBoxFirstName.Text + "', '" + textBoxLastName.Text + "', '" + textBoxAddress.Text + "', '" + textBoxEmailAddress.Text + "', '" + textBoxPhoneNumber.Text + "', '" + textBoxtotalRooms.Text + "', '" + textBoxtotalAdults.Text + "', '" + textBoxtotalChildren.Text + "', '" + comboBoxPreference1.Text.ToString() + "', '" + comboBoxPreference2.Text.ToString() + "', '" + dateTimePickerDepartureDate.Value.ToString("yyyy-MM-dd") + "', '" + dateTimePickerArrivalDate.Value.ToString("yyyy-MM-dd") + "', '" + richTextBoxQuestionsComments.Text + "', '" + textBoxReservedUsername.Text + "', '" + textBoxReservedPassword.Text + "')";
SqlCommand cmd = new SqlCommand(cmdstring + values, constring);
cmd.ExecuteNonQuery();
constring.Close();
MessageBox.Show("reservation completed");
CustomerGuide very = new CustomerGuide();
very.Show();
this.Close();
}
/*
* MailAddress from = new MailAddress("*****@*****.**", "Galaxy Hotel Reservation");
* MailAddress to = new MailAddress(textBoxEmailAddress.Text.ToString(), "Galaxy Hotel Reservation");
* List<MailAddress> cc = new List<MailAddress>();
* cc.Add(new MailAddress("*****@*****.**", "Galaxy Hotel Reservation"));
* SendEmail("Hotel Reservation Successful", from, to, cc);
*/
}
