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