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