// didnt update the email creator field - a field that can not be changed
public bool Insert(dataBoard board) // insert new board to database according to the dataBoard fields
{
using (var connection = new SQLiteConnection(_connectionString))
{
int res = -1;
SQLiteCommand command = new SQLiteCommand(null, connection);
try
{
connection.Open();
command.CommandText = $"INSERT INTO {tableName} ({dataBoard.boardEmailCreator},{dataBoard.boardTaskCounterKey},{dataBoard.boardColumnCounterKey},{dataBoard.boardBoardId}) " +
$"VALUES (@emailCreator,@taskCounterKey,@columnCounterKey,@boardId);";
SQLiteParameter emailParam = new SQLiteParameter(@"emailCreator", board.emailCreator);
SQLiteParameter taskCounterKeyParam = new SQLiteParameter(@"taskCounterKey", board.taskCounterKey);
SQLiteParameter columnCounterKeyParam = new SQLiteParameter(@"columnCounterKey", board.columnCounterKey);
SQLiteParameter boardIdParam = new SQLiteParameter(@"boardId", board.boardId);
command.Parameters.Add(emailParam);
command.Parameters.Add(taskCounterKeyParam);
command.Parameters.Add(columnCounterKeyParam);
command.Parameters.Add(boardIdParam);
command.Prepare();
res = command.ExecuteNonQuery();
}
catch
{
log.Warn("Insert failed");
}
finally
{
command.Dispose();
connection.Close();
}
return(res > 0);
}
}
protected override dal ConvertReaderToObject(SQLiteDataReader reader) // reading from DB and create dataBoard Object
{
dataBoard result = new dataBoard(reader.GetString(0), Convert.ToInt32(reader.GetValue(1)), Convert.ToInt32(reader.GetValue(2)), Convert.ToInt32(reader.GetValue(3)));
return(result);
}