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(); }