protected Affiliation Seed(CreateAffiliation command)
{
// make sure entity does not already exist
Affiliation affiliation = _queryProcessor.Execute(
new AffiliationByPrimaryKey(command.PersonId, command.EstablishmentId));
if (affiliation != null) return affiliation;
_createAffiliation.Handle(command);
_unitOfWork.SaveChanges();
return command.CreatedAffiliation;
}
public void Handle(ImportUsfPerson command)
{
if (command == null)
{
throw new ArgumentNullException("command");
}
var reportBuilder = command.ReportBuilder ?? new WorkReportBuilder("Import USF Person");
// find user by id
reportBuilder.Report("Querying database for user #{0}.", command.UserId);
var user = _entities.Get <User>()
.EagerLoad(_entities, new Expression <Func <User, object> >[]
{
x => x.Person.Affiliations,
})
.Single(x => x.RevisionId == command.UserId);
reportBuilder.Report("Found matching user with name '{0}'.", user.Name);
// invoke USF person service
reportBuilder.Report("Invoking USF person service with user name '{0}'.", user.Name);
//const string testJson = "{\"Last Name\":\"Hernandez\",\"First Name\":\"Mario\",\"Middle Name\":\" \",\"Suffix\":\" \",\"Gender\":\"Male\",\"USF Email Address\":\"[email protected]\",\"lastUpdate\":\"05-28-2013\",\"profile\":[{\"DEPTID\":\"0-5830-001\",\"Faculty Rank\":\"2\",\"Position Title\":\"Professor\",\"Institutional Affiliation\":\"USF Tampa\",\"College\":\"College of Behavioral and Community Sciences\",\"Department/Program\":\"Division of Administration and Communication\"},{\"DEPTID\":\"0-6405-000\",\"Faculty Rank\":\"2\",\"Position Title\":\"Professor\",\"Institutional Affiliation\":\"USF Tampa\",\"College\":\"College of Public Health\",\"Department/Program\":\"Department of Community and Family Health\"}]}";
//var usfPerson = JsonConvert.DeserializeObject<UsfPersonData>(testJson);
var usfPerson = _queryProcessor.Execute(new UsfPerson(command.Service, user.Name)
{
ReportBuilder = reportBuilder,
});
if (usfPerson == null)
{
throw new InvalidOperationException(string.Format(
"Could not obtain data for user '{2}' using '{0}_{1}'service integration.",
command.Service.Integration.Name, command.Service.Integration.TenantId, user.Name));
}
reportBuilder.Report("Deserialized USF person response to CLR object.");
reportBuilder.Report("JSON value of deserialized response is:");
reportBuilder.Report(JsonConvert.SerializeObject(usfPerson));
reportBuilder.Report("Invoking command to import USF organization data.");
_importEstablishments.Handle(new ImportUsfEstablishments(command.Principal, command.Service, usfPerson.LastUpdate)
{
ReportBuilder = reportBuilder,
});
// check affiliations (only do this once when created)
if (usfPerson.Affiliations != null && usfPerson.Affiliations.Any())
{
reportBuilder.Report("USF person has affiliations, loading offspring and module settings.");
var usf = _entities.Query <Establishment>()
.EagerLoad(_entities, new Expression <Func <Establishment, object> >[]
{
x => x.Offspring,
})
.Single(x => x.RevisionId == command.Service.Integration.TenantId);
var offspring = usf.Offspring.Select(x => x.Offspring).ToArray();
var settings = _queryProcessor.Execute(new EmployeeSettingsByEstablishment(usf.RevisionId)
{
EagerLoad = new Expression <Func <EmployeeModuleSettings, object> >[]
{
x => x.FacultyRanks,
},
});
reportBuilder.Report("Iterating over {0} affiliations.", usfPerson.Affiliations.Length);
var createdAffiliations = new List <Affiliation>();
foreach (var usfAffiliation in usfPerson.Affiliations)
{
// make sure the establishment exists
var establishment = offspring.SingleOrDefault(x => x.CustomIds.Any(y => y.Value == usfAffiliation.DepartmentId));
if (establishment == null)
{
throw new InvalidOperationException(string.Format(
"Could not find UCosmic establishment for USF Department '{0}'.", usfAffiliation.DepartmentId));
}
// make sure the affiliation is not a duplicate
if (createdAffiliations.Any(x => x.EstablishmentId == establishment.RevisionId && x.PersonId == user.Person.RevisionId))
{
continue;
}
var facultyRank = settings.FacultyRanks.SingleOrDefault(x => x.Rank == usfAffiliation.PositionTitle);
var createAffiliationCommand = new CreateAffiliation(command.Principal, user.Person.RevisionId, establishment.RevisionId)
{
NoCommit = true,
FacultyRankId = facultyRank != null ? facultyRank.Id : (int?)null,
};
_createAffiliation.Handle(createAffiliationCommand);
createdAffiliations.Add(createAffiliationCommand.Created);
}
}
// possibly add a new email addresss
if (!user.Name.Equals(usfPerson.EmailAddress, StringComparison.OrdinalIgnoreCase))
{
reportBuilder.Report("USF person has email address '{0}' different from username.", usfPerson.EmailAddress);
// create user command will already have created an email based on the username / EPPN
// we trust USF email addresses, so change the email added during person creation
user.Person.Emails.Single(x => x.IsDefault).Value = usfPerson.EmailAddress;
}
// update person
var displayName = _queryProcessor.Execute(new GenerateDisplayName
{
FirstName = usfPerson.FirstName,
MiddleName = usfPerson.MiddleName,
LastName = usfPerson.LastName,
Suffix = usfPerson.Suffix,
});
if (string.IsNullOrWhiteSpace(displayName))
{
displayName = usfPerson.EmailAddress;
}
var updatePersonCommand = new UpdatePerson(command.Principal, user.Person.RevisionId)
{
NoCommit = true,
FirstName = usfPerson.FirstName,
MiddleName = usfPerson.MiddleName,
LastName = usfPerson.LastName,
Gender = string.IsNullOrWhiteSpace(usfPerson.Gender) ? "P" : usfPerson.Gender.Substring(0, 1).ToUpper(),
Suffix = usfPerson.Suffix,
DisplayName = displayName,
IsDisplayNameDerived = false,
IsActive = true,
};
_updatePerson.Handle(updatePersonCommand);
reportBuilder.Report("Committing changes based on USF person response.");
_entities.SaveChanges();
reportBuilder.Report("Committed changes based on USF person response.");
}