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