Пример #1
0
        public ActionResult Edit(Models.Product postback, HttpPostedFileBase file)
        {
            string Picture = null;

            if (file != null)
            {
                Picture = System.IO.Path.GetFileName(file.FileName);
                string path = System.IO.Path.Combine(Server.MapPath("~/images/"), Picture);
                // file is uploaded
                file.SaveAs(path);
            }
            postback.DefaultImageURL = file != null ? Picture : postback.DefaultImageURL;
            if (this.ModelState.IsValid)
            {
                using (Models.PlymouthEntities db = new Models.PlymouthEntities())
                {
                    var result = (from s in db.Products where s.Id == postback.Id select s).FirstOrDefault();

                    result.Name            = postback.Name; result.Price = postback.Price;
                    result.PublishDate     = postback.PublishDate; result.Quantity = postback.Quantity;
                    result.Status          = postback.Status; result.CategoryId = postback.CategoryId;
                    result.DefaultImageId  = postback.DefaultImageId; result.Description = postback.Description;
                    result.DefaultImageURL = postback.DefaultImageURL;

                    db.SaveChanges();

                    TempData["ResultMessage"] = String.Format("Product {0} has been successfully edited", postback.Name);
                    return(RedirectToAction("Index"));
                }
            }
            else
            {
                return(View(postback));
            }
        }
Пример #2
0
        public ActionResult Create(Models.Product postback, HttpPostedFileBase File)
        {
            string Picture = null;

            if (File != null)
            {
                Picture = System.IO.Path.GetFileName(File.FileName);
                string path = System.IO.Path.Combine(Server.MapPath("~/images/"), Picture);
                // file is uploaded
                File.SaveAs(path);
            }
            postback.DefaultImageURL = Picture;
            if (this.ModelState.IsValid)
            {
                using (Models.PlymouthEntities db = new Models.PlymouthEntities())
                {
                    db.Products.Add(postback);
                    db.SaveChanges();
                    TempData["ResultMessage"] = String.Format("Product {0} has been successfully created", postback.Name);
                    return(RedirectToAction("Index"));
                }
            }
            ViewBag.ResultMessage = "Information not correct, please check.";
            return(View());
        }
        public ActionResult Delete(int id)
        {
            using (Models.PlymouthEntities db = new Models.PlymouthEntities())
            {
                var result = (from s in db.OrderDetails
                              where s.OrderId == id
                              select s).FirstOrDefault();
                var result1 = (from s in db.Orders
                               where s.Id == id
                               select s).FirstOrDefault();
                if (result != default(Models.OrderDetail))
                {
                    db.OrderDetails.Remove(result);
                    db.Orders.Remove(result1);
                    db.SaveChanges();

                    TempData["ResultMessage"] = String.Format("Order {0} has been deleted succesfully.", result.Id);
                    return(RedirectToAction("Index"));
                }
                else
                {
                    TempData["resultMessage"] = "Record not found, cannot be deleted, please check.";
                    return(RedirectToAction("Index"));
                }
            }
        }
Пример #4
0
        public ActionResult Index(Models.OrderModel.Table postback)
        {
            if (this.ModelState.IsValid)
            {
                var currentcart = Models.Cart.Operation.GetCurrentCart();
                var userId      = HttpContext.User.Identity.GetUserId();

                using (Models.PlymouthEntities db = new Models.PlymouthEntities())
                {
                    var order = new Models.Order()
                    {
                        UserId      = userId,
                        TableNumber = postback.TableNumber
                    };
                    db.Orders.Add(order);
                    db.SaveChanges();

                    var orderDetails = currentcart.ToOrderDetailList(order.Id);

                    db.OrderDetails.AddRange(orderDetails);
                    db.SaveChanges();
                }
                return(Content("Order Sucess!"));
            }
            return(View());
        }
Пример #5
0
 public ActionResult Index()
 {
     using (Models.PlymouthEntities db = new Models.PlymouthEntities())
     {
         var result = (from s in db.Products select s).ToList();
         return(View(result));
     }
 }
Пример #6
0
        public ActionResult Index()
        {
            List <Models.Product> result = new List <Models.Product>();

            ViewBag.ResultMessage = TempData["ResultMessage"];

            using (Models.PlymouthEntities db = new Models.PlymouthEntities())
            {
                result = (from s in db.Products select s).ToList();
                return(View(result));
            }
        }
Пример #7
0
        public ActionResult MyOrder()
        {
            var userId = HttpContext.User.Identity.GetUserId();

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

                return(View(result));
            }
        }
Пример #8
0
 public ActionResult Edit(int id)
 {
     using (Models.PlymouthEntities db = new Models.PlymouthEntities())
     {
         var result = (from s in db.Products where s.Id == id select s).FirstOrDefault();
         if (result != default(Models.Product))
         {
             return(View(result));
         }
         else
         {
             TempData["ResultMessage"] = "Information not correct, please check.";
             return(RedirectToAction("Index"));
         }
     }
 }
        public ActionResult Details(int id)
        {
            using (Models.PlymouthEntities db = new Models.PlymouthEntities())
            {
                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));
                }
            }
        }