public List <Capture> GetPicturesFromDB() { try { _conn.Open(); if (_limit > 0) { _query = $"SELECT * FROM `Capture` WHERE ID != 1 LIMIT {_limit};"; } else { _query = $"SELECT * FROM `Capture` WHERE ID != 1;"; } _cmd = new MySqlCommand() { Connection = _conn, CommandText = _query }; _cmd.ExecuteNonQuery(); Capture capture; using (DbDataReader reader = _cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { capture = new Capture { CaptureImage = reader.GetString(reader.GetOrdinal("CaptureImage")), Result = reader.GetString(reader.GetOrdinal("Result")) }; _captures.Add(capture); } } } _conn.Close(); } catch (Exception ex) { Debug.WriteLine(ex.ToString()); } return(_captures); }
public Capture GetPictureForPredict() { try { _conn.Open(); _query = $"SELECT * FROM `Capture` WHERE ID == 1;"; _cmd = new MySqlCommand() { Connection = _conn, CommandText = _query }; _cmd.ExecuteNonQuery(); using (DbDataReader reader = _cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { _predictCapture = new Capture { CaptureImage = reader.GetString(reader.GetOrdinal("CaptureImage")), Result = reader.GetString(reader.GetOrdinal("Result")) }; } } } _conn.Close(); } catch (Exception ex) { Debug.WriteLine(ex.ToString()); } return(_predictCapture); }