public void LoadEmpSchedInListView(ListView lv)
{
Emp_Sched es = new Emp_Sched();
DataTable dt = new DataTable();
dt = es.SELECT_ALL();
if (dt != null)
{
int ctr = 1;
foreach (DataRow r in dt.Rows)
{
ListViewItem li = new ListViewItem();
li.Text = ctr.ToString();
li.SubItems.Add(r["fullname"].ToString());
li.SubItems.Add(r["mon"].ToString());
li.SubItems.Add(r["tue"].ToString());
li.SubItems.Add(r["wed"].ToString());
li.SubItems.Add(r["thu"].ToString());
li.SubItems.Add(r["fri"].ToString());
li.SubItems.Add(r["sat"].ToString());
li.SubItems.Add(r["sun"].ToString());
li.SubItems.Add(Convert.ToDateTime(r["date_updated"].ToString()).ToShortDateString());
lv.Items.Add(li);
ctr++;
}
}
}
public void LoadEmpSchedInListView(ListView lv)
{
Emp_Sched es = new Emp_Sched();
DataTable dt = new DataTable();
dt = es.SELECT_ALL();
if (dt != null)
{
int ctr = 1;
foreach (DataRow r in dt.Rows)
{
ListViewItem li = new ListViewItem();
li.Text = ctr.ToString();
li.SubItems.Add(r["fullname"].ToString());
li.SubItems.Add(r["mon"].ToString());
li.SubItems.Add(r["tue"].ToString());
li.SubItems.Add(r["wed"].ToString());
li.SubItems.Add(r["thu"].ToString());
li.SubItems.Add(r["fri"].ToString());
li.SubItems.Add(r["sat"].ToString());
li.SubItems.Add(r["sun"].ToString());
li.SubItems.Add(Convert.ToDateTime(r["date_updated"].ToString()).ToShortDateString());
lv.Items.Add(li);
ctr++;
}
}
}
public void LoadEmpSched(ComboBox cbo)
{
Emp_Sched es = new Emp_Sched();
DataTable dt = new DataTable();
dt = es.SELECT_ALL();
if (dt != null)
{
foreach (DataRow r in dt.Rows)
{
cbo.Items.Add(r["lname"] + ", " + r["fname"] + " " + r["mname"] + "-" + r["empid"]);
}
}
}
public void LoadEmpSched(ComboBox cbo)
{
Emp_Sched es = new Emp_Sched();
DataTable dt = new DataTable();
dt = es.SELECT_ALL();
if (dt != null)
{
foreach (DataRow r in dt.Rows)
{
cbo.Items.Add(r["lname"] + ", " + r["fname"] + " " + r["mname"] + "-" + r["empid"]);
}
}
}
