//Updates the driver's first name, last name, phone number, qualifications, changes status of assigned training, disciplinary records private void Update(int ID, string name, string surname, string PhoneNumber) { //Checks if there is a name and surname in the textbox if (NameTextBox.Text == "" || SurnameTextBox.Text == "") { MessageBox.Show("Please insert First Name and Last Name."); return; } //Checks if the phoneNumber length is == 11 if (PhoneNumber.Length != 11) { MessageBox.Show("Invalid Phone number. Please try again."); PhoneNumberTextBox.Clear(); return; } //Update driver's name, surname, phone number UpdateDriver(ID, name, surname, PhoneNumber); //Deletes assigned qualifications DeleteAssignedQualifications(ID); //Inserts Qualifications InsertQualifications(ID); //Changes the status of assigned qualifications ChangeStatus(ID); //Deletes previous disciplinary records DeleteDisciplinaryRecords(ID); //Inserts Disciplinary Records InsertDisciplinaryRecords(ID); }
private void newWorkerSubmit_Click(object sender, EventArgs e) { string newUserBannerId = BannerTextBox.Text; string newUserFirstName = FirstNameTextBox.Text; string newUserLastName = LastNameTextBox.Text; string newUserPhoneNumber = PhoneNumberTextBox.Text; string newUserEmail = EmailTextBox.Text; string newUserUserType = UserTypeTextBox.Text; string newUserNotes = NotesTextBox.Text; string newUserStatus = StatusTextBox.Text; User newUser = new User(newUserBannerId, newUserFirstName, newUserLastName, newUserPhoneNumber, newUserEmail, newUserUserType, newUserNotes, newUserStatus); newUser.insert(); BannerTextBox.Clear(); FirstNameTextBox.Clear(); LastNameTextBox.Clear(); PhoneNumberTextBox.Clear(); EmailTextBox.Clear(); UserTypeTextBox.Clear(); NotesTextBox.Clear(); StatusTextBox.Clear(); NewWorkerNotificationLabel.Text = "User added to database"; }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { if (orderDetails.CurrentAddress == null) { SearchTextBox.Text = ""; PhoneNumberTextBox.Clear(); HouseNumberTextBox.Clear(); } }
private void SubmitButton_Click(object sender, EventArgs e) { myUserToModify.SetFirstName(FirstNameTextBox.Text); myUserToModify.SetLastName(LastNameTextBox.Text); myUserToModify.SetPhoneNumber(PhoneNumberTextBox.Text); myUserToModify.SetEmailAddress(EmailTextBox.Text); myUserToModify.SetUserType(UserTypeTextBox.Text); myUserToModify.SetNotes(NotesTextBox.Text); myUserToModify.SetStatus(StatusTextBox.Text); myUserToModify.update(); FirstNameTextBox.Clear(); LastNameTextBox.Clear(); PhoneNumberTextBox.Clear(); EmailTextBox.Clear(); UserTypeTextBox.Clear(); NotesTextBox.Clear(); StatusTextBox.Clear(); NewWorkerNotificationLabel.Text = "User updated"; }
private void SubmitButton_Click(object sender, EventArgs e) { try { string gender; if (FemaleradioButton1.Checked) { gender = FemaleradioButton1.Text; } else { gender = MaleradioButton2.Text; } Address addr = new Address(StreetTextBox.Text, CityTextBox.Text, StateTextBox.Text, ZipTextBox.Text); CreditCard cc = new CreditCard(int.Parse(CardNumbertextBox1.Text), int.Parse(PintextBox1.Text), DateTime.Parse(ExpirationDatedateTimePicker1.Text)); Customer cust1 = new Customer(FirstNameTextBox.Text, LastNameTextBox.Text, gender, addr, PhoneNumberTextBox.Text, int.Parse(IDNumberTextBox.Text), cc); foreach (Person p in TravelAgency.people) { if (cust1.isEqual(p)) { throw new DuplicateDataExcception("Sorry! This Customer already exists!"); } } string s = " "; if (FirstNameTextBox.Text == s || LastNameTextBox.Text == s) { throw new InvalidName("Invalid Name"); } if (PhoneNumberTextBox.Text == s) { throw new InvalidPhoneNumber("Invalid PhoneNumber"); } if (StreetTextBox.Text == s || CityTextBox.Text == s || StateTextBox.Text == s || ZipTextBox.Text == s) { throw new InvalidAddress("Invalid Address"); } if (IDNumberTextBox.Text == s) { throw new InvalidDataException("Invalid ID"); } if (CardNumbertextBox1.Text == s || PintextBox1.Text == s) { throw new InvalidDataException("invalid card"); } if (!FemaleradioButton1.Checked && !MaleradioButton2.Checked) { throw new InvalidDataException("Invalid Gender"); } TravelAgency.people.Add(cust1); MessageBox.Show("Customer " + FirstNameTextBox.Text + " " + LastNameTextBox.Text + " was added"); FirstNameTextBox.Clear(); LastNameTextBox.Clear(); PhoneNumberTextBox.Clear(); StreetTextBox.Clear(); CityTextBox.Clear(); StateTextBox.Clear(); ZipTextBox.Clear(); IDNumberTextBox.Clear(); FemaleradioButton1.Checked = false; MaleradioButton2.Checked = false; PintextBox1.Clear(); ExpirationDatedateTimePicker1.ResetText(); CardNumbertextBox1.Clear(); } catch (InvalidName) { MessageBox.Show("Invalid Name"); } catch (InvalidPhoneNumber) { MessageBox.Show("Invalid phone Number"); } catch (DuplicateDataExcception ex) { MessageBox.Show(ex.Message); } catch (OverflowException oe) { MessageBox.Show(oe.Message); } catch (Exception q) { MessageBox.Show(q.Message); } }
public void SubmitButton_Click(object sender, EventArgs e) { try { string gender; if (FemaleradioButton1.Checked) { gender = FemaleradioButton1.Text; } else { gender = MaleradioButton2.Text; } Passport pass = new Passport(FirstNameTextBox.Text, LastNameTextBox.Text, CountryOfBirthTextBox.Text, NationalityTextBoox.Text); Address adr = new Address(StreetTextBox.Text, CityTextBox.Text, StateTextBox.Text, ZipTextBox.Text); Person adam1 = new Passenger(int.Parse(IDNumberTextBox.Text), FirstNameTextBox.Text, LastNameTextBox.Text, gender, PhoneNumberTextBox.Text, adr, pass); foreach (Person p in TravelAgency.people) { if (adam1.isEqual(p)) { throw new DuplicateDataExcception("Sorry! This Passenger already exists"); } } string s = " "; if (FirstNameTextBox.Text == s || LastNameTextBox.Text == s) { throw new InvalidName("Invalid Name"); } if (PhoneNumberTextBox.Text == s) { throw new InvalidPhoneNumber("Invalid PhoneNumber"); } if (StreetTextBox.Text == s || CityTextBox.Text == s || StateTextBox.Text == s || ZipTextBox.Text == s) { throw new InvalidAddress("Invalid Address"); } if (CountryOfBirthTextBox.Text == s) { throw new InvalidDataException("Invalid Country of Birth"); } if (NationalityTextBoox.Text == s) { throw new InvalidDataException("Invalid Nationality"); } if (IDNumberTextBox.Text == s) { throw new InvalidDataException("Invalid ID"); } if (PassportNumberTextBox.Text == s) { throw new InvalidDataException("Invalid Passport Number"); } if (!FemaleradioButton1.Checked && !MaleradioButton2.Checked) { throw new InvalidDataException("Invalid Gender"); } TravelAgency.people.Add(adam1); MessageBox.Show("Passenger " + FirstNameTextBox.Text + " " + LastNameTextBox.Text + " was added"); IDNumberTextBox.Clear(); FirstNameTextBox.Clear(); LastNameTextBox.Clear(); PhoneNumberTextBox.Clear(); StreetTextBox.Clear(); CityTextBox.Clear(); StateTextBox.Clear(); ZipTextBox.Clear(); CountryOfBirthTextBox.Clear(); NationalityTextBoox.Clear(); FemaleradioButton1.Checked = false; MaleradioButton2.Checked = false; PassportTextBox.Clear(); } catch (InvalidName) { MessageBox.Show("Invalid Name"); } catch (InvalidPhoneNumber) { MessageBox.Show("invalid Phone Number"); } catch (DuplicateDataExcception ex) { MessageBox.Show(ex.Message); } catch (OverflowException oe) { MessageBox.Show(oe.Message); } catch (Exception q) { MessageBox.Show(q.Message); } }
//Inserts the driver in the database private void InsertDriver() { //Gets the textbox values string firstName = FirstNameTextBox.Text; string lastName = LastNameTextBox.Text; string phoneNumber = PhoneNumberTextBox.GetPhoneNumber(); //Checks if First Name textbox and Last Name textbox are empty if (FirstNameTextBox.Text == "" || LastNameTextBox.Text == "") { MessageBox.Show("Please insert First Name and Last Name."); return; } //Checks if the phoneNumber length is == 11 if (phoneNumber.Length != 11) { MessageBox.Show("Invalid Phone number. Please try again."); PhoneNumberTextBox.Clear(); return; } //The first query inserts the Driver's name and surname String query = "INSERT INTO `driver`(`first_Name`, `last_Name`, `Phone_Number`) VALUES('" + firstName + "','" + lastName + "','" + phoneNumber + "')"; var Qualification_ID = new List<int>(); try { MySqlDataReader reader = null; databaseConnection.Open(); MySqlCommand getID = databaseConnection.CreateCommand(); getID.CommandText = query; getID.ExecuteNonQuery(); //Get last inserted ID. Using this ID we insert the driver's qualifications long ID = getID.LastInsertedId; MessageBox.Show("Driver successfully added. Name: " + firstName + " " + lastName + ", " + phoneNumber + " ID: " + ID + "."); databaseConnection.Close(); foreach (DataGridViewRow row in AddQualificationsGridView.Rows) { if (!row.IsNewRow) { for (int i = 0; i < AddQualificationsGridView.Columns.Count; i++) { String Qualification = Convert.ToString(row.Cells[i].Value); //The second query selects the qualifications query = "SELECT `Qualification_ID`FROM `qualification` WHERE `Qualification` LIKE '" + Qualification + "'"; databaseConnection.Open(); using (MySqlCommand cmd = new MySqlCommand(query, databaseConnection)) { reader = cmd.ExecuteReader(); while (reader.Read()) { Qualification_ID.Add((int)reader["Qualification_ID"]); } databaseConnection.Close(); foreach (int e in Qualification_ID) { databaseConnection.Open(); MySqlCommand cmd2 = databaseConnection.CreateCommand(); //The third query inserts the qualifications and assigns them to that driver's ID cmd2.CommandText = "INSERT INTO `assigned_qualification` (`id`, `Qualification_ID`) VALUES(@id, @qualification_id)"; cmd2.Parameters.AddWithValue("@id", ID); cmd2.Parameters.AddWithValue("@qualification_id", Qualification_ID[0]); cmd2.ExecuteNonQuery(); databaseConnection.Close(); } Qualification_ID.Clear(); } } } } } catch (Exception e) { MessageBox.Show("Add button error: " + e.Message); } }
private void SubmitButton_Click(object sender, EventArgs e) { try //throw this exception if this passenger already exists { string gender; if (FemaleradioButton1.Checked) { gender = FemaleradioButton1.Text; } else { gender = MaleradioButton2.Text; } Address addr = new Address(StreetTextBox.Text, CityTextBox.Text, StateTextBox.Text, ZipTextBox.Text); TravelAgent trav1 = new TravelAgent(FirstNameTextBox.Text, LastNameTextBox.Text, gender, addr, PhoneNumberTextBox.Text, int.Parse(IDNumberTextBox.Text), double.Parse(EarningstextBox1.Text), SsnTextBox.Text); trav1.countofEmployees++; foreach (Person p in TravelAgency.people) { if (trav1.isEqual(p)) { throw new DuplicateDataExcception("Sorry! This Passenger already exists!"); } } string s = " "; if (FirstNameTextBox.Text == s || LastNameTextBox.Text == s) { throw new InvalidName("Invalid Name"); } if (PhoneNumberTextBox.Text == s) { throw new InvalidPhoneNumber("Invalid PhoneNumber"); } if (StreetTextBox.Text == s || CityTextBox.Text == s || StateTextBox.Text == s || ZipTextBox.Text == s) { throw new InvalidAddress("Invalid Address"); } if (IDNumberTextBox.Text == s) { throw new InvalidDataException("Invalid ID"); } if (SsnTextBox.Text == s) { throw new InvalidDataException("Invalid Passport Number"); } if (!FemaleradioButton1.Checked && !MaleradioButton2.Checked) { throw new InvalidDataException("Invalid Gender"); } TravelAgency.people.Add(trav1); MessageBox.Show("Travel Agent " + FirstNameTextBox.Text + " " + LastNameTextBox.Text + " was added"); FirstNameTextBox.Clear(); LastNameTextBox.Clear(); PhoneNumberTextBox.Clear(); StreetTextBox.Clear(); SsnTextBox.Clear(); CityTextBox.Clear(); StateTextBox.Clear(); ZipTextBox.Clear(); FemaleradioButton1.Checked = false; MaleradioButton2.Checked = false; IDNumberTextBox.Clear(); EarningstextBox1.Clear(); } catch (InvalidName) { MessageBox.Show("Invalid Name"); } catch (InvalidPhoneNumber) { MessageBox.Show("Invalid phone Number"); } catch (DuplicateDataExcception ex) { MessageBox.Show(ex.Message); } catch (OverflowException oe) { MessageBox.Show(oe.Message); } catch (FormatException f) { MessageBox.Show(f.Message); } catch (Exception q) { MessageBox.Show(q.Message); } }