Exemplo n.º 1
0
        private static void InitiliazeDatabase()
        {
            var ctx = new CarDealerContext();

            ctx.Database.Initialize(true);
        }
        public static void Main(string[] args)
        {
            CarDealerContext db = new CarDealerContext();

            //Problem - 00
            //ResetDatabase(db);

            //Problem - 09
            //string inputXml = File.ReadAllText(@"../../../Datasets/suppliers.xml");
            //string result = ImportSuppliers(db, inputXml);
            //Console.WriteLine(result);

            //Problem - 10
            //string inputXml = File.ReadAllText(@"../../../Datasets/parts.xml");
            //string result = ImportParts(db, inputXml);
            //Console.WriteLine(result);

            //Problem - 11
            //string inputXml = File.ReadAllText(@"../../../Datasets/cars.xml");
            //string result = ImportCars(db, inputXml);
            //Console.WriteLine(result);

            //Problem - 12
            //string inputXml = File.ReadAllText(@"../../../Datasets/customers.xml");
            //string result = ImportCustomers(db, inputXml);
            //Console.WriteLine(result);

            //Problem - 13
            //string inputXml = File.ReadAllText(@"../../../Datasets/sales.xml");
            //string result = ImportSales(db, inputXml);
            //Console.WriteLine(result);

            //Problem - 14
            //EnsureDirectoryPath(directoryPath);
            //string xml = GetCarsWithDistance(db);
            //File.WriteAllText(directoryPath + "/cars.xml", xml);

            //Problem - 15
            //EnsureDirectoryPath(directoryPath);
            //string xml = GetCarsFromMakeBmw(db);
            //File.WriteAllText(directoryPath + "/bmw-cars.xml", xml);

            //Problem - 16
            //EnsureDirectoryPath(directoryPath);
            //string xml = GetLocalSuppliers(db);
            //File.WriteAllText(directoryPath + "/local-suppliers.xml", xml);

            //Problem - 17
            //EnsureDirectoryPath(directoryPath);
            //string xml = GetCarsWithTheirListOfParts(db);
            //File.WriteAllText(directoryPath + "/cars-and-parts.xml", xml);

            //Problem - 18
            //EnsureDirectoryPath(directoryPath);
            //string xml = GetTotalSalesByCustomer(db);
            //File.WriteAllText(directoryPath + "/customers-total-sales.xml", xml);

            //Problem - 19
            EnsureDirectoryPath(directoryPath);
            string xml = GetSalesWithAppliedDiscount(db);

            File.WriteAllText(directoryPath + "/sales-discounts.xml", xml);
        }
        public static void Main(string[] args)
        {
            var context = new CarDealerContext();

            Console.WriteLine(GetCarsFromMakeBmw(context));
        }
Exemplo n.º 4
0
 //17. Cars with Their List of Parts
 public static string GetCarsWithTheirListOfParts(CarDealerContext context)
 {
     return(null);
 }
Exemplo n.º 5
0
        public static string ImportCars(CarDealerContext context, string inputJson)
        {
            var carsDTOs = JsonConvert.DeserializeObject <List <CarImportDTO> >(inputJson);

            var partIds = context
                          .Parts
                          .Select(p => p.Id)
                          .ToHashSet();

            var carPartsToAdd = new HashSet <PartCar>();
            var carsToAdd     = new List <Car>();

            foreach (var carDTO in carsDTOs)
            {
                var car = new Car()
                {
                    Make              = carDTO.Make,
                    Model             = carDTO.Model,
                    TravelledDistance = carDTO.TravelledDistance
                };

                carsToAdd.Add(car);
            }

            context.Cars.AddRange(carsToAdd);
            context.SaveChanges();

            foreach (var carDTO in carsDTOs)
            {
                carDTO.PartsId = carDTO
                                 .PartsId
                                 .Distinct()
                                 .ToList();

                var currentCar = context
                                 .Cars
                                 .FirstOrDefault(c => c.Make == carDTO.Make &&
                                                 c.Model == carDTO.Model &&
                                                 c.TravelledDistance == carDTO.TravelledDistance);

                foreach (var partId in carDTO.PartsId)
                {
                    if (!partIds.Contains(partId))
                    {
                        continue;
                    }

                    var partCar = new PartCar
                    {
                        CarId  = currentCar.Id,
                        PartId = partId
                    };

                    if (!carPartsToAdd.Contains(partCar))
                    {
                        carPartsToAdd.Add(partCar);
                    }

                    if (carPartsToAdd.Count > 0)
                    {
                        currentCar.PartCars = carPartsToAdd;
                        context.PartCars.AddRange(carPartsToAdd);
                        carPartsToAdd.Clear();
                    }
                }
            }

            context.SaveChanges();

            return($"Successfully imported {context.Cars.ToList().Count}.");
        }
