public static FirmViewModel ReadFirms() { var imported = Db.Trackings.Where(a => a.Name == _firmTable).Any(); var firms = new List<Firm>(); var errors = new List<KeyValuePair<string, string>>(); ReadData("~/Assets/Firm.xls", imported, firms, errors); if (!imported) { var tracking = new Tracking() { Name = _firmTable }; Db.Trackings.Add(tracking); Db.SaveChanges(); } var viewModel = FirmViewModel.Create(firms, errors, imported); return viewModel; }
public static SeminarViewModel ReadSeminar() { var imported = Db.Trackings.Where(a => a.Name == _seminarTable).Any(); var seminars = new List<Seminar>(); var errors = new List<KeyValuePair<string, string>>(); ReadData("~/Assets/Seminar.xls", imported, seminars, errors); if (!imported) { var tracking = new Tracking() { Name = _seminarTable }; Db.Trackings.Add(tracking); Db.SaveChanges(); } var viewModel = SeminarViewModel.Create(seminars, errors, imported); return viewModel; }