public void PopulateData(string filePath, ExposureDb db)
{
var fileReader = new ExcelFileReader();
db.Branches.AddOrUpdate(branch => branch.Name, fileReader.ReadDistinctBrnaches(filePath).ToArray());
db.Brands.AddOrUpdate(brand => brand.Name, fileReader.ReadDistinctBrands(filePath).ToArray());
db.Disciplines.AddOrUpdate(discipline => discipline.Name,
fileReader.ReadDistinctDisciplines(filePath).ToArray());
var records = fileReader.ReadExposureRecords(filePath).ToArray();
foreach (var exposureRecord in records)
{
db.ExposureRecords.AddOrUpdate(record => new { record.Brand, record.Month }, exposureRecord);
db.SaveChanges();
}
}
public ExposureRecordsController()
{
db = new ExposureDb();
model = new ExposurePresenterViewModel();
model.Brands = db.Brands.Select(brand => brand.Name).ToList();
model.Brands.Sort(String.Compare);
model.Disciplines = db.Disciplines.Select(discipline => discipline.Name).ToList();
model.Disciplines.Sort(String.Compare);
model.Branches = db.Branches.Select(branch => branch.Name).ToList();
model.Branches.Sort(String.Compare);
Palete = new List <Color>()
{
Color.Gray,
Color.LightSalmon,
Color.LightPink,
Color.PaleGreen,
Color.LightSeaGreen,
Color.IndianRed,
Color.Yellow
};
}