Exemplo n.º 6
0
        public static void Main(string[] args)
        {
            var dbContext = new CarDealerContext();

            InitializeMapper();
        }
Exemplo n.º 7
0
 //s12.
 public static string ImportCustomers(CarDealerContext context, string inputXml)
 => ImportBulkDataFromXml <Customer>(context, inputXml, _ => true);
Exemplo n.º 8
0
 public static string ImportCars(CarDealerContext context, string inputXml)
 {
     return("");
 }
Exemplo n.º 9
0
        public static void Main(string[] args)
        {
            var context = new CarDealerContext();

            Console.WriteLine(GetOrderedCustomers(context));
        }
Exemplo n.º 10
0
        public static void Main(string[] args)
        {
            CarDealerContext db = new CarDealerContext();
            //ResetDatabase(db);

            //Problem 01
            //string inputJson = File.ReadAllText("../../../Datasets/suppliers.json");
            //string result=ImportSuppliers(db, inputJson);
            //Console.WriteLine(result);

            //Problem 02
            //string inputJson = File.ReadAllText("../../../Datasets/parts.json");
            //string result = ImportParts(db, inputJson);
            //Console.WriteLine(result);

            //Problem 03
            string inputJson = File.ReadAllText("../../../Datasets/cars.json");
            string result    = ImportCars(db, inputJson);

            Console.WriteLine(result);

            //Problem 04
            //string inputJson = File.ReadAllText("../../../Datasets/customers.json");
            //string result = ImportCustomers(db, inputJson);
            //Console.WriteLine(result);

            //Problem 05
            //string inputJson = File.ReadAllText("../../../Datasets/sales.json");
            //string result = ImportSales(db, inputJson);
            //Console.WriteLine(result);

            //Problem 06
            //EnsureDirectoryExists();
            //string json = GetOrderedCustomers(db);
            //File.WriteAllText(ResultsDirectoryPath + "/ordered-customers.json", json);

            //Problem 07
            //EnsureDirectoryExists();
            //string json = GetCarsFromMakeToyota(db);

            //File.WriteAllText(ResultsDirectoryPath + "/toyota-cars.json", json);

            //Problem 08
            //EnsureDirectoryExists();
            //string json = GetLocalSuppliers(db);
            //File.WriteAllText(ResultsDirectoryPath + "/local-suppliers.json", json);


            //--Import Parts
            //ImportPartCars(db);


            //Problem 09
            //EnsureDirectoryExists();
            //string json = GetCarsWithTheirListOfParts(db);
            //File.WriteAllText(ResultsDirectoryPath + "/cars-and-parts.json", json);

            //Problem 10
            //InitializeMapper();
            //EnsureDirectoryExists();
            //string json = GetTotalSalesByCustomer(db);
            //File.WriteAllText(ResultsDirectoryPath + "/customers-total-sales.json", json);

            //Problem 11
            EnsureDirectoryExists();
            string json = GetSalesWithAppliedDiscount(db);

            File.WriteAllText(ResultsDirectoryPath + "/sales-discounts.json", json);
        }
