/// <summary> /// 用户的详细信息页面 /// </summary> /// <returns></returns> public ActionResult Me() { if (!IsLogined()) { return(Content("<script>alert('请登录');window.location.href='/Users/Login'</script>")); } ViewBag.TitleBar = "我的"; //通过Session获取id,不能通过url地址来获取 string id = Session["UserId"].ToString(); ////1.对id进行合法性验证 int userid; if (!int.TryParse(id, out userid)) { return(Content("<script>alert('参数不合法');window.location.href='/Users/Login'</script>")); } //2.查询该id对应的用户信息 using (ShoppingEntities dc = new ShoppingEntities()) { Users entity = dc.Users.FirstOrDefault(u => u.UserID == userid); if (entity != null)//查询到该用户 { return(View(entity)); } else//查询不到该用户 { return(Redirect("/Users/Index")); } } }
public ActionResult MySellProduct() { //1. 先判断用户是否登录了 if (!IsLogined()) { return(Content("<script>alert('请登录');window.location.href='/Users/Login'</script>")); } //通过Session获取id,不能通过url地址来获取 string id = Session["UserId"].ToString(); //2.对id进行合法性验证 int userid; if (!int.TryParse(id, out userid)) { return(Content("<script>alert('参数不合法');window.location.href='/Users/Login'</script>")); } //3. 查询订单表,通过卖家id来判断,还添加了评价 using (ShoppingEntities dc = new ShoppingEntities()) { List <Dictionary <String, Object> > sellList = new List <Dictionary <String, Object> >(); var tradeList = dc.TradeRecord.Where(tra => tra.UserSellID == userid).ToList(); foreach (var trade in tradeList) { sellList.Add(ProductObjectToJson.Convert(trade.Product, trade)); } Dictionary <String, Object> retJson = new Dictionary <String, Object>(); retJson.Add("total", sellList.Count()); retJson.Add("products", sellList); return(Json(retJson, JsonRequestBehavior.DenyGet)); } }
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 ProductDetails(int id) { var db = new ShoppingEntities(); Product pro = db.Products.Find(id); return(View(pro)); }
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 async Task <Response <bool> > UpdateCategory(CategoryViewModel cat) { Response <bool> response = new Response <bool>(); try { using (var dc = new ShoppingEntities()) { var query = dc.spUpdCategory(cat.CategoryID, cat.CategoryName, cat.CategoryDescription, cat.CategoryImage, cat.CategoryDateCreated); if (query == -1) { response.Count = 1; response.Message = null; response.Result = true; } else { response.Count = 0; response.Message = "No se actualizo"; response.Result = false; } } return(response); } catch (Exception ex) { response.Count = 0; response.Message = ex.Message; response.Result = false; return(response); } }
public async Task <Response <bool> > InsertUser(UserViewModel user) { Response <bool> response = new Response <bool>(); try { using (var dc = new ShoppingEntities()) { var query = dc.spInsUser(user.UserName, user.UserLastName, user.UserAddress, user.UserSex, user.UserEmail, user.UserPassword, user.UserLatitude, user.UserLongitude, user.UserImage, user.UserType, true); if (query == -1) { response.Count = 1; response.Result = true; response.Message = null; } else { response.Count = 0; response.Result = false; response.Message = "No se inserto"; } } return(response); } catch (Exception ex) { response.Count = 0; response.Result = false; response.Message = ex.Message; return(response); } }
// // GET: /Order/ #region 返回订单页面 public ActionResult Index() { //1. 登录判断 if (!IsLogined()) { return(Content("<script>alert('请登录');window.location.href='/Users/Login'</script>")); } //通过Session 获取用户的id int userId = 0; if (!int.TryParse(Session["UserId"].ToString(), out userId)) { return(Content("<script>alert('请登录');window.location.href='/Users/Login'</script>")); } ShoppingEntities se = new ShoppingEntities(); Users user = se.Users.FirstOrDefault(u => u.UserID == userId); userId = user.UserID; //通过用户的ID查到产品 var order = se.TradeRecord.Where(tra => tra.UserBuyID == userId).ToList(); ViewBag.title = "我的订单"; ViewBag.Id = userId; return(View(order)); }
public async Task <Response <bool> > Authenticate(string email, string password) { Response <bool> response = new Response <bool>(); try { using (var dc = new ShoppingEntities()) { var query = dc.spSelUser(email, password).FirstOrDefault(); if (query != null) { response.Count = 1; response.Result = true; response.Message = null; } else { response.Count = 0; response.Result = false; response.Message = "No se encotro el usuario"; } } return(response); } catch (Exception ex) { response.Count = 0; response.Result = false; response.Message = ex.Message; return(response); } }
public ActionResult Index() { var db = new ShoppingEntities(); var lista = db.Listas.FirstOrDefault(l => l.Aberta); return(View(lista)); }
public UserController(ShoppingEntities shoppingEntities, IUltilityService ultilityService , INotificationService notificationService) { this.shoppingEntities = shoppingEntities; this.notificationService = notificationService; this.ultilityService = ultilityService; }
public async Task <Response <bool> > DeleteCategory(Guid categoryID) { Response <bool> response = new Response <bool>(); try { using (var dc = new ShoppingEntities()) { var query = dc.spDelCategory(categoryID); if (query == -1) { response.Count = 1; response.Message = null; response.Result = true; } else { response.Count = 0; response.Message = "No se elimino"; response.Result = false; } } return(response); } catch (Exception ex) { response.Count = 0; response.Message = ex.Message; response.Result = false; return(response); } }
public ActionResult DeleteProduct(int id) { var db = new ShoppingEntities(); Product p = db.Products.Find(id); return(View(p)); }
public IHttpActionResult CompleteOrder(int OrderID) { if (OrderDataValidation.ValidateOpenOrder(OrderID)) { if (!CartDataValidation.ValidateEmptyCart(OrderID)) { using (ShoppingEntities entity = new ShoppingEntities()) { using (ShoppingDiscount total = new ShoppingDiscount()) { entity.Orders.First(o => o.O_ID == OrderID).O_TotalAmount = total.TotalAfterDiscount(OrderID); entity.Orders.First(o => o.O_ID == OrderID).O_Status = ShoppingData.CloseOrderStatus; entity.SaveChanges(); return(Ok("Total Amount after Discount = " + total.TotalAfterDiscount(OrderID))); } } } else { return(BadRequest("There is no item in cart")); } } else { return(BadRequest("Invalid OrderID")); } }
/// <summary> /// 判断用户是否登录或登录过 /// </summary> /// <returns></returns> public Boolean IsLogined() { //判断是否有 cookie if (Request.Cookies["isremember"] != null) { //将Cookie中保存的用户id读取出来,存储到Session中 string idStr = Request.Cookies["isremember"].Value; int userid; if (!int.TryParse(idStr, out userid)) { return(false); } //通过id查询数据库获取用户名 using (ShoppingEntities dc = new ShoppingEntities()) { Users model = dc.Users.FirstOrDefault(u => u.UserID == userid); Session["LoginUser"] = model.UserName; Session["UserId"] = model.UserID; //返回登录后的用户头像地址 Session["userIcon"] = model.UserIcon; } return(true); } // 判断是否有 Session if (Session["LoginUser"] != null) { return(true); } return(false); }
public ActionResult Login(user u) { using (ShoppingEntities se = new ShoppingEntities()) { var isSuccess = (from user in se.users where u.username == user.username && u.password == user.password select user.userid).Any(); if (isSuccess) { var userData = (from user in se.users where u.username == user.username && u.password == user.password select user).First(); Session["CurrentUserID"] = userData.userid; CurrentUserID = userData.userid; if (userData.userid == 1) { return(RedirectToAction("Success", "Login")); } else { return(RedirectToAction("NonAdmin", "Login")); } } else { ViewBag.loginMessage = "Incorrect username or password"; } } return(View()); }
//管理员删除产品操作 public ActionResult Delete(String id) { //1、检查参数id的合法性 string -> int int productId; if (!int.TryParse(id, out productId)) { return(Content("<script>alert('参数不合法');window.location.href='/AdminProduct/Index'</script>")); } //2、使用EF删除产品 using (ShoppingEntities dc = new ShoppingEntities()) { //1、先查询 Product entity = dc.Product.FirstOrDefault(p => p.ProID == productId); //2、后删除 dc.Product.Remove(entity); //3、保存回数据库中 if (dc.SaveChanges() > 0) { return(Content("<script>alert('产品下架成功!');window.location.href='/AdminProduct/Index'</script>")); } else { return(Content("<script>alert('产品下载失败!');window.location.href='/AdminProduct/Index'</script>")); } } }
public ActionResult ViewCart() { List <CartProduct> productsInCart = new List <CartProduct>(); using (ShoppingEntities se = new ShoppingEntities()) { var ProductDetails = (from cartTbl in se.carts where cartTbl.userid == CurrentUserID select cartTbl).ToList(); if (ProductDetails == null) { ViewBag.NoProductsFound = "Your Cart Is Empty!"; } else { 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.Quantity = (int)product.quantity; cp.Product = ProductInCart; productsInCart.Add(cp); } } ViewBag.ProductList = productsInCart; } return(View()); }
public ActionResult ListProducts() { var db = new ShoppingEntities(); var q = (from product in db.Products select product); return(View(q)); }
public ActionResult Product() { ViewBag.Message = "Products page."; var db = new ShoppingEntities(); var q = from s in db.Products select s; return(View(q)); }
/// <summary> /// 检查用户账号的唯一性 /// </summary> /// <param name="useraccount">传入的账号参数名必须与模型类的属性名保持一致</param> /// <returns>JSON数据,值为true,表示用户账号可以使用,值为false,表示用户名不可以使用</returns> public ActionResult CheckUserAccount(string useraccount) { using (ShoppingEntities dc = new ShoppingEntities()) { //在Users表中,查询UserAccount字段等于输入的参数值的记录个数,个数为0则表示true,个数不为0则表示false bool result = dc.Users.Count(u => u.UserAccount == useraccount) == 0; return(Json(result, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// 用户添加收藏,需要登录 /// </summary> /// <param name="pid">产品id</param> /// <returns></returns> /// AddFavorite public ActionResult AddFavorite(string pid) { if (!IsLogined()) { return(Content("<script>alert('请登录才可以收藏');window.location.href='/Users/Login'</script>")); } int proId = 0; if (!int.TryParse(pid, out proId)) { return(Content("<script>alert('查询查询错误');window.location.href='/Users/Me'</script>")); } //获取用户id int userId; if (!int.TryParse(Session["UserId"].ToString(), out userId)) { return(Content("<script>alert('请登录');window.location.href='/Users/Login'</script>")); } //添加收藏 using (ShoppingEntities dc = new ShoppingEntities()) { var favoriteEntity = new Favorite(); favoriteEntity.FavUID = userId; favoriteEntity.FavPID = proId; //发布用户不可以收藏自己的产品 var productEntity = dc.Product.FirstOrDefault(p => p.ProID == proId); if (productEntity.ProWhoUser == userId) { return(Content("<script>alert('不可以收藏自己的产品');window.location.href='/Product/Detail/" + pid + "'</script>")); } //收藏前先判断是否有重复收藏 var favRet = dc.Favorite.FirstOrDefault(fav => fav.FavPID == proId && fav.FavUID == userId); if (favRet != null) { return(Content("<script>alert('不可以重复收藏');window.location.href='/Product/Detail/" + pid + "'</script>")); } else { dc.Favorite.Add(favoriteEntity); if (dc.SaveChanges() > 0) { return(Content("<script>alert('收藏成功');window.location.href='/Product/Detail/" + pid + "'</script>")); } else { return(Content("<script>alert('收藏失败');window.location.href='/Product/Detail" + pid + "'</script>")); } } } }
public ActionResult DeleteConfirmed(int id) { var db = new ShoppingEntities(); Product p = db.Products.Find(id); db.Products.Remove(p); db.SaveChanges(); return(RedirectToAction("ListProducts")); }
public ActionResult ViewProducts() { IEnumerable <product> productList; using (ShoppingEntities se = new ShoppingEntities()) { productList = (from product in se.products where product.isactive != false select product).ToList(); } return(View(productList)); }
public ActionResult AddProducts(product p) { using (ShoppingEntities se = new ShoppingEntities()) { se.products.Add(p); se.SaveChanges(); } return(View()); }
public ActionResult Register(user u) { using (ShoppingEntities se = new ShoppingEntities()) { se.users.Add(u); se.SaveChanges(); } return(View()); }
public ActionResult SetNewPassword(user u) { using (ShoppingEntities se = new ShoppingEntities()) { if (u.password == u.ConfirmPassword) { } } return(View()); }
public ActionResult DeleteProductFromCart(int DelProd) { using (ShoppingEntities se = new ShoppingEntities()) { var RemoveFromCart = (from RemoveElement in se.carts where RemoveElement.productid == DelProd select RemoveElement).First(); se.carts.Remove(RemoveFromCart); se.SaveChanges(); } return(RedirectToAction("ViewCart")); }
public ActionResult EditProduct(int prodID) { product existingProduct = new product(); using (ShoppingEntities se = new ShoppingEntities()) { existingProduct = (from p1 in se.products where prodID == p1.productid select p1).First(); } return(View(existingProduct)); }
public ActionResult ProductDescription(int prodID) { string description = ""; using (ShoppingEntities se = new ShoppingEntities()) { description = (from des in se.products where prodID == des.productid select des.productdescription).First(); } ViewBag.Data = description; return(View()); }