private void LoadCategories()
{
var categories = new List <ListViewItem>();
CategoryList.Items.Clear();
DBRequests.MakeRequest(DBRequests.LoadCategories(), (connection, sqlCommand) =>
{
using (var reader = sqlCommand.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
categories.Add(new ListViewItem(reader.GetString(0)));
}
}
CategoryList.Alignment = ListViewAlignment.Left;
CategoryList.Dock = DockStyle.Fill;
CategoryList.View = View.List;
// Initialize the tile size.
CategoryList.TileSize = new Size(100, 25);
CategoryList.Items.AddRange(categories.ToArray());
}
});
}
private void SelectCategoryBtn_Click(object sender, EventArgs e)
{
DBRequests.MakeRequest(DBRequests.ChangePhotoCategory(_activePhoto.ID, _categories[CategoryList.SelectedIndices[0]].ID), (connection, command) =>
{
using (var reader = command.ExecuteReader())
{
CategoryLabel.Text = _categories[CategoryList.SelectedIndices[0]].Name;
}
});
}
private void RemovePhotoBtn_Click(object sender, EventArgs e)
{
DBRequests.MakeRequest(DBRequests.DeletePhoto(_activePhoto.ID), (connection, sqlCommand) =>
{
sqlCommand.ExecuteNonQuery();
var view = new AlbumManager();
view.Show();
Hide();
});
}
private void ChangePhotoName_Click(object sender, EventArgs e)
{
DBRequests.MakeRequest(DBRequests.RenamePhoto(_activePhoto.ID, PhotoNameTextBox.Text), (connection, command) =>
{
using (var reader = command.ExecuteReader())
{
NameLabel.Text = PhotoNameTextBox.Text;
}
});
}
private void ChangePhotoDesc_Click(object sender, EventArgs e)
{
DBRequests.MakeRequest(DBRequests.ChangePhotoDescription(_activePhoto.ID, PhotoDescTextBox.Text), (connection, command) =>
{
using (var reader = command.ExecuteReader())
{
PhotoDescriptionLabel.Text = PhotoDescTextBox.Text;
}
}
);
}
private void ChangeCategoryNameBtn_Click(object sender, EventArgs e)
{
DBRequests.MakeRequest(DBRequests.RenameCategory(CategoryList.SelectedItems[0].Text, ChangeCategoryNameTextBox.Text), (connection, sqlCommand) =>
{
Console.WriteLine(connection);
Console.WriteLine(sqlCommand);
using (var reader = sqlCommand.ExecuteReader())
{
Console.WriteLine(reader);
LoadCategories();
}
});
}
private void AddCategoryBtn_Click(object sender, EventArgs e)
{
DBRequests.MakeRequest(DBRequests.CreateCategory(NewCategoryNameTextBox.Text), (connection, sqlCommand) =>
{
Console.WriteLine(connection);
Console.WriteLine(sqlCommand);
using (var reader = sqlCommand.ExecuteReader())
{
Console.WriteLine(reader);
LoadCategories();
}
});
}
private void RemoveAlbumBtn_Click(object sender, EventArgs e)
{
DBRequests.MakeRequest(DBRequests.DeleteAlbum(AlbumList.SelectedItems[0].ToString()), (connection, sqlCommand) =>
{
Console.WriteLine(connection);
Console.WriteLine(sqlCommand);
using (var reader = sqlCommand.ExecuteReader())
{
Console.WriteLine(reader);
LoadAlbums();
}
});
}
private void Login(object sender, EventArgs e)
{
DBRequests.MakeRequest(DBRequests.Login(LoginTextBox.Text, PassTextBox.Text), (sqlConnetion, sqlCommand) =>
{
using (var reader = sqlCommand.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
LoggedUser = (int)reader.GetValue(0);
IsAdmin = (int)reader.GetValue(1) == 1;
Console.WriteLine("Logged as User:" + LoggedUser);
var mainMenu = new MainMenu();
mainMenu.Show();
Hide();
}
}
});
}
private void LoadAlbums()
{
DBRequests.MakeRequest(DBRequests.LoadAlbums(), (connection, sqlCommand) =>
{
using (var reader = sqlCommand.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
_albums.Add(new TextInstance {
Name = reader.GetString(0)
});
}
}
AlbumList.Refresh();
}
});
}
public PhotoManager(Photo photo)
{
InitializeComponent();
_activePhoto = photo;
LoadCategories();
PhotoPreview.SizeMode = PictureBoxSizeMode.StretchImage;
PhotoPreview.Image = ImageFromByteArray(photo.PhotoData);
PhotoDescTextBox.Text = photo.Desc;
PhotoDescriptionLabel.Text = photo.Desc;
ResolutionLabel.Text += photo.Resolution;
DBRequests.MakeRequest(DBRequests.GetAlbumName(photo.Album), (connection, command) =>
{
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
AlbumLabel.Text += reader.GetString(0);
}
}
}
});
DBRequests.MakeRequest(DBRequests.GetCategoryName(photo.Category), (connection, command) =>
{
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
CategoryLabel.Text += reader.GetString(0);
}
}
}
});
FormatLabel.Text += photo.Format;
SizeLabel.Text += GetBytesReadable(photo.Size);
CreationDateLabel.Text += photo.CreationDate;
NameLabel.Text += photo.Name;
TagsLabel.Text = photo.Tags.Replace(",", ", ");
}
private void LoadCategories()
{
DBRequests.MakeRequest(DBRequests.LoadCategories(), (connection, sqlCommand) =>
{
using (var reader = sqlCommand.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
_categories.Add(new TextInstance {
Name = reader.GetString(0), ID = reader.GetInt32(1)
});
}
}
CategoryListBox.Refresh();
}
});
}
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();
}
}
}
private void LoadAlbums()
{
_albums.Clear();
AlbumCombo.Items.Clear();
DBRequests.MakeRequest(DBRequests.LoadAlbums(), (connection, sqlCommand) =>
{
using (var reader = sqlCommand.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var textInstance = new TextInstance {
ID = reader.GetInt32(1), Name = reader.GetString(0)
};
_albums.Add(textInstance);
}
}
AlbumCombo.Items.AddRange(_albums.ToArray());
}
});
}
public AlbumView(string album)
{
InitializeComponent();
// Initialize myListView.
PhotoList.Dock = DockStyle.Fill;
PhotoList.View = View.Tile;
// Initialize the tile size.
PhotoList.TileSize = new Size(200, 100);
// Initialize the item icons.
ImageList = new ImageList();
if (album == "PreImportedPhotos")
{
var root = Application.StartupPath;
var preImported = Path.Combine(root, "PreImportedPhotos");
var images = Directory.EnumerateFiles(preImported).ToList();
foreach (var image in images)
{
var renFace = Image.FromFile(image);
ImageList.Images.Add(renFace);
PhotoList.Items.Add(new ListViewItem(new[] { Path.GetFileName(image) }, PhotoList.Items.Count));
}
ImageList.ImageSize = new Size(100, 100);
PhotoList.LargeImageList = ImageList;
// Add column headers so the subitems will appear.
PhotoList.Columns.AddRange(new[]
{ new ColumnHeader() });
}
var albumID = -1;
DBRequests.MakeRequest(DBRequests.GetAlbumIndex(album), (connection, command) =>
{
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
albumID = reader.GetInt32(0);
}
}
}
});
DBRequests.MakeRequest(DBRequests.GetPhotos(albumID), (connection, command) =>
{
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
_photos.Add(new Photo
{
ID = reader.GetInt32(0),
Name = reader.GetString(1),
Owner = reader.GetInt32(2),
Desc = reader.GetString(3),
Tags = reader.GetString(4),
Category = reader.GetInt32(5),
Album = reader.GetInt32(6),
Format = reader.GetString(7),
Resolution = reader.GetString(8),
CreationDate = reader.GetDateTime(9).ToLongDateString(),
Size = reader.GetInt32(10),
PhotoData = reader.GetValue(11) as byte[]
});
}
}
}
});
foreach (var image in _photos)
{
var renFace = ImageFromByteArray(image.PhotoData);
ImageList.Images.Add(renFace);
PhotoList.Items.Add(new ListViewItem(new[] { image.Name }, PhotoList.Items.Count));
}
ImageList.ImageSize = new Size(100, 100);
PhotoList.LargeImageList = ImageList;
// Add column headers so the subitems will appear.
PhotoList.Columns.AddRange(new[]
{ new ColumnHeader() });
}
private void SearchBtn_Click(object sender, EventArgs e)
{
_photos.Clear();
var query = DBRequests.FindPhoto();
if (!string.IsNullOrWhiteSpace(NameTextBox.Text))
{
query = query.WithName(NameTextBox.Text);
}
if (!string.IsNullOrWhiteSpace(CategoryCombo.Text))
{
query = query.WithCategory(_categories[CategoryCombo.SelectedIndex].ID);
}
if (!string.IsNullOrWhiteSpace(AlbumCombo.Text))
{
query = query.WithAlbum(_albums[AlbumCombo.SelectedIndex].ID);
}
if (!string.IsNullOrWhiteSpace(TagTextBox.Text))
{
query = query.WithTag(TagTextBox.Text);
}
var queryString = query.ToString();
var wherePosition = queryString.IndexOf("WHERE", 0);
var firstPart = queryString.Substring(0, wherePosition + 5);
var secondPart = queryString.Substring(wherePosition + 5, queryString.Length - firstPart.Length);
secondPart = secondPart.Replace("WHERE", "OR");
var newQueryString = firstPart + secondPart;
DBRequests.MakeRequest(newQueryString, (connection, command) =>
{
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine();
_photos.Add(new Photo
{
ID = reader.GetInt32(0),
Name = reader.GetString(1),
Owner = reader.GetInt32(2),
Desc = reader.GetString(3),
Tags = reader.GetString(4),
Category = reader.GetInt32(5),
Album = reader.GetInt32(6),
Format = reader.GetString(7),
Resolution = reader.GetString(8),
CreationDate = reader.GetDateTime(9).ToLongDateString(),
Size = reader.GetInt32(10),
PhotoData = reader.GetValue(11) as byte[]
});
}
// Initialize myListView.
PhotoList.View = View.Tile;
// Initialize the tile size.
PhotoList.TileSize = new Size(200, 100);
// Initialize the item icons.
var ImageList = new ImageList();
foreach (var image in _photos)
{
var renFace = ImageFromByteArray(image.PhotoData);
ImageList.Images.Add(renFace);
PhotoList.Items.Add(new ListViewItem(new[] { image.Name }, PhotoList.Items.Count));
}
ImageList.ImageSize = new Size(100, 100);
PhotoList.LargeImageList = ImageList;
// Add column headers so the subitems will appear.
PhotoList.Columns.AddRange(new[]
{ new ColumnHeader() });
}
}
});
}
