示例#1
0
        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);
            }
        }
示例#2
0
        public async void TestHireRequests()
        {
            var options = new DbContextOptionsBuilder <Databasecontext
                                                       >().UseInMemoryDatabase(databaseName: "Test1")
                          .Options;

            using (var context = new Databasecontext(options))
            {
                var hireRequest = new HireRequest(1, "1", "1");

                HireRequestsController HireRequests = new HireRequestsController(context);
                context.Add(hireRequest);
                context.SaveChanges();

                var hire = await HireRequests.GetHireRequests();

                IEnumerable <HireRequest> result = hire.Value;
                Assert.Single(result);
                Assert.Equal("1", result.Last().ClientId);
            }
        }
示例#3
0
        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);
            }
        }
示例#4
0
        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);
            }
        }
示例#5
0
        public async void TestPostSkills()
        {
            var options = new DbContextOptionsBuilder <Databasecontext
                                                       >().UseInMemoryDatabase(databaseName: "Test3")
                          .Options;

            using (var context = new Databasecontext(options))
            {
                var skill = new SkillsVM()
                {
                    skillId          = "1",
                    skillName        = "test",
                    skillDescription = "test"
                };

                SkillsController Skills = new SkillsController(context);

                await Skills.PostSkill(skill);

                var find = context.Skills.Find(1);
                Assert.Equal(1, find.SkillId);
            }
        }
示例#6
0
        public async void TestDeleteSkills()
        {
            var options = new DbContextOptionsBuilder <Databasecontext
                                                       >().UseInMemoryDatabase(databaseName: "Test4")
                          .Options;

            using (var context = new Databasecontext(options))
            {
                var skill = new Skill()
                {
                    SkillId          = 1,
                    skillName        = "test",
                    skillDescription = "test"
                };

                SkillsController Skills = new SkillsController(context);

                context.Skills.Add(skill);
                await Skills.DeleteSkill(1);

                var find = context.Skills.Find(1);
                Assert.Null(find);
            }
        }
示例#7
0
        public async void TestReturnSkillsWithId()
        {
            var options = new DbContextOptionsBuilder <Databasecontext
                                                       >().UseInMemoryDatabase(databaseName: "Test")
                          .Options;

            using (var context = new Databasecontext(options))
            {
                var skill = new Skill()
                {
                    SkillId     = 1,
                    SkillName   = "test",
                    Description = "test"
                };
                context.Add(skill);
                context.SaveChanges();
                SkillsController Skills = new SkillsController(context);

                var skills = await Skills.GetSkill(1);

                Skill result = skills.Value;
                Assert.Equal("test", result.Description);
            }
        }
示例#8
0
 public Nhanvienf()
 {
     mydatabase = new Databasecontext();
 }
 public ClientsController(Databasecontext context)
 {
     _context = context;
 }
示例#10
0
 public HireRequestsController(Databasecontext context)
 {
     _context = context;
 }
 public ContractorsController(Databasecontext context)
 {
     _context = context;
 }
示例#12
0
 public Userf()
 {
     mydatabase = new Databasecontext();
 }
示例#13
0
 public UserRepositpory()
 {
     _dataConext = new Databasecontext();
 }
 public EmployeeRepository()
 {
     _dataConext = new Databasecontext();
 }
 public PositionNeedsSkillsController(Databasecontext context)
 {
     _context = context;
 }
示例#16
0
 public ProjectsController(Databasecontext context)
 {
     _context = context;
 }
 public SkillsController(Databasecontext context)
 {
     _context = context;
 }
示例#18
0
 public PositionsController(Databasecontext context)
 {
     _context = context;
 }
示例#19
0
 public phongbanf()
 {
     mydatabase = new Databasecontext();
 }