// event method for when the delete booking button has been clicked
private void btnDeleteBook_Click(object sender, EventArgs e)
{
// show confirmation message - if answered yes, continue
if (MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
// delete the booking with id of x from tblBookings
string cmd = String.Format("DELETE from tblBookings WHERE Id = {0}", book.id);
Debug.WriteLine("Started delete process..");
try
{
// execute command with the miscAction method
db.miscAction(cmd);
help.refreshHomeForm();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
// closes the form
this.Close();
}
}
// event method for when the delete all bookings button is clicked
private void btnDeleteAll_Click(object sender, EventArgs e)
{
// show confirmation dialog to user. continue if user clicked 'yes'
if (MessageBox.Show("Are you sure you want to delete all bookings?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
// sends misc query to database
db.miscAction("TRUNCATE TABLE tblBookings");
}
}
// when delete all bookings button is clicked
private void btnDeleteAll_Click(object sender, EventArgs e)
{
// show confirmation message - if answer is yes
if (MessageBox.Show("Are you sure you want to delete all bookings?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
// delete all bookings
db.miscAction("TRUNCATE TABLE tblBookings");
// refresh the form
refreshForm();
}
}
// when the submit button is clicked
private void btnSubmit_Click(object sender, EventArgs e)
{
// default the password given to null
string givenPassword = null;
// CHECK: password match
if (!String.IsNullOrEmpty(txtPass1.Text))
{
// if both passwords are tge sane
if (txtPass1.Text == txtPass2.Text)
{
// the given password is that has been entered into txtPass1
givenPassword = txtPass1.Text;
}
// else throw error message, abandon checks and force password reattempt
else
{
MessageBox.Show("The two passwords you entered don't match!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
// CHECK: username already exists
if (db.checkUsernameExists(txtUsername.Text, userID))
{
// throw error message to user
MessageBox.Show("That username is taken!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
// CHECK: username alphanumeric
Regex alphanumeric = new Regex("^[a-zA-Z0-9]*$");
// if the username does not meet the regex requirements: throw error message
if (!alphanumeric.IsMatch(txtUsername.Text))
{
MessageBox.Show("The username should only contain alphanumeric characters! (A-Z, a-z and 0-9)", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
// CHECK: username length is less than or = 15
if (txtUsername.Text.Length > 15)
{
MessageBox.Show("The username should be 15 characters or less!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
// if form is set to new user mode
if (newUserMode)
{
try
{
// set SQL command to INSERT
string cmd = String.Format("INSERT INTO tblUsers (FirstName, SecondName, Password, Role, Username) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')", txtName1.Text, txtName2.Text, txtPass1.Text, bxRoleList.Text, txtUsername.Text);
// send the command to the Database server
db.miscAction(cmd);
// refresh the home form to accomodate for new data
helper.refreshHomeForm();
// close this form
this.Close();
}
// if error in the sending of the SQL command: throw to user
catch (Exception ex)
{
MessageBox.Show("An unexpected error occured. \nDetails: " + ex.ToString(), "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// if form is in edit mode
else
{
// if no new password is given, set the given password to their current password
if (String.IsNullOrEmpty(givenPassword))
{
givenPassword = user.password;
}
try
{
// call updateuser method and pass through all user details
db.updateUser(userID, txtName1.Text, txtName2.Text, givenPassword, bxRoleList.Text, txtUsername.Text);
// if the user being edited is the current logged in user
if (session.userID == userID)
{
// change their name shown at top to updated name
session.name = new string[] { txtName1.Text, txtName2.Text };
}
// refresh the home form to show new details
helper.refreshHomeForm();
// close the form
this.Close();
}
// if an error occurs, throw to user
catch (Exception ex)
{
MessageBox.Show("An unexpected error occured. \nDetails: " + ex.ToString(), "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
