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