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); }