Ejemplo n.º 1
0
        public void AddToCart(int id)
        {
            // Retrieve the product from the database.
            string ShoppingCartId = GetCatrId();
            var    user           = from u in DB.users where u.userName == ShoppingCartId select u;

            WebDL.user userdata = user.FirstOrDefault();
            var        cartItem = DB.shoppingCarts.FirstOrDefault(
                c => c.user.userName == ShoppingCartId &&
                c.productID == id);

            if (cartItem == null)
            {
                // Create a new cart item if no cart item exists.
                cartItem = new shoppingCart
                {
                    productID = id,
                    quantity  = 1,
                    userID    = userdata.userID,
                    shoppingCartExpiredDate = DateTime.Now.AddDays(7),
                    user    = DB.users.SingleOrDefault(u => u.userID == userdata.userID),
                    product = DB.products.SingleOrDefault(p => p.productID == id)
                };

                DB.shoppingCarts.Add(cartItem);
            }
            else
            {
                // If the item does exist in the cart,
                // then add one to the quantity.
                cartItem.quantity++;
            }
            DB.SaveChanges();
        }
Ejemplo n.º 2
0
 private void loadCogiggnee()
 {
     using (WebDL.Team2_BookDBEntities bke = new Team2_BookDBEntities())
     {
         //int  id =bke.users.Find(Session.["userId"]);
         var        data = from ur in bke.users where ur.userID == userId select ur;
         WebDL.user user = data.First();
         lbCustomerName.Text    = user.userName;
         lbDeliveryAddress.Text = user.userAddress;
         lbContactNumber.Text   = user.userPhone.ToString();
     }
 }
Ejemplo n.º 3
0
        public void AddToCart(string name)
        {
            ShoppingCartActions  Action = new ShoppingCartActions();
            Team2_BookDBEntities DB     = new Team2_BookDBEntities();
            // Retrieve the product from the database.
            string ShoppingCartId = Action.GetCatrId();
            var    user           = from u in DB.users where u.userName == ShoppingCartId select u;

            WebDL.user userdata = user.FirstOrDefault();
            var        book     = from b in DB.products where b.productName == name select b;

            WebDL.product bookdata = book.FirstOrDefault();
            var           cartItem = DB.shoppingCarts.FirstOrDefault(
                c => c.user.userName == ShoppingCartId &&
                c.product.productName == name);
            var product = DB.products.FirstOrDefault(p => p.productName == name);

            if (cartItem == null)
            {
                // Create a new cart item if no cart item exists.
                cartItem = new shoppingCart
                {
                    productID = bookdata.productID,
                    quantity  = Convert.ToInt32(tbQuantity.Text),
                    userID    = userdata.userID,
                    shoppingCartExpiredDate = DateTime.Now.AddDays(7),
                    user    = DB.users.SingleOrDefault(u => u.userID == userdata.userID),
                    product = DB.products.SingleOrDefault(p => p.productName == name)
                };

                DB.shoppingCarts.Add(cartItem);
            }
            else
            {
                // If the item does exist in the cart,
                // then add one to the quantity.
                cartItem.quantity += Convert.ToInt32(tbQuantity.Text);
            }
            product.productQty -= Convert.ToInt32(tbQuantity.Text);

            DB.SaveChanges();
        }
Ejemplo n.º 4
0
        protected void btnAddToCart_Click(object sender, EventArgs e)
        {
            Button btn         = (Button)sender;
            string productName = btn.CssClass;

            using (WebDL.Team2_BookDBEntities context = new WebDL.Team2_BookDBEntities())
            {
                string userNameFromSession = Session["userName"].ToString();
                var    data  = from p in context.products where p.productName == productName select p;
                var    data2 = from u in context.users where u.userName == userNameFromSession select u;

                WebDL.user         userGetFromSession = data2.First();
                WebDL.product      pToBeAdded         = data.First();
                WebDL.shoppingCart sc = new WebDL.shoppingCart();
                sc.product  = pToBeAdded;
                sc.quantity = 1;
                sc.userID   = userGetFromSession.userID;
                sc.shoppingCartExpiredDate = DateTime.Now.Date;
                context.shoppingCarts.Add(sc);
                context.SaveChanges();
                lbMsg.Text = "product: " + productName + " is added to shopping cart";
            }
        }