public void Execute(IJobExecutionContext context)
{
var apiClient = new APIClient();
var settings = SettingsComponent.GetComponent <LeagueAppsSettings>();
var connectionStatus = DefinedValueCache.Get(settings.GetAttributeValue(Constants.DefaultConnectionStatus).AsGuid());
var createNew = context.JobDetail.JobDataMap.GetString("CreateNew").AsBoolean();
int lastId = 0;
long latestUpdated = 0;
List <Member> members = null;
var count = 0;
do
{
members = apiClient.GetPrivate <List <Member> >("v2/sites/{siteid}/export/members-2?last-updated=" + latestUpdated.ToString() + "&last-id=" + lastId.ToString());
foreach (var member in members)
{
lastId = member.userId;
latestUpdated = member.lastUpdated;
var person = LeagueAppsHelper.GetPersonByApiId(member.userId);
if (person == null && !createNew)
{
continue;
}
if (person == null)
{
person = LeagueAppsHelper.CreatePersonFromMember(member, connectionStatus);
}
if (person == null)
{
continue;
}
var family = person.PrimaryFamily;
if (family == null)
{
continue;
}
family.LoadAttributes();
if (family.GetAttributeValue(Constants.LeagueAppsFamilyId).IsNullOrWhiteSpace())
{
family.SetAttributeValue(Constants.LeagueAppsFamilyId, member.groupId);
family.SaveAttributeValues();
}
count++;
}
} while (members != null && members.Any());
context.Result = "Successfully imported " + count + " participants.";
}
/// <summary>Process all leagues (programs) from LeagueApps.</summary>
/// <param name="message">The message that is returned depending on the result.</param>
/// <param name="state">The state of the process.</param>
/// <returns><see cref="WorkerResultStatus"/></returns>
public void Execute(IJobExecutionContext context)
{
RockContext dbContext = new RockContext();
GroupService groupService = new GroupService(dbContext);
AttributeService attributeService = new AttributeService(dbContext);
AttributeValueService attributeValueService = new AttributeValueService(dbContext);
GroupTypeRoleService groupTypeRoleService = new GroupTypeRoleService(dbContext);
DefinedValueService definedValueService = new DefinedValueService(dbContext);
DefinedTypeService definedTypeService = new DefinedTypeService(dbContext);
BinaryFileService binaryFileService = new BinaryFileService(dbContext);
// Get the datamap for loading attributes
JobDataMap dataMap = context.JobDetail.JobDataMap;
var warnings = string.Empty;
var processed = 0;
try
{
var apiClient = new APIClient();
var settings = SettingsComponent.GetComponent <LeagueAppsSettings>();
//Group Attributes
var parentGroup = groupService.Get(settings.GetAttributeValue(Constants.ParentGroup).AsGuid());
var yearGroupType = GroupTypeCache.Get(settings.GetAttributeValue(Constants.YearGroupType).AsGuid());
var categoryGroupType = GroupTypeCache.Get(settings.GetAttributeValue(Constants.CategoryGroupType).AsGuid());
var leagueGroupType = GroupTypeCache.Get(settings.GetAttributeValue(Constants.LeagueGroupType).AsGuid());
var sportsType = DefinedTypeCache.Get(Constants.SPORTS_TYPE.AsGuid());
var seasonsType = DefinedTypeCache.Get(Constants.SEASONS_TYPE.AsGuid());
var gendersType = DefinedTypeCache.Get(Constants.GENDERS_TYPE.AsGuid());
var groupMemberAttribute = AttributeCache.Get(settings.GetAttributeValue(Constants.LeagueGroupTeam).AsGuid());
//Person Attribute
var personattribute = AttributeCache.Get(Constants.ATTRIBUTE_PERSON_USER_ID.AsGuid());
var connectionStatus = DefinedValueCache.Get(settings.GetAttributeValue(Constants.DefaultConnectionStatus).AsGuid());
var groupEntityType = EntityTypeCache.Get(typeof(Group)).Id;
var programs = apiClient.GetPublic <List <Programs> >("/v1/sites/{siteid}/programs/current");
var groups = groupService.Queryable().Where(g => g.GroupTypeId == leagueGroupType.Id).ToList();
foreach (Contracts.Programs program in programs)
{
// Process the program
Group league = null;
Group league2 = null;
Group league3 = null;
var startdate = program.startTime;
var mode = program.mode.ToLower();
mode = mode.First().ToString().ToUpper() + mode.Substring(1);
var grandparentgroup = string.Format("{0}", startdate.Year);
if (program.programId > 0)
{
league = groupService.Queryable().Where(l => l.Name == grandparentgroup && l.ParentGroupId == parentGroup.Id).FirstOrDefault();
if (league != null)
{
league2 = groupService.Queryable().Where(l => l.Name == mode && l.ParentGroupId == league.Id).FirstOrDefault();
if (league2 != null)
{
league3 = groupService.Queryable().Where(l => l.ForeignId == program.programId && l.GroupTypeId == leagueGroupType.Id && l.ParentGroupId == league2.Id).FirstOrDefault();
}
}
}
Guid guid = Guid.NewGuid();
Guid guid2 = Guid.NewGuid();
Guid guid3 = Guid.NewGuid();
if (league == null)
{
// Create league grandparent Group
Group leagueGPG = new Group();
leagueGPG.Name = grandparentgroup;
leagueGPG.GroupTypeId = yearGroupType.Id;
leagueGPG.ParentGroupId = parentGroup.Id;
leagueGPG.IsSystem = false;
leagueGPG.IsActive = true;
leagueGPG.IsSecurityRole = false;
leagueGPG.Order = 0;
leagueGPG.Guid = guid;
groupService.Add(leagueGPG);
// Now save the league grandparent group
dbContext.SaveChanges();
league = leagueGPG;
}
if (league2 == null)
{
// Create league parent Group
Group leaguePG = new Group();
leaguePG.Name = mode;
leaguePG.GroupTypeId = categoryGroupType.Id;
leaguePG.ParentGroupId = league.Id;
leaguePG.IsSystem = false;
leaguePG.IsActive = true;
leaguePG.IsSecurityRole = false;
leaguePG.Order = 0;
leaguePG.Guid = guid2;
groupService.Add(leaguePG);
// Now save the league parent group
dbContext.SaveChanges();
league2 = leaguePG;
}
if (league3 == null)
{
// Create the league
Group leagueG = new Group();
leagueG.Name = program.name;
leagueG.GroupTypeId = leagueGroupType.Id;
leagueG.ParentGroupId = league2.Id;
leagueG.IsSystem = false;
leagueG.IsActive = true;
leagueG.IsSecurityRole = false;
leagueG.Order = 0;
leagueG.Description = HTMLConvertor.Convert(program.description);
leagueG.ForeignId = program.programId;
groupService.Add(leagueG);
// Now save the league
dbContext.SaveChanges();
league3 = leagueG;
}
else
{
groups.Remove(league3);
}
league3.LoadAttributes();
var sport = definedValueService.Queryable().Where(d => d.Value == program.sport && d.DefinedTypeId == sportsType.Id).FirstOrDefault();
var season = definedValueService.Queryable().Where(d => d.Value == program.season && d.DefinedTypeId == seasonsType.Id).FirstOrDefault();
var groupgender = definedValueService.Queryable().Where(d => d.Value == program.gender && d.DefinedTypeId == gendersType.Id).FirstOrDefault();
if (!sport.IsNull())
{
league3.SetAttributeValue("Sport", sport.Guid);
}
if (!season.IsNull())
{
league3.SetAttributeValue("Season", season.Guid);
}
league3.SetAttributeValue("ExperienceLevel", program.experienceLevel);
if (!groupgender.IsNull())
{
league3.SetAttributeValue("Gender", groupgender.Guid);
}
if (startdate != DateTime.MinValue)
{
league3.SetAttributeValue("StartTime", startdate);
}
if (program.publicRegistrationTime != DateTime.MinValue)
{
league3.SetAttributeValue("PublicRegistrationTime", program.publicRegistrationTime);
}
if (program.ageLimitEffectiveDate != DateTime.MinValue)
{
league3.SetAttributeValue("AgeLimitDate", program.ageLimitEffectiveDate.Date.ToString("d"));
}
league3.SetAttributeValue("ProgramURL", program.programUrlHtml);
league3.SetAttributeValue("RegisterURL", program.registerUrlHtml);
league3.SetAttributeValue("ScheduleURL", program.scheduleUrlHtml);
league3.SetAttributeValue("StandingsURL", program.standingsUrlHtml);
league3.SetAttributeValue("ProgramLogo", program.programLogo150);
league3.SaveAttributeValues();
dbContext.SaveChanges();
var applicants = apiClient.GetPrivate <List <Registrations> >("/v2/sites/{siteid}/export/registrations-2?last-updated=0&last-id=0&program-id=" + program.programId);
context.UpdateLastStatusMessage("Processing league " + (processed + 1) + " of " + programs.Count + ": " + program.startTime.Year + " > " + program.mode + " > " + program.name + " (" + applicants.Count + " members).");
foreach (Contracts.Registrations applicant in applicants)
{
// Use a fresh RockContext on every person/groupmember to keep things moving quickly
using (var rockContext = new RockContext())
{
PersonService personService = new PersonService(rockContext);
GroupMemberService groupMemberService = new GroupMemberService(rockContext);
LocationService locationService = new LocationService(rockContext);
Person person = null;
// 1. Try to load the person using the LeagueApps UserId
var attributevalue = applicant.userId.ToString();
var personIds = attributeValueService.Queryable().Where(av => av.AttributeId == personattribute.Id &&
(av.Value == attributevalue ||
av.Value.Contains("|" + attributevalue + "|") ||
av.Value.StartsWith(attributevalue + "|"))).Select(av => av.EntityId);
if (personIds.Count() == 1)
{
person = personService.Get(personIds.FirstOrDefault().Value);
}
// 2. If we don't have a person match then
// just use the standard person match/create logic
if (person == null)
{
var member = apiClient.GetPrivate <Member>("/v2/sites/{siteid}/members/" + applicant.userId);
person = LeagueAppsHelper.CreatePersonFromMember(member, connectionStatus);
}
// Check to see if the group member already exists
var groupmember = groupMemberService.GetByGroupIdAndPersonId(league3.Id, person.Id).FirstOrDefault();
if (groupmember == null)
{
Guid guid5 = Guid.NewGuid();
groupmember = new GroupMember();
groupmember.PersonId = person.Id;
groupmember.GroupId = league3.Id;
groupmember.IsSystem = false;
groupmember.Guid = guid5;
if (!String.IsNullOrEmpty(applicant.role))
{
var role = applicant.role.Split('(')[0].Trim();
if (role == "FREEAGENT" || role == "PLAYER")
{
role = "Member";
}
else if (role == "CAPTAIN")
{
role = "Captain";
}
else if (role == "HEAD COACH" || role == "Head Coach")
{
role = "Head Coach";
}
else if (role == "ASST. COACH" || role == "Asst. Coach")
{
role = "Asst. Coach";
}
else
{
role = "Member";
}
var grouprole = groupTypeRoleService.Queryable().Where(r => r.GroupTypeId == leagueGroupType.Id && r.Name == role).FirstOrDefault().Id;
groupmember.GroupRoleId = grouprole;
}
else
{
groupmember.GroupRoleId = leagueGroupType.DefaultGroupRoleId.Value;
}
groupmember.GroupMemberStatus = GroupMemberStatus.Active;
groupMemberService.Add(groupmember);
rockContext.SaveChanges();
}
// Make sure we update the team if necessary
groupmember.LoadAttributes();
groupmember.SetAttributeValue(groupMemberAttribute.Key, applicant.team);
groupmember.SaveAttributeValues(rockContext);
}
}
processed++;
}
foreach (Group sportsleague in groups)
{
sportsleague.IsActive = false;
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception("LeagueApps Job Failed", ex);
}
finally
{
dbContext.SaveChanges();
}
if (warnings.Length > 0)
{
throw new Exception(warnings);
}
context.Result = "Successfully imported " + processed + " leagues.";
}