Beispiel #1
0
        public ActionResult AddFoodToCart(String FoodID, String Size)
        {
            List <OrderDetail> mycart = (List <OrderDetail>)Session[CART_STRING];

            if (mycart == null)
            {
                mycart = new List <OrderDetail>();
            }

            OrderDetail item = new OrderDetail {
                FoodID = FoodID, Size = Size
            };

            if (mycart.Exists(o => o.FoodID == FoodID && o.Size == Size))
            {
                //plus quantity with 1
                int index       = mycart.FindIndex(o => o.FoodID == item.FoodID && o.Size == item.Size);
                int oldquantity = mycart[index].Quantity;
                mycart[index].Quantity = oldquantity + 1;

                if (DiscountHelper.IsDiscountToday() && oldquantity % 2 == 1)
                {
                    //discount
                    if (Size == "S")
                    {
                        mycart[index].Discount += mycart[index].Dish.Price * 2 * 0.15;
                    }
                    else if (Size == "M")
                    {
                        mycart[index].Discount += mycart[index].Dish.Price * 2 * 0.25;
                    }
                    else if (Size == "L")
                    {
                        mycart[index].Discount += mycart[index].Dish.Price * 2 * 0.35;
                    }
                }
            }
            else
            {
                using (PizzaExpressModel context = new PizzaExpressModel())
                {
                    //create new order detail by load some info
                    //Debug.WriteLine("vao den doan lay tu DB");

                    var dish = context.Dishes.Include(d => d.Food).Single(d => d.FoodID == FoodID && d.Size == Size);
                    //dish.Food = food;
                    item.Dish     = dish;
                    item.Size     = Size;
                    item.Quantity = 1;
                    mycart.Add(item);
                }
            }

            Session[CART_STRING] = mycart;

            return(Content("add to cart successfully, size of cart now is " + mycart.Count));
        }
Beispiel #2
0
 public ActionResult GetContact(String name, String email, String phone, String message)
 {
     using (PizzaExpressModel context = new PizzaExpressModel())
     {
         object[] contactparams = new object[]
         {
             new SqlParameter("@name", name),
             new SqlParameter("@email", email),
             new SqlParameter("@phone", phone),
             new SqlParameter("@message", message)
         };
         context.Database.ExecuteSqlCommand("insert into Contact values(@name, @email, @phone, @message)", contactparams);
     }
     return(Redirect("/Home/"));
 }
Beispiel #3
0
        protected void btnOrder_Click(object sender, EventArgs e)
        {
            List <OrderDetail> mycart = (List <OrderDetail>)Session[CART_STRING];

            if (mycart != null)
            {
                //add order and order detail to database
                String   name        = tbxName.Text.Trim();
                String   address     = tbxAddress.Text.Trim();
                String   phone       = tbxPhone.Text.Trim();
                String   note        = tbxNote.Text.Trim();
                DateTime shippedDate = Convert.ToDateTime(tbxShipdate.Text);

                using (PizzaExpressModel context = new PizzaExpressModel())
                {
                    object[] dbparams = new object[]
                    {
                        new SqlParameter("@name", name),
                        new SqlParameter("@address", address),
                        new SqlParameter("@phone", phone),
                        new SqlParameter("@note", note),
                        new SqlParameter("@orderDate", DateTime.Now),
                        new SqlParameter("@shippedDate", shippedDate)
                    };

                    int OrderID = context.Database.SqlQuery <int>("insert into Orders(CustomerName, CustomerAddress, " +
                                                                  "Phone, OrderDate, ShippedDate, Note) output inserted.OrderID values(@name, @address, @phone, @orderDate, @shippedDate, @note)", dbparams).Single();

                    foreach (var od in mycart)
                    {
                        object[] odparams = new object[]
                        {
                            new SqlParameter("@OrderID", OrderID),
                            new SqlParameter("@FoodID", od.FoodID),
                            new SqlParameter("@Size", od.Size),
                            new SqlParameter("@Discount", od.Discount),
                            new SqlParameter("@Quantity", od.Quantity)
                        };
                        var x = context.Database.ExecuteSqlCommand("insert into OrderDetail values(@OrderID, @FoodID, @Size, @Discount, @Quantity)", odparams);
                    }
                    mycart.Clear();
                    Session[CART_STRING] = mycart;
                    Response.Redirect("/Home/Index");
                }
            }
        }
Beispiel #4
0
        // GET: CustomerOrder
        public ActionResult Index(int?CategoryID, int?page)
        {
            using (PizzaExpressModel context = new PizzaExpressModel())
            {
                var Categories = context.Categories.ToList();
                ViewData["Categories"] = Categories;
                Category Category = null;


                var pageindex = page ?? 1;
                var Food      = context.Foods.Include(f => f.Dishes)
                                .Where(f => f.CategoryID == (CategoryID == null ? 1 : CategoryID))
                                .OrderBy(f => f.FoodID)
                                .ToPagedList(pageindex, PAGESIZE);

                Category = context.Categories.Single
                               (c => c.CategoryID == (CategoryID == null ? 1 : CategoryID));

                ViewData["Category"] = Category;
                return(View(Food));
            }
        }