Guest User

Untitled

a guest
Feb 16th, 2019
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.46 KB | None | 0 0
  1. public void OnComplete(object Capture, string ReaderSerialNumber, DPFP.Sample Sample)
  2. {
  3.  
  4. Bitmap bitmap;
  5. bitmap = ConvertSampleToBitmap(Sample);
  6. Bitmap img = new Bitmap(bitmap, Picture.Size);
  7. this.Invoke(new Function(delegate ()
  8. {
  9. Picture.Image = img; // fit the image into the picture box
  10. //string ping;
  11. using (MemoryStream m = new MemoryStream())
  12. {
  13. img.Save(m, ImageFormat.Bmp);
  14. m.Position = 0;
  15. DPFP.Template Template = new DPFP.Template(m);
  16. MemoryStream fingerprintData = new MemoryStream();
  17. Template.Serialize(fingerprintData);
  18. fingerprintData.Position = 0;
  19. BinaryReader br = new BinaryReader(fingerprintData);
  20. Byte[] bytes = br.ReadBytes((Int32)fingerprintData.Length);
  21. string ping = BitConverter.ToString(bytes);
  22.  
  23. MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
  24.  
  25. connBuilder.Add("Server", "localhost");
  26. connBuilder.Add("Port", "3306");
  27. connBuilder.Add("Database", "db_fingerprint");
  28. connBuilder.Add("Username", "root");
  29. connBuilder.Add("Password", "");
  30.  
  31. MySqlConnection conn = new MySqlConnection(connBuilder.ConnectionString);
  32.  
  33. MySqlCommand cmd = conn.CreateCommand();
  34.  
  35. cmd.CommandText = "INSERT INTO tbl_finger VALUES(@finger_id, @finger_tag, @stud_id)";
  36. cmd.Parameters.AddWithValue("finger_id", "");
  37. cmd.Parameters.AddWithValue("stud_id", txtstud_num.Text);
  38. cmd.Parameters.AddWithValue("finger_tag", ping);
  39.  
  40. conn.Open();
  41. int a = cmd.ExecuteNonQuery();
  42. if (a > 0)
  43. {
  44. MessageBox.Show("Fingerprint Registered.");
  45. cmd.CommandText = "UPDATE tbl_students SET is_registered = 1 WHERE stud_id = '" + txtstud_num.Text + "';";
  46. cmd.ExecuteNonQuery();
  47. }
  48. else
  49. {
  50. MessageBox.Show("No Fingerprint Registered.");
  51. }
  52. conn.Close();
  53. }
  54. }));
  55. }
Add Comment
Please, Sign In to add comment