예제 #1
0
        public ActionResult SerachByUserName(string name)
        {
            string searchUserId = null;

            using (Models.UserEntities db = new Models.UserEntities())   //查詢目前網站使用者暱稱符合UserName的UserId
            {
                searchUserId = (from s in db.AspNetUsers
                                where s.UserName == name
                                select s.Id).FirstOrDefault();
            }



            if (!String.IsNullOrEmpty(searchUserId))
            {
                using (Models.ItemEntities db = new Models.ItemEntities())    //如果有存在UserId則將此UserId的所有訂單找出
                {
                    var result = (from s in db.Orders
                                  where s.UserId == searchUserId
                                  select s).ToList();

                    return(View("Index", result));
                }
            }
            else
            {
                return(View("Index", new List <Models.Order>()));
            }
        }
예제 #2
0
        public ActionResult Edit(Models.Product postinfo)
        {
            if (this.ModelState.IsValid)
            {
                using (Models.ItemEntities db = new Models.ItemEntities())
                {
                    var result = (from s in db.Products where s.Id == postinfo.Id select s).FirstOrDefault();
                    result.Name             = postinfo.Name;
                    result.PublishDate      = postinfo.PublishDate;
                    result.Status           = postinfo.Status;
                    result.Price            = postinfo.Price;
                    result.Quantity         = postinfo.Quantity;
                    result.CategoryID       = postinfo.CategoryID;
                    result.Description      = postinfo.Description;
                    result.DefaultImageId   = postinfo.DefaultImageId;
                    result.DefaultImageName = postinfo.DefaultImageName;

                    db.SaveChanges();
                    TempData["ResultMsg"] = string.Format("商品[{0}]成功修改", postinfo.Name);
                    return(RedirectToAction("Index"));
                }
            }
            else
            {
                return(View(postinfo));
            }
        }
예제 #3
0
        [Authorize] // 登入會員才可留言
        public ActionResult AddComment(int id, string Content)
        {
            var userId = HttpContext.User.Identity.GetUserId();     //取得目前登入使用者Id



            var currentDateTime = DateTime.Now;

            var comment = new Models.ProductCommet()
            {
                ProductId  = id,
                Content    = Content,
                UserId     = userId,
                CreateDate = currentDateTime,
                UserName   = User.Identity.GetUserName()
            };

            using (Models.ItemEntities db = new Models.ItemEntities())
            {
                db.ProductCommets.Add(comment);
                db.SaveChanges();
            }

            return(RedirectToAction("Details", new { id = id }));
        }
예제 #4
0
 public ActionResult Index()
 {
     using (Models.ItemEntities db = new Models.ItemEntities())
     {
         var result = (from s in db.Products select s).ToList();
         return(View(result));
     }
 }
예제 #5
0
        public ActionResult ShowAll()
        {
            using (Models.ItemEntities db = new Models.ItemEntities())
            {
                var result = (from s in db.Orders select s).ToList();

                return(View("Index", result));
            }
        }
예제 #6
0
        public ActionResult MyOrder()
        {
            var UserId = HttpContext.User.Identity.GetUserId();

            using (Models.ItemEntities db = new Models.ItemEntities())
            {
                var result = (from s in db.Orders where s.UserId == UserId select s).ToList();

                return(View(result));
            }
        }
예제 #7
0
        public ActionResult MyOrderDetail(int id)
        {
            using (Models.ItemEntities db = new Models.ItemEntities())
            {
                var result = (from s in db.OrderDetails where s.OrderId == id select s).ToList();

                if (result.Count == 0)
                {
                    return(RedirectToAction("Index"));
                }
                else
                {
                    return(View(result));
                }
            }
        }
예제 #8
0
 public ActionResult Edit(int id)
 {
     using (Models.ItemEntities db = new Models.ItemEntities())
     {
         var result = (from s in db.Products where s.Id == id select s).FirstOrDefault();
         if (result != default(Models.Product))  //驗證是否有資料存在
         {
             return(View(result));
         }
         else
         {
             TempData["ResultMsg"] = "資料有誤";
             return(RedirectToAction("Index"));
         }
     }
 }
