private void AddPhotoClicked(object sender, EventArgs e)
{
if (_loadedImage == null)
{
return;
}
var imageData = ImageToByteArray(_loadedImage);
var constring = DBRequests.AddPhoto(PhotoNameTextBox.Text, imageData, (AlbumListBox.SelectedItems[0] as TextInstance).ID, (CategoryListBox.SelectedItems[0] as TextInstance).ID, LoginPage.LoggedUser, PhotoDescTextBox.Text,
_tags.Select((instance, i) => instance.Name).ToArray(), _loadedImageExtension, _loadedImage.Size, imageData.Length);
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HMatuszewski.PhotoAlbum.Properties.Settings.BDFotoConnectionString"].ConnectionString))
{
using (var command = new SqlCommand(constring, connection))
{
command.Parameters.Add("@image", SqlDbType.Binary).Value = imageData;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
}
}
