private void emp_listBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (emp_listBox.SelectedItem != null)
{
thumb_enroll_obj = new sms_emp_thumb_enroll();
employee_finger_GBs.DataContext = null;
sms_employee emp = emp_listBox.SelectedItem as sms_employee;
employee_details_GBs.DataContext = emp;
employee_finger_GBs.Visibility = Visibility.Visible;
thumb_enroll_obj.emp_id = Convert.ToInt32(emp.id);
hide_status();
fp.BeginEnroll();
fp.BeginCapture();
e.Handled = true;
thumb_enroll_obj = empDAL.get_all_thumb_enroll_by_emp_id(Convert.ToInt32(emp.id));
employee_finger_GBs.DataContext = thumb_enroll_obj;
}
else
{
employee_finger_GBs.Visibility = Visibility.Collapsed;
}
}
public void load_enroll()
{
try
{
isAttendance = false;
hide_status();
employee_details_GBs.DataContext = null;
emp_list = empDAL.get_all_active_employees();
thumb_enroll_obj = new sms_emp_thumb_enroll();
foreach (var item in emp_list)
{
item.icon = MetroMenuResources.Logo.User;
}
emp_listBox.ItemsSource = emp_list;
if (isInitialized)
{
fp.BeginEnroll();
}
else
{
employee_finger_GBs.Visibility = Visibility.Collapsed;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void try_again_btn_Click(object sender, RoutedEventArgs e)
{
thumb_enroll_obj = new sms_emp_thumb_enroll();
employee_finger_GBs.DataContext = null;
sms_employee emp = emp_listBox.SelectedItem as sms_employee;
thumb_enroll_obj.emp_id = Convert.ToInt32(emp.id);
hide_status();
fp.BeginEnroll();
fp.BeginCapture();
}
public List <sms_emp_thumb_enroll> get_all_thumb_enroll()
{
fp = new ZKFPEngX();
List <sms_emp_thumb_enroll> enroll_list = new List <sms_emp_thumb_enroll>();
using (MySqlConnection con = new MySqlConnection(ConnectionString.con_string))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText = "SELECT* FROM sms_emp_thumb_enroll as thumb Inner Join sms_emp as emp on emp.id=thumb.emp_id where emp.is_active='Y'";
cmd.Connection = con;
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
try
{
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
sms_emp_thumb_enroll emp = new sms_emp_thumb_enroll()
{
id = Convert.ToInt32(reader["id"]),
emp_id = Convert.ToInt32(reader["emp_id"]),
template = fp.DecodeTemplate1(reader["template"].ToString()),
image1 = (byte[])reader["image1"],
image2 = (byte[])reader["image2"],
image3 = (byte[])reader["image3"],
quality1 = Convert.ToInt32(reader["quality1"]),
quality2 = Convert.ToInt32(reader["quality2"]),
quality3 = Convert.ToInt32(reader["quality3"]),
hand = Convert.ToString(reader["hand"]),
finger_type_id = Convert.ToInt32(reader["finger_type_id"]),
date_time = Convert.ToDateTime(reader["date_time"]),
created_by = Convert.ToString(reader["created_by"]),
is_active = Convert.ToString(reader["is_active"]),
emp_login_id = Convert.ToInt32(reader["emp_login_id"])
};
enroll_list.Add(emp);
}
}
catch (Exception ex)
{
throw ex;
}
return(enroll_list);
}
}
}
public int insert_thumb_enroll(sms_emp_thumb_enroll enroll)
{
int i = 0;
try
{
using (MySqlConnection con = new MySqlConnection(ConnectionString.con_string))
{
con.Open();
using (MySqlTransaction trans = con.BeginTransaction())
{
try
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText = "Delete from sms_emp_thumb_enroll where emp_id=@emp_id && hand=@hand && finger_type_id=@finger_type_id";
cmd.Connection = con;
cmd.Transaction = trans;
cmd.Parameters.Add("@emp_id", MySqlDbType.Int32).Value = enroll.emp_id;
cmd.Parameters.Add("@hand", MySqlDbType.VarChar).Value = enroll.hand;
cmd.Parameters.Add("@finger_type_id", MySqlDbType.Int32).Value = enroll.finger_type_id;
i = Convert.ToInt32(cmd.ExecuteNonQuery());
}
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText = "INSERT INTO sms_emp_thumb_enroll(emp_id, template, image1, image2, image3, quality1,quality2, quality3, hand, finger_type_id,created_by, emp_login_id, date_time) Values(@emp_id, @template, @image1, @image2, @image3, @quality1,@quality2, @quality3, @hand, @finger_type_id,@created_by, @emp_login_id, @date_time)";
cmd.Connection = con;
cmd.Parameters.Add("@emp_id", MySqlDbType.Int32).Value = enroll.emp_id;
cmd.Parameters.Add("@template", MySqlDbType.Text).Value = enroll.templateStr;
cmd.Parameters.Add("@image1", MySqlDbType.Blob).Value = enroll.image1;
cmd.Parameters.Add("@image2", MySqlDbType.Blob).Value = enroll.image2;
cmd.Parameters.Add("@image3", MySqlDbType.Blob).Value = enroll.image3;
cmd.Parameters.Add("@quality1", MySqlDbType.Int32).Value = enroll.quality1;
cmd.Parameters.Add("@quality2", MySqlDbType.Int32).Value = enroll.quality2;
cmd.Parameters.Add("@quality3", MySqlDbType.Int32).Value = enroll.quality3;
cmd.Parameters.Add("@hand", MySqlDbType.VarChar).Value = enroll.hand;
cmd.Parameters.Add("@finger_type_id", MySqlDbType.Int32).Value = enroll.finger_type_id;
cmd.Parameters.Add("@created_by", MySqlDbType.VarChar).Value = enroll.created_by;
cmd.Parameters.Add("@emp_login_id", MySqlDbType.Int32).Value = enroll.emp_login_id;
cmd.Parameters.Add("@date_time", MySqlDbType.DateTime).Value = enroll.date_time;
i = Convert.ToInt32(cmd.ExecuteNonQuery());
trans.Commit();
con.Close();
}
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(i);
}