Exemplo n.º 11
0
 public static string ImportCars(CarDealerContext context, string inputJson)
 {
Exemplo n.º 12
0
 //s10.
 public static string ImportSuppliers(CarDealerContext context, string inputJson)
 => DeserializeAddEntities <Supplier>(context, inputJson, user => { return(true); });
Exemplo n.º 13
0
 public static string ImportSales(CarDealerContext context, string inputJson)
 => DeserializeAddEntities <Sale>(context, inputJson, customer => true);
Exemplo n.º 14
0
 //s13.
 public static string ImportCustomers(CarDealerContext context, string inputJson)
 => DeserializeAddEntities <Customer>(context, inputJson, categoryProducts => { return(true); });
Exemplo n.º 15
0
        private static void BuildDatabaseAndInsertData
            (string suppliersJson, string partsJson, string carsJson, string customersJson, string salesJson, CarDealerContext db)
        {
            ResetDatabase(db);

            ImportSuppliers(db, suppliersJson);
            ImportParts(db, partsJson);
            ImportCars(db, carsJson);
            ImportCustomers(db, customersJson);
            ImportSales(db, salesJson);
        }
Exemplo n.º 16
0
 private static void ResetDb(CarDealerContext dbContext)
 {
     dbContext.Database.EnsureDeleted();
     dbContext.Database.EnsureCreated();
     // System.Console.WriteLine("Db reset success!!!");
 }
        public static void Main(string[] args)
        {
            var context = new CarDealerContext();

            Console.WriteLine(GetTotalSalesByCustomer(context));
        }
Exemplo n.º 18
0
        public static void Main(string[] args)
        {
            var dbContext = new CarDealerContext();

            ResetDatabase(dbContext);

            //EXERCISE 9 - Import Suppliers
            var importSuppliersXml      = File.ReadAllText("../../../Datasets/suppliers.xml");
            var resultOfSuppliersImport = ImportSuppliers(dbContext, importSuppliersXml);

            Console.WriteLine(resultOfSuppliersImport);

            //EXERCISE 10 - Import Parts
            var importPartsXml      = File.ReadAllText("../../../Datasets/parts.xml");
            var resultOfPartsImport = ImportParts(dbContext, importPartsXml);

            Console.WriteLine(resultOfPartsImport);

            //EXERCISE 11 - Import Cars
            var importCarsXml      = File.ReadAllText("../../../Datasets/cars.xml");
            var resultOfCarsImport = ImportCars(dbContext, importCarsXml);

            Console.WriteLine(resultOfCarsImport);

            //EXERCISE 12 - Import Customers
            var importCustomersXml      = File.ReadAllText("../../../Datasets/customers.xml");
            var resultOfCustomersImport = ImportCustomers(dbContext, importCustomersXml);

            Console.WriteLine(resultOfCustomersImport);

            //EXERCISE 13 - Import Sales
            var importSalesXml      = File.ReadAllText("../../../Datasets/sales.xml");
            var resultOfSalesImport = ImportSales(dbContext, importSalesXml);

            Console.WriteLine(resultOfSalesImport);

            //EXERCISE 14 - Export Cars With Distance
            var carsWithDistanceXml = GetCarsWithDistance(dbContext);

            Console.WriteLine(carsWithDistanceXml);
            File.WriteAllText("../../../ExportedXMLs/carsWithDistance.xml", carsWithDistanceXml);

            //EXERCISE 15 - Export Cars From Make BMW
            var bmwCarsXml = GetCarsFromMakeBmw(dbContext);

            Console.WriteLine(bmwCarsXml);
            File.WriteAllText("../../../ExportedXMLs/allBMWs.xml", bmwCarsXml);

            //EXERCISE 16 - Export Local Suppliers
            var localSuppliers = GetLocalSuppliers(dbContext);

            Console.WriteLine(localSuppliers);
            File.WriteAllText("../../../ExportedXMLs/localSuppliers.xml", localSuppliers);

            //EXERCISE 17 - Export Cars With Their List Of Parts
            var carsWithTheirParts = GetCarsWithTheirListOfParts(dbContext);

            Console.WriteLine(carsWithTheirParts);
            File.WriteAllText("../../../ExportedXMLs/carsWithTheirParts.xml", carsWithTheirParts);

            //EXERCISE 18 - Export Total Sales By Customer
            var customersWithSalesAndSpents = GetTotalSalesByCustomer(dbContext);

            Console.WriteLine(customersWithSalesAndSpents);
            File.WriteAllText("../../../ExportedXMLs/customersWithSalesAndSpents.xml", customersWithSalesAndSpents);

            //EXERCISE 19 - Export Sales With Applied Discount
            var salesWithDiscount = GetSalesWithAppliedDiscount(dbContext);

            Console.WriteLine(salesWithDiscount);
            File.WriteAllText("../../../ExportedXMLs/salesWithDiscount.xml", salesWithDiscount);
        }
Exemplo n.º 19
0
 private static void ResetDatabase(CarDealerContext context)
 {
     context.Database.EnsureDeleted();
     context.Database.EnsureCreated();
 }
Exemplo n.º 20
0
        public static void Main(string[] args)
        {
            var db = new CarDealerContext();

            Console.WriteLine(GetCarsWithTheirListOfParts(db));
        }
Exemplo n.º 21
0
        public static void Main(string[] args)
        {
            var context = new CarDealerContext();

            File.WriteAllText("../../../Datasets/ExportXMLs/sales-discounts.xml", GetSalesWithAppliedDiscount(context));
        }
Exemplo n.º 22
0
        public static void Main(string[] args)
        {
            var db = new CarDealerContext();
            //ResetDatabase(db);

            //exercise 8
            //string inputSup = File.ReadAllText(@"..\..\..\Datasets\suppliers.json");
            //string result = ImportSuppliers(db, inputSup);
            //Console.WriteLine(result);

            //exercise 9
            //string input = File.ReadAllText(@"..\..\..\Datasets\parts.json");
            //string result = ImportParts(db, input);
            //Console.WriteLine(result);

            //exercise 10

            //string input = File.ReadAllText(@"..\..\..\Datasets\cars.json");
            //string result = ImportCars(db, input);
            //Console.WriteLine(result);


            //exercise 11

            //string input = File.ReadAllText(@"..\..\..\Datasets\customers.json");
            //string result = ImportCustomers(db, input);
            //Console.WriteLine(result);


            //exercise 12

            //string input = File.ReadAllText(@"..\..\..\Datasets\sales.json");
            //string result = ImportSales(db, input);
            //Console.WriteLine(result);


            //exercise 13
            //string result = GetOrderedCustomers(db);
            //Console.WriteLine(result);


            ////exercise 14
            //string result = GetCarsFromMakeToyota(db);
            //Console.WriteLine(result);

            //////exercise 15
            //string result = GetLocalSuppliers(db);
            //Console.WriteLine(result);

            //exercise 16
            //string result = GetCarsWithTheirListOfParts(db);
            //Console.WriteLine(result);


            //exercise 17
            //string result = GetTotalSalesByCustomer(db);
            //Console.WriteLine(result);


            //exercise 18
            string result = GetSalesWithAppliedDiscount(db);

            Console.WriteLine(result);
        }
        public static void Main(string[] args)
        {
            var context = new CarDealerContext();

            Console.WriteLine(GetCarsWithDistance(context));
        }
Exemplo n.º 24
0
 private static void ResetDatabase(CarDealerContext db)
 {
     db.Database.EnsureDeleted();
     db.Database.EnsureCreated();
 }
Exemplo n.º 25
0
 public static string GetSalesWithAppliedDiscount(CarDealerContext context)
 {
 }
Exemplo n.º 26
0
 public Deserializer(CarDealerContext context)
 {
     this.context = context;
 }
        public static void Main(string[] args)
        {
            var context = new CarDealerContext();

            Console.WriteLine(GetLocalSuppliers(context));
        }
Exemplo n.º 28
0
        public static void Main(string[] args)
        {
            CarDealerContext context = new CarDealerContext();

            //ResetDatabase(context);

            #region 09.Import Suppliers
            //string inputJson = File.ReadAllText("../../../Datasets/suppliers.json");

            //string result = ImportSuppliers(context, inputJson);
            #endregion

            #region 10. Import Parts
            //string inputJson = File.ReadAllText("../../../Datasets/parts.json");

            //string result = ImportParts(context, inputJson);
            #endregion

            #region 11. Import Cars
            //string inputJson = File.ReadAllText("../../../Datasets/cars.json");

            //string result = ImportCars(context, inputJson);
            #endregion

            #region 12. Import Customers
            //string inputJson = File.ReadAllText("../../../Datasets/customers.json");

            //string result = ImportCustomers(context, inputJson);
            #endregion

            #region 13. Import Sales
            //string inputJson = File.ReadAllText("../../../Datasets/sales.json");

            //string result = ImportSales(context, inputJson);
            #endregion

            #region 14. Export Ordered Customers
            //string json = GetOrderedCustomers(context);

            //EnsureDirectoryExists(ResultDirectoryPath);

            //File.WriteAllText(ResultDirectoryPath + "/ordered-customers.json", json);
            #endregion

            #region 15. Export Cars From Make Toyota
            //string json = GetCarsFromMakeToyota(context);

            //EnsureDirectoryExists(ResultDirectoryPath);

            //File.WriteAllText(ResultDirectoryPath + "/toyota-cars.json", json);
            #endregion

            #region 16. Export Local Suppliers
            //string json = GetLocalSuppliers(context);

            //EnsureDirectoryExists(ResultDirectoryPath);

            //File.WriteAllText(ResultDirectoryPath + "/local-suppliers.json", json);
            #endregion

            #region 17. Export Cars With Their List Of Parts
            //string json = GetCarsWithTheirListOfParts(context);

            //EnsureDirectoryExists(ResultDirectoryPath);

            //File.WriteAllText(ResultDirectoryPath + "/cars-and-parts.json", json);
            #endregion

            #region 18. Export Total Sales By Customer
            //string json = GetTotalSalesByCustomer(context);

            //EnsureDirectoryExists(ResultDirectoryPath);

            //File.WriteAllText(ResultDirectoryPath + "/customers-total-sales.json", json);
            #endregion

            #region 19. Export Sales With Applied Discount
            //string json = GetSalesWithAppliedDiscount(context);

            //EnsureDirectoryExists(ResultDirectoryPath);

            //File.WriteAllText(ResultDirectoryPath + "/sales-discounts.json", json);
            #endregion

            //Console.WriteLine(json);
            //Console.WriteLine(result);
        }
Exemplo n.º 29
0
        //Problem 11 - Import Cars
        public static string ImportCars(CarDealerContext context, string inputJson)
        {
            var carsImport = JsonConvert.DeserializeObject <CarImportDto[]>(inputJson);
            var carsToAdd  = Mapper.Map <CarImportDto[], Car[]>(carsImport);

            context.AddRange(carsToAdd);
            context.SaveChanges();

            HashSet <int> partIds = context.Parts.Select(x => x.Id).ToHashSet();

            HashSet <PartCar> carPartsToAdd = new HashSet <PartCar>();

            foreach (var car in carsImport)
            {
                car.PartsId = car
                              .PartsId
                              .Distinct()
                              .ToList();

                Car currentCar = context.
                                 Cars
                                 .Where(x => x.Make == car.Make &&
                                        x.Model == car.Model &&
                                        x.TravelledDistance == car.TravelledDistance)
                                 .FirstOrDefault();

                if (currentCar == null)
                {
                    continue;
                }

                foreach (var id in car.PartsId)
                {
                    if (!partIds.Contains(id))
                    {
                        continue;
                    }

                    PartCar partCar = new PartCar
                    {
                        CarId  = currentCar.Id,
                        PartId = id
                    };

                    if (!carPartsToAdd.Contains(partCar))
                    {
                        carPartsToAdd.Add(partCar);
                    }
                }

                if (carPartsToAdd.Count > 0)
                {
                    currentCar.PartCars = carPartsToAdd;
                    context.PartCars.AddRange(carPartsToAdd);
                    carPartsToAdd.Clear();
                }
            }

            context.SaveChanges();

            return($"Successfully imported {context.Cars.ToList().Count}.");
        }
Exemplo n.º 30
0
        public static void Main()
        {
            const string Root         = @"../../../Datasets/";
            const string CarsXml      = "cars.xml";
            const string CustomersXml = "customers.xml";
            const string PartsXml     = "parts.xml";
            const string SalesXml     = "sales.xml";
            const string SuppliersXml = "suppliers.xml";

            Mapper.Initialize(cfg =>
            {
                cfg.AddProfile <CarDealerProfile>();
            });

            try
            {
                using (var context = new CarDealerContext())
                {
                    // Database initialize.
                    //context.Database.EnsureCreated();
                    //Console.WriteLine("Database created successfully!");

                    // III. Import data
                    // 09. ImportSuppliers
                    //string result = ImportSuppliers(context, File.ReadAllText(Root + SuppliersXml));

                    // 10. Import Parts
                    //string result = ImportParts(context, File.ReadAllText(Root + PartsXml));

                    // 11. Import Cars
                    //string result = ImportCars(context, File.ReadAllText(Root + CarsXml));

                    // 12. Import Customers
                    //string result = ImportCustomers(context, File.ReadAllText(Root + CustomersXml));

                    // 13. Import Sales
                    //string result = ImportSales(context, File.ReadAllText(Root + SalesXml));

                    // IV. Query and Export Data
                    // 14. Export Cars With Distance
                    //string result = GetCarsWithDistance(context);

                    // 15. Export Cars From Make BMW
                    //string result = GetCarsFromMakeBmw(context);

                    // 16. Export Local Suppliers
                    //string result = GetLocalSuppliers(context);

                    // 17.Export Cars With Their List Of Parts
                    //string result = GetCarsWithTheirListOfParts(context);

                    // 18. Export Total Sales By Customer
                    //string result = GetTotalSalesByCustomer(context);

                    // 19. Export Sales With Applied Discount
                    string result = GetSalesWithAppliedDiscount(context);

                    Console.WriteLine(result);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
        }