public IEnumerable<string> GetCategoryNames() { using (var connection = this.GetConnection()) { var categoryQueryObject = new CategoryQueryObject(); return connection.Query<string>(categoryQueryObject.GetCategoryNames()); } }
public void UpdateCategoryPicture(Category category) { if (category == null) { return; } using (var connection = this.GetConnection()) { var categoryQueryObject = new CategoryQueryObject(); connection.Execute(categoryQueryObject.UpdateCategoryImage(category.CategoryID, category.Picture)); } }
public Category GetByCategoryName(string categoryName) { using (var connection = this.GetConnection()) { var categoryQueryObject = new CategoryQueryObject(); var categories = connection.Query<Category>(categoryQueryObject.GetByCategoryName(categoryName)).ToList(); if (!categories.Any()) { throw new EntityNotFoundException(string.Format("Category with {0} name is not found in database.", categoryName)); } return categories.First(); } }