public void DeleteRow(JobPortal portal, int id)
{
string tableName = portal.ToString();
string sql = string.Format("DELETE FROM {0} WHERE id={1}", tableName, id);
_dbConnection.Open();
SQLiteCommand command = new SQLiteCommand(sql, _dbConnection);
command.ExecuteNonQuery();
_dbConnection.Close();
}
// TODO: try catch
private bool TableExists(JobPortal table)
{
string tableName = table.ToString();
string sql = string.Format(
"SELECT count(*) AS count FROM sqlite_master WHERE type='table' AND name='{0}'", tableName);
_dbConnection.Open();
SQLiteCommand command = new SQLiteCommand(sql, _dbConnection);
SQLiteDataReader reader = command.ExecuteReader();
long count = 0;
while (reader.Read())
{
count = (long)reader["count"];
}
_dbConnection.Close();
return count == 1;
}
// TODO: try catch
private void CreateTable(JobPortal table)
{
Logger.LogStart(Logger.MethodName);
string tableName = table.ToString();
string columnsDefinition = CreateColumnsDefinition();
string sql = string.Format(
"CREATE TABLE {0} (" +
"Id INTEGER PRIMARY KEY NOT NULL, " +
"DateTime TEXT NOT NULL, " +
"{1})", tableName, columnsDefinition);
_dbConnection.Open();
SQLiteCommand command = new SQLiteCommand(sql, _dbConnection);
command.ExecuteNonQuery();
Logger.LogInfo(string.Format("Tabel '{0}' created.", table));
_dbConnection.Close();
Logger.LogStop(Logger.MethodName);
}