private static void AddParams(DiscountAddRequest model, SqlParameterCollection col)
{
col.AddWithValue("@ProductId", model.ProductId);
col.AddWithValue("@CouponCode", model.CouponCode);
col.AddWithValue("@Title", model.Title);
col.AddWithValue("@Description", model.Description);
col.AddWithValue("@Percentage", model.Percentage);
col.AddWithValue("@ValidFrom", model.ValidFrom);
col.AddWithValue("@ValidUntil", model.ValidUntil);
col.AddWithValue("@IsRedeemedAllowed", model.IsRedeemedAllowed);
}
public async Task <DiscountAddResponse> Add(DiscountAddRequest request)
{
var discout = request.ViewModel.MapToModel();
await BaseBeforeAddAsync(discout, request.RequestOwner);
try
{
await _discountFacade.AddAsync(discout);
}
catch (Exception e)
{
return(new DiscountAddResponse()
{
Access = ResponseAccess.BadRequest, Message = e.Message
});
}
await BaseAfterAddAsync(discout, request.RequestOwner);
return(new DiscountAddResponse {
Access = ResponseAccess.Granted
});
}
public int Add(DiscountAddRequest model, int userId)
{
int id = 0;
_data.ExecuteNonQuery("dbo.Discounts_Insert",
inputParamMapper : delegate(SqlParameterCollection col)
{
AddParams(model, col);
col.AddWithValue("@CreatedBy", userId);
SqlParameter idOut = new SqlParameter("@Id", System.Data.SqlDbType.Int);
idOut.Direction = System.Data.ParameterDirection.Output;
col.Add(idOut);
},
returnParameters : delegate(SqlParameterCollection returnCollection)
{
object oId = returnCollection["@Id"].Value;
Int32.TryParse(oId.ToString(), out id);
});
return(id);
}
public ActionResult <ItemResponse <int> > Create(DiscountAddRequest model)
{
ObjectResult result = null;
int userId = _authService.GetCurrentUserId();
try
{
int id = _service.Add(model, userId);
ItemResponse <int> response = new ItemResponse <int>()
{
Item = id
};
result = Created201(response);
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
ErrorResponse response = new ErrorResponse(ex.Message);
result = StatusCode(500, response);
}
return(result);
}
