private void button_Click(object sender, RoutedEventArgs e) { var context = new WayneCarCorpsContext(); var pdfExporter = new PdfExporter(new EfRepository <Sale>(context)); pdfExporter.CreatePdfTable(); }
public static void Main(string[] args) { Database.SetInitializer(new MigrateDatabaseToLatestVersion <WayneCarCorpsContext, Configuration>()); var db = new WayneCarCorpsContext(); db.Database.CreateIfNotExists(); var cars = new MongoDBExtractor <MongoCar>().GetEntitiesCollection("Cars"); var kernel = BootstrapNinject(); var carsImporter = kernel.Get <CarsImporter>(); carsImporter.import(cars); var xmlImporter = kernel.Get <XmlImporter>(); xmlImporter.Import(); var zipExtractor = kernel.Get <ExcelReader>(); zipExtractor.ExtractZipFiles(); var pdfExporter = kernel.Get <PdfExporter>(); pdfExporter.CreatePdfTable(); var jsonExporter = kernel.Get <JsonWriter>(); jsonExporter.WriteToJson(); var xmlExporter = kernel.Get <XmlReportExporter>(); xmlExporter.GetSalesForEachDealership(); // CHANGE PASSWORD IN CONNECTIONS STRING FluentModelContext context = new FluentModelContext(); OpenAccessRepository <SalesReport> report = new OpenAccessRepository <SalesReport>(context); //ExcelWriter.WriteToExcel(report); //UpdateMongoDB(); }
public void WriteToJson() { var dbContext = new WayneCarCorpsContext(); var salesOfCars = this.repositorySales.All() .GroupBy(x => x.CarId) .Select(x => new { CarId = x.Key, TotalSum = x.Sum(car => car.PricePerCar), SoldCars = x.Sum(car => car.SoldCars) }); var cars = from model in this.repositoryModels.All() join car in this.repositoryCars.All() on model.Id equals car.ModelId join sale in salesOfCars on car.Id equals sale.CarId select new { CarModelId = model.Id, CarModel = model.Name, Manufacturer = model.Manufacturer.Name, Seats = model.NumberOfSeats, Dealer = car.Dealer.Name, TotalSum = sale.TotalSum, SoldCars = sale.SoldCars }; foreach (var car in cars) { var serializedObject = JsonConvert.SerializeObject(car, Formatting.Indented); using (var writer = new StreamWriter(string.Format(JsonFilesPath, car.CarModelId))) { writer.WriteLine(serializedObject); } } }