private bool ValidateDataDeleteExisting()
{
// Validate user entry (for deleting an existing user)
m_error = false;
m_errorID = CommonDefs.fieldsNone;
m_errorCode = CommonDefs.FieldError.fieldError_None;
// Note: Only the employee ID is required for deleting a user
// Employee ID
int employeeID = -1;
if (string.IsNullOrEmpty(txtEmployeeID.Text))
{
m_error = true;
m_errorID |= CommonDefs.fieldEmployeeID;
m_errorCode = CommonDefs.FieldError.fieldError_Blank;
}
else if (!int.TryParse(txtEmployeeID.Text, out employeeID))
{
m_error = true;
m_errorID |= CommonDefs.fieldEmployeeID;
m_errorCode = CommonDefs.FieldError.fieldError_Invalid;
}
else if ((employeeID < employeeIdMin) || (employeeID > employeeIdMax))
{
m_error = true;
m_errorID |= CommonDefs.fieldEmployeeID;
m_errorCode = CommonDefs.FieldError.fieldError_OutOfRange;
}
// Confirm this employee exists in the database
if (!m_error)
{
string query = (
"SELECT * FROM EmployeeData WHERE " +
"EmployeeID=" + employeeID.ToString() + ";");
if (!DoesQueryReturnRows(query))
{
m_error = true;
m_errorID |= CommonDefs.fieldEmployeeID;
m_errorCode = CommonDefs.FieldError.fieldError_IdUnknown;
}
}
// If there are no errors, this user can be edited in the database!
if (!m_error)
{
m_employee.EmployeeID = employeeID;
}
return(!m_error);
}
private string GetInvalidDataReason(CommonDefs.FieldError error)
{
string reason = string.Empty;
switch (error)
{
case CommonDefs.FieldError.fieldError_Blank:
reason = "Blank";
break;
case CommonDefs.FieldError.fieldError_Length:
reason = "Length too long";
break;
case CommonDefs.FieldError.fieldError_Invalid:
reason = "Invalid format";
break;
case CommonDefs.FieldError.fieldError_OutOfRange:
reason = "Out of range";
break;
case CommonDefs.FieldError.fieldError_IdUnknown:
reason = "ID not recognised";
break;
case CommonDefs.FieldError.fieldError_DuplicateName:
reason = "Duplicate name";
break;
case CommonDefs.FieldError.fieldError_DuplicateUsername:
reason = "User already exists";
break;
default:
reason = "Unknown";
break;
}
return(reason);
}
private bool ValidateDataEditExisting()
{
// Validate user entry (for editing an existing user)
m_error = false;
m_errorID = CommonDefs.fieldsNone;
m_errorCode = CommonDefs.FieldError.fieldError_None;
// Assume all user data has been entered and is valid
m_editFields = CommonDefs.fieldsAll;
// Employee ID
int employeeID = -1;
if (string.IsNullOrEmpty(txtEmployeeID.Text))
{
m_error = true;
m_errorID |= CommonDefs.fieldEmployeeID;
m_errorCode = CommonDefs.FieldError.fieldError_Blank;
}
else if (!int.TryParse(txtEmployeeID.Text, out employeeID))
{
m_error = true;
m_errorID |= CommonDefs.fieldEmployeeID;
m_errorCode = CommonDefs.FieldError.fieldError_Invalid;
}
else if ((employeeID < employeeIdMin) || (employeeID > employeeIdMax))
{
m_error = true;
m_errorID |= CommonDefs.fieldEmployeeID;
m_errorCode = CommonDefs.FieldError.fieldError_OutOfRange;
}
// Confirm this employee exists in the database
if (!m_error)
{
string query = (
"SELECT * FROM EmployeeData WHERE " +
"EmployeeID=" + employeeID.ToString() + ";");
if (!DoesQueryReturnRows(query))
{
m_error = true;
m_errorID |= CommonDefs.fieldEmployeeID;
m_errorCode = CommonDefs.FieldError.fieldError_IdUnknown;
}
}
// Check at least one user detail has been provided (e.g. first name)
if (!m_error)
{
if ((string.IsNullOrEmpty(txtFirstName.Text)) &&
(string.IsNullOrEmpty(txtLastName.Text)) &&
(string.IsNullOrEmpty(txtPay.Text)))
{
m_error = true;
m_errorID |= (
CommonDefs.fieldFirstName |
CommonDefs.fieldLastName |
CommonDefs.fieldPay);
m_errorCode = CommonDefs.FieldError.fieldError_Blank;
m_editFields &= ~(CommonDefs.fieldFirstName);
m_editFields &= ~(CommonDefs.fieldLastName);
m_editFields &= ~(CommonDefs.fieldPay);
}
}
// First name
if (!m_error)
{
if ((string.IsNullOrEmpty(txtFirstName.Text)) ||
(txtFirstName.Text.Length > firstNameLengthMax))
{
m_editFields &= ~(CommonDefs.fieldFirstName);
}
}
// Last name
if (!m_error)
{
if ((string.IsNullOrEmpty(txtLastName.Text)) ||
(txtLastName.Text.Length > lastNameLengthMax))
{
m_editFields &= ~(CommonDefs.fieldLastName);
}
}
// Check for a duplicate combination of (FirstName,LastName)
if (!m_error)
{
if ((!string.IsNullOrEmpty(txtFirstName.Text)) &&
(!string.IsNullOrEmpty(txtLastName.Text)))
{
string query = (
"SELECT * FROM EmployeeData WHERE " +
"FirstName='" + txtFirstName.Text + "' AND " +
"LastName='" + txtLastName.Text + "';");
if (DoesQueryReturnRows(query))
{
m_error = true;
m_errorID |= (
CommonDefs.fieldFirstName |
CommonDefs.fieldLastName);
m_errorCode = CommonDefs.FieldError.fieldError_DuplicateName;
m_editFields &= ~(CommonDefs.fieldFirstName);
m_editFields &= ~(CommonDefs.fieldLastName);
}
}
}
// Pay
decimal pay = 0.0m;
if (!m_error)
{
if (string.IsNullOrEmpty(txtPay.Text))
{
m_editFields &= ~(CommonDefs.fieldPay);
}
else if (!decimal.TryParse(txtPay.Text, out pay))
{
m_error = true;
m_errorID |= CommonDefs.fieldPay;
m_errorCode = CommonDefs.FieldError.fieldError_Invalid;
m_editFields &= ~(CommonDefs.fieldPay);
}
else if ((pay < payMin) || (pay > payMax))
{
m_error = true;
m_errorID |= CommonDefs.fieldPay;
m_errorCode = CommonDefs.FieldError.fieldError_OutOfRange;
}
}
// If there are no errors, this user can be edited in the database!
if (!m_error)
{
m_employee.EmployeeID = employeeID;
m_employee.FirstName = txtFirstName.Text;
m_employee.LastName = txtLastName.Text;
m_employee.Pay = pay;
}
return(!m_error);
}
private bool ValidateDataNewUser()
{
// Validate user entry (for adding a new user)
m_error = false;
m_errorID = CommonDefs.fieldsNone;
m_errorCode = CommonDefs.FieldError.fieldError_None;
// First name
if (string.IsNullOrEmpty(txtFirstName.Text))
{
m_error = true;
m_errorID |= CommonDefs.fieldFirstName;
m_errorCode = CommonDefs.FieldError.fieldError_Blank;
}
else if (txtFirstName.Text.Length > firstNameLengthMax)
{
m_error = true;
m_errorID |= CommonDefs.fieldFirstName;
m_errorCode = CommonDefs.FieldError.fieldError_Length;
}
// Last name
if (string.IsNullOrEmpty(txtLastName.Text))
{
m_error = true;
m_errorID |= CommonDefs.fieldLastName;
m_errorCode = CommonDefs.FieldError.fieldError_Blank;
}
else if (txtLastName.Text.Length > lastNameLengthMax)
{
m_error = true;
m_errorID |= CommonDefs.fieldLastName;
m_errorCode = CommonDefs.FieldError.fieldError_Length;
}
// Check for a duplicate combination of (FirstName,LastName)
if (!m_error)
{
string query = (
"SELECT * FROM EmployeeData WHERE " +
"FirstName='" + txtFirstName.Text + "' AND " +
"LastName='" + txtLastName.Text + "';");
if (DoesQueryReturnRows(query))
{
m_error = true;
m_errorID |= (
CommonDefs.fieldFirstName |
CommonDefs.fieldLastName);
m_errorCode = CommonDefs.FieldError.fieldError_DuplicateName;
}
}
// Pay
decimal pay = 0.0m;
if (!m_error)
{
if (string.IsNullOrEmpty(txtPay.Text))
{
m_error = true;
m_errorID |= CommonDefs.fieldPay;
m_errorCode = CommonDefs.FieldError.fieldError_Blank;
}
else if (!decimal.TryParse(txtPay.Text, out pay))
{
m_error = true;
m_errorID |= CommonDefs.fieldPay;
m_errorCode = CommonDefs.FieldError.fieldError_Invalid;
}
else if ((pay < payMin) || (pay > payMax))
{
m_error = true;
m_errorID |= CommonDefs.fieldPay;
m_errorCode = CommonDefs.FieldError.fieldError_OutOfRange;
}
}
// If there are no errors, this user can be added to the database!
if (!m_error)
{
m_employee.FirstName = txtFirstName.Text;
m_employee.LastName = txtLastName.Text;
m_employee.Pay = pay;
}
return(!m_error);
}
