public bool Insert(DTOs.BoardDTO Board) //creates a new board in the database.
{
using (var connection = new SQLiteConnection(_connectionString))
{
var command = new SQLiteCommand(connection);
int res = -1;
try
{
connection.Open();
command.CommandText = $"INSERT INTO {_tableName} ({DTOs.BoardDTO.BoardEmailColumnEmail},{DTOs.BoardDTO.BoardDeletedTaskColumn}) " +
$"VALUES (@EmailVal,@DeletedTaskVal);";
var emailParam = new SQLiteParameter(@"EmailVal", Board.Email);
var deletedTasksParam = new SQLiteParameter(@"DeletedTaskVal", Board.DeletedTasks);
command.Parameters.Add(emailParam);
command.Parameters.Add(deletedTasksParam);
command.Prepare();
res = command.ExecuteNonQuery();
}
catch (Exception)
{
log.Debug("an error occured while inserting a new board");
}
finally
{
command.Dispose();
connection.Close();
}
return(res > 0);
}
}
public bool Delete(DTOs.BoardDTO DTOObj) //Deletes a specific board.
{
int res = -1;
using (var connection = new SQLiteConnection(_connectionString))
{
var command = new SQLiteCommand
{
Connection = connection,
CommandText = $"DELETE FROM {_tableName} WHERE [{DTOs.BoardDTO.BoardEmailColumnEmail}]=@Email"
};
var emailParam = new SQLiteParameter(@"Email", DTOObj.Email);
command.Parameters.Add(emailParam);
try
{
connection.Open();
res = command.ExecuteNonQuery();
}
catch (Exception)
{
log.Debug("an error occured while deleting this board");
}
finally
{
command.Dispose();
connection.Close();
}
}
return(res > 0);
}
