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