static void Main(string[] args) { var dbContext = new TinyCrmDbContext(); /*var productsSeed = GetProductsFromCsv("C:\\data.csv"); * foreach (Product p in productsSeed) * { * dbContext.Add(p); * } * dbContext.SaveChanges();*/ var customerOpts = new CustomerOptions { CreatedFrom = new DateTime(2020, 5, 1), CreatedTo = new DateTime(2020, 5, 3) }; // var customer = SearchCustomers(customerOpts, dbContext).SingleOrDefault(); var customers = SearchCustomers(customerOpts, dbContext).ToList(); if (customers.Any()) { Console.WriteLine("===Customers==="); foreach (Customer c in customers) { Console.WriteLine($"| {c.CustomerId} | {c.VatNumber} | {c.FirstName} | {c.LastName} | {c.Created} |"); } } else { Console.WriteLine("Nothing Found!"); } /*var productOpts = new ProductOptions * { * Categories = new List<ProductCategory>() * { * ProductCategory.Headphones * } * }; * * var products = SearchProducts(productOpts, dbContext).ToList(); * * var order = new Order() * { * DeliveryAddress = "Unknown 123, 00000" * }; * * if (products.Any()) * { * foreach (Product p in products) * { * order.OrderProducts.Add( * new OrderProduct() * { * Product = p * }); * } * } * else * { * Console.WriteLine("Nothing Found!"); * } * * if (customer != null) * { * customer.Orders.Add(order); * dbContext.SaveChanges(); * }*/ dbContext.Dispose(); }