private BlobsImage GetBlobsImage(MySqlCommand cmd)
{
BlobsImage returnValue = null;
Connection.Open();
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
returnValue = new BlobsImage((string)rdr[0], (byte[])rdr[1]);
break;
}
rdr.Close();
Connection.Close();
Console.WriteLine($@"Successfully fetched image: {returnValue?.Name}");
return(returnValue);
}
private void btnFetch_Click(object sender, EventArgs e)
{
string name = txtFetchName.Text.Trim();
if (string.IsNullOrEmpty(name))
{
MessageBox.Show(@"Oops... No image name was provided!");
return;
}
BlobsImage img = this._dh.GetSpecificBlobsImage(name);
if (img != null)
{
ptbImage.BackgroundImage = img.Img;
txtFetchName.Clear();
}
else
{
MessageBox.Show(@"No image found with that name!");
}
}
private void btnShowLast_Click(object sender, EventArgs e)
{
BlobsImage img = this._dh.GetLatestBlobsImage();
ptbImage.BackgroundImage = img.Img;
}
