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(); }