public static void UpdateCart(MODEL.ShoppingCart cart) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shoppingCart set "); strSql.Append("userId=@userId,"); strSql.Append("prdNo=@prdNo,"); strSql.Append("prdName=@prdName,"); //strSql.Append("prdPrice=@prdPrice,"); strSql.Append("prdQty=@prdQty, "); strSql.Append("settleStt=@settleStt "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int), new SqlParameter("@userId", SqlDbType.VarChar), new SqlParameter("@prdNo", SqlDbType.VarChar), new SqlParameter("@prdName", SqlDbType.VarChar), //new SqlParameter("@prdPrice", SqlDbType.VarChar), new SqlParameter("@prdQty", SqlDbType.VarChar), new SqlParameter("@settleStt", SqlDbType.Int) }; parameters[0].Value = cart.Id; parameters[1].Value = cart.UserId; parameters[2].Value = cart.PrdNo; parameters[3].Value = cart.PrdName; //parameters[4].Value = cart.PrdPrice; parameters[4].Value = cart.PrdQty; parameters[5].Value = cart.SettleStt; DBHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string PrdNo = context.Request["PrdNo"]; if (context.Session["userInfo"] == null) { context.Response.Write("NoLogin"); } else { if (!string.IsNullOrEmpty(PrdNo)) { MODEL.Product product = BLL.ProductManager.GetPrd(PrdNo); if (product != null) { MODEL.User user = context.Session["userInfo"] as MODEL.User; MODEL.ShoppingCart cart = BLL.ShoppingCartManager.GetCart(user.LoginId, PrdNo); if (cart != null) { cart.PrdQty = cart.PrdQty + 1; BLL.ShoppingCartManager.UpdateCart(cart); } else { cart = new MODEL.ShoppingCart(); cart.UserId = user.LoginId; cart.PrdName = product.PrdName; cart.PrdNo = product.PrdNo; cart.PrdQty = 1; cart.SettleStt = 0; BLL.ShoppingCartManager.AddCart(cart); } string strCart = Common.LoadShoppingCart.GetCartByUser(); context.Response.Write(strCart); } } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string PrdNo = context.Request["PrdNo"]; if (context.Session["userInfo"] == null) { context.Response.Write("NoLogin"); } else { if (!string.IsNullOrEmpty(PrdNo)) { MODEL.Product product = BLL.ProductManager.GetPrd(PrdNo); if (product != null) { MODEL.User user = context.Session["userInfo"] as MODEL.User; MODEL.ShoppingCart cart = BLL.ShoppingCartManager.GetCart(user.LoginId, PrdNo); if (cart != null) { cart.PrdQty = cart.PrdQty + 1; BLL.ShoppingCartManager.UpdateCart(cart); } else { cart = new MODEL.ShoppingCart(); cart.UserId = user.LoginId; cart.PrdName = product.PrdName; cart.PrdNo = product.PrdNo; cart.PrdQty = 1; cart.SettleStt = 0; BLL.ShoppingCartManager.AddCart(cart); } string strCart = Common.LoadShoppingCart.GetCartByUser(); context.Response.Write(strCart); } } } }
public static void AddCart(MODEL.ShoppingCart cart) { string sql = @"INSERT INTO dbo.shoppingCart ( userId , prdNo , prdName , prdQty , settleStt ) VALUES ( @userId , -- userId - varchar(50) @prdNo , -- prdNo - varchar(50) @prdName , -- prdName - varchar(200) @prdQty , -- prdQty - int 0 -- settleStt - int )"; SqlParameter[] parameter = new SqlParameter[4]; parameter[0] = new SqlParameter("@userId", cart.UserId); parameter[1] = new SqlParameter("@prdNo", cart.PrdNo); parameter[2] = new SqlParameter("@prdName", cart.PrdName); parameter[3] = new SqlParameter("@prdQty", cart.PrdQty); DBHelper.ExecuteNonQuery(sql, CommandType.Text, parameter); }
public static void AddCart(MODEL.ShoppingCart cart) { DAL.ShoppingCartService.AddCart(cart); }
public static void UpdateCart(MODEL.ShoppingCart cart) { DAL.ShoppingCartService.UpdateCart(cart); }