public async Task <ActionResult <ProjectPositions> > PostProjectPositions(ProjectPositions projectPositions) { _context.ProjectPositions.Add(projectPositions); await _context.SaveChangesAsync(); return(CreatedAtAction("GetProjectPositions", new { id = projectPositions.ProjectPositionsId }, projectPositions)); }
public async Task <IActionResult> PutProjectPositions(int id, ProjectPositions projectPositions) { if (id != projectPositions.ProjectPositionsId) { return(BadRequest()); } _context.Entry(projectPositions).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProjectPositionsExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async void TestReturnProjectPositions() { var options = new DbContextOptionsBuilder <Databasecontext >().UseInMemoryDatabase(databaseName: "Test2") .Options; using (var context = new Databasecontext(options)) { var projectPositions = new ProjectPositions(); context.Add(projectPositions); context.SaveChanges(); ProjectPositionsController ProjectPositions = new ProjectPositionsController(context); var projectpos = await ProjectPositions.GetProjectPositions(); IEnumerable <ProjectPositions> result = projectpos.Value; Assert.Single(result); } }
public async void TestReturnProjectPositionsWithId() { var options = new DbContextOptionsBuilder <Databasecontext >().UseInMemoryDatabase(databaseName: "Test") .Options; using (var context = new Databasecontext(options)) { var projectPositions = new ProjectPositions(); context.Add(projectPositions); context.SaveChanges(); ProjectPositionsController ProjectPositions = new ProjectPositionsController(context); var project = await ProjectPositions.GetProjectPositions(1); ProjectPositions result = project.Value; Assert.Equal(1, result.ProjectPositionsId); } }
public async void TestPostProjectPositions() { var options = new DbContextOptionsBuilder <Databasecontext >().UseInMemoryDatabase(databaseName: "Test4") .Options; using (var context = new Databasecontext(options)) { var projectPositions = new ProjectPositions() { ProjectId = 1 }; ProjectPositionsController ProjectPositions = new ProjectPositionsController(context); var actionresult = await ProjectPositions.PostProjectPositions(projectPositions); ProjectPositions res = context.ProjectPositions.Find(1); Assert.Equal(1, res.ProjectPositionsId); } }
public async void DeleteProjectPositions() { var options = new DbContextOptionsBuilder <Databasecontext >().UseInMemoryDatabase(databaseName: "Test4") .Options; using (var context = new Databasecontext(options)) { var projectPositions = new ProjectPositions() { ProjectId = 1 }; ProjectPositionsController ProjectPositions = new ProjectPositionsController(context); context.Add(projectPositions); await ProjectPositions.DeleteProjectPositions(1); var result = context.ProjectPositions.Find(1); Assert.Null(result); } }
public async void TestGetContractorProjects() { var options = new DbContextOptionsBuilder <Databasecontext >().UseInMemoryDatabase(databaseName: "Test6") .Options; using (var context = new Databasecontext(options)) { var project = new Project("user", DateTime.Now, DateTime.Now, 1.00, "test", "test") { ProjectId = 3, UserId = "1", StartDate = DateTime.Now, EndDate = DateTime.Now, PaymentOffered = 1.00, ProjectName = "test", Description = "test" }; var projectpos = new ProjectPositions() { ProjectPositionsId = 1, ProjectId = 3, PositionId = 1, ContractorId = "1" }; context.Add(project); context.Add(projectpos); context.SaveChanges(); ProjectsController projectController = new ProjectsController(context); var actionresult = await projectController.GetProjectByContractor("1"); var result = (OkObjectResult)actionresult.Result; List <Project> result2 = (List <Project>)result.Value; Assert.Equal(3, result2.Last().ProjectId); } }
public async void TestGetProjectPositionsByProjectId() { var options = new DbContextOptionsBuilder <Databasecontext >().UseInMemoryDatabase(databaseName: "Test3") .Options; using (var context = new Databasecontext(options)) { var projectPositions = new ProjectPositions() { ProjectId = 1 }; context.Add(projectPositions); context.SaveChanges(); ProjectPositionsController ProjectPositions = new ProjectPositionsController(context); var actionresult = await ProjectPositions.GetPositionsByProjectId(1); var result = (OkObjectResult)actionresult.Result; List <ProjectPositions> result2 = (List <ProjectPositions>)result.Value; Assert.Equal(1, result2.Last().ProjectId); } }