private void btnClosePanelAddMP3Files_Click(object sender, EventArgs e) { BCHWinFormUtilities.ListBoxToListBox(ucDirFileSearch1.FileListBox, lbMP3Files, true); tbMP3Count.Text = lbMP3Files.Items.Count.ToString(); pnlBatchMp3TagEdit.Visible = true; pnlDirFileSearch.Visible = false; }
private void LoadDbTableListBox(ref OperationResult op) { try { lbTables.Items.Clear(); DataTable dt = _mp3Repository.GetAllTables(ref op); if (!op.Success) { rtbMessages.Text = op.GetAllErrorsAndExceptions("\n"); return; } BCHWinFormUtilities.DataTableToListBox(dt, lbTables, "name"); lbTables.SelectedIndex = 0; LoadDbColumnListBox(lbTables.SelectedItem.ToString(), ref op); if (!op.Success) { return; } } catch (Exception ex) { op.AddException(ex); return; } }
private void btnClosePanelAddMP3Files_Click(object sender, EventArgs e) { BCHWinFormUtilities.ListBoxToListBox(ucDirFileSearch1.FileListBox, lbFiles, true); lblFileCount.Text = "Count: " + lbFiles.Items.Count.ToString(); pnlMain.Visible = true; pnlDirFileSearch.Visible = false; }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { OperationResult _op = new OperationResult(); List <string> mp3List = BCHWinFormUtilities.ListBoxToList(lbMP3Files); int mp3Cnt = mp3List.Count; BadFiles = EditMP3Tags(mp3List, dddtbMp3RootDir.ItemText, ckbUseFolderInfo.Checked, ref _op); this.Op.AddOperationResult(ref _op); }
private void LoadDB(ref OperationResult op) { try { MP3DBManager mdbmgr = new MP3DBManager(); mdbmgr.SetDataStore(ddtbMp3DbFile.ItemText, ref op); mdbmgr.onCountChange += SetCount; List <string> mp3List = BCHWinFormUtilities.ListBoxToList(lbMP3s); string mp3RtDir = dddtbGetMp3RootDir.ItemText; mdbmgr.InsertMP3s(mp3List, mp3RtDir, ckbUseFolderInfo.Checked, ref op); } catch (Exception ex) { op.AddException(ex); } }
private void addMP3FilesMenuItem_Click(object sender, EventArgs e) { ucDirFileSearch1.FileTypeEnabled = false; List <string> ftList = ucDirFileSearch1.FileTypeList; if (ftList.Count < 1 || ftList.Count > 1 || !ftList.Contains("mp3", StringComparer.CurrentCultureIgnoreCase)) { ftList.Clear(); ftList.Add("mp3"); ucDirFileSearch1.FileTypeList = ftList; } BCHWinFormUtilities.ListBoxToListBox(lbMP3Files, ucDirFileSearch1.FileListBox, true); pnlBatchMp3TagEdit.Visible = false; pnlDirFileSearch.Visible = true; }
private void btnGetFiles_Click(object sender, EventArgs e) { ucDirFileSearch1.FileTypeEnabled = true; List <string> ftList = ucDirFileSearch1.FileTypeList; //if (ftList.Count < 1 || ftList.Count > 1 || // !ftList.Contains("mp3", StringComparer.CurrentCultureIgnoreCase)) //{ // ftList.Clear(); // ftList.Add("mp3"); // ucDirFileSearch1.FileTypeList = ftList; //} BCHWinFormUtilities.ListBoxToListBox(lbFiles, ucDirFileSearch1.FileListBox, true); pnlMain.Visible = false; pnlDirFileSearch.Visible = true; }
private void LoadDbColumnListBox(string tableName, ref OperationResult op) { try { lbColumns.Items.Clear(); DataTable dt = _mp3Repository.GetTableColumns(tableName, ref op); if (!op.Success) { return; } BCHWinFormUtilities.DataTableToListBox(dt, lbColumns, "name"); } catch (Exception ex) { op.AddException(ex); } }
private void LoadDbColumnListBox(string tableName, ref OperationResult op) { try { MP3DBManager mdbmgr = new MP3DBManager(); mdbmgr.SetDataStore(ddtbMp3DbFile.ItemText, ref op); lbColumns.Items.Clear(); DataTable dt = mdbmgr.GetDbTableColumns(tableName, ref op); BCHWinFormUtilities.DataTableToListBox(dt, lbColumns, "ColumnName"); } catch (Exception ex) { op.AddException(ex); rtbMessages.Text = op.GetAllErrorsAndExceptions("\n"); return; } }
private void LoadDbTableListBox(ref OperationResult op) { try { MP3DBManager mdbmgr = new MP3DBManager(); mdbmgr.SetDataStore(ddtbMp3DbFile.ItemText, ref op); //string sql = // "SELECT MSysObjects.Name AS TableName " + // "FROM MSysObjects " + // "WHERE (((Left([Name],1))<>\"~\") " + // "AND ((Left([Name],4))<>\"MSys\") " + // "AND ((MSysObjects.Type) In (1,4,6))) " + // "order by MSysObjects.Name " + // ""; lbTables.Items.Clear(); DataTable dt = mdbmgr.GetDbTables(ref op); BCHWinFormUtilities.DataTableToListBox(dt, lbTables, "TABLE_NAME"); lbTables.SelectedIndex = 0; LoadDbColumnListBox(lbTables.SelectedItem.ToString(), ref op); if (!op.Success) { rtbMessages.Text = op.GetAllErrorsAndExceptions("\n"); return; } } catch (Exception ex) { op.AddException(ex); rtbMessages.Text = op.GetAllErrorsAndExceptions("\n"); return; } }