private void InsertAuthorToDb(string author)
{
//MessageBox.Show("Need to add " + author);
using (ODBCClass o = new ODBCClass(DSN))
{
OdbcCommand oCommand = o.GetCommand("INSERT INTO authors(author) VALUES('" + author + "')");
oCommand.ExecuteNonQuery();
}
Log(author);
}
private void InsertTitleToDb(string title, int authorID)
{
//MessageBox.Show("Need to add " + author);
string sSQL = "INSERT INTO storytapes(authorid,title,addeddt,seriesorder,filepath,id3tags) VALUES("
+ authorID.ToString() + ",'" + title + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
+ "',0,'" + title.Replace(" ", "_").ToLower() + "','N')";
using (ODBCClass o = new ODBCClass(DSN))
{
OdbcCommand oCommand = o.GetCommand(sSQL);
oCommand.ExecuteNonQuery();
}
//Log(sSQL);
}
private void SetTagsUpdated(string author, string album)
{
if (!firstRun)
{
album = album.Replace("'", "");
using (ODBCClass o = new ODBCClass(DSN))
{
OdbcCommand oCommand = o.GetCommand("UPDATE storytapes SET"
+ " id3tags='Y'"
+ " WHERE title = '" + album + "'"
+ " AND authorid=(SELECT id FROM `authors` WHERE author='" + author + "')");
oCommand.ExecuteNonQuery();
}
}
}
private DataTable GetDBAuthors()
{
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
using (ODBCClass o = new ODBCClass(DSN))
{
OdbcCommand oCommand = o.GetCommand("SELECT * FROM authors");
OdbcDataReader oReader = oCommand.ExecuteReader();
dt.Load(oReader);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
sb.AppendLine(row["author"].ToString());
}
}
//tb.Text = sb.ToString();
return(dt);
}
}
public List <string> GetTitlesForAuthor(int authorID)
{
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
List <string> titles = new List <string>();
using (ODBCClass o = new ODBCClass(DSN))
{
OdbcCommand oCommand = o.GetCommand("SELECT title FROM storytapes"
+ " WHERE authorid=" + authorID.ToString());
OdbcDataReader oReader = oCommand.ExecuteReader();
dt.Load(oReader);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
titles.Add(row["title"].ToString());
}
}
return(titles);
}
}