private void LoadData(string filter) { using (PsiPlayerDbContext context = new PsiPlayerDbContext()) { if (filter == string.Empty) { dataGridView1.DataSource = context.Songs.ToList(); } else { dataGridView1.DataSource = context.Songs.Where(x => x.Title.Contains(filter)).ToList(); } } }
private void AddFiles_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "mp3 Files (*mp3), AVI Files (*avi)|*.mp3; *.wmv"; openFileDialog.Multiselect = true; if (openFileDialog.ShowDialog() == DialogResult.OK) { foreach (var item in openFileDialog.FileNames) { if (item.Contains(".wmv")) { VideoPlayerForm form = new VideoPlayerForm(item); form.ShowDialog(); return; } } using (PsiPlayerDbContext context = new PsiPlayerDbContext()) { foreach (string path in openFileDialog.FileNames) { AudioFile song = new AudioFile(path); activePL.Songs.Add(song); context.Songs.Add(song); if (song.Length.Seconds < 10) { listBox1.Items.Add(String.Format("{0}:0{1} --- {2} - {3}", song.Length.Minutes, song.Length.Seconds, song.Artist, song.Title)); } else { listBox1.Items.Add(String.Format("{0}:{1} --- {2} - {3}", song.Length.Minutes, song.Length.Seconds, song.Artist, song.Title)); } } context.SaveChanges(); } } }