protected void GET_OFFICER_HEADSHOT(string query, string record_guid)
{
DataTable dt = HeadShotEngine.SELECT_OFFICER_HEAD_SHOT(query, record_guid);
if (dt == null || dt.Rows.Count == 0)
{
this.picBoxImage.Image = null;
}
else
{
DataRow dtRow = dt.Rows[0];
if (dtRow["image_data"] != DBNull.Value)
{
MemoryStream stream = new MemoryStream((byte[])dtRow["image_data"]);
this.picBoxImage.Image = Image.FromStream(stream);
return;
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.picBoxImage.Image == null)
{
MessageBox.Show("No Image selected");
return;
}
try
{
Image img = this.picBoxImage.Image;
byte[] arr = (byte[])(new ImageConverter()).ConvertTo(img, typeof(byte[]));
HeadShotEngine.INSERT_OR_UPDATE_IMAGE("UPDATE_GUARD_IMAGE_LARGE", this.lbl_guid.Text, arr);
MessageBox.Show("Update Successfull");
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
}
}
protected void GET_OFFICER_HEADSHOT(string query, string record_guid)
{
DataTable dt = HeadShotEngine.SELECT_OFFICER_HEAD_SHOT(query, record_guid);
if (dt != null && dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
if (dtRow["image_data"] != DBNull.Value)
{
byte[] data = (Byte[])dtRow["image_data"];
MemoryStream stream = new MemoryStream(data);
picBoxImage.Image = Image.FromStream(stream);
}
}
else
{
picBoxImage.Image = null;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (picBoxImage.Image == null)
{
MessageBox.Show("No Image selected");
}
else
{
try
{
Image img = picBoxImage.Image;
byte[] arr;
ImageConverter converter = new ImageConverter();
arr = (byte[])converter.ConvertTo(img, typeof(byte[]));
HeadShotEngine.INSERT_OR_UPDATE_IMAGE("UPDATE_GUARD_HEAD_SHOT", lbl_guid.Text, arr);
MessageBox.Show("Update Successfull");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
