public bool RemoveImageData(int learningDataId)
{
return(DataAccessHelper.ExecuteWithinConnection(
(connection) => connection.Execute($"DELETE FROM {TableName} WHERE {ColumnNames.ParentKey} = {learningDataId}"),
_configuration
) == 1);
}
public IEnumerable <int> GetAllIds(int?categoryId)
{
var idQuery = $@"SELECT {ColumnNames.PrimaryKey} FROM {TableName}";
if (categoryId.HasValue)
{
idQuery += $" WHERE {ColumnNames.CategoryId} = {categoryId.Value}";
}
return(DataAccessHelper.ExecuteWithinConnection((connection) => connection.Query <int>(idQuery).ToList(), _configuration));
}
public bool UpdateLearningData(LearningData learningData)
{
var updateQuery = $@"
UPDATE {TableName}
SET {ColumnNames.Name} = @Name,
{ColumnNames.Description} = @Description,
{ColumnNames.Number} = @Number,
{ColumnNames.CategoryId} = @CategoryId,
WHERE {ColumnNames.PrimaryKey} = @LearningDataId";
return(DataAccessHelper.ExecuteWithinConnection((connection) => connection.Execute(updateQuery), _configuration) == 1);
}
public int AddLearningData(LearningData learningData)
{
var insertAndSelectIdQuery = $@"
INSERT INTO {TableName} ({ColumnNames.Name}, {ColumnNames.Description}, {ColumnNames.Number}, {ColumnNames.CategoryId})
OUTPUT INSERTED.{ColumnNames.PrimaryKey}
VALUES (@Name, @Description, @Number, @CategoryId);";
return(DataAccessHelper.ExecuteWithinConnection(
(connection) => connection.QuerySingle <int>(insertAndSelectIdQuery, learningData),
_configuration
));
}
public bool AddImageData(ImageData imageData)
{
// TODO: Use one transaction for image data and learning data. Maybe reconsider interfaces
var insertAndSelectIdQuery = $@"
INSERT INTO {TableName} ({ColumnNames.ParentKey}, {ColumnNames.Title}, {ColumnNames.Data})
VALUES (@LearningDataId, @Title, @Data)";
return(DataAccessHelper.ExecuteWithinConnection(
(connection) => connection.Execute(insertAndSelectIdQuery, imageData),
_configuration
) == 1);
}
public bool UpdateImageData(ImageData imageData)
{
var updateQuery = $@"UPDATE {TableName} SET {ColumnNames.Title} = @Title, {ColumnNames.Data} = @Data WHERE {ColumnNames.ParentKey} = @LearningDataId";
return(DataAccessHelper.ExecuteWithinConnection((connection) => connection.Execute(updateQuery, imageData), _configuration) == 1);
}