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