private void loadAbums() { ApplicationDBEntities1 db = new ApplicationDBEntities1(); var selectedItem = from el in db.ImagesInAlbums join b in db.Albums on el.albumID equals b.id where el.fileID == this.imgID select b; this.album_list.ItemsSource = selectedItem.ToList(); }
private void addTag_Click(object sender, RoutedEventArgs e) { ApplicationDBEntities1 db = new ApplicationDBEntities1(); Tag tagObject = new Tag() { tagName = tag_name.Text, }; db.Tags.Add(tagObject); db.SaveChanges(); this.loadTags(); }
private void addAalbum_Click(object sender, RoutedEventArgs e) { ApplicationDBEntities1 db = new ApplicationDBEntities1(); Album albumObject = new Album() { albumName = album_name.Text, }; db.Albums.Add(albumObject); db.SaveChanges(); this.loadAbums(); }
public Details(int imageID) { InitializeComponent(); //Initial setting for the Combobox (Dropdown) with the albums (NO NEED TO CHANGE) DataContext = this; cbItems = new ObservableCollection <ComboBoxItem>(); var cbItem = new ComboBoxItem { Content = "<--Select-->" }; SelectedcbItem = cbItem; cbItems.Add(cbItem); //Store the IF of the image this.imgID = imageID; this.loadAbums(); //Query the DB based on the ID received ApplicationDBEntities1 db = new ApplicationDBEntities1(); var images = from d in db.Files where d.id.Equals(imgID) select d; foreach (var el in images) { //Name of the file FileName.Text = $"{el.fileName}"; // Size in KB FileSize.Text = $"{el.fileSize} KB"; //Display the image on the screen imagePathToDisplay = el.filePath; var uriSource = new Uri(el.filePath, UriKind.RelativeOrAbsolute); singleImage.Source = new BitmapImage(uriSource); //Query the Albums table to get a list of albuns availables var albums = from d in db.Albums select d; foreach (var alb in albums) { //For every "album", display on our combobox cbItems.Add(new ComboBoxItem { Content = alb.albumName, Tag = alb.id }); } } }
private void deleteAlbum_Click(object sender, RoutedEventArgs e) { ApplicationDBEntities1 db = new ApplicationDBEntities1(); var selectedItem = from el in db.Albums where el.id == this.albumSelected select el; Album albumToDelete = selectedItem.SingleOrDefault(); if (albumToDelete != null) { db.Albums.Remove(albumToDelete); db.SaveChanges(); } this.loadAbums(); }
private void deleteTag_Click(object sender, RoutedEventArgs e) { ApplicationDBEntities1 db = new ApplicationDBEntities1(); var selectedItem = from el in db.Tags where el.id == this.tagSelected select el; Tag tagToDelete = selectedItem.SingleOrDefault(); if (tagToDelete != null) { db.Tags.Remove(tagToDelete); db.SaveChanges(); } this.loadTags(); }
private void album_list_Main_SelectionChanged(object sender, SelectionChangedEventArgs e) { ComboBoxItem typeItem = (ComboBoxItem)listAlbums.SelectedItem; string contentName = typeItem.Content.ToString(); Console.WriteLine("album name: " + contentName); ApplicationDBEntities1 db = new ApplicationDBEntities1(); var selectedItem = from el in db.Albums where el.albumName == contentName select el; if (selectedItem.FirstOrDefault <Album>() != null) { albumSelectedToAddRemove = selectedItem.FirstOrDefault <Album>().id; } }
private void addAlbum_Click(object sender, RoutedEventArgs e) { //TO DO: Grab selected album and add image to DB ImagesAlbums // Re-load the list ApplicationDBEntities1 db = new ApplicationDBEntities1(); ImagesInAlbum albumObject = new ImagesInAlbum() { fileID = this.imgID, albumID = albumSelectedToAddRemove }; db.ImagesInAlbums.Add(albumObject); db.SaveChanges(); this.loadAbums(); }
private void loadTags() { ApplicationDBEntities1 db = new ApplicationDBEntities1(); this.tag_list.ItemsSource = db.Tags.ToList(); }
private void loadAbums() { ApplicationDBEntities1 db = new ApplicationDBEntities1(); this.album_list.ItemsSource = db.Albums.ToList(); }