01.void TimeCheckIn()
02. {
03. if (cbbActivity.Text == "")
04. {
05. MessageBox.Show("กรุณาใสชื่อกิจกรรมก่อน", "ข้อความระบบ");
06. }
07. else
08. {
09.
10. conn.Open();
11. SqlCommand cmd = new SqlCommand("SELECT * FROM Student WHERE StudentBarcodeID = '" + txtBarcodeID.Text + "'", conn);
12. SqlDataReader dr;
13. dr = cmd.ExecuteReader();
14. while (dr.Read())
15. {
16. if (dr["StudentBarcodeID"].ToString() == txtBarcodeID.Text)
17. {
18. string a1 = dr["StudentID"].ToString();
19. string a2 = dr["StudentName"].ToString();
20. string a3 = DateTime.Now.ToLongTimeString();
21. string a4 = DateTime.Now.ToLongDateString();
22. conn.Close();
23. SqlCommand aa = new SqlCommand("SELECT * FROM Activity", conn);
24. conn.Open();
25. SqlDataReader bb;
26. bb = aa.ExecuteReader();
27. bb.Read();
28. string b2 = bb["DateSet"].ToString();
29. string b3 = bb["TimeInSet"].ToString();
30. string b4 = bb["TimeOutSet"].ToString();
31. conn.Close();
32.
33. SqlConnection conn2 = new SqlConnection("Data Source=PIMBONPC\\SA;Initial Catalog=ProjectBarcode;Integrated Security=True");
34. SqlDataAdapter da = new SqlDataAdapter();
35. da.InsertCommand = new SqlCommand("INSERT INTO Check VALUES (@StudentID, @StudentName, @ActivityName, @DateSet, @DateIn, @TimeInSet, @TimeIn, @DateOut, @TimeOutSet, @TimeOut)", conn2);
36. da.InsertCommand.Parameters.Add("@StudentID", SqlDbType.VarChar).Value = a1;
37. da.InsertCommand.Parameters.Add("@StudentName", SqlDbType.VarChar).Value = a2;
38. da.InsertCommand.Parameters.Add("@ActivityName", SqlDbType.VarChar).Value = cbbActivity.Text;
39. da.InsertCommand.Parameters.Add("@DateSet", SqlDbType.VarChar).Value = b2;
40. da.InsertCommand.Parameters.Add("@DateIn", SqlDbType.VarChar).Value = a4;
41. da.InsertCommand.Parameters.Add("@TimeInSet", SqlDbType.VarChar).Value = b3;
42. da.InsertCommand.Parameters.Add("@TimeIn", SqlDbType.VarChar).Value = a3;
43. da.InsertCommand.Parameters.Add("@DateOut", SqlDbType.VarChar).Value = "";
44. da.InsertCommand.Parameters.Add("@TimeOutSet", SqlDbType.VarChar).Value = b4;
45. da.InsertCommand.Parameters.Add("@TimeOut", SqlDbType.VarChar).Value = "";
46.
47. conn.Open();
48. da.InsertCommand.ExecuteNonQuery();
49. conn.Close();
50.
51. da.SelectCommand = new SqlCommand("SELECT * FROM Check", conn);
52. ds.Clear();
53. da.Fill(ds);
54. dg.DataSource = ds.Tables[0];
55.
56.
57.
58. }
59. else
60. {
61. MessageBox.Show("ไม่พบในฐานข้อมูล");
62. }
63. }
64. }
65. }
