public static void Main()
{
var db = new CombinationsContext();
db.Combinations.Add(new Combinations { LaptopId = 1, MouseId = 1 });
db.SaveChanges();
Console.WriteLine(db.Combinations.Count());
}
public static void Main()
{
var db = new CombinationsContext();
db.Stores.Add(new StoreName { Town = "Sofia", Store = "LaptopHeaven" });
db.Stores.Add(new StoreName { Town = "Plovdiv", Store = "PlowMyDiv" });
db.Stores.Add(new StoreName { Town = "Varna", Store = "DownByTheRiver" });
db.Stores.Add(new StoreName { Town = "Bourgas", Store = "PCSaysMeow" });
db.Stores.Add(new StoreName { Town = "Pleven", Store = "SthSthLaptopsSth" });
db.Stores.Add(new StoreName { Town = "Haskovo", Store = "HasLenovo" });
db.Stores.Add(new StoreName { Town = "Kyustendil", Store = "UpOnTheCherryTree" });
db.SaveChanges();
Console.WriteLine(db.Stores.Count());
}
public void Generate(CombinationsContext combinationsContext, MySqlContext mySqlContext)
{
Spreadsheet document = new Spreadsheet();
Worksheet sheet = document.Workbook.Worksheets.Add("SalesReport");
sheet.Cell(0, 0).Value = "TOWN";
sheet.Cell(0, 1).Value = "STORE";
sheet.Cell(0, 2).Value = "DATE";
sheet.Cell(0, 3).Value = "SOLD LAPTOPS COUNT";
Color headerColor = Color.FromArgb(75, 172, 198);
sheet.Cell(0, 0).FillPattern = PatternStyle.Solid;
sheet.Cell(0, 1).FillPattern = PatternStyle.Solid;
sheet.Cell(0, 2).FillPattern = PatternStyle.Solid;
sheet.Cell(0, 3).FillPattern = PatternStyle.Solid;
sheet.Cell(0, 0).FillPatternForeColor = headerColor;
sheet.Cell(0, 1).FillPatternForeColor = headerColor;
sheet.Cell(0, 2).FillPatternForeColor = headerColor;
sheet.Cell(0, 3).FillPatternForeColor = headerColor;
sheet.Columns[0].Width = 300;
sheet.Columns[1].Width = 300;
sheet.Columns[2].Width = 300;
sheet.Columns[3].Width = 300;
var a = mySqlContext.GetAll<SalesReport>().ToList();
var row = 1;
var bs = combinationsContext.Stores.ToList();
foreach (var report in a)
{
sheet.Cell(row, 0).Value = report.Town;
sheet.Cell(row, 1).Value = bs.First(x => x.Town == report.Town).Store;
sheet.Cell(row, 2).Value = report.Quantity;
sheet.Cell(row, 3).Value = report.Date;
++row;
}
document.SaveAs("export.xls");
document.Close();
}
