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);
}
