Example #1
0
        async void Add_To_ShoppingCart(object sender, System.EventArgs e)
        {
            HomepageListView.IsVisible = true;
            var button  = sender as Button;
            var product = button.CommandParameter as Product_Retailer;

            await conn.CreateTableAsync <shoppingcart>();

            //System.Diagnostics.Debug.WriteLine(product.ProductName);

            var item = new shoppingcart
            {
                ProductID     = product.ProductID,
                ProductName   = product.ProductName,
                Price         = product.Price,
                Brand         = product.Brand,
                Category      = product.Category,
                ImageUrl      = product.ImageUrl,
                BigImageUrl   = product.BigImageUrl,
                Description   = product.Description,
                Retailer_Name = product.Retailer_Name,
                Latitude      = product.Latitude,
                Longitude     = product.Longitude
            };

            await conn.InsertAsync(item);

            await DisplayAlert("Successfully added to Shopping Cart", item.ProductName, "OK");
        }
Example #2
0
        public ActionResult Add_To_Cart(int id)
        {
            //Console.WriteLine("Add to wishlist is succesfully called");
            int?ProductId;

            ProductId = id;


            using (new_testEntities db = new new_testEntities())
            {
                product product = db.product.FirstOrDefault(x => x.ID == id);
                string  userid  = "0";
                if (Request.IsAuthenticated)
                {
                    userid = User.Identity.GetUserId();
                }
                shoppingcart shoppingcart = db.shoppingcart.FirstOrDefault(x => x.ProductId == id && x.UserId == userid);
                wishlist     Wishlist     = db.wishlist.FirstOrDefault(x => x.ProductId == id);

                if (shoppingcart == null)
                {
                    db.shoppingcart.Add(new shoppingcart {
                        ProductId = Wishlist.ProductId, UserId = User.Identity.GetUserId(), Quantity = Wishlist.Quantity, ProductName = Wishlist.ProductName, Price = Wishlist.Price, Imagepath = Wishlist.Imagepath
                    });
                    db.SaveChanges();
                }
                else
                {
                    shoppingcart.Quantity += Wishlist.Quantity;
                    db.SaveChanges();
                }

                return(RedirectToAction("Index", "Shoppingcart"));
            }
        }
Example #3
0
        public ActionResult Minus_To_Cart(int id)
        {
            //Console.WriteLine("Add to shoppingcart is succesfully called");
            int?ProductId;

            ProductId = id;


            using (new_testEntities db = new new_testEntities())
            {
                //user user = db.user.FirstOrDefault(x => x.ID == id);
                shoppingcart Shoppingcart = db.shoppingcart.FirstOrDefault(x => x.ProductId == id);


                Shoppingcart.Quantity -= 1;
                db.SaveChanges();

                if (Shoppingcart.Quantity <= 0)
                {
                    db.shoppingcart.Remove(Shoppingcart);
                    db.SaveChanges();
                }


                return(RedirectToAction("Index", "Shoppingcart"));
            }
        }
Example #4
0
        public JsonResult AddShopcart(string prodId, int num, string prodPrice)
        {
            string res        = string.Empty;
            string userOpenId = base.getUserOpenIdFromCookie();

            if (string.IsNullOrEmpty(userOpenId))
            {
                res = "false";//这里可以扩展,可以换成枚举,目前功能不需要
            }
            else
            {
                try
                {
                    ShopCartBiz  shopcartBiz  = ShopCartBiz.CreateNew();
                    shoppingcart userShopcart = shopcartBiz.checkProdExistInCarts(userOpenId, prodId);
                    if (userShopcart != null)
                    {
                        int addNum = userShopcart.num + num;
                        shopcartBiz.UpdateProdInCarts(userOpenId, prodId, addNum, prodPrice);
                    }
                    else
                    {
                        shopcartBiz.AddProdInCarts(userOpenId, prodId, num, prodPrice);
                    }
                    res = shopcartBiz.getUserCartsNum(userOpenId).ToString();
                }
                catch (Exception e)
                {
                    _Apilog.WriteLog("添加购物车异常: " + e.Message);
                    res = "false";
                }
            }
            return(Json(res));
        }
Example #5
0
        static void Main(string[] args)
        {
            Console.WriteLine("Welcome");
            Console.WriteLine("Enter your name");
            string       person_name = Console.ReadLine();
            shoppingcart client      = new shoppingcart();

            Console.ReadKey();
        }
Example #6
0
        public ActionResult Delete(int id)
        {
            using (new_testEntities db = new new_testEntities())
            {
                shoppingcart shoppingcart = db.shoppingcart.FirstOrDefault(x => x.ProductId == id);
                db.shoppingcart.Remove(shoppingcart);
                db.SaveChanges();
            }

            return(RedirectToAction("Index", "Shoppingcart"));
        }
Example #7
0
        /// <summary>
        /// 检查购物车中是否有这个商品
        /// </summary>
        /// <param name="userOpenId">用户微信openId</param>
        /// <param name="prodId">商品Id</param>
        public shoppingcart checkProdExistInCarts(string userOpenId, string prodId)
        {
            shoppingcart queryshoppingcart = new shoppingcart();

            using (IDbConnection conn = DapperHelper.MySqlConnection())
            {
                string sqlCommandText = @"SELECT * FROM ShoppingCart WHERE userOpenId=@userOpenId and productId=@productId and status=1 ";
                queryshoppingcart = conn.Query <shoppingcart>(sqlCommandText, new { userOpenId = userOpenId, productId = prodId }).FirstOrDefault();
            }
            return(queryshoppingcart);
        }
Example #8
0
        public int InsertShoppingCart(shoppingcart Shoppingcart)
        {
            string sql = "insert into shoppingcart(user_id,goods_id,unit_price,number,total_price)values(@UserID,@GoodsID,@UnitPrice,@Number,@TotalAmount)";

            SqlParameter[] para =
            {
                new SqlParameter("@UserID",      Shoppingcart.user_id),
                new SqlParameter("@GoodsID",     Shoppingcart.goods_id),
                new SqlParameter("@UnitPrice",   Shoppingcart.unit_price),
                new SqlParameter("@Number",      Shoppingcart.number),
                new SqlParameter("@TotalAmount", Shoppingcart.total_price)
            };
            return(DBHelper.GetExcuteNonQuery(sql, para));
        }
Example #9
0
        public JsonResult CreateOrderFromShopcart(string prodIds)
        {
            string userOpenId = base.getUserOpenIdFromCookie();
            string res        = "fail";

            if (!string.IsNullOrEmpty(userOpenId))
            {
                try
                {
                    //订单付款页面用户回退购物车页面,然后再创单时实际没有商品,规避此类垃圾数据
                    string[] prods     = prodIds.Split(',');
                    bool     prodExist = false;
                    for (int i = 0; i < prods.Length; i++)
                    {
                        shoppingcart checkResult = ShopCartBiz.CreateNew().checkProdExistInCarts(userOpenId, prods[i]);
                        if (checkResult != null)
                        {
                            prodExist = true;
                            break;
                        }
                    }

                    if (prodExist)
                    {
                        string salesNo = WxPayApi.GenerateOutTradeNo();// Guid.NewGuid().ToString();
                        OrderBiz.CreateNew().createOrderFromShopcart(prodIds, userOpenId, salesNo);
                        res = salesNo;
                    }
                    else
                    {
                        res = "noProds";
                    }
                }
                catch (Exception e)
                {
                    res = "fail";
                    _Apilog.WriteLog("ProductsController/CreateOrderFromShopcart 异常: " + e.Message);
                }
            }
            else
            {
                _Apilog.WriteLog("ProductsController/CreateOrderFromShopcart 用户userOpenId 为空: " + prodIds);
            }
            return(Json(res));
        }
Example #10
0
        async void Add_To_ShoppingCart(object sender, System.EventArgs e)
        {
            var button  = sender as Button;
            var product = button.CommandParameter as Product;

            await conn.CreateTableAsync <shoppingcart>();

            var item = new shoppingcart
            {
                ProductID   = product.ProductID,
                ProductName = product.ProductName,
                Price       = product.Price,
                Brand       = product.Brand,
                Category    = product.Category,
                ImageUrl    = product.ImageUrl,
                BigImageUrl = product.BigImageUrl,
                Description = product.Description
            };

            await conn.InsertOrReplaceAsync(item);

            await DisplayAlert("Successfully added to Shopping Cart", item.ProductName, "OK");
        }
Example #11
0
        protected void LVgoods_ItemCommand(object sender, ListViewCommandEventArgs e)
        {
            int    num       = int.Parse(ViewState["stock"].ToString());
            string Eventname = e.CommandName;

            switch (Eventname)
            {
            case "Minus":
            {
                int i = Convert.ToInt32(ViewState["ShoppingCartNumber"]);
                if (i > 0)
                {
                    i--;
                    ViewState["ShoppingCartNumber"] = i;
                    Bindgoods();
                }
            }
            break;

            case "Add":
            {
                int i = Convert.ToInt32(ViewState["ShoppingCartNumber"]);
                if (i < num)
                {
                    i++;
                    ViewState["ShoppingCartNumber"] = i;
                    Bindgoods();
                }
            }
            break;

            //加入购物车
            case "AddShoppingCart":
            {
                if (Session["user_name"] != null)
                {
                    int number = Convert.ToInt32(ViewState["ShoppingCartNumber"]);
                    if (number > 0)
                    {
                        int       user_id  = Convert.ToInt32(Session["user_id"]);
                        int       goods_id = Convert.ToInt32(ViewState["goods_id"]);
                        DataTable goods    = GoodsManager.JudgeMallYorN(user_id, goods_id);
                        if (goods != null && goods.Rows.Count != 0)
                        {
                            float total_price = (float.Parse(((Label)e.Item.FindControl("RTprice")).Text)) * (Convert.ToInt32(ViewState["ShoppingCartNumber"]));
                            int   result      = GoodsManager.UpdateShoppingCart(user_id, goods_id, number, total_price);
                            if (result >= 1)
                            {
                                Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('加入购物车成功!');</script>");
                                BindUserMallCart();
                            }
                        }
                        else
                        {
                            shoppingcart Shoppingcart = new shoppingcart();
                            Shoppingcart.user_id     = Convert.ToInt32(Session["user_id"]);
                            Shoppingcart.goods_id    = Convert.ToInt32(ViewState["goods_id"]);
                            Shoppingcart.unit_price  = float.Parse(((Label)e.Item.FindControl("RTprice")).Text);
                            Shoppingcart.number      = Convert.ToInt32(ViewState["ShoppingCartNumber"]);
                            Shoppingcart.total_price = (float.Parse(((Label)e.Item.FindControl("RTprice")).Text)) * (Convert.ToInt32(ViewState["ShoppingCartNumber"]));
                            int result = GoodsManager.InsertShoppingCart(Shoppingcart);
                            if (result >= 1)
                            {
                                Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('加入购物车成功!');</script>");
                                BindUserMallCart();
                            }
                            else
                            {
                                Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('请确定购买数量');</script>");
                            }
                        }
                    }
                    else
                    {
                        Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('已经卖光了。。。');</script>");
                    }
                }
                else
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('请先登录');</script>");
                    Response.Redirect("login1.aspx");
                }
            }
            break;
            }
        }
Example #12
0
 public static int InsertShoppingCart(shoppingcart Shoppingcart)
 {
     return(igoods.InsertShoppingCart(Shoppingcart));
 }
Example #13
0
        public void addcar(object sender, EventArgs e)
        {
            int num = int.Parse(ViewState["stock"].ToString());

            if (num > 0)
            {
                if (Session["user_name"] != null)
                {
                    int number = Convert.ToInt32(ViewState["ShoppingCartNumber"]);
                    if (number > 0)
                    {
                        int       user_id  = Convert.ToInt32(Session["user_id"]);
                        int       goods_id = Convert.ToInt32(ViewState["goods_id"]);
                        DataTable goods    = GoodsManager.JudgeMallYorN(user_id, goods_id);
                        if (goods != null && goods.Rows.Count != 0)
                        {
                            Button btn         = (Button)sender;
                            Label  RTprice     = btn.Parent.FindControl("RTprice") as Label;
                            string str         = RTprice.Attributes["data-value"];
                            float  total_price = float.Parse(str) * (Convert.ToInt32(ViewState["ShoppingCartNumber"]));
                            int    result      = GoodsManager.UpdateShoppingCart(user_id, goods_id, number, total_price);
                            if (result >= 1)
                            {
                                Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('加入购物车成功!');</script>");
                                BindUserMallCart();
                            }
                        }
                        else
                        {
                            Button       btn          = (Button)sender;
                            Label        gprices      = btn.Parent.FindControl("RTprice") as Label;
                            float        str          = float.Parse(gprices.Attributes["data-value"]);
                            shoppingcart Shoppingcart = new shoppingcart();
                            Shoppingcart.user_id  = Convert.ToInt32(Session["user_id"]);
                            Shoppingcart.goods_id = 1033;
                            Convert.ToInt32(ViewState["goods_id"]);
                            Shoppingcart.unit_price = str;
                            //float.Parse(((Label)e.Item.FindControl("RTprice")).Text);
                            Shoppingcart.number      = Convert.ToInt32(ViewState["ShoppingCartNumber"]);
                            Shoppingcart.total_price = str * (Convert.ToInt32(ViewState["ShoppingCartNumber"]));
                            int result = GoodsManager.InsertShoppingCart(Shoppingcart);
                            if (result >= 1)
                            {
                                Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('加入购物车成功!');</script>");
                                BindUserMallCart();
                            }
                            else
                            {
                                Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('请确定购买数量');</script>");
                            }
                        }
                    }
                    else
                    {
                        Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('已经卖光了。。。');</script>");
                    }
                }
                else
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('请先登录');</script>");
                    Response.Redirect("login1.aspx");
                }
            }
        }