public void AddCartIDandUserIDInCart(CartDO dataModel) { SqlCommand cmd = new SqlCommand("insert into Cart values(@User_ID)", conn); cmd.Parameters.AddWithValue("@User_ID", dataModel.User_ID); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); }
//改变订单产品数量 public CartDO UpdateShu(CartDO product) { var productExists = _context.Set <CartDO>().Any(t => t.Id == product.Id); if (!productExists) { throw new Exception("没有找到指定ID的产品记录"); } _context.Set <CartDO>().Update(product); _context.SaveChanges(); return(product); }
public IActionResult Cart(long id) { String user = HttpContext.Session.GetString("User"); var users = _productService.Search(user); var product = _productService.GetById(id); var car = _productService.GetByCartNumber(product.ProductNumber); product.Shuliang--; if (car != null && car.UserName == user && car.Time == "1") { car.Shuliang++; _productService.UpdateShu(car); } else { var cart = new CartDO { ProductNumber = product.ProductNumber, ProductName = product.ProductName, Price = Convert.ToDouble(product.Price), ProductType = product.ProductType, Shuliang = 1, UserName = user, ImgUrl = users.City, Total = Convert.ToString(product.Price), Time = "1" }; _productService.Insertcart(cart); } try { _productService.Update(product); return(Json(new { code = "success", date = product })); } catch (Exception ex) { return(Json(new { code = "fail", message = ex.Message })); } }
public ActionResult AddToCart(int id, CartAddViewModel model) { CartDO cartDO = new CartDO(); if (User.Identity.IsAuthenticated) { cartDO.User_ID = User.Identity.GetUserId(); //checking if user already has cart created cartDO = cartManagement.GetCartByUserID(cartDO.User_ID); if (cartDO.Cart_ID == 0) { try { cartDO.User_ID = User.Identity.GetUserId(); cartDO.Cart_ID = model.Cart_ID; CartManagement cartManagement = new CartManagement(); cartManagement.AddCartIDandUserIDInCart(cartDO); return(RedirectToAction("Index")); } catch (Exception e) { Console.WriteLine(e); } } else { return(RedirectToAction("Index")); } } else { return(RedirectToAction("Login", "Account")); } return(null); }
public CartDO GetCartByUserID(string User_ID) { SqlCommand cmd = new SqlCommand("Select * from Cart where User_ID = @User_ID", conn); cmd.Parameters.AddWithValue("@User_ID", User_ID); SqlDataReader reader = null; CartDO modelData = new CartDO(); conn.Open(); reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { modelData.Cart_ID = Convert.ToInt32(reader[0]); modelData.User_ID = reader[1].ToString(); } conn.Close(); return(modelData); }
public void Insertcart(CartDO product) { _context.Set <CartDO>().Add(product); _context.SaveChanges(); }