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