private void scan_FormClosedOut(object sender, FormClosedEventArgs e) { String employeeID = employeeId; String EmployeeName = null; { DBConnect d = new DBConnect(); String query = "Select name from employee where employeeNo = '" + employeeID + "'"; MySqlCommand c = new MySqlCommand(query, d.con); MySqlDataReader r = c.ExecuteReader(); while (r.Read()) { EmployeeName = r[0].ToString(); } } DBConnect db = new DBConnect(); String date = DateTime.Now.ToString("yyyy-MM-dd"); String time = DateTime.Now.ToString("HH:mm"); String q = "update employee_attendance SET outTime = '" + time + "' where employeeNo = '" + employeeID + "' and date = '" + date + "'"; MySqlCommand cmd = new MySqlCommand(q, db.con); cmd.ExecuteNonQuery(); AutoClosingMessageBoxes.Show(EmployeeName + " OUT " + date + " " + time, "Done", 2000); }
private void AttendanceScanBarcodeClosedIN(object sender, FormClosedEventArgs e) { try { String q = "SELECT name FROM employee WHERE employeeNo='" + employeeID + "'"; MySqlCommand cmd = new MySqlCommand(q, db.con); MySqlDataReader r = cmd.ExecuteReader(); while (r.Read()) { employeeName = r["name"].ToString(); } this.date = DateTime.Now.ToString("yyyy-MM-dd"); this.time = DateTime.Now.ToString("HH:MM:ss"); //MessageBox.Show(time); AutoClosingMessageBoxes.Show("User : "******"-IN- On " + date + " At " + time, scanType, 5000); String qu = "INSERT INTO employee_attendance(employeeNo,name,date,inTime) VALUES('" + employeeID + "','" + employeeName + "','" + date + "','" + time + "')"; //String qu = "INSERT INTO `employee_attendance`( `employeeNo`, `name`, `date`, `inTime`, `outTime`, `timeWorked`)VALUES('x','xx','xxx','xxxx','xxxxx','xxxxxx')"; //MessageBox.Show(qu); MySqlCommand cmd1 = new MySqlCommand(qu, db.con); cmd1.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } }