public void LoadAtt_BY_EMPID_BW_DATES_InListView(ListView lv)
{
Attendance a = new Attendance();
DataTable dt = new DataTable();
//get empid from combobox
if (cboEmp.Text != "") {
String[] eid = cboEmp.Text.Split('-');
a.empid = eid[1];
dt = a.SELECT_BY_EMPID_BW_DATES(dtpFrom.Value, dtpTo.Value);
if (dt != null)
{
lv.Items.Clear();
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["position_"].ToString());
li.SubItems.Add(Convert.ToDateTime(r["date_"].ToString()).ToLongDateString());
li.SubItems.Add(r["attendance"].ToString());
li.Tag = r["empid"].ToString();
// li.SubItems.Add(Convert.ToDateTime(r["date_updated"].ToString()).ToLongDateString());
lv.Items.Add(li);
ctr++;
}
}
else
{
MessageBox.Show("Error");
}
}
}
//BACKGROUND WORKER TO GET THE ATTENDANCE
//INSTANTIATE AN ATTENDANCE OBJECT
//SET THE OBJECT.EMPID
//GET ATTENDANCE BY_EMPID BETWEEN_DATES AND PUT IT IN A DATATABLE NAMED attendancedt
private void bgwattendance_DoWork(object sender, DoWorkEventArgs e)
{
Attendance att = new Attendance();
att.empid = emp.empid;
if (dbcon.CONNECT())
{
attendancedt = att.SELECT_BY_EMPID_BW_DATES(cutoff.from_date, cutoff.to_date, dbcon);
}
}
