private void UpdateCartSession() { if (Session["cartid"] == null) { if (!string.IsNullOrEmpty(baseviewmodel.cartid)) { cart = db.carts.Where(x => x.id.ToString() == baseviewmodel.cartid).SingleOrDefault(); if (cart != null) { Session["cartid"] = baseviewmodel.cartid; } } } if (Session["cartid"] != null) { if (cart == null) { cart = db.carts.Where(x => x.id.ToString() == baseviewmodel.cartid).SingleOrDefault(); } } if (cart != null) { sessionid = cart.userid; subdomainid = cart.subdomainid; baseviewmodel.store_name = cart.MASTERsubdomain.organisation.name; baseviewmodel.year = DateTime.UtcNow.Year; if (cart.userid.HasValue) { baseviewmodel.user_name = cart.user.firstName; } } }
public void FillRepeater() { using (cart obj = new cart()) { obj._userid = Convert.ToInt64(Session["UserID"].ToString()); obj._sessionid = Session["Current"].ToString(); obj._orderid = Convert.ToInt64("0"); DataSet ds = new DataSet(); ds = obj.cart_details(); if (ds.Tables[0].Rows.Count > 0) { rptcart.DataSource = ds; rptcart.DataBind(); } else { lblerror.Text = "No Item In Cart"; lblerror.Visible = true; rptcart.Visible = false; totaldiv.Visible = false; btnconfirm.Visible = false; } ds = obj.cart_total(); lbltotals.Text = ds.Tables[0].Rows[0]["total"].ToString(); } }
public ActionResult AddToCart(string id) { int accountid = (Session["User"] as account).id; int pid = Convert.ToInt32(id); var query = from cart in cos.carts where cart.id_user == accountid && cart.id_products == pid select cart; if (query.SingleOrDefault() != null) { cart existCart = query.FirstOrDefault(); existCart.quantity++; } else { var newcart = new cart { id_user = accountid, id_products = pid, quantity = 1, createdAt = DateTime.Now }; cos.carts.Add(newcart); } cos.SaveChanges(); return(View("Cart")); }
public baseCartController() { cart = null; db = new tradelrDataContext(); repository = new TradelrRepository(db); baseviewmodel = new BaseViewModel(); }
public async Task <IActionResult> Putcart([FromRoute] int id, [FromBody] cart cart) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != cart.cartID) { return(BadRequest()); } _context.Entry(cart).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!cartExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public List <cart> GetAllItems() { List <cart> allItems = new List <cart>(); string cs = @"URI=file:../cart.db"; using var con = new SQLiteConnection(cs); con.Open(); string stm = "SELECT * FROM cart"; using var cmd = new SQLiteCommand(stm, con); using SQLiteDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { cart temp = new cart() { cartid = rdr.GetInt32(0), itemName = rdr.GetString(1), price = rdr.GetDouble(2), quantity = rdr.GetInt32(3) }; allItems.Add(temp); } return(allItems); }
public ActionResult update() { String temp; cart cart = (cart)Session["cart"]; for (int i = 0; i < cart.lstcart.Count(); i++) { temp = Request.Form[cart.lstcart[i].Id_Product.ToString()]; if (temp == null && cart.lstcart[i].Amount != null) { continue; } else if (temp == null || Int32.Parse(temp) == 0) { cart.lstcart.RemoveAt(i); } else { cart.lstcart[i].Amount = Int32.Parse(temp); //cart.lstcart[i].Total = (Double)cart.lst[i].amount * cart.lst[i].price; } } Session["Cart"] = cart; return(View()); }
public ActionResult pay(bill ttKhachHang) { ttKhachHang.create_date = DateTime.Now.Date; db = new ToysDBContext(); db.bills.Add(ttKhachHang); cart cart = (cart)Session["cart"]; foreach (CartItem item in cart.lstcart) { bill_detail detail = new bill_detail(); detail.bill_id = ttKhachHang.id; detail.product_id = item.Id_Product; detail.amount = item.Amount; detail.price = item.Amount * item.price; db.bill_detail.Add(detail); } int stt = db.SaveChanges(); string message = "Có lỗi khi đặt hàng!"; if (stt > 0) { message = "Đặt hàng thành công"; } Session["message"] = message; Session["Cart"] = null; return(RedirectToAction("Index", "Home")); }
private void button1_Click_1(object sender, EventArgs e) { moveSidePanel(U_sb_btn); cart btt = new cart(); Addcontrolstopanel(btt); }
/// <summary> /// /// </summary> /// <param name="parm"></param> /// <param name="msgType">1 add 0 del</param> /// <returns></returns> public ApiMessage <bool> Add(cart parm) { var api = new ApiMessage <bool>(); var list = _db.Query <cart>(@"SELECT * FROM Cart WHERE UserID=@UserID AND ProductID=@ProductID", parm).ToList(); if (list.Any()) { var node = list.FirstOrDefault(); if (parm.Amount == 0) { node.Delete(); } else { node.Amount = parm.Amount; node.CreatDate = DateTime.Now; node.Update(); } } else { parm.CreatDate = DateTime.Now; parm.ID = Guid.NewGuid().ToString(); parm.Insert(); } api.Msg = "添加成功"; return(api); }
protected void btnclearall_Click(object sender, EventArgs e) { using (cart obj = new cart()) { if (Session["UserID"] != null) { if (Session["UserID"] != "") { obj._userid = Convert.ToInt64(Session["UserID"].ToString()); obj._sessionid = Session["Current"].ToString(); obj._orderid = Convert.ToInt64("0"); obj.cart_clear(); FillRepeater(); lblMsg.Text = "Your Cart is Clear"; lblMsg.Visible = true; } } else { obj._userid = Convert.ToInt64("0"); obj._sessionid = Session["Current"].ToString(); obj._orderid = Convert.ToInt64("0"); obj.cart_clear(); FillRepeater(); lblMsg.Text = "Your Cart is Clear"; lblMsg.Visible = true; } } }
public void Updateuserid() { if (Session["UserID"] != null) { if (Session["UserID"] != "") { using (cart obj = new cart()) { obj._userid = Convert.ToInt64(Session["UserID"].ToString()); obj._sessionid = Session["Current"].ToString(); obj._orderid = Convert.ToInt64("0"); obj.cart_updateuserid(); DataSet ds = new DataSet(); DataSet dsr = new DataSet(); ds = obj.cart_selectbyusoid(); dsr = obj.cart_selectbyuoid(); int i = dsr.Tables[0].Rows.Count; int j = ds.Tables[0].Rows.Count; if (i > j) { obj.cart_updatesessionid(); } } } } }
/// <summary> /// 添加购物车 /// </summary> /// <returns></returns> public ActionResult Add() { // string cgoodsid = Request.QueryString["goodsid"]; string cgoodsname = Request.QueryString["goodsname"]; string cgoodsnewprice = Request.QueryString["goodsnewprice"]; string cgooodscolor = Request.QueryString["gooodscolor"]; string cgoodssize = Request.QueryString["goodssize"]; string cgoodsnumber = Request.QueryString["goodsnumber"]; string cgoodsimage = Request.QueryString["goodsimgae"]; //将用户选中的商品加入购物车,根据用户是否等,用户登录 直接加入数据库,没有登录直接加入cookies cart cart = new cart { goodsname = cgoodsname, goodsimage = cgoodsimage, goodsnewprice = Convert.ToDecimal(cgoodsnewprice), goodssize = cgoodssize, goodsnumber = Convert.ToInt32(cgoodsnumber), goodscolor = cgooodscolor }; //定义一个集合存储cart对象 IList <cart> clist = new List <cart>(); clist.Add(cart); // HttpCookie cartlistcookie = new HttpCookie("cartlist", clist); return(View()); }
public void macCart(cart obj) { SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["EcommerceCon"].ConnectionString; if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "macClientInfo"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@mac", SqlDbType.VarChar).Value = obj.mac; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { TempData["cartProds"] = dr["cartProds"].ToString(); TempData["amtDue"] = dr["amtDue"].ToString(); } con.Close(); }
public ActionResult Display(int[] def) { //TempData["qwe"] = form1["def"]; miniprojectEntities entities = new miniprojectEntities(); //booklist result = new booklist(); //result.selectedbook = def; ////return RedirectToAction("Displayfinal"); //IEnumerable<int> y = result.selectedbook; ////List<booklist> selbooks; cart order = new cart(); booklist temp = new booklist(); foreach (int item in def) { temp = entities.booklists.FirstOrDefault(x => x.book_id == item); order.book_id = temp.book_id; order.book_name = temp.book_name; order.author_name = temp.author_name; order.price = temp.price; order.genre_id = temp.genre_id; // order.user_id= entities.carts.Add(order); entities.SaveChanges(); } return(RedirectToAction("Displayfinal")); }
protected void btnaddcart_Click(object sender, EventArgs e) { using (cart obj = new cart()) { if (ViewState["rbtnid"] != null) { obj._productid = Convert.ToInt64(Request.QueryString["sid"].ToString()); obj._ppid = Convert.ToInt64(ViewState["rbtnid"].ToString()); obj._prid = Convert.ToInt64(ViewState["prid"].ToString()); Session["Current"] = Session.SessionID.ToString(); obj._sessionid = Session["Current"].ToString(); obj._orderid = Convert.ToInt64("0"); obj._credit = Convert.ToInt64(lbltotal.Text.ToString()); if (Session["UserID"] != null) { if (Session["UserID"] != "") { obj._userid = Convert.ToInt64(Session["UserID"].ToString()); } } else { obj._userid = Convert.ToInt64("0"); } obj.cart_insert(); Response.Redirect("Cart.aspx"); } else { lblMsg.Visible = true; lblMsg.Text = "Chose one product item"; } } }
protected void addcart_Click(object sender, ImageClickEventArgs e) { Userinfo user = new Userinfo(); if (this.countliteral.Text.Trim() != "缺货") { cart ocart = new cart(); if (ocart.isexitproduct(int.Parse(this.Request.QueryString["pid"].ToString())) == false) { if (ocart.addtocart(int.Parse(this.Request.QueryString["pid"].ToString()), user.getUserID(), 1, false) == 1) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('购物成功')</script>", false); } else { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('购物失败')</script>", false); } } else { if (ocart.updatecartbyid(int.Parse(this.Request.QueryString["pid"].ToString())) == 1) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('购物成功')</script>", false); } else { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('购物失败')</script>", false); } } } else { this.addcart.Enabled = false; } }
public JsonResult AddItem(productos producto, int cantidad) { EstatusLog estatus = new EstatusLog(); cart carrito = new cart(); if (logic.ActiveUser() == null) { estatus.success = false; estatus.errorMsg = "NotUser"; return(Json(estatus)); } carrito.userid = logic.ActiveUser().id; carrito.prodid = producto.id; carrito.cantidad = cantidad; carrito.fecha = DateTime.Now; try { db.cart.Add(carrito); db.SaveChanges(); } catch (Exception ex) { estatus.success = false; estatus.errorMsg = ex.Message; } return(Json(estatus)); }
public ActionResult Adtocart(tbl_product pi, string qty, int Id) { tbl_product p = db.tbl_product.Where(x => x.pro_id == Id).SingleOrDefault(); cart c = new cart(); c.productid = p.pro_id; c.price = (float)p.pro_price; c.qty = Convert.ToInt32(qty); c.bill = c.price * c.qty; c.productname = p.pro_name; if (TempData["cart"] == null) { li.Add(c); TempData["cart"] = li; } else { List <cart> li2 = TempData["cart"] as List <cart>; li2.Add(c); TempData["cart"] = li2; } TempData.Keep(); return(RedirectToAction("Index")); }
public ActionResult AddToCart(String name) { menu r = null; cart c = new cart(); foreach (var i in t.menus) { if (name == i.name) { r = i; break; } } if (r == null) { return(HttpNotFound()); } else { c.name = r.name; c.free = r.free; c.price = r.price; t.carts.Add(c); t.SaveChanges(); return(RedirectToAction("Cart")); } }
public int Index(cart obj) { int qty; try { SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["EcommerceCon"].ConnectionString; if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "pSMWcartQty"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@mac", SqlDbType.VarChar).Value = obj.mac; cmd.Parameters.Add("@id", SqlDbType.VarChar).Value = obj.productId; qty = Convert.ToInt16(cmd.ExecuteScalar()); con.Close(); return(qty); } catch (Exception e) { return(0); } }
public void Index(cart a) { try { SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["EcommerceCon"].ConnectionString; if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "cartAdd"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@mac", SqlDbType.VarChar).Value = a.mac; cmd.Parameters.Add("@product_id", SqlDbType.VarChar).Value = a.productId; cmd.Parameters.Add("@cartProds", SqlDbType.Int).Value = Convert.ToInt32(a.cartProds); cmd.Parameters.Add("@amtDue", SqlDbType.Int).Value = Convert.ToInt32(a.amtDue); cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = a.username; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { } }
public void UpdateCart(string value, double price) { // string cs = @"URI=file:../cart.db"; // make this a static class!! // using var con = new SQLiteConnection(cs); // con.Open(); ConnectionString myConnection = new ConnectionString(); string cs = myConnection.cs; using var con = new MySqlConnection(cs); con.Open(); Console.WriteLine("I made it to the price and it is " + price); // cmd.CommandText = @"INSERT INTO cart(itemName, quantity, price) VALUES(@itemName, @quantity, @price)"; string stm = @"INSERT INTO cart(itemName, quantity, price) VALUES(@itemName, @quantity, @price)"; using var cmd = new MySqlCommand(stm, con); cmd.Parameters.AddWithValue("@itemName", value); cmd.Parameters.AddWithValue("@quantity", 1); cmd.Parameters.AddWithValue("@price", price); cmd.Prepare(); cmd.ExecuteNonQuery(); cart addparm = new cart() { itemName = value, quantity = 0, price = price }; addChickenParm.Add(addparm); }
public void Post([FromBody] cart value) { Console.WriteLine(value); iPostCart insertObject = new saveData(); insertObject.UpdateCart(value.itemName, value.price); }
public ActionResult AddToCart(int?id) { if (Session["email"] != null) { if (db.products.Find(id) != null) { var prod = db.products.Where(u => u.id == id).ToList(); cart cart = new cart(); cart.product = prod.Select(u => u.id).FirstOrDefault(); cart.user = int.Parse(Session["id"].ToString()); cart.Qte = 1; db.carts.Add(cart); db.SaveChanges(); return(Redirect("/products/Details/" + id)); } else { return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } } else { return(Redirect("/users/Login")); } }
public static void Add(cart value) { Console.WriteLine("made it to add"); int id = maxIDfinder.find(); Console.WriteLine(id); string cs = @"URI=file:../carttotals.db"; using var con = new SQLiteConnection(cs); con.Open(); var newQ = value.quantity + 1; var newP = 0.0; if (value.quantity == 0) { newP = value.price * newQ; } else { newP = (value.price / value.quantity) * newQ; } Console.WriteLine(value.price + " " + newQ); string stm = @$ "UPDATE carttotals set qhouse = {newQ}, phouse = {newP} WHERE orderID = @id"; using var cmd = new SQLiteCommand(stm, con); cmd.Parameters.AddWithValue("@id", id); cmd.Prepare(); cmd.ExecuteNonQuery(); con.Close(); }
protected void btnAdd_Click(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(Request.QueryString["id"])) { string clientId = Context.User.Identity.GetUserId(); if (clientId != null) { int id = Convert.ToInt32(Request.QueryString["id"]); int amount = Convert.ToInt32(ddlAmount.SelectedValue); cart cart = new cart { Amount = amount, ClientID = clientId, DatePurchased = DateTime.Now, IsInCart = true, ProductID = id }; CartModel model = new CartModel(); lblResult.Text = model.InsertCart(cart); } else { lblResult.Text = "Please Log in to order items"; } } }
public void addCartItem(int id, cart value) { // string cs = @"URI=file:../cart.db"; // using var con = new SQLiteConnection(cs); // con.Open(); ConnectionString myConnection = new ConnectionString(); string cs = myConnection.cs; using var con = new MySqlConnection(cs); con.Open(); var newQ = value.quantity + 1; var newP = (value.price / value.quantity) * newQ; Console.WriteLine(value.price + " " + newQ); string stm = @$ "UPDATE cart set quantity = {newQ}, price = {newP} WHERE cartid = @id"; using var cmd = new MySqlCommand(stm, con); cmd.Parameters.AddWithValue("@id", id); cmd.Prepare(); cmd.ExecuteNonQuery(); con.Close(); addChickenParm.Add(value); }
/* * 将专辑作为参数加入到购物车中,在 Cart 表中跟踪每个专辑的数量,在这个方法中,我们将会检查是在表中增加一个新行,还是仅仅在用户已经选择的专辑上增加数量。 */ public void AddToCart(album album) { Maticsoft.BLL.cart item = new Maticsoft.BLL.cart(); List <Maticsoft.DAL.SqlWhereClass> lssqlwhere = new List <Maticsoft.DAL.SqlWhereClass>(); Maticsoft.DAL.SqlWhereClass sqlwhere = new Maticsoft.DAL.SqlWhereClass("CartId", "CartId", Maticsoft.DAL.NetOperate.EQ, "'" + ShoppingCartid + "'"); lssqlwhere.Add(sqlwhere); sqlwhere = new Maticsoft.DAL.SqlWhereClass("AlbumId", "AlbumId", Maticsoft.DAL.NetOperate.EQ, album.AlbumId.ToString()); lssqlwhere.Add(sqlwhere); var CartItem = item.GetModel(lssqlwhere); if (CartItem == null) { CartItem = new cart { AlbumId = album.AlbumId, CartId = ShoppingCartid, Count = 1, DateCreated = DateTime.Now }; item.Add(CartItem); } else { CartItem.Count++; item.Update(CartItem); } }
protected void Button2_Click(object sender, EventArgs e) { int i = int.Parse(Request.QueryString["id"]); int qnty = int.Parse(TextBox1.Text); if (int.Parse(TextBox1.Text) != 0) { int cost = int.Parse(TextBox1.Text) * (int.Parse(Label6.Text)); shoppingDataContext sdc2 = new shoppingDataContext(); cart cart = new cart() { quantity = int.Parse(TextBox1.Text), total_cost = cost, cust_id = int.Parse(Session["cust"].ToString()), prod_id = int.Parse(Request.QueryString["id"]) }; sdc2.carts.InsertOnSubmit(cart); sdc2.SubmitChanges(); Label12.Text = "Successfully Added.."; } else { Label12.Text = "Plz select quntity"; } }
partial void Insertcart(cart instance);
partial void Updatecart(cart instance);
public void UpdateCate(cart ca) { try { LQDataContext ctxx = new LQDataContext(); var q = ctxx.carts.Where(d => d.id_cart == ca.id_cart).SingleOrDefault(); q.time_cart = ca.time_cart; ctxx.SubmitChanges(); } catch (Exception ex) { } }
private void attach_carts(cart entity) { this.SendPropertyChanging(); entity.cust = this; }
partial void Deletecart(cart instance);
public void add_cart() { if (c != null) { cartss = new cart(); cartss.id_cus = c.id_cus; cartss.time_cart = DateTime.Now; rp.AddCart(cartss); } }
private void detach_carts(cart entity) { this.SendPropertyChanging(); entity.cust = null; }
public bool AddCart(cart ca) { LQDataContext ctxs = new LQDataContext(); ctxs.carts.InsertOnSubmit(ca); ctxs.SubmitChanges(); return true; }