public void SetCartItems([FromBody] SetCartItems cartItemInfo) { string uniqueId = cartItemInfo.UniqueID.ToString(); string isCart = cartItemInfo.IsShoppingCart ? "Y" : "N"; DBFacilitator.ExecuteCommand( PostgreSQLConnectionString, DELETE_CART, new List <Tuple <string, string, NpgsqlDbType> >() { { new Tuple <string, string, NpgsqlDbType>(":UniqueId", uniqueId, NpgsqlDbType.Integer) }, { new Tuple <string, string, NpgsqlDbType>(":IsShoppingCart", isCart, NpgsqlDbType.Char) } } ); foreach (var item in cartItemInfo.CartItems) { DBFacilitator.ExecuteCommand( PostgreSQLConnectionString, INSERT_CART_ITEMS, new List <Tuple <string, string, NpgsqlDbType> >() { { new Tuple <string, string, NpgsqlDbType>(":UniqueId", uniqueId, NpgsqlDbType.Integer) }, { new Tuple <string, string, NpgsqlDbType>(":IsShoppingCart", isCart, NpgsqlDbType.Char) }, { new Tuple <string, string, NpgsqlDbType>(":ItemId", item.ItemId, NpgsqlDbType.Text) }, { new Tuple <string, string, NpgsqlDbType>(":Name", item.Name, NpgsqlDbType.Text) }, { new Tuple <string, string, NpgsqlDbType>(":Type", item.Type, NpgsqlDbType.Text) }, { new Tuple <string, string, NpgsqlDbType>(":CategoryId", item.CategoryId, NpgsqlDbType.Text) }, { new Tuple <string, string, NpgsqlDbType>(":ProductId", item.ProductId, NpgsqlDbType.Text) }, { new Tuple <string, string, NpgsqlDbType>(":Quantity", item.Quantity.ToString(), NpgsqlDbType.Numeric) }, { new Tuple <string, string, NpgsqlDbType>(":Price", item.Price.ToString(), NpgsqlDbType.Numeric) } } ); } }
public void SetCartItems(SetCartItems cartItemInfo) { dal.SetCartItems(cartItemInfo.UniqueID, cartItemInfo.CartItems, cartItemInfo.IsShoppingCart); }
public void SetCartItems(int uniqueID, ICollection <CartItemInfo> cartItems, bool isShoppingCart) { var setCartItems = new SetCartItems(uniqueID, cartItems, isShoppingCart); Utility.ServiceCall(requestURL + "/setcartitems", JsonConvert.SerializeObject(setCartItems)); }