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;
}
}
