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); */ }