private void addEmployeeButton_Click(object sender, EventArgs e)
{
EmployeeLevel level = EmployeeLevel.EMPLOYEE;
switch (levelBox.Text)
{
case "Employee":
level = EmployeeLevel.EMPLOYEE;
break;
case "Manager":
level = EmployeeLevel.MANAGER;
break;
case "Admin":
level = EmployeeLevel.ADMIN;
break;
}
if (DatabaseInputValidation.mandatoryStringIsValid(newUsernameInput.Text, 3) && newPasswordInput.Text.Length >= 4)
{
bool success = Database.Instance.createEmployee(empFName.Text, empLName.Text, newUsernameInput.Text, newPasswordInput.Text, level);
if (success)
{
MessageBox.Show("User creation succeeded.");
}
else
{
MessageBox.Show("User creaton failed.");
}
}
else
{
MessageBox.Show("Please enter the new employee's username and password (passwords must be at least four characters).");
}
}
private bool validateNote()
{
if (DatabaseInputValidation.stringIsValid(noteText.Text))
{
return(true);
}
return(false);
}
private void modifyButton_Click(object sender, EventArgs e)
{
if (FirstNameTextbox.Text != "" && LastNameTextbox.Text != "" && MiddleInitTextbox.Text != "" && EmailTextbox.Text != "" && PhoneTextbox.Text != "" && IDTextbox.Text != "")
{
//First make sure all the text boxes are filled
bool isValid = true;
if (!DatabaseInputValidation.nameIsValid(FirstNameTextbox.Text) && isValid)
{
isValid = false;
MessageBox.Show("First Name has Invalid Input!");
}
if (!DatabaseInputValidation.nameIsValid(FirstNameTextbox.Text) && isValid)
{
isValid = false;
MessageBox.Show("Last Name has Invalid Input!");
}
if (!DatabaseInputValidation.nameIsValid(FirstNameTextbox.Text) && isValid)
{
isValid = false;
MessageBox.Show("Middle Initial has Invalid Input!");
}
if (!DatabaseInputValidation.uintIsValid(PhoneTextbox.Text) && isValid)
{
isValid = false;
MessageBox.Show("Phone Number has Invalid Input!");
}
if (!DatabaseInputValidation.uintIsValid(IDTextbox.Text) && isValid)
{
isValid = false;
MessageBox.Show("ID number has Invalid Input!");
}
if (!DatabaseInputValidation.stringIsValid(EmailTextbox.Text) && isValid)
{
isValid = false;
MessageBox.Show("Email has Invalid Input!");
}
if (isValid)
{
var sign = new SignWaiver(FirstNameTextbox.Text, LastNameTextbox.Text, MiddleInitTextbox.Text, PhoneTextbox.Text, EmailTextbox.Text, Convert.ToInt32(IDTextbox.Text), true);
sign.Show();
//createPatron(string fName, string lName, string midI, string phone, string email, string pat_Id)
// bool status = Database.Instance.modifyPatron(FirstNameTextbox.Text, LastNameTextbox.Text, MiddleInitTextbox.Text, PhoneTextbox.Text, EmailTextbox.Text, Convert.ToInt32(IDTextbox.Text));
}
}
else
{
MessageBox.Show("Make sure all textboxes are filled out!");
}
}
private void reqButton_Click(object sender, EventArgs e)
{
//Patron ID validation goes here
if (!DatabaseInputValidation.uintIsValidWithinRange(idTextBox.Text, 0, 9999999))
{
MessageBox.Show("Please enter a valid patron ID!");
}
if (!String.IsNullOrEmpty(idTextBox.Text) &&
DatabaseInputValidation.mandatoryStringIsValid(reasonTextBox.Text, 1) && DatabaseInputValidation.mandatoryStringIsValid(lengthTextBox.Text, 1))
{
String reqText = "Suspension Request for Patron: " + idTextBox.Text + " For: " + reasonTextBox.Text + ". Suggested Suspension: " + lengthTextBox.Text;
Database.Instance.addNote(reqText, 10);
}
else
{
MessageBox.Show("Please enter information for all fields!");
}
}
private void logButton_Click(object sender, EventArgs e)
{
PatronLoginStatus loggedIn = PatronLoginStatus.MISCERROR;
if (String.IsNullOrEmpty(idTextbox.Text))
{
MessageBox.Show("Please input an ID!");
}
else if (!DatabaseInputValidation.uintIsValid(idTextbox.Text))
{
MessageBox.Show("User ID must be a number!");
}
else
{
loggedIn = Database.Instance.patron_login(idTextbox.Text);
string status;
switch (loggedIn)
{
case PatronLoginStatus.MISCERROR:
status = "Login failed!"; break;
case PatronLoginStatus.PATRONNOTFOUND:
status = "Patron not found!"; break;
case PatronLoginStatus.WAVEREXPIRED:
status = "Waver expired! Please resign the waver."; break;
case PatronLoginStatus.PATRONSUSPENDED:
status = "Patron currently suspended!"; break;
case PatronLoginStatus.SUCCESS:
status = "Login successful!"; break;
case PatronLoginStatus.PATRONSUSPCLEAR:
status = "Patron Suspension Cleared, Please Re-Enter your Login!"; break;
default:
status = "what"; break;
}
MessageBox.Show(status);
}
}
private bool databaseSearchValidation()
{
bool isValid = false;
switch (tableSelectBox.SelectedIndex)
{
case ((int)DatabaseSearchVal.EMPLOYEE):
if (DatabaseInputValidation.uintIsValid(empIdBox.Text) &&
DatabaseInputValidation.uintIsValidWithinRange(empLevelBox.Text, 0, 2) &&
DatabaseInputValidation.stringIsValid(empUsernameBox.Text))
{
isValid = true;
}
break;
case ((int)DatabaseSearchVal.PATRON):
if (DatabaseInputValidation.uintIsValid(patronIdBox.Text) &&
DatabaseInputValidation.nameIsValid(patronFirstNameBox.Text) &&
DatabaseInputValidation.nameIsValid(patronLastNameBox.Text))
{
isValid = true;
}
break;
case ((int)DatabaseSearchVal.LOGINS):
if (DatabaseInputValidation.uintIsValid(loginPatronIdBox.Text))
{
isValid = true;
}
break;
case ((int)DatabaseSearchVal.SUSPENSIONS):
if (DatabaseInputValidation.uintIsValid(susPatronIdBox.Text))
{
isValid = true;
}
break;
}
return(isValid);
}
public void StringInputValidation3()
{
Assert.IsFalse(DatabaseInputValidation.mandatoryStringIsValid("", 1));
}
public void StringInputValidation2()
{
Assert.IsTrue(DatabaseInputValidation.stringIsValid(""));
}
public void StringInputValidation1()
{
Assert.IsFalse(DatabaseInputValidation.stringIsValid("sagd325g##@@!ADSF2357hsdakf2!@^$#&$!!$#"));
}
public void NameInputValidation4()
{
Assert.IsFalse(DatabaseInputValidation.nameIsValid("#######"));
}
public void NameInputValidation3()
{
Assert.IsFalse(DatabaseInputValidation.nameIsValid("a32d"));
}
public void NameInputValidation2()
{
Assert.IsTrue(DatabaseInputValidation.nameIsValid(""));
}
public void NameInputValidation1()
{
Assert.IsTrue(DatabaseInputValidation.nameIsValid("John Dickenson"));
}
public void PositiveIntInputValidation6()
{
Assert.IsTrue(DatabaseInputValidation.uintIsValid(""));
}
public void PositiveIntInputValidation5()
{
Assert.IsFalse(DatabaseInputValidation.uintIsValid("sad"));
}
private void regButton_Click(object sender, EventArgs e)
{
string patron = patronTextBox.Text;
string clinic = clinicTextBox.Text;
if (!DatabaseInputValidation.uintIsValidWithinRange(patron, 0, 9999999) || !DatabaseInputValidation.uintIsValidWithinRange(clinic, 0, 99999999) ||
String.IsNullOrEmpty(patron) || String.IsNullOrEmpty(clinic))
{
MessageBox.Show("Please enter valid patron and clinic IDs!");
return;
}
string status = "";
bool valid = false;
//Check if Patron Valid
string where = " Where PatronId = " + patron + ";"; //find clinic where clinic_Id = clinic && time >= today
//MessageBox.Show(where);
DataTable dataset = Database.Instance.searchDatabase("patron", "PatronID, FK_Suspend", where);
if (dataset.Rows.Count == 1) //If Patron found
{
if (dataset.Rows[0]["FK_Suspend"].ToString() == "") //check for suspension
{
valid = true;
}
else
{
status = "Patron is Suspeneded";
}
}
else //If Patron not found
{
status = "Patron Not found! ";
valid = false;
}
//Check if Clinic Valid
if (valid)
{
DateTime today = DateTime.Today; //need to check if the clinic is still available
string todayStr = today.Year.ToString() + "-" + today.Month.ToString() + "-" + today.Day.ToString() + " " + today.TimeOfDay.ToString();
where = " WHERE Clinic_ID = " + clinic + ";"; //find clinic where clinic_Id = clinic && time >= today
dataset = Database.Instance.searchDatabase("clinics ", where);
if (dataset.Rows.Count == 1) //If we have a Clinic with the Proper ID
{
string stmt = "Insert Into climbing_wall.clinic_registration (FK_Clinic_ID, FK_Patron_ID) VALUES (" + clinic + ", " + patron + ");";
if (Database.Instance.nonQuery(stmt))
{
status = "Regristration Successful!";
}
else
{
status += "Registration Failed!";
}
}
else
{
status += "Clinic " + clinic + "Not Found or has already occured!";
}
}
//Add Registration to reg Table
MessageBox.Show(status);
}
