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();
}