예제 #9
0
        public ActionResult Details(int id)
        {
            using (Models.ItemEntities db = new Models.ItemEntities())
            {
                var result = (from s in db.Products
                              where s.Id == id
                              select s).FirstOrDefault();

                if (result == default(Models.Product))
                {
                    return(RedirectToAction("Index"));
                }
                else
                {
                    return(View(result));
                }
            }
        }
예제 #10
0
        public ActionResult Creat(Models.Product postinfo)
        {
            if (this.ModelState.IsValid)
            {
                using (Models.ItemEntities db = new Models.ItemEntities())
                {
                    postinfo.DefaultImageName = postinfo.DefaultImageName + ".png";
                    db.Products.Add(postinfo);
                    db.SaveChanges();

                    TempData["ResultMsg"] = string.Format("商品[{0}]成功建立", postinfo.Name);
                }
                return(RedirectToAction("Index"));
            }

            ViewBag.ResultMessage = "資料有誤";

            return(View(postinfo));
        }
예제 #11
0
 public ActionResult Delete(int id)
 {
     using (Models.ItemEntities db = new Models.ItemEntities())
     {
         var result = (from s in db.Products where s.Id == id select s).FirstOrDefault();
         if (result != default(Models.Product))  //資料判斷有無
         {
             db.Products.Remove(result);
             db.SaveChanges();
             TempData["ResultMsg"] = string.Format("商品[{0}]成功刪除", result.Name);
             return(RedirectToAction("Index"));
         }
         else
         {
             TempData["ResultMsg"] = "指定資料不存在";
             return(RedirectToAction("Index"));
         }
     }
 }
예제 #12
0
        public ActionResult Index()
        {
            var userName = User.Identity.GetUserName();

            if (userName == "Admin")
            {
                using (Models.ItemEntities db = new Models.ItemEntities())
                {
                    var result = (from s in db.Orders select s).ToList();

                    return(View(result));
                }
            }

            else
            {
                return(Content("<script>alert('權限不足 滾啦!');history.go(-1);</script>"));
                //return Content("<script>alert('權限不足 滾啦!');window.location.href='../Home/Index';</script>");
            }
        }
예제 #13
0
        public ActionResult Index()
        {
            var userName = User.Identity.GetUserName();

            if (userName == "Admin")
            {
                List <Models.Product> result = new List <Models.Product>();

                ViewBag.ResultMessage = TempData["ResultMsg"];

                using (Models.ItemEntities db = new Models.ItemEntities())
                {
                    result = (from s in db.Products select s).ToList();
                    return(View(result));
                }
            }
            else
            {
                return(Content("<script>alert('權限不足 滾啦!');history.go(-1);</script>"));
                //return Content("<script>alert('權限不足 滾啦!');window.location.href='../Home/Index';</script>");
                //return Redirect("/Home/Index");
            }
        }
예제 #14
0
        public ActionResult Index(Models.OrderModel.Ship postback)
        {
            if (this.ModelState.IsValid)
            {
                var currentcart = Models.Cart.Operation.GetCurrentCart();//取得目前購物車


                var userId = HttpContext.User.Identity.GetUserId();//取得登入使用者Id

                using (Models.ItemEntities db = new Models.ItemEntities())
                {
                    var order = new Models.Order()
                    {
                        UserId          = userId,
                        RecieverName    = postback.RecieverName,
                        RecieverPhone   = postback.RecieverPhone,
                        RecieverAddress = postback.RecieverAddress
                    };

                    db.Orders.Add(order);   //加其入Orders資料表後,儲存變更
                    db.SaveChanges();


                    var orderDetails = currentcart.ToOrderDetailList(order.Id);//取得購物車中OrderDetai物件


                    db.OrderDetails.AddRange(orderDetails);//將其加入OrderDetails資料表後,儲存變更
                    db.SaveChanges();
                }

                var currentCart = Models.Cart.Operation.GetCurrentCart();
                currentCart.ClearCart();
                return(Redirect("/Order/MyOrder"));
            }
            return(View());
        }