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