public async Task <IActionResult> Create([Bind("id,reviewID,reportContent,isHandled")] Report report)
{
if (ModelState.IsValid)
{
_context.Add(report);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(report));
}
public async Task <IActionResult> Create([Bind("Id,CustomerName,CompanyName,Email,ReportType,ReportDescription,ReportDate")] Report report)
{
if (ModelState.IsValid)
{
_context.Add(report);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(report));
}
public void TestGetById()
{
var options = new DbContextOptionsBuilder <ReportContext>()
.UseInMemoryDatabase(databaseName: "testGetById")
.Options;
//Set up the objects first.
User user = new User
{
FirstName = "Darius is a cat"
};
string address1 = "21 Darius Road";
string address2 = "22 Darius Road";
House house = new House
{
Address = address1,
ConstructionType = "Wood",
InspectionDate = DateTime.Today
};
House house2 = new House
{
Address = address2,
ConstructionType = "Wood",
InspectionDate = DateTime.Today
};
HouseUser hu = new HouseUser
{
House = house,
User = user
};
HouseUser hu2 = new HouseUser
{
House = house2,
User = user
};
user.Inspected = new List <HouseUser> {
hu, hu2
};
//Set up the context.
using (var context = new ReportContext(options))
{
context.Add(user);
context.SaveChanges();
}
//Try retreiving
using (var context = new ReportContext(options))
{
//Find id of user!
long userId = context.User.Single().Id;
//Find id of house!
long houseId1 = context.House.Where(h => h.Address == address1).Single().Id;
long houseId2 = context.House.Where(h => h.Address == address2).Single().Id;
UserController userController = new UserController(context);
OkObjectResult result = userController.GetById(userId) as OkObjectResult;
User userGot = result.Value as User;
Assert.AreEqual(200, result.StatusCode);
Assert.IsNotNull(userGot);
Assert.AreEqual(userId, userGot.Id);
Assert.AreEqual("Darius is a cat", user.FirstName);
//Should include houseUser
ICollection <HouseUser> houseUsers = userGot.Inspected;
Assert.IsNotNull(houseUsers);
Assert.AreEqual(2, houseUsers.Count);
//Should then include house
HouseUser firstHouseUser = houseUsers.Where(x => x.House.Address == address1).Single();
HouseUser secondHouseUser = houseUsers.Where(x => x.House.Address == address2).Single();
Assert.IsNotNull(firstHouseUser);
Assert.IsNotNull(secondHouseUser);
//Same user
Assert.AreEqual(userId, firstHouseUser.User.Id);
Assert.AreEqual(userId, secondHouseUser.User.Id);
//Two houses
Assert.AreEqual(houseId1, firstHouseUser.House.Id);
Assert.AreEqual(houseId2, secondHouseUser.House.Id);
}
}
public Task SaveReport(Report report)
{
return(_reportContext.Add((ReportDataBase.Models.Report)report));
}
public void AddCompanyReport(CompanyReport report)
{
context.Add(report);
context.SaveChanges();
}
