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