/// <summary>
/// gets the infor for a particular staff member
/// AC 10/15/2012
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnStaffLookup_Click(object sender, EventArgs e)
{
try
{
BusinessTier staffBT = new BusinessTier();
Dictionary<String, String> staffInfo = new Dictionary<string, string>();
staffInfo.Add("staffID", txtStaffID.Text);
// expects a dataset with two tables: error table and a results table
DataSet staffDS = staffBT.getStaff(staffInfo);
pnlBranch.Visible = false;
pnlStaff.Visible = false;
// first table in the dataset is the error table
// the second table is the results table
// accesses the results if the error table is empty
if (staffDS.Tables[0].Rows.Count == 0 && staffDS.Tables[1].Rows.Count > 0)
{
lblStaffError.Text = "";
lblStaffID.Text = staffDS.Tables[1].Rows[0][0].ToString();
lblStaffFirst.Text = staffDS.Tables[1].Rows[0][1].ToString();
lblStaffLast.Text = staffDS.Tables[1].Rows[0][2].ToString();
lblStaffPosition.Text = staffDS.Tables[1].Rows[0][3].ToString();
lblStaffGender.Text = staffDS.Tables[1].Rows[0][4].ToString();
lblStaffDOB.Text = staffDS.Tables[1].Rows[0][5].ToString();
lblStaffSalary.Text = staffDS.Tables[1].Rows[0][6].ToString();
lblStaffBranchID.Text = staffDS.Tables[1].Rows[0][7].ToString();
pnlStaff.Visible = true;
}
else if (staffDS.Tables[0].Rows.Count > 0)
{
lblStaffID.Text = "";
lblStaffFirst.Text = "";
lblStaffLast.Text = "";
lblStaffPosition.Text = "";
lblStaffGender.Text = "";
lblStaffDOB.Text = "";
lblStaffSalary.Text = "";
lblStaffBranchID.Text = "";
lblStaffError.Text = staffDS.Tables[0].Rows[0][0].ToString();
}
else
{
lblStaffID.Text = "";
lblStaffFirst.Text = "";
lblStaffLast.Text = "";
lblStaffPosition.Text = "";
lblStaffGender.Text = "";
lblStaffDOB.Text = "";
lblStaffSalary.Text = "";
lblStaffBranchID.Text = "";
lblStaffError.Text = "*Staff member not found!";
}
}
catch (Exception ex)
{
lblStaffError.Text = "A minor error occured. Please contact an Administrator.";
BusinessTier.logError(ex, ex.Source.ToString(), ex.TargetSite.ToString());
}
}
