public void Image(string employeeId, PictureBox employeeImage, Label fileExtension) //Display user image
{
Color _themeColor = Color.FromArgb(172, 188, 212);
string sqlQuery = "SELECT user_image, file_extension FROM dbo.Employee_Image WHERE employee_id=@employee_id";
using (SqlConnection con = new SqlConnection(_connectionString))
using (SqlCommand sqlCmd = new SqlCommand(sqlQuery, con))
{
con.Open();
sqlCmd.Parameters.Add("@employee_id", SqlDbType.NVarChar).Value = employeeId;
using (SqlDataReader reader = sqlCmd.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
if (reader.GetValue(0) == null && reader.GetValue(0) == null) //if image is null add border color to tag
{
employeeImage.Tag = _themeColor;
}
else
{
employeeImage.Tag = null;
fileExtension.Text = reader.GetValue(1).ToString();
employeeImage.Image = ImageOperations.BytesToImage((byte[])(reader.GetValue(0)));
}
return;
}
employeeImage.Image = null; //if (!reader.HasRows)
}
}
}