public IEnumerable <AspNetUser> GetUsers() { var context2 = new DevDetective2Entities(); var context1 = new DevDetectiveEntities1(); var usersIds = context1.FacilityUsers.Where(x => x.Facility.TenantId == _tenantId).Select(x => x.UserId).ToList(); var users = context2.AspNetUsers.Where(x => !usersIds.Contains(x.Email)); return(users); }
protected void CreateFacilityUser(object sender, EventArgs e) { var context2 = new DevDetective2Entities(); var context1 = new DevDetectiveEntities1(); var userEmail = UserIdTextBox.Text; var user = context2.AspNetUsers.FirstOrDefault(x => x.Email == userEmail); if (user == null) { throw new Exception("Todo add an error message"); } int facilityId = -100000; int.TryParse(FacilityIdTextBox.Text, out facilityId); var facilities = context1.Facilities.Where(x => x.TenantId == _tenantId).ToList(); var matchingFacility = facilities.FirstOrDefault(x => x.Id == facilityId); if (matchingFacility != null) { var fu = new FacilityUser(); fu.UserId = userEmail; fu.FacilityId = matchingFacility.Id; matchingFacility.FacilityUsers.Add(fu); var childFacilities = matchingFacility.Facilities1; foreach (var child in childFacilities) { var childFu = new FacilityUser(); childFu.UserId = userEmail; matchingFacility.ParentFacilityId = _tenantId; childFu.FacilityId = child.Id; child.FacilityUsers.Add(childFu); } } else { foreach (var facility in facilities) { var fu = new FacilityUser(); fu.UserId = userEmail; fu.FacilityId = facility.Id; facility.FacilityUsers.Add(fu); } } context1.SaveChanges(); }