public int Add(ShoppingCartAddRequest model, int userId)
{
int id = 0;
string procName = "dbo.ShoppingCart_InsertV3";
_data.ExecuteNonQuery(procName,
inputParamMapper : delegate(SqlParameterCollection col)
{
AddCommonParams(model, col);
SqlParameter idOut = new SqlParameter("@cartId", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
col.Add(idOut);
col.AddWithValue("@createdBy", userId);
col.AddWithValue("@modifiedBy", userId);
},
returnParameters : delegate(SqlParameterCollection returnCollection)
{
object oId = returnCollection["@cartId"].Value;
int.TryParse(oId.ToString(), out id);
});
return(id);
}
private void AddCommonParams(ShoppingCartAddRequest model, SqlParameterCollection col)
{
col.AddWithValue("@productId", model.ProductId);
col.AddWithValue("@quantity", model.Quantity);
col.AddWithValue("@specRequests", model.SpecialRequests);
}
