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