/* * Adds a media to the database */ private void AddMediaButton_Click(object sender, RoutedEventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = fileTypeFilter; if (openFileDialog.ShowDialog() == true) { try { FileStream file = File.Open(openFileDialog.FileName, FileMode.Open); using (var db = new mainEntities()) { string fileExt = Path.GetExtension(file.Name).Remove(0, 1); string fileType = extensions[fileExt]; Medias newMedia = new Medias { Name = Path.GetFileNameWithoutExtension(file.Name), Ext = fileExt, ExtID = (from ext in db.MediaExtensions where ext.Extension == fileExt select ext).Single <MediaExtensions>().Id, Path = file.Name, Type = fileType, TypeID = (from type in db.MediaTypes where type.Name == fileType select type).Single <MediaTypes>().Id }; db.Medias.Add(newMedia); db.SaveChanges(); Populate(); file.Close(); db.Dispose(); } } catch (IOException) { } } }
/* * Removes every medias from the database */ private void RemoveAllButton_Click(object sender, RoutedEventArgs e) { using (var db = new mainEntities()) { db.Medias.RemoveRange(from media in db.Medias select media); db.SaveChanges(); selectionList.Clear(); Populate(); db.Dispose(); } }
/* * Removes the selected medias from the database */ private void RemoveButton_Click(object sender, RoutedEventArgs e) { using (var db = new mainEntities()) { foreach (Medias m in selectionList) { db.Medias.RemoveRange(from media in db.Medias where media.Id == m.Id select media); } db.SaveChanges(); selectionList.Clear(); Populate(); db.Dispose(); } }