public bool AnyMissngTables(ref OperationResult op)
{
if (!HastunesSongTable || !HasItunesPlaylistTable || !HasItunesPlaylistSongTable)
{
op.AddInformation("Missing Table)s:\n");
if (!HastunesSongTable)
{
op.AddInformation("Missing tbItunesSong table.\n");
}
if (!HasItunesPlaylistTable)
{
op.AddInformation("Missing tbMp3Info table.\n");
}
if (!HasItunesPlaylistSongTable)
{
op.AddInformation("Missing tbItunesPlaylistSong table.\n");
}
return(true);
}
return(false);
}
public bool AnyMissngTables(ref OperationResult op)
{
if (!HasFileInfoTable || !HasMp3InfoTable || !HasArtistTable)
{
op.AddInformation("Missing Table)s:\n");
if (!HasFileInfoTable)
{
op.AddInformation("Missing tbFileInfo table.\n");
}
if (!HasMp3InfoTable)
{
op.AddInformation("Missing tbMp3Info table.\n");
}
if (!HasArtistTable)
{
op.AddInformation("Missing tbArtist table.\n");
}
return(true);
}
return(false);
}
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
Op.AddInformation("Files copied successfully.");
//try
//{
// System.Diagnostics.Process.Start("explorer.exe", ucGetToPath.FileName);
//}
//catch (Exception ex)
//{
// Op.AddException(ex);
//}
ucResultDisplay1.DisplayText = Op.GetAllInfos("\n");
}
private void btnExecuteSql_Click(object sender, EventArgs e)
{
OperationResult op = new OperationResult();
lblResults.Text = "Results (0)";
rtbMessages.Text = "";
dgvSqlResults.DataSource = null;
try
{
MP3DBManager mdbmgr = new MP3DBManager();
mdbmgr.SetDataStore(ddtbMp3DbFile.ItemText, ref op);
Dictionary <string, string> parms = new Dictionary <string, string>();
string sql = rtbSql.Text;
parms.Add("Sql", sql);
DataTable dt = mdbmgr.RunSqlScript(ref parms, DAL.SqlScriptEnum.DynamicSQL, ref op);
int count = 0;
if (dt != null && dt.Rows.Count > 0)
{
count = dt.Rows.Count;
dgvSqlResults.DataSource = dt;
lblResults.Text = $"Results ({count})";
}
if (op.Success)
{
op.AddInformation("SQL Excution Successfull");
rtbMessages.Text = op.GetAllInfos("\n");
}
else
{
rtbMessages.Text = op.GetAllErrorsAndExceptions("\n");
}
}
catch (Exception ex)
{
op.AddException(ex);
rtbMessages.Text = op.GetAllErrorsAndExceptions("\n");
}
}
private void btnExecuteSql_Click(object sender, EventArgs e)
{
OperationResult op = new OperationResult();
lblResults.Text = "Results (0)";
rtbMessages.Text = "";
dgvSqlResults.DataSource = null;
try
{
string sql = rtbSql.Text;
DataTable dt = _mp3Repository.RunSql(sql, ref op);
if (!op.Success)
{
rtbMessages.Text = op.GetAllErrorsAndExceptions("\n");
return;
}
int count = 0;
if (dt != null && dt.Rows.Count > 0)
{
count = dt.Rows.Count;
dgvSqlResults.DataSource = dt;
lblResults.Text = $"Results ({count})";
}
if (op.Success)
{
op.AddInformation("SQL Excution Successfull");
rtbMessages.Text = op.GetAllInfos("\n");
}
else
{
rtbMessages.Text = op.GetAllErrorsAndExceptions("\n");
}
}
catch (Exception ex)
{
op.AddException(ex);
rtbMessages.Text = op.GetAllErrorsAndExceptions("\n");
}
}
public void CreateM3U(ref OperationResult op)
{
if (!IsSet)
{
op.AddError("M3U object not set. You must call the \"SetM3U(string fileNameAndPath, " +
"ref OperationResult op)\" successfully before you can create an M3U file");
return;
}
if (this.M3USongList.Count < 1)
{
op.AddError("There are no songs in the M3U list. You must call the \"SetM3USongs(List<string> list, bool" +
"addOrReplace, ref OperationResult op)\" successfully before you can create an M3U file");
return;
}
List <string> mList = new List <string>();
//mList.Add("#EXTM3U - Created by Barry Hill's M3U Editor");
//mList.Add("#EXTINF - ");
mList.AddRange(this.M3USongList);
string fname = this.M3UFileNameAndPath;
if (!fname.EndsWith(".m3u", StringComparison.CurrentCultureIgnoreCase))
{
fname = fname + ".m3u";
}
BCHFileIO.WriteFullFile(fname, mList, ref op);
if (!op.Success)
{
return;
}
op.AddInformation("M3U file created successfully.");
}
private List <string> GetTableData(string sql, string tableName, string delimiter, ref OperationResult op)
{
List <string> data = new List <string>();
try
{
MP3DBManager mdbmgr = new MP3DBManager();
mdbmgr.SetDataStore(ddtbMp3DbFile.ItemText, ref op);
Dictionary <string, string> parms = new Dictionary <string, string>();
parms.Add("Sql", sql);
DataTable dt = mdbmgr.RunSqlScript(ref parms, DAL.SqlScriptEnum.DynamicSQL, ref op);
string colVal = "";
if (dt != null && dt.Rows.Count > 0)
{
DataTable dtn = mdbmgr.GetDbTables(ref op);
DataTable dtColomns = mdbmgr.GetDbTableColumns(tableName, ref op);
StringBuilder rowData = new StringBuilder();
string rowString = "";
int colCount = dt.Columns.Count;
string val;
string cols = "";
int c = 0;
foreach (DataRow row in dtColomns.Rows)
{
val = row["ColumnName"] != null && row["ColumnName"].ToString().Trim().Length > 0 ? row["ColumnName"].ToString().Trim() : string.Empty;
cols += val + (c < colCount - 1 ? delimiter : "");
c++;
}
data.Add(cols);
foreach (DataRow row in dt.Rows)
{
rowData = new StringBuilder();
for (int i = 0; i < colCount; i++)
{
//if(tableName == )
colVal = row[i].ToString();
colVal = string.IsNullOrWhiteSpace(colVal) ? "<null>>" : colVal;
rowData.Append(colVal + (i < colCount - 1 ? delimiter: ""));
}
rowString = rowData.ToString();
data.Add(rowString);
}
}
if (op.Success)
{
op.AddInformation("SQL Excution Successfull");
}
}
catch (Exception ex)
{
op.AddException(ex);
}
return(data);
}
