/// <summary>
/// Activates selected query
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CBxQueries_SelectedIndexChanged(object sender, EventArgs e)
{
RTBxEmpInfo.Clear();
switch (CBxQueries.SelectedIndex)
{
case 0:
RTBxEmpInfo.AppendText(businessRules.QueryEmpSortedLastName());
break;
case 1:
RTBxEmpInfo.AppendText(businessRules.QueryEmpSortFirstName());
break;
case 2:
RTBxEmpInfo.AppendText(businessRules.QueryHasAnyBenefits());
break;
case 3:
RTBxEmpInfo.AppendText(businessRules.QueryEmpHasCourses());
break;
case 4:
RTBxEmpInfo.AppendText(businessRules.QueryEmpWhoAreMarried());
break;
case 5:
RTBxEmpInfo.AppendText(businessRules.QueryEmpWhoAreSingle());
break;
default:
break;
}
}
/// <summary>
/// Starts Search for employee
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSearch_Click(object sender, EventArgs e)
{
RTBxEmpInfo.Clear();
EpForm.Clear();
string output;
if (RBtnSearchID.Checked || RBtnSearchLastName.Checked)
{
if (RBtnSearchID.Checked) {
if (valid.ValidIDFormat(TxtSearchEmployee.Text))
{
uint key = uint.Parse(TxtSearchEmployee.Text);
Employee emp = businessRules[key];
output = businessRules.QueryEmpID(TxtSearchEmployee.Text);
if (ChBxBenefits.Checked && ChBxCourses.Checked) { output = businessRules.QueryEmpID(TxtSearchEmployee.Text) + emp.DisplayBenefits() + emp.DisplayCourses(); }
else if (ChBxBenefits.Checked) { output = businessRules.QueryEmpID(TxtSearchEmployee.Text) + emp.DisplayBenefits(); }
else {
if (ChBxCourses.Checked) {
output = businessRules.QueryEmpID(TxtSearchEmployee.Text) + emp.DisplayCourses();
}
}
RTBxEmpInfo.AppendText(output);
}
else { EpForm.SetError(TxtSearchEmployee, "Invalid ID"); }
}
else {
if (valid.ValidLastNameFormat(TxtSearchEmployee.Text))
{
output = businessRules.QueryEmpLastName(TxtSearchEmployee.Text);
if (ChBxBenefits.Checked && ChBxCourses.Checked) { output = businessRules.QueryLastNameBenefitsCourses(TxtSearchEmployee.Text); }
else if (ChBxBenefits.Checked) { output = businessRules.QueryLastNamesWithBenefits(TxtSearchEmployee.Text); }
else { output = businessRules.QueryLastNameWithCourses(TxtSearchEmployee.Text); }
RTBxEmpInfo.AppendText(output);
}
else { EpForm.SetError(TxtSearchEmployee, "Invalid Last Name"); }
}
}
else
{
if (!(RBtnSearchID.Checked || RBtnSearchLastName.Checked))
{
EpForm.SetError(RBtnSearchID, "Choose One");
EpForm.SetError(RBtnSearchLastName, "Choose One");
}
}
}
/// <summary>
/// Using an indexer, displays current database to a textbox
/// </summary>
private void DisplayAllEmployeesInDataBase()
{
RTBxEmpInfo.Clear();
RTBxEmpInfo.AppendText(businessRules.DisplayEmployees());
}
/// <summary>
/// clear all text boxes to be empty or default values
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnClearList_Click(object sender, EventArgs e)
{
RTBxEmpInfo.Clear();
}
