private void LoadItemList()
{
SqlDataReader dr;
ListViewItem lvi;
this.Cursor = Cursors.WaitCursor;
if (miDeptFilter != 0)
{
dr = CBEmployee.GetListByDept(miDeptFilter);
}
else
{
dr = CBEmployee.GetList();
}
lvwItems.Items.Clear();
while (dr.Read())
{
lvi = new ListViewItem();
lvi.Text = dr["ID"].ToString();
lvi.SubItems.Add(dr["Abbrev"].ToString());
lvi.SubItems.Add(dr["Name"].ToString());
lvwItems.Items.Add(lvi);
}
dr.Close();
dr = null;
sbPanStatus.Text = lvwItems.Items.Count.ToString() + " employee(s)";
this.Cursor = Cursors.Default;
}
private void LoadAvailableEmployees()
{
SqlDataReader dr;
RSLib.COListItem li;
dr = CBEmployee.GetListByDept(miCurrDept);
lstAvailable.Items.Clear();
while (dr.Read())
{
li = new RSLib.COListItem();
li.ID = Convert.ToInt32(dr["ID"]);
li.Description = dr["Name"].ToString();
lstAvailable.Items.Add(li);
}
dr.Close();
}
private void LoadLeads(int deptID)
{
SqlDataReader dr;
RSLib.COListItem li;
dr = CBEmployee.GetListByDept(deptID);
clstProjects.Items.Clear();
while (dr.Read())
{
li = new RSLib.COListItem();
li.ID = Convert.ToInt32(dr["ID"]);
li.Description = dr["Name"].ToString();
clstProjects.Items.Add(li);
}
clstProjects.SetItemChecked(0, true);
dr.Close();
}
