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