public void SetUp()
        {
            var dbContextOptionsBuilder = new DbContextOptionsBuilder <OrgChartDbContext>();

            dbContextOptionsBuilder.UseInMemoryDatabase(Guid.NewGuid().ToString());
            _context = new OrgChartDbContext(dbContextOptionsBuilder.Options, _userService);
        }
        public DepartmentViewModel(Department department)
        {
            Department = department;

            var dbContext = new OrgChartDbContext();
            Managers = new SelectList(new EmployeeRepository(dbContext).SelectAll().Where(_ => _.IsManager).OrderBy(_ => _.LastName), "Id", "LastName", department.ManagerId);
            Departments = new SelectList(new DepartmentRepository(dbContext).SelectAll().OrderBy(_ => _.Name), "Id", "Name", department.ParentDepartmentId);
        }
        public EmployeeViewModel(Employee employee)
        {
            Employee = employee;

            var dbContext = new OrgChartDbContext();
            JobTitles = new SelectList(new JobTitleRepository(dbContext).SelectAll().OrderBy(_ => _.Description), "Id", "Description", employee.JobTitleId);
            Departments = new SelectList(new DepartmentRepository(dbContext).SelectAll(), "Id", "Name", employee.DepartmentId);
            Managers = new SelectList(new EmployeeRepository(dbContext).SelectAll().Where(_ => _.IsManager).OrderBy(_ => _.LastName), "Id", "LastName", employee.ManagerId);
        }
Exemple #4
0
        public void CanUpdateEntity()
        {
            _employee.FirstName = "Sample";
            _dbcontext.SaveChanges();

            var verifyContext = new OrgChartDbContext();
            var updated = verifyContext.Employees.Single(_ => _.Id == _employee.Id);

            Assert.That(updated.Id, Is.EqualTo(_employee.Id));
        }
        public void CanUpdateEntity()
        {
            _department.Name = "Sample Department";
            _dbcontext.SaveChanges();

            var verifyContext = new OrgChartDbContext();
            var updated = verifyContext.Departments.Single(_ => _.Id == _department.Id);

            Assert.That(_department.Name, Is.EqualTo(updated.Name));
        }
Exemple #6
0
        public void CanUpdateEntity()
        {
            _jobTitle.Description = "newDescription";
            _dbcontext.SaveChanges();

            var verifyContext = new OrgChartDbContext();
            var updated = verifyContext.JobTitles.Single(_ => _.Id == _jobTitle.Id);

            Assert.That(_jobTitle.Description, Is.EqualTo(updated.Description));
        }
Exemple #7
0
        public void SetUp()
        {
            _dbcontext = new OrgChartDbContext();
            _jobTitle = new JobTitle
            {
                Description = "test",
            };

            _dbcontext.JobTitles.Add(_jobTitle);
            _dbcontext.SaveChanges();
        }
        public void SetUp()
        {
            _dbcontext = new OrgChartDbContext();
            _department = new Department
            {
                Name = "Test Department",
                ParentDepartmentId = null,
            };

            _dbcontext.Departments.Add(_department);
            _dbcontext.SaveChanges();
        }
Exemple #9
0
        public void SetUp()
        {
            _dbcontext = new OrgChartDbContext();
            _employee = new Employee
            {
                FirstName = "Test",
                LastName = "Person",
                JobTitleId = null,
                IsManager = false,
                ManagerId = null,
                DepartmentId = null,
            };

            _dbcontext.Employees.Add(_employee);
            _dbcontext.SaveChanges();
        }
        public static async Task SeedAsync(OrgChartDbContext context, string userId)
        {
            var organizations = context.Set <Organization>();

            if (!organizations.Any())
            {
                var dunderMifflin = new Organization
                {
                    Name   = "Dunder Mifflin",
                    UserId = userId
                };
                await organizations.AddAsync(dunderMifflin);

                await context.SaveChangesAsync();

                var people = context.Set <Person>();

                var davidWallace = new Person
                {
                    UserId       = userId,
                    FirstName    = "David",
                    LastName     = "Wallace",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "111-111-1111",
                    Title        = "Chief Financial Officer",
                    ReportsTo    = null,
                    Organization = dunderMifflin
                };

                await people.AddAsync(davidWallace);

                await context.SaveChangesAsync();

                var janLevinson = new Person
                {
                    UserId       = userId,
                    FirstName    = "Jan",
                    LastName     = "Levinson",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "222-222-2222",
                    ReportsTo    = davidWallace,
                    Organization = dunderMifflin,
                    Title        = "Vice President of Northeast Sales"
                };

                await people.AddAsync(janLevinson);

                await context.SaveChangesAsync();

                var michaelScott = new Person
                {
                    UserId       = userId,
                    FirstName    = "Michael",
                    LastName     = "Scott",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "333-333-3333",
                    ReportsTo    = janLevinson,
                    Organization = dunderMifflin,
                    Title        = "Regional Manager"
                };

                await people.AddAsync(michaelScott);

                await context.SaveChangesAsync();

                var jimHalpert = new Person
                {
                    UserId       = userId,
                    FirstName    = "Jim",
                    LastName     = "Halpert",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "444-444-4444",
                    ReportsTo    = michaelScott,
                    Organization = dunderMifflin,
                    Title        = "Assistant Regional Manager"
                };

                var dwightSchrute = new Person
                {
                    UserId       = userId,
                    FirstName    = "Dwight",
                    LastName     = "Schrute",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "555-555-5555",
                    ReportsTo    = michaelScott,
                    Organization = dunderMifflin,
                    Title        = "Assistant to the Regional Manager"
                };

                await people.AddRangeAsync(jimHalpert, dwightSchrute);

                await context.SaveChangesAsync();

                var phyllisLapin = new Person
                {
                    UserId       = userId,
                    FirstName    = "Phyllis",
                    LastName     = "Lapin",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "666-666-6666",
                    ReportsTo    = jimHalpert,
                    Organization = dunderMifflin,
                    Title        = "Sales Representative"
                };

                var stanleyHudson = new Person
                {
                    UserId       = userId,
                    FirstName    = "Stanley",
                    LastName     = "Hudson",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "777-777-7777",
                    ReportsTo    = jimHalpert,
                    Organization = dunderMifflin,
                    Title        = "Sales Representative"
                };

                var angelaMartin = new Person
                {
                    UserId       = userId,
                    FirstName    = "Angela",
                    LastName     = "Martin",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "888-888-8888",
                    ReportsTo    = jimHalpert,
                    Organization = dunderMifflin,
                    Title        = "Senior Accountant"
                };

                await people.AddRangeAsync(phyllisLapin, stanleyHudson, angelaMartin);

                await context.SaveChangesAsync();

                var oscarMartinez = new Person
                {
                    UserId       = userId,
                    FirstName    = "Oscar",
                    LastName     = "Martinez",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "999-999-9999",
                    ReportsTo    = angelaMartin,
                    Organization = dunderMifflin,
                    Title        = "Accountant"
                };

                var kevinMalone = new Person
                {
                    UserId       = userId,
                    FirstName    = "Kevin",
                    LastName     = "Malone",
                    EmailAddress = "*****@*****.**",
                    PhoneNumber  = "000-000-0000",
                    ReportsTo    = angelaMartin,
                    Organization = dunderMifflin,
                    Title        = "Accountant"
                };

                await people.AddRangeAsync(oscarMartinez, kevinMalone);

                await context.SaveChangesAsync();

                var org = context.Set <Organization>().IgnoreQueryFilters().Where(o => o.UserId == userId).ToList();
                System.Console.WriteLine();
            }
        }
 public void TearDown()
 {
     _context.Dispose();
     _context = null;
 }