public async Task <IActionResult> GetProductsByCategory(string categoryName)
{
try
{
var productsByCategory = await _dbServices.GetProductsByCategoryAsync(categoryName);
return(StatusCode(200, productsByCategory));
}
catch (SqlException se)
{
if (se.Number == 50000 && se.Message.StartsWith($"Category"))
{
return(StatusCode(400, $"Invalid Category Name provided"));
}
#if DEBUG
return(StatusCode(400, se));
#else
return(StatusCode(400, $"A sql related error has occurred while attempting to get products by category"));
#endif
}
catch (Exception ex)
{
#if DEBUG
return(StatusCode(500, ex));
#else
return(StatusCode(500, $"A generic exception was caught while attempting to get products by category"));
#endif
}
}
