public IHttpActionResult GetByProductId(Guid productId) { var productOptions = _productOptionRepository.GetByProductId(productId); if (productOptions == null || !productOptions.Any()) { return(StatusCode(HttpStatusCode.NotFound)); } return(Ok(productOptions)); }
public void Delete(Guid productId) { var options = _productOptionRepository.GetByProductId(productId); foreach (var option in options.Items) { _productOptionRepository.Delete(option.Id); } using (var conn = NewConnection()) { var cmd = conn.CreateCommand(); cmd.CommandText = $"DELETE FROM Product WHERE Id = @Id"; cmd.Parameters.AddWithValue("@Id", productId); conn.Open(); cmd.ExecuteNonQuery(); } }
public ProductOptions GetOptions(Guid productId) { return(_productOptionRepository.GetByProductId(productId)); }