Exemple #1
0
        public int CO(Order order, HttpContextBase c) // create order
        {
            decimal orderTotal = 0;
            var     CT         = GCT();
            Orders  O          = new Orders();

            //List<OrderDetails> ODL = new List<OrderDetails> { };

            foreach (var Toy in CT)
            {
                double w    = DateTime.Now.DayOfYear / 7;
                var    week = (int)Math.Ceiling(w);

                var OD = new OrderDetails           //alles wat in de cart zit wordt toegevoegd als orderdetails
                {
                    //OrderDetailId = O.LastRecordOD() + 1,
                    ToyId     = Toy.ToyId,
                    OrderId   = order.OrderId,
                    UnitPrice = Toy.Toy.Price,
                    Quantity  = Toy.Count,
                    Week      = week,
                    Month     = DateTime.Now.Month,
                    year      = DateTime.Now.Year,
                    Day       = DateTime.Now.Day,
                    Hour      = DateTime.Now.Hour,
                    Minute    = DateTime.Now.Minute,

                    Status = "In Progress",
                    CName  = Toy.Toy.Categories.CName,
                    SCName = Toy.Toy.SubCategories.SCName
                };

                order.Total += (Toy.Count * Toy.Toy.Price);     //per toy wordt de orderprijs bijgewerkt
                //ODL.Add(OD);                                    //orderdetail wordt aan de list toegevoegd
                db.OrderDetails.Add(OD);                        //
            }

            O.ATO(order, c);          // de order wordt toegoegd in de db
            order.Total = orderTotal; //de totaal wordt 0
            db.SaveChanges();         //db save
            EC();                     //empty cart
            return(order.OrderId);    //return id
        }
        public int CreateOrder(Order order, HttpContextBase context)
        {
            decimal       orderTotal = 0;
            var           CartToy    = GetCartToys();
            OrdersService Order      = new OrdersService();

            //List<OrderDetails> ODL = new List<OrderDetails> { };
            foreach (var Toy in CartToy)
            {
                double w    = DateTime.Now.DayOfYear / 7;
                var    week = (int)Math.Ceiling(w);

                var OrderDetail = new OrderDetails           //alles wat in de cart zit wordt toegevoegd als orderdetails
                {
                    //OrderDetailId = O.LastRecordOD() + 1,
                    ToyId     = Toy.ToyId,
                    OrderId   = order.OrderId,
                    UnitPrice = Toy.Toy.Price,
                    Quantity  = Toy.Count,
                    Week      = week,
                    Month     = DateTime.Now.Month,
                    year      = DateTime.Now.Year,
                    Day       = DateTime.Now.Day,
                    Hour      = DateTime.Now.Hour,
                    Minute    = DateTime.Now.Minute,

                    Status          = "In Progress",
                    CategoryName    = Toy.Toy.Categories.CategoryName,
                    SubCategoryName = Toy.Toy.SubCategories.SubCategoryName
                };
                order.Total += (Toy.Count * Toy.Toy.Price);     //per toy wordt de orderprijs bijgewerkt
                db.OrderDetails.Add(OrderDetail);               //
            }

            Order.AddOrder(order, context); //Add order to db
            order.Total = orderTotal;       //Put total to 0
            db.SaveChanges();               //db save
            EmptyCart();                    //empty cart
            return(order.OrderId);          //return id
        }
        public void COD(int y, int m, int d, int dayofyear, int min, int h, int s, Order o, string c, List <Cart> TL)
        {
            var     date       = new DateTime(y, m, d, h, min, s);
            decimal orderTotal = 0;
            Orders  O          = new Orders();

            //var TL = new List<Cart>();

            foreach (var T in TL)
            {
                //double w = dayofyear / 7;
                //var week = (int)Math.Ceiling(w);
                var week = Week(dayofyear);
                var OD   = new OrderDetails         //alles wat in de cart zit wordt toegevoegd als orderdetails
                {
                    //OrderDetailId = O.LastRecordOD(),
                    ToyId     = T.ToyId,
                    OrderId   = o.OrderId,
                    UnitPrice = T.Toy.Price,
                    Quantity  = T.Count,
                    Week      = week,
                    Month     = m,
                    year      = y,
                    Day       = d,
                    Hour      = h,
                    Minute    = min,
                    Status    = "Completed",
                    CName     = T.Toy.Categories.CName,
                    SCName    = T.Toy.SubCategories.SCName
                };

                o.Total += (T.Count * T.Toy.Price);

                db.OrderDetails.Add(OD);
            }

            AO(o, c);
            o.Total = orderTotal;
            db.SaveChanges();
        }