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