private void loadUserData()
{
UserModel user = oracleSQLConnector.loadUserFromDataBase();
userNameTextBlock.Text = user.getFullName();
userEmailTextBlock.Text = user.getEmailAddress();
userPhoneNumberTextBlock.Text = user.getPhoneNumberStr();
OracleSQLConnectorImages connector = new OracleSQLConnectorImages();
byte[] blob = user.getImageBlob();//connector.getImageBytes(GlobalClass.getUserID());
if (blob != null)
{
BitmapImage newImg = ToImage(blob);
userImage.Source = newImg;
}
}
private void userImage_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
try
{
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.DefaultExt = ".jpg";
dlg.Filter = "Image File (.jpg; .png)|*.jpg; *.png";
Nullable <bool> result = dlg.ShowDialog();
if (result == true)
{
string filename = dlg.FileName;
BitmapImage newImg = new BitmapImage(new Uri(filename));
var newImgSize = new System.IO.FileInfo(filename).Length;
if (newImgSize > 204800 || newImg.PixelWidth > 256 || newImg.PixelHeight > 256)
{
MessageBox.Show("Selected image is too large. (Max 200kB | 256x256px)");
}
else
{
OracleSQLConnectorImages connector = new OracleSQLConnectorImages();
if (connector.sendImageToDB("trainer_table", GlobalClass.getTrainerID(), filename))
{
userImage.Source = newImg;
}
else
{
MessageBox.Show("Error, while sending image to DataBase.");
}
}
}
}
catch
{
}
}
