public async Task <IActionResult> Create(CreateViewModel createPerson) { try { if (ModelState.IsValid) { int intGroupId; if (!int.TryParse(createPerson.SelectedGroupId, out intGroupId)) { return(View(createPerson)); } //create person from person view model var person = new Entities.Models.Person { Name = createPerson.PersonName, DateAdded = createPerson.DateAdded, Group = new Entities.Models.Group { Id = intGroupId } }; await _personRepository.AddPerson(person); return(RedirectToAction(nameof(Index))); } return(View(createPerson)); } catch (Exception e) { _logger.LogError(e, $"Error whilst creating new person - {createPerson.PersonName}"); throw; } }
public static IWebHost MigrateDb(this IWebHost host) { using (IServiceScope scope = host.Services.CreateScope()) { // Create database if required and ensure it is at a new enough version scope.ServiceProvider.GetRequiredService <RepositoryContext>().Database.Migrate(); // seed excel data var context = scope.ServiceProvider.GetRequiredService <RepositoryContext>(); //esa var person = new Entities.Models.Person { Name = "Esa Kukkamäki", Age = 38 }; excelLoader.ExcelHandler.SeedDbForExcelData(context, "ESAYHT_hiihto.xls", person); //eero person = new Entities.Models.Person { Name = "Eero Kukkamäki", Age = 69 }; excelLoader.ExcelHandler.SeedDbForExcelData(context, "EEROYHT.xls", person); }; return(host); }