//load tất cả sản phẩm trong giỏ hàng public List <CartItemDTO> GetCartItemsByCartID(int cartID) { List <CartItemDTO> listCartItems = new List <CartItemDTO>(); string sql = "Select * From CartItem Where cartID = @cartID"; SqlConnection cnn = new SqlConnection(Consts.Consts.connectionString); if (cnn.State == ConnectionState.Closed) { cnn.Open(); } SqlCommand cmd = new SqlCommand(sql, cnn); cmd.Parameters.AddWithValue("@cartID", cartID); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { int productDetailID = (int)dr[1]; int quantity = (int)dr[2]; ProductDTO product = new ProductData().GetProductByProductDetailID(productDetailID); double price = product.Price; string color = product.Color; string name = new ShoesData().GetShoesDetailByProductID(product.ProductId).Name; double size = new ProductDetailData().GetSizeByProductDetailID(productDetailID); CartItemDTO dto = new CartItemDTO { ProductDetailId = productDetailID, Quantity = quantity, Price = (float)price, Color = color, Name = name, Size = size }; dto.Image = new ProductImageData().GetImageByProductID(new ProductData().GetProductByProductDetailID(dto.ProductDetailId).ProductId); listCartItems.Add(dto); } cnn.Close(); return(listCartItems); }
private void DeleteCartItem(CartItemDTO cartItem) { string sql = "Delete From CartItem Where cartID = @cartID and productDetailID = @productDetailID"; SqlConnection cnn = new SqlConnection(Consts.Consts.connectionString); if (cnn.State == ConnectionState.Closed) { cnn.Open(); } SqlCommand cmd = new SqlCommand(sql, cnn); cmd.Parameters.AddWithValue("@cartID", cartItem.CartId); cmd.Parameters.AddWithValue("@productDetailID", cartItem.ProductDetailId); cmd.ExecuteNonQuery(); }
//thêm sản phẩm mới vào giỏ hàng public bool InsertNewItemToCart(CartItemDTO item) { bool result = false; string sql = "Insert into CartItem values(@cartID, @productDetailID, @quantity)"; SqlConnection cnn = new SqlConnection(Consts.Consts.connectionString); if (cnn.State == ConnectionState.Closed) { cnn.Open(); } SqlCommand cmd = new SqlCommand(sql, cnn); cmd.Parameters.AddWithValue("@cartID", item.CartId); cmd.Parameters.AddWithValue("@productDetailID", item.ProductDetailId); cmd.Parameters.AddWithValue("@quantity", item.Quantity); if (cmd.ExecuteNonQuery() > 0) { result = true; } cnn.Close(); return(result); }