public PeopleController(IPeopleData peopleData, IWebHostEnvironment environment, PeopleDBContext peopleDBContext, IPeopleRepository peopleRepository)
{
_peopleData = peopleData;
_environment = environment;
_peopleDBContext = peopleDBContext;
_peopleRepository = peopleRepository;
}
public async void GetPersonsTest()
{
var options = new DbContextOptionsBuilder <PeopleDBContext>()
.UseInMemoryDatabase(databaseName: "PeopleDB")
.Options;
Person[] testPersons =
new List <Person>
{
new Person {
PersonId = "1", FirstName = "test", LastName = "last"
},
new Person {
PersonId = "2", FirstName = "test1", LastName = "last1"
},
new Person {
PersonId = "3", FirstName = "Found", LastName = "Never"
},
new Person {
PersonId = "4", FirstName = "first", LastName = "test"
},
new Person {
PersonId = "5", FirstName = "first1", LastName = "test1"
}
}.ToArray();
// Setup test data in the InMemory database
using (var context = new PeopleDBContext(options))
{
context.Persons.AddRange(testPersons);
context.SaveChanges();
}
// mock the hosting environment
var hostingEnv = new Mock <IHostingEnvironment>();
// Use a clean instance of the context to run the test
using (var context = new PeopleDBContext(options))
{
/* Act */
var result = await context.FindPersonsByName("es");
/* Assert */
Assert.Equal(4, result.Count());
var testResult = result.ToArray();
// should contain all but the middle person
Assert.Equal("1", testResult[0].PersonId);
Assert.Equal("2", testResult[1].PersonId);
Assert.Equal("4", testResult[2].PersonId);
Assert.Equal("5", testResult[3].PersonId);
}
}
public JsonResult GetListOfPeople()
{
List <Person> people = new List <Person>();
using (PeopleDBContext context = new PeopleDBContext()) {
people = context.People.ToList();
}
return(new JsonResult {
Data = people, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetLastPerson()
{
Person p = null;
using (PeopleDBContext context = new PeopleDBContext()) {
p = context.People.OrderByDescending(c => c.Id).Take(1).FirstOrDefault();
}
return(new JsonResult {
Data = p, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public PeopleControllerTests()
{
DbContextOptionsBuilder <PeopleDBContext> options = new DbContextOptionsBuilder <PeopleDBContext>();
options.UseInMemoryDatabase("Server=(localdb)\\mssqllocaldb;Database=EFProviders.InMemory;Trusted_Connection=True;ConnectRetryCount=0");
context = new PeopleDBContext(options.Options);
if (context.People.ToList().Count == 0)
{
PeopleDBInitializer peopleDBInitializer = new PeopleDBInitializer(context);
peopleDBInitializer.SeedDBContext();
}
}
private void ConfigureInMemoryDBContext(IServiceCollection services)
{
DbContextOptionsBuilder <PeopleDBContext> options = new DbContextOptionsBuilder <PeopleDBContext>();
options.UseInMemoryDatabase(Configuration.GetConnectionString("DevConnection"));
PeopleDBContext context = new PeopleDBContext(options.Options);
var peopleDbInitializer = new PeopleDBInitializer(context);
peopleDbInitializer.SeedDBContext();
services.AddSingleton(context);
}
public static void initialize(PeopleDBContext context)
{
context.Database.EnsureCreated();
if (context.Poeples.Any())
{
return;
}
else
{
context.Poeples.Add(new Person("Mattias", "Rävemåla", "Malmö"));
context.SaveChanges();
}
}
public ActionResult Edit(int id)
{
using (PeopleDBContext context = new PeopleDBContext()) {
var model = context.People.FirstOrDefault(p => p.Id == id);
if (model != null)
{
return(PartialView("_Edit", model));
}
else
{
return(RedirectToAction("Index"));
}
}
}
public ActionResult Delete(int id)
{
using (PeopleDBContext context = new PeopleDBContext()) {
try {
Person person = context.People.Find(id);
context.People.Remove(person);
context.SaveChanges();
}
catch (DataException ex) {
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(Person person)
{
using (PeopleDBContext context = new PeopleDBContext()) {
var model = context.People.FirstOrDefault(p => p.Id == person.Id);
if (model != null && TryUpdateModel(model, "", new string[] { "Lastname", "Firtsname", "Country", "Phonenumber", "ProfilePicPath" }))
{
try {
context.SaveChanges();
return(RedirectToAction("Index"));
}
catch (DataException ex) {
ModelState.AddModelError("", "Unable to update");
}
}
}
return(RedirectToAction("Index"));
}
public PeopleRepository()
{
db = new PeopleDBContext();
}
public PeopleService(PeopleDBContext peopleDBContext)
{
_peopleDBContext = peopleDBContext;
}
public PeopleDBInitializer(PeopleDBContext peopleDbContext)
{
this.peopleDbContext = peopleDbContext;
}
//private IPeopleRepository _peopleRepository;
public PeopleController(PeopleDBContext peopleDBContext, IWebHostEnvironment environment)
{
_peopleDBContext = peopleDBContext;
_environment = environment;
//_peopleRepository = peopleRepository;
}
public PeopleController(PeopleDBContext peopleContext)
{
this.peopleContext = peopleContext;
}
public ValuesController(PeopleDBContext peopleDbContext)
{
_peopleDbContext = peopleDbContext;
}
public PeopleRepository(PeopleDBContext peopleDBContext)
{
_peopleDBContext = peopleDBContext;
}
public UserRepository(PeopleDBContext context, ILogger <UserRepository> logger)
{
_context = context;
_logger = logger;
}
public PeopleRepository(PeopleDBContext ctx)
{
this._context = ctx;
}
