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;
}
}
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_employee> get_all_active_employees()
{
List <sms_employee> emp_list = new List <sms_employee>();
//using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["Connection_String"].ConnectionString))
using (MySqlConnection con = new MySqlConnection(ConnectionString.con_string))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText = "SELECT* FROM sms_emp as emp Inner Join sms_emp_title as title on emp.emp_title_id=title.id Inner join sms_emp_designation as designation on emp.emp_designation_id= designation.id where emp.is_active='Y' Order by emp.emp_type_id ASC";
cmd.Connection = con;
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
try
{
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
sms_employee emp = new sms_employee()
{
id = Convert.ToString(reader["id"].ToString()),
emp_name = Convert.ToString(reader["emp_name"].ToString()),
emp_father = Convert.ToString(reader["emp_father"].ToString()),
emp_nationality = Convert.ToString(reader["emp_nationality"].ToString()),
emp_religion = Convert.ToString(reader["emp_religion"].ToString()),
emp_exp = Convert.ToString(reader["emp_exp"].ToString()),
emp_cnic = Convert.ToString(reader["emp_cnic"].ToString()),
emp_qual = Convert.ToString(reader["emp_qual"].ToString()),
emp_sex = Convert.ToString(reader["emp_sex"].ToString()),
emp_marital = Convert.ToString(reader["emp_marital"].ToString()),
emp_dob = Convert.ToDateTime(reader["emp_dob"]),
joining_date = Convert.ToDateTime(reader["joining_date"]),
emp_email = Convert.ToString(reader["emp_email"].ToString()),
emp_address = Convert.ToString(reader["emp_address"].ToString()),
emp_remarks = Convert.ToString(reader["emp_remarks"].ToString()),
emp_pay = Convert.ToString(reader["emp_pay"].ToString()),
emp_cell = Convert.ToString(reader["emp_cell"].ToString()),
emp_phone = Convert.ToString(reader["emp_phone"].ToString()),
emp_type_id = Convert.ToString(reader["emp_type_id"].ToString()),
emp_type = Convert.ToString(reader["emp_type"].ToString()),
title_id = Convert.ToInt32(reader["emp_title_id"].ToString()),
title = Convert.ToString(reader["title"].ToString()),
designation_id = Convert.ToInt32(reader["emp_designation_id"]),
designation = Convert.ToString(reader["designation"]),
image = (byte[])reader["image"],
date_time = Convert.ToDateTime(reader["date_time"]),
created_by = Convert.ToString(reader["created_by"].ToString()),
is_active = Convert.ToString(reader["is_active"].ToString()),
};
emp_list.Add(emp);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
return(emp_list);
}
