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