public ActionResult Submit(int id) { //1. 登录判断 if (!IsLogined()) { return(Content("<script>alert('请登录');window.location.href='/Users/Login'</script>")); } //往数据库的表中修改内容 using (ShoppingEntities se = new ShoppingEntities()) { string text = Request.Form["text"]; TradeRecord order = se.TradeRecord.FirstOrDefault(u => u.TraPID == id); //判断是否提交过评论 if (order.TraComment == null) { var entry = se.Entry(order); entry.State = System.Data.EntityState.Unchanged; entry.Property("TraComment").IsModified = true; order.TraComment = text; if (se.SaveChanges() > 0) { return(Content("<script>alert('提价评价成功!');window.location.href='/Order/Index';</script>")); } else { return(Content("<script>alert('提价评价失败!');window.location.href='/Order/Index';</script>")); } } else { return(Content("<script>alert('已经提交过评论了,请勿重复提交!');window.location.href='/Order/Index';</script>")); } } }
public ActionResult UpdateProduct(Product p) { WebImage photo = null; var newFileName = ""; var imagePath = ""; var imageThumbPath = ""; photo = WebImage.GetImageFromRequest(); if (photo != null) { newFileName = Path.GetFileName(photo.FileName); imagePath = @"images/Products/" + newFileName; photo.Save(@"~/" + imagePath); imageThumbPath = @"images/Products/thumbnails/" + newFileName; photo.Resize(width: 165, height: 35, preserveAspectRatio: false, preventEnlarge: true); photo.Save(@"~/" + imageThumbPath); } var db = new ShoppingEntities(); var im = "/" + imagePath; var im1 = "/" + imageThumbPath; p.Img = im; p.Thumbnail = im1; db.Entry(p).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ListProducts")); }
public ActionResult Edit([Bind(Include = "ShoppingID,ShoppingName,Address,Phone")] Shopping shopping) { if (ModelState.IsValid) { db.Entry(shopping).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(shopping)); }
public ActionResult Edit([Bind(Include = "ID,Nome,Latitude,Longitude")] Loja loja) { if (ModelState.IsValid) { db.Entry(loja).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(loja)); }
public ActionResult Edit([Bind(Include = "ID,Data,Descricao,LojaID, Aberta")] Lista lista) { if (ModelState.IsValid) { db.Entry(lista).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.LojaID = new SelectList(db.Lojas, "ID", "Nome", lista.LojaID); return(View(lista)); }
public ActionResult Edit([Bind(Include = "ID,CategoriaID,Nome,Unidade,QtdNormal,MarcasSim,MarcasNao,ListaPadrao")] Produto produto) { if (ModelState.IsValid) { db.Entry(produto).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoriaID = new SelectList(db.Categorias, "ID", "Nome", produto.CategoriaID); return(View(produto)); }
public ActionResult Edit([Bind(Include = "ProductID,Name,Price,Description,ImageURL,CategoryID")] Product product) { if (ModelState.IsValid) { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CName", product.CategoryID); return(View(product)); }
public ActionResult DeleteProduct(int prodID) { using (ShoppingEntities se = new ShoppingEntities()) { var existingProduct = (from p1 in se.products where prodID == p1.productid select p1).First(); existingProduct.isactive = false; se.Entry(existingProduct).State = EntityState.Modified; se.SaveChanges(); } return(RedirectToAction("ViewProducts")); }
public async Task <ActionResult> Edit([Bind(Include = "ItemId,Name,Price,Description,LocationId,Stock")] Item item) { if (ModelState.IsValid) { db.Entry(item).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "Name", item.LocationId); return(View(item)); }
public ActionResult Edit(Users entity) { string intro = entity.UserIntro; entity.UserIntro = intro.Trim(); using (ShoppingEntities dc = new ShoppingEntities()) { //获取entity实体的状态 var entry = dc.Entry(entity); entry.State = System.Data.EntityState.Unchanged; //指定修改的属性 entry.Property("UserName").IsModified = true; entry.Property("UserGender").IsModified = true; entry.Property("UserAddress").IsModified = true; entry.Property("UserIntro").IsModified = true; entry.Property("UserPhone").IsModified = true; //dc.Entry<Users>(entity).State = EntityState.Modified; //try { dc.Configuration.ValidateOnSaveEnabled = false; //保存回数据库中 if (dc.SaveChanges() > 0) { dc.Configuration.ValidateOnSaveEnabled = true; return(Content("<script>alert('修改成功');window.location.href='/Users/Me'</script>")); } else { return(Content("<script>alert('修改失败');window.location.href='/Users/Edit'</script>")); } } //catch (Exception e) //{ // String str = e.Message; // return Content("<script>alert('" + str + "');window.location.href='/Users/Me'</script>"); //} } }
public ActionResult EditProduct(product p) { using (ShoppingEntities se = new ShoppingEntities()) { var existingProduct = (from p1 in se.products where p.productid == p1.productid select p1).First(); if (existingProduct != null) { existingProduct.productname = p.productname; existingProduct.productdescription = p.productdescription; existingProduct.productprice = p.productprice; existingProduct.productimage = p.productimage; existingProduct.productcount = p.productcount; se.Entry(existingProduct).State = EntityState.Modified; se.SaveChanges(); } else { return(View()); } } return(View()); }
public ActionResult AddToCart(int prodID) { int LoggedInUserID = CurrentUserID; List <CartProduct> prodList = new List <CartProduct>(); using (ShoppingEntities se = new ShoppingEntities()) { var existingProduct = (from cartTbl in se.carts where cartTbl.userid == CurrentUserID && cartTbl.productid == prodID select cartTbl).FirstOrDefault(); if (existingProduct != null) { existingProduct.quantity = existingProduct.quantity + 1; se.Entry(existingProduct).State = EntityState.Modified; se.SaveChanges(); } else { cart cart = new cart(); int defaultItemQuantity = 1; cart.productid = prodID; cart.quantity = defaultItemQuantity; cart.userid = LoggedInUserID; se.carts.Add(cart); se.SaveChanges(); } var ProductDetails = (from cartTbl in se.carts where cartTbl.userid == CurrentUserID select cartTbl).ToList(); foreach (var product in ProductDetails) { var ProductInCart = (from prodTbl in se.products where prodTbl.productid == product.productid select prodTbl).First(); CartProduct cp = new CartProduct(); cp.Product = ProductInCart; cp.Quantity = (int)product.quantity; prodList.Add(cp); } ViewBag.ProductList = prodList; } return(View()); }
/// <summary> /// 删除订单,因为数据量少,暂时不给操作 /// </summary> /// <param name="Pid"></param> /// <returns></returns> public ActionResult Delete(int Pid) { ShoppingEntities se = new ShoppingEntities(); TradeRecord entity = se.TradeRecord.FirstOrDefault(u => u.TraPID == Pid); se.TradeRecord.Remove(entity); //修改买卖状态 Product pro = se.Product.FirstOrDefault(u => u.ProID == Pid); var entry = se.Entry(pro); entry.State = System.Data.EntityState.Unchanged; entry.Property("ProIsSell").IsModified = true; pro.ProIsSell = false; if (se.SaveChanges() > 0) { return(Content("<script>alert('删除订单成功!');window.location.href='/Order/Index'</script>")); } else { return(Content("<script>alert('删除订单失败!');window.location.href='/Order/Index'</script>")); } }
public ActionResult Detail(string proId, string sellerId) { //1. 登录判断 if (!IsLogined()) { return(Content("<script>alert('请登录');window.location.href='/Users/Login'</script>")); } int pid = 0; if (!int.TryParse(proId, out pid)) { return(Content("<script>alert('购买失败!');window.location.href='/Home/Index'</script>")); } string backUrl = "/Product/Detail/" + pid; //该产品的发布者 int sellId = 0; if (!int.TryParse(sellerId, out sellId)) { return(Content("<script>alert('购买失败!');window.location.href='" + backUrl + "'</script>")); } using (ShoppingEntities se = new ShoppingEntities()) { //查询是否有指定的产品 var proEntity = se.Product.FirstOrDefault(p => p.ProID == pid); if (proEntity == null) { return(Content("<script>alert('没有该产品!');window.location.href='/Home/Index'</script>")); } //查询该产品是否是指定的发布用户 var userEntity = se.Product.FirstOrDefault(p => p.ProWhoUser == sellId); if (userEntity == null) { return(Content("<script>alert('卖家没有发布过这个产品!');window.location.href='/Home/Index'</script>")); } //修改product表中的字段,让该 product 下架 var entry = se.Entry(proEntity); entry.State = System.Data.EntityState.Unchanged; entry.Property("ProIsSell").IsModified = true; proEntity.ProIsSell = true; //创建订单 TradeRecord tradeEntity = new TradeRecord(); //获取当前用户的id int buyUserId = 0; if (!int.TryParse(Session["UserId"].ToString(), out buyUserId)) { return(Content("<script>alert('请登录');window.location.href='/Users/Login'</script>")); } //买家和卖家不能是同一个人 if (sellId == buyUserId) { return(Content("<script>alert('不能购买自己发布的商品');window.location.href='" + backUrl + "'</script>")); } //订单需要的字段:产品id, 买家id, 卖家id tradeEntity.UserBuyID = buyUserId; tradeEntity.UserSellID = sellId; tradeEntity.TraPID = pid; //需要指定购买时间(不设置的话有坑) tradeEntity.TraBuyTime = DateTime.Now; //添加到数据库 se.TradeRecord.Add(tradeEntity); if (se.SaveChanges() > 0) { return(Content("<script>alert('购买成功!');window.location.href='/Order/Index';</script>")); } else { return(Content("<script>alert('购买失败!');window.location.href='/Home/Index'</script>")); } } }