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