public ActionResult Display()
{
var db = new ParserDbContext();
var set = db.Person;
var people = set.ToList();
ViewData.Add("People", people);
return(View());
}
public ActionResult Upload(IFormFile file)
{
try {
var db = new ParserDbContext();
var stream = Request.Form.Files[0].OpenReadStream();
var reader = new StreamReader(stream);
db.Person.AddRange(ReadStream(reader));
db.SaveChanges();
return(RedirectToAction(nameof(Display)));
} catch {
return(View("Error"));
}
}
public static async Task InitDb(IServiceProvider serviceProvider, string connectionString)
{
var logger = serviceProvider.GetRequiredService <ILogger <ParserDbContext> >();
try
{
ParserDbContext.SetConnectionString(connectionString);
var context = serviceProvider.GetRequiredService <ParserDbContext>();
await context.Database.MigrateAsync();
}
catch (Exception e)
{
logger.LogCritical(e, "Unable to migrate databese");
throw;
}
}
public Repository(ParserDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public AsyncRepository(ParserDbContext context)
{
Context = context;
}
