public ActionResult <ItemResponse <VerifiedDiscount> > Search(int productId, string q) { ActionResult result = null; try { VerifiedDiscount discount = _service.GetVerifiedDiscount(productId, q); if (discount == null) { result = NotFound404(new ErrorResponse("Discount not found")); } else { ItemResponse <VerifiedDiscount> response = new ItemResponse <VerifiedDiscount>(); response.Item = discount; result = Ok200(response); } } catch (Exception ex) { Logger.LogError(ex.ToString()); result = StatusCode(500, new ErrorResponse(ex.Message.ToString())); } return(result); }
public VerifiedDiscount GetVerifiedDiscount(int productId, string q) { VerifiedDiscount discount = null; _data.ExecuteCmd( "dbo.Discounts_Get_Verified", inputParamMapper : delegate(SqlParameterCollection parameterCollection) { parameterCollection.AddWithValue("@Query", q); parameterCollection.AddWithValue("@ProductId", productId); }, singleRecordMapper : delegate(IDataReader reader, short set) { discount = new VerifiedDiscount(); discount.ProductId = reader.GetSafeInt32(0); discount.Percentage = reader.GetSafeDecimal(1); } ); return(discount); }