protected override void OnDoWork(DoWorkEventArgs e) { ReportProgress(0, SortingState.Start); TableController tableController = new TableController(); AudioFileInfo audioFile = new AudioFileInfo(); tableController.InsertInitialize(); while (FileListEnumerator.MoveNext()) { if (CancellationPending) { e.Cancel = true; break; } FileInfo currentFile = new FileInfo(FileListEnumerator.Key.ToString()); audioFile.GetInfo(currentFile); tableController.Insert(currentFile, audioFile); } ReportProgress(100, "Done!"); e.Result = SortingState.Completed; }
private void FillDataGridViewWithFilter() { tableController = new TableController(); string album = string.Empty; string artist = string.Empty; string genre = string.Empty; string fileName = string.Empty; if (albumComboBox.SelectedItem != null) { album = Convert.ToString(this.albumComboBox.SelectedItem); artistComboBox.SelectedItem = null; genreComboBox.SelectedItem = null; fileNameComboBox.SelectedItem = null; } if (artistComboBox.SelectedItem != null) { artist = Convert.ToString(this.artistComboBox.SelectedItem); genreComboBox.SelectedItem = null; fileNameComboBox.SelectedItem = null; albumComboBox.SelectedItem = null; } if (genreComboBox.SelectedItem != null) { genre = Convert.ToString(this.genreComboBox.SelectedItem); artistComboBox.SelectedItem = null; fileNameComboBox.SelectedItem = null; albumComboBox.SelectedItem = null; } if (fileNameComboBox.SelectedItem != null) { fileName = Convert.ToString(this.fileNameComboBox.SelectedItem); artistComboBox.SelectedItem = null; albumComboBox.SelectedItem = null; genreComboBox.SelectedItem = null; } try { object datasource = (tableController.GetCustomizedViewByTableName( (int)pageSizeNumericUpDown.Value, currentPage, album, artist, genre, fileName)); if (datasource != null) { mainDataGridView.DataSource = datasource; } } catch (Exception exception) { } }
private void FillComboBoxWithData() { tableController = new TableController(); if (artistComboBox.Items.Count > 0) { artistComboBox.Items.Clear(); } artistComboBox.Items.AddRange( tableController.GetListByTableName(TableList.Artist).ToArray()); if (albumComboBox.Items.Count > 0) { albumComboBox.Items.Clear(); } albumComboBox.Items.AddRange( tableController.GetListByTableName(TableList.Album).ToArray()); if (genreComboBox.Items.Count > 0) { genreComboBox.Items.Clear(); } genreComboBox.Items.AddRange( tableController.GetListByTableName(TableList.Genre).ToArray()); if (fileNameComboBox.Items.Count > 0) { fileNameComboBox.Items.Clear(); } fileNameComboBox.Items.AddRange( tableController.GetListByTableName(TableList.FileName).ToArray()); }
private void FillComboBoxWithData() { tableController = new TableController(); if (artistComboBox.Items.Count > 0) { artistComboBox.Items.Clear(); } foreach (Model.SimpleTable value in tableController.GetListByTableName(TableList.Artist)) { artistComboBox.Items.Add(value.Name); } if (albumComboBox.Items.Count > 0) { albumComboBox.Items.Clear(); } foreach (Model.SimpleTable value in tableController.GetListByTableName(TableList.Album)) { albumComboBox.Items.Add(value.Name); } if (genreComboBox.Items.Count > 0) { genreComboBox.Items.Clear(); } foreach (Model.SimpleTable value in tableController.GetListByTableName(TableList.Genre)) { genreComboBox.Items.Add(value.Name); } if (fileNameComboBox.Items.Count > 0) { fileNameComboBox.Items.Clear(); } foreach (Model.SimpleTable value in tableController.GetListByTableName(TableList.FileName)) { fileNameComboBox.Items.Add(value.Name); } }
public mainForm() { InitializeComponent(); tableController = new TableController(); }