private void lstvStaffDetails_SelectedIndexChanged(object sender, EventArgs e)
{
int j = lstvStaffDetails.SelectedIndices.Count;
if (j > 0)
{
cmdViewStaffDetails.Enabled = true;
cmdEnrollFingerprintBiometrics.Enabled = true;
string[] data = new string[2];
ListViewItem lvi = lstvStaffDetails.Items[lstvStaffDetails.SelectedIndices[0]];
ListViewRowColors.recolorselectedListItems(lvi);
data[0] = lvi.SubItems[1].Text;
data[1] = lvi.SubItems[2].Text;
string[] person = idDict[data[0]];
this.data = person;
}
else
{
ListViewRowColors.recolorListItems(lstvStaffDetails);
cmdViewStaffDetails.Enabled = false;
cmdEnrollFingerprintBiometrics.Enabled = false;
}
}
public void getAttendanceRecords()
{
command = connection.GetCommand("Select p.national_id,p.surname,p.first_name, p.other_name, " +
"t.time_in,t.time_out, t.minutes from dbo.person p, dbo.time_attendance t where " +
"t.person_id=p.person_id and t.dayDate=@dayDate", CommandType.Text);
DateTime dt = DateTime.Now;
string strDate = dt.Date.ToString("yyyy - MM - dd");
command.AddParameter("@dayDate", strDate, SqlDbType.VarChar);
txtDate.Text = strDate;
using (command)
{
// initialize the reader and execute the command
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
int i = 0;
lstvStaffDetails.Items.Clear();
while (reader.Read())
{
// Create a ListViewItem object for evey item that you wish to add the ListView.
string[] lv = new String[5];
//lv[0] = Convert.ToString(reader["staff_no"]);
lv[0] = Convert.ToString(reader["national_id"]);
lv[1] = Convert.ToString(reader["surname"]) + " " + Convert.ToString(reader["first_name"])
+ " " + Convert.ToString(reader["other_name"]);
lv[2] = Convert.ToString(reader["time_in"]);
lv[3] = Convert.ToString(reader["time_out"]);
lv[4] = Convert.ToString(reader["minutes"]);
lstvStaffDetails.Items.Add(new ListViewItem(lv, i));
i++;
}
reader.Close();
ListViewRowColors.recolorListItems(lstvStaffDetails);
}
else
{
Messaging.information("No attendance details for this day is found found!", title);
}
}
}
}
public void searchPerson(string id)
{
if (!id.Equals(""))
{
if (optSearchIDname.Checked)
{
command = connection.GetCommand("SELECT * FROM dbo.person WHERE national_id = @_id", CommandType.Text);
command.AddParameter("@_id", id, SqlDbType.VarChar);
}
else if (optSearchStaffNumber.Checked)
{
command = connection.GetCommand("Select * from dbo.person p, dbo.person_job pj " +
"where p.person_id=pj.person_id and pj.staff_no = @_id", CommandType.Text);
command.AddParameter("@_id", id, SqlDbType.VarChar);
}
}
else
{
//create the command
command = connection.GetCommand("SELECT * FROM dbo.person order by surname asc", CommandType.Text);
}
using (command)
{
// initialize the reader and execute the command
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
int i = 0;
lstvStaffDetails.Items.Clear();
idDict.Clear();
person_idDict.Clear();
while (reader.Read())
{
// Create a ListViewItem object for evey item that you wish to add the ListView.
string[] lv = new String[4];
lv[0] = Convert.ToString(i + 1);//Convert.ToString(reader["designation"]);
lv[1] = Convert.ToString(reader["national_id"]);
lv[2] = Convert.ToString(reader["surname"]) + " " + Convert.ToString(reader["first_name"])
+ " " + Convert.ToString(reader["other_name"]);
lv[3] = Convert.ToString(reader["person_id"]);
//lv[3] = Convert.ToString(reader["designation"]);
lstvStaffDetails.Items.Add(new ListViewItem(lv, i));;
idDict.Add(Convert.ToString(reader["national_id"]), lv);
person_idDict.Add(Convert.ToString(reader["national_id"]), Convert.ToString(reader["person_id"]));
i++;
}
reader.Close();
ListViewRowColors.recolorListItems(lstvStaffDetails);
}
else
{
Messaging.information("No staff details found!", title);
}
}
}
}
