public List <sms_emp_attendance> get_all_attendance_by_date(DateTime dt) { List <sms_emp_attendance> att_list = new List <sms_emp_attendance>(); try { using (MySqlConnection con = new MySqlConnection(ConnectionString.con_string)) { using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "SELECT * FROM sms_emp_attendance as att inner join sms_emp as emp on att.emp_id=emp.id where Date(att.date_time)=@date order by att.date_time DESC"; cmd.Connection = con; cmd.Parameters.Add("@date", MySqlDbType.Date).Value = dt; //cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { sms_emp_attendance att = new sms_emp_attendance() { id = Convert.ToInt32(reader["id"]), emp_id = Convert.ToInt32(reader["emp_id"]), mode = reader["mode"].ToString(), date_time = Convert.ToDateTime(reader["date_time"]), emp_login_id = Convert.ToInt32(reader["emp_login_id"]), image = (byte[])reader["image"], emp_name = reader["emp_name"].ToString(), created_by = reader["created_by"].ToString(), }; att_list.Add(att); } } } } catch (Exception ex) { throw ex; } return(att_list); }
public int insert_thumb_attendance(sms_emp_attendance attendance) { int i = 0; try { using (MySqlConnection con = new MySqlConnection(ConnectionString.con_string)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand()) { cmd.CommandText = "INSERT INTO sms_emp_attendance(emp_id, mode,created_by, emp_login_id, date_time) Values(@emp_id, @mode,@created_by, @emp_login_id, @date_time)"; cmd.Connection = con; cmd.Parameters.Add("@emp_id", MySqlDbType.Int32).Value = attendance.emp_id; cmd.Parameters.Add("@mode", MySqlDbType.VarChar).Value = attendance.mode; cmd.Parameters.Add("@created_by", MySqlDbType.VarChar).Value = attendance.created_by; cmd.Parameters.Add("@emp_login_id", MySqlDbType.Int32).Value = attendance.emp_login_id; cmd.Parameters.Add("@date_time", MySqlDbType.DateTime).Value = attendance.date_time; i = Convert.ToInt32(cmd.ExecuteNonQuery()); con.Close(); } } } catch (Exception ex) { throw ex; } return(i); }
void fp_OnCapture(bool ActionResult, object ATemplate) { try { mode = ""; bool check = false; if (ActionResult) { aTemplate = new object(); aTemplate = ATemplate; aTemplateString = fp.GetTemplateAsString(); foreach (var item in thumb_enroll_list) { check = false; pTemplateString = Convert.ToBase64String(item.template); if (fp.VerFingerFromStr(pTemplateString, aTemplateString, true, true)) { employee_att_details_GBs.DataContext = null; //fill object attendance_obj = new sms_emp_attendance(); attendance_obj.emp_id = item.emp_id; if (empDAL.get_last_attendance_mode(item.emp_id) == "checkin") { mode = "checkout"; mode_text = "You Are Out"; } else { mode = "checkin"; mode_text = "You Are In"; } attendance_obj.mode = mode; attendance_obj.emp_login_id = 0; attendance_obj.date_time = DateTime.Now; attendance_obj.created_by = "Tahir"; if (empDAL.insert_thumb_attendance(attendance_obj) > 0) { employee_att_details_GBs.DataContext = emp_list.Where(x => x.id == item.emp_id.ToString()).First(); mode_text_TB.Text = mode_text; check = true; error_grid.Visibility = Visibility.Collapsed; load_emp_att_history(); break; } } } if (check == false) { employee_att_details_GBs.DataContext = null; error_grid.Visibility = Visibility.Visible; error_grid.DataContext = "Not Verified Please Try Again"; mode_text_TB.Text = ""; } } else { MessageBox.Show("Capture Failed"); } }catch (Exception ex) { MessageBox.Show(ex.Message); } }