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