Example #1
0
        public void SaveOrder(Order order, string Email)
        {
            Order existing = context.Customers
                             .Include("Orders.OrderedMeals")
                             .FirstOrDefault(c => c.EMail == Email)
                             .Orders.FirstOrDefault(o => o.StartDate.Date == order.StartDate.Date);

            context.Customers
            .Include("Orders.OrderedMeals")
            .FirstOrDefault(c => c.EMail == Email)
            .Orders.Remove(existing);

            context.SaveChanges();
            order.Id = 0;
            foreach (OrderedMeal oMeal in order.OrderedMeals)
            {
                oMeal.Id = 0;
            }

            context.Customers
            .Include("Orders.OrderedMeals")
            .FirstOrDefault(c => c.EMail == Email)
            .Orders.Add(order);

            context.SaveChanges();
        }
Example #2
0
        public static void EnsurePopulated(IApplicationBuilder app)
        {
            AppOrderDbContext context = app.ApplicationServices.GetRequiredService <AppOrderDbContext>();

            if (!context.Customers.Any())
            {
                context.Customers.Add(new Customer()
                {
                    EMail      = "*****@*****.**",
                    BirthDate  = new DateTime(2000, 03, 24),
                    Name       = "Customer Jack",
                    Address    = "Lovensdijkstraat 61",
                    PostalCode = "4000VM"
                });
                context.SaveChanges();
            }
        }