public static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <ConfluxDbContext, Configuration>());
var db = new ConfluxDbContext();
JSON.SaveFile(db);
var carPrices = db.Cars
.Select(c => new { c.Model, c.Make, c.Price })
.ToList();
PDFReporter.CreateReport(carPrices, "../../PDF-Reports/car-price.pdf", "Car prices report");
Console.WriteLine("Car prices report created.");
var carPricesInRange = db.Cars
.Where(c => c.Price > 15000 && c.Price < 25000)
.ToList();
PDFReporter.CreateReport(carPricesInRange, "../../PDF-Reports/car-price-between-15000-and-25000.pdf", "Car prices between 15000 and 25000");
Console.WriteLine("Car prices between 15000 and 25000 report created.");
XmlReport xlmReport = new XmlReport();
bool success = xlmReport.GenerateXmlReport("../../xmlReport.xml");
Console.WriteLine("XML Report created at: '../ConfluxApplication/xmlReport.xml'");
db.Dispose();
}
public bool GenerateXmlReport(string name)
{
using (var db = new ConfluxDbContext())
{
try
{
XDocument xmlDocument = new XDocument(
new XDeclaration("1.0", "utf-8", "no"),
new XProcessingInstruction("xml-stylesheet", @"type=""text/xsl"" href=""SalesStyle.xslt"""));
var dealerExpenses = from dealer in db.DealerExpenses select dealer;
var dealerByName = dealerExpenses.GroupBy(x => x.DealerName);
var exp = new XElement("Expenses-By-Month");
xmlDocument.Add(exp);
foreach (var item in dealerByName)
{
var saleInMonth = new XElement("dealer");
exp.Add(saleInMonth);
var dealer = new XAttribute("name", item.Key);
saleInMonth.Add(dealer);
foreach (var date in item)
{
//// TODO Get date for sum of price and calculate total sum
saleInMonth.Add(
new XElement(
"expenses",
new XAttribute("date", (date.Month).ToString("MMM yyyy")),
date.Value));
}
}
xmlDocument.Save(name);
}
catch (Exception e)
{
Console.WriteLine("Error when generating XML report! Error: {0}", e.InnerException.Message);
return(false);
}
return(true);
}
}