public int ReduceCartItem(sf_CartItemObj cart, string conString = null) { var p = new DynamicParameters(); // p.Add("@ItemId", cart.ItemId, DbType.String); p.Add("@ItemId", cart.ItemId, DbType.Int32); p.Add("@Quantity", cart.Quantity, DbType.Int32); //p.Add("@UnitPrice", cart.UnitPrice, DbType.Decimal); p.Add("@LineTotal", cart.LineTotal, DbType.Decimal); p.Add("@CartId", cart.CartId, DbType.String); string sql = @"proc_ReduceCartItem"; var rec = Execute(c => c.Execute(sql, p, commandType: CommandType.StoredProcedure), conString); return(rec); }
public int PostCartItem(sf_CartItemObj cart, string conString = null) { var p = new DynamicParameters(); p.Add("@Id", cart.ItemId, DbType.String); p.Add("@ItemId", cart.ItemId, DbType.Int32); p.Add("@Quantity", cart.Quantity, DbType.Int32); p.Add("@UnitPrice", cart.UnitPrice, DbType.Decimal); p.Add("@LineTotal", cart.LineTotal, DbType.Decimal); p.Add("@TaxValue", cart.TaxValue, DbType.Decimal); p.Add("@CartId", cart.CartId, DbType.String); p.Add("@Discount", cart.Discount, DbType.Decimal); p.Add("@CreatedDate", cart.CreatedDate, DbType.DateTime); // p.Add("@IsPickUp", cart.IsPickUp, DbType.Boolean); string sql = @"proc_PostCartItem"; var rec = Execute(c => c.Execute(sql, p, commandType: CommandType.StoredProcedure), conString); return(rec); }
public void ReduceItem(sf_CartItemObj cart) { //using (var _db = new WingtipToys.Models.ProductContext()) //{ try { ShoppingCartId = GetCartId(); cart.CartId = ShoppingCartId; //var myItem = (from c in _db.ShoppingCartItems where c.CartId == updateCartID && c.Product.ProductID == updateProductID select c).FirstOrDefault(); //if (myItem != null) //{ // myItem.Quantity = quantity; // _db.SaveChanges(); //} var rst = _repo.ReduceCartItem(cart); } catch (Exception exp) { throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp); } // } }
public void AddToCart(sf_CartItemObj item) { // Retrieve the product from the database. ShoppingCartId = GetCartId(); //var cartItem = _db.ShoppingCartItems.SingleOrDefault( // c => c.CartId == ShoppingCartId // && c.ProductId == id); var cartItem = _repo.GetCartItem(item.ItemId, ShoppingCartId).FirstOrDefault(); if (cartItem == null) { // Create a new cart item if no cart item exists. cartItem = new sf_CartItemObj { Id = Guid.NewGuid().ToString(), ItemId = item.ItemId, CartId = ShoppingCartId, LineTotal = item.LineTotal, UnitPrice = item.UnitPrice, Quantity = 1, CreatedDate = DateTime.Now }; // _db.ShoppingCartItems.Add(cartItem); _repo.PostCartItem(cartItem); } else { // If the item does exist in the cart, // then add one to the quantity. cartItem.Quantity++; _repo.UpdateCartItem(cartItem); } // _db.SaveChanges(); }