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