private void nxtButton_Click(object sender, EventArgs e)
{
if (!Regex.IsMatch(firstNametxtbox.Text, @"^[a-zA-Z0 ]+$"))
{
MessageBox.Show("First name can not be empty or contains numbers and symbol");
}
else if (!Regex.IsMatch(lastNametxtbox.Text, @"^[a-zA-Z0 ]+$"))
{
MessageBox.Show("Last name can not be empty or contains numbers and symbol");
}
else if (!Regex.IsMatch(gendertxtbox.Text, @"^[a-zA-Z0 ]+$"))
{
MessageBox.Show("Gender can not be empty or contains numbers and symbol");
}
else if (!Regex.IsMatch(passportNumbtxtbox.Text, @"^[a-zA-Z0-9 ]+$"))
{
MessageBox.Show("Passport number can not be empty or contains symbol");
}
else if (Nationalitytxtbox.Text == "")
{
MessageBox.Show("Nationality can not be empty");
}
else if (Addresstxtbox.Text == "")
{
MessageBox.Show("Address can not be empty");
}
else if (!Regex.IsMatch(postCodetxtbox.Text, @"^[a-zA-Z0-9 ]{7,8}\b+$"))
{
MessageBox.Show("Post code can not be empty or contains symbols");
}
else if (!Double.TryParse(contactNumbertxtbox.Text, out mynum))
{
MessageBox.Show("Contact number can not be empty or it must not contain letters or symbols");
}
else if (!Regex.IsMatch(emailtxtbox.Text, @"^[a-zA-Z0-9 ]+$"))
{
MessageBox.Show("Must be a valid email address");
}
else
//KEVIN
{
MessageBox.Show("Booking Reserved");
string cString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=PrimaryDB.mdb";
string save = "INSERT INTO Customers (CustomerFirstName, CustomerLastName, Gender, PassportNumber, Nationality, Address, PostCode, ContactNumber, EmailAddress) " +
"VALUES (@CustomerFirstName, @CustomerLastName, @Gender, @PassportNumber, @Nationality, @Address, @PostCode, @ContactNumber, @EmailAddress)";
object[] customers = { "@CustomerFirstName", firstNametxtbox.Text, "@CustomerLastName", lastNametxtbox.Text, "@Gender", gendertxtbox.Text,
"@PassportNumber", passportNumbtxtbox.Text, "@Nationality", Nationalitytxtbox.Text, "@Address", Addresstxtbox.Text,"@PostCode",
postCodetxtbox.Text, "@ContactNumber", contactNumbertxtbox.Text, "@EmailAddress", emailtxtbox.Text };
var dbFunc = new DatabaseFunctions();
dbFunc.writeDatabase(save, cString, customers);
this.Hide();
Booking_Confirmation b = new Booking_Confirmation();
b.ShowDialog();
}
}
private void nxtButton_Click(object sender, EventArgs e)
{
// Basic validation which will notify the user if they have added invalid characters
if (!Regex.IsMatch(firstNametxtbox.Text, @"^[a-zA-Z0]+$"))
{
MessageBox.Show("First name can not be empty or contains numbers and symbol");
}
else if (!Regex.IsMatch(lastNametxtbox.Text, @"^[a-zA-Z0]+$"))
{
MessageBox.Show("Last name can not be empty or contains numbers and symbol");
}
else if (!Regex.IsMatch(gendertxtbox.Text, @"^[a-zA-Z0]+$"))
{
MessageBox.Show("Gender can not be empty or contains numbers and symbol");
}
else if (!Regex.IsMatch(passportNumbtxtbox.Text, @"^[a-zA-Z0-9]+$"))
{
MessageBox.Show("Passport number can not be empty or contains symbol");
}
else if (!Regex.IsMatch(Nationalitytxtbox.Text, @"^[a-zA-Z0-9]+$"))
{
MessageBox.Show("Nationality can not be empty or contains symbol");
}
else if (!Regex.IsMatch(Addresstxtbox.Text, @"^[A-Za-z0-9'\.\-\s\,]"))
{
MessageBox.Show("Must be a valid address");
}
else if (!Regex.IsMatch(postCodetxtbox.Text, @"^[a-zA-Z0-9 ]{7,8}\b+$"))
{
MessageBox.Show("Post code can not be empty or contains symbols");
}
else if (!Regex.IsMatch(contactNumbertxtbox.Text, @"(\+?( |-|\.)?\d{1,2}( |-|\.)?)?(\(?\d{3}\)?|\d{3})( |-|\.)?(\d{3}( |-|\.)?\d{4})"))
{
MessageBox.Show("Contact number can not be empty or contain letters or symbols");
}
else if (!Regex.IsMatch(emailtxtbox.Text, @"^([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+)\.([a-zA-Z]{2,5})$"))
{
MessageBox.Show("Must be a valid email address");
}
else
{
// Connects to the database
string cString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=PrimaryDB.mdb";
// SQL query that will insert customer details to the database
string save = "INSERT INTO Customers (CustomerFirstName, CustomerLastName, Gender, PassportNumber, Nationality, Address, PostCode, " +
"ContactNumber, EmailAddress) VALUES (@CustomerFirstName, @CustomerLastName, @Gender, @PassportNumber, @Nationality, @Address, " +
"@PostCode, @ContactNumber, @EmailAddress)";
// Objects it requires
object[] customers = { "@CustomerFirstName", firstNametxtbox.Text, "@CustomerLastName", lastNametxtbox.Text, "@Gender", gendertxtbox.Text,
"@PassportNumber", passportNumbtxtbox.Text, "@Nationality", Nationalitytxtbox.Text, "@Address", Addresstxtbox.Text,"@PostCode",
postCodetxtbox.Text, "@ContactNumber", contactNumbertxtbox.Text, "@EmailAddress", emailtxtbox.Text };
try
{
// Function to write to database using the variables
var dbFunc = new DatabaseFunctions();
dbFunc.writeDatabase(save, cString, customers);
MessageBox.Show("Booking Reserved");
this.Hide();
booking.fname = firstNametxtbox.Text;
booking.sname = lastNametxtbox.Text;
booking.customerAddress = Addresstxtbox.Text;
booking.customerPhone = contactNumbertxtbox.Text;
booking.gender = gendertxtbox.Text;
booking.passportNum = passportNumbtxtbox.Text;
booking.nationality = Nationalitytxtbox.Text;
booking.postCode = postCodetxtbox.Text;
booking.email = emailtxtbox.Text;
Booking_Confirmation b = new Booking_Confirmation(booking.bookingDate, booking.fname, booking.sname,
booking.customerAddress, booking.customerPhone, booking.gender, booking.nationality,
booking.passportNum, booking.postCode, booking.email, booking.flightNumber,
booking.flightType, booking.Departuretime, booking.arrivalTime, booking.numAdults,
booking.numChild, booking.flightDestination, booking.flightTotalPrice, booking.carNumPlate,
booking.carSeats, booking.carMake, booking.carModel, booking.carHirePrice, booking.carHireName,
booking.hotelStar, booking.hotelCheckin, booking.hotelCheckout, booking.hotelName, booking.hotelTotalPrice, booking.totalPrice);
b.ShowDialog();
}
catch (Exception)
{
MessageBox.Show("An error occurred. Please contact the system administrator");
}
}
}