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 { } }