public async Task UpdatePlan(PlanDto dto)
{
var plan = await _planRepository.GetPlan(dto.Id);
plan.Name = dto.Name;
await _planRepository.UpdatePlan(plan);
var allLevels = (await _planRepository.GetLevels(dto.PatrolId)).ToList();
var allSkills = (await _planRepository.GetSkills(dto.PatrolId)).ToList();
var allGroups = (await _groupRepository.GetGroupsForPatrol(dto.PatrolId)).ToList();
//update existing sections
var sections = await _planRepository.GetSectionsForPlan(dto.Id);
foreach (var section in sections)
{
var newSection = dto.Sections.SingleOrDefault(x => x.Id == section.Id);
if (newSection == null)
{
//remove
await _planRepository.DeleteSection(section);
}
else
{
section.Name = newSection.Name;
section.Color = newSection.Color;
await _planRepository.UpdateSection(section);
//sync levels
var sectionLevels = (await _planRepository.GetSectionLevels(section.Id)).OrderBy(x => x.ColumnIndex).ToList();
foreach (var sectionLevel in sectionLevels)
{
var newSectionlevel = newSection.Levels.SingleOrDefault(x => x.Id == sectionLevel.Id);
if (newSectionlevel == null)
{
await _planRepository.DeleteSectionLevel(sectionLevel);
}
else
{
sectionLevel.ColumnIndex = newSectionlevel.ColumnIndex;
sectionLevel.LevelId = newSectionlevel.Level.Id;
await _planRepository.UpdateSectionLevel(sectionLevel);
}
}
foreach (var newSectionLevel in newSection.Levels.Where(x => x.Id == default(int)))
{
var sectionLevel = new SectionLevel()
{
SectionId = section.Id,
ColumnIndex = newSectionLevel.ColumnIndex,
LevelId = newSectionLevel.Level.Id
};
await _planRepository.InsertSectionLevel(sectionLevel);
}
//sync skills
var sectionSkills = (await _planRepository.GetSectionSkills(section.Id)).OrderBy(x => x.RowIndex).ToList();
foreach (var sectionSkill in sectionSkills)
{
var newSectionSkill = newSection.Skills.SingleOrDefault(x => x.Id == sectionSkill.Id);
if (newSectionSkill == null)
{
await _planRepository.DeleteSectionSkill(sectionSkill);
}
else
{
sectionSkill.RowIndex = newSectionSkill.RowIndex;
sectionSkill.SkillId = newSectionSkill.Skill.Id;
await _planRepository.UpdateSectionSkill(sectionSkill);
}
}
foreach (var newSectionSkill in newSection.Skills.Where(x => x.Id == default(int)))
{
var sectionSkill = new SectionSkill()
{
SectionId = section.Id,
RowIndex = newSectionSkill.RowIndex,
SkillId = newSectionSkill.Skill.Id
};
await _planRepository.InsertSectionSkill(sectionSkill);
}
//sync groups
var sectionGroups = (await _planRepository.GetSectionGroups(section.Id)).ToList();
foreach (var sectionGroup in sectionGroups)
{
var newSectionGroup = newSection.Groups.SingleOrDefault(x => x.Id == sectionGroup.Id);
if (newSectionGroup == null)
{
await _planRepository.DeleteSectionGroup(sectionGroup);
}
else
{
sectionGroup.GroupId = newSectionGroup.GroupId;
await _planRepository.UpdateSectionGroup(sectionGroup);
}
}
foreach (var newSectionGroup in newSection.Groups.Where(x => x.Id == default(int)))
{
var sectionGroup = new SectionGroup()
{
SectionId = section.Id,
GroupId = newSectionGroup.GroupId
};
await _planRepository.InsertSectionGroup(sectionGroup);
}
}
}
//create new sections
foreach (var newSection in dto.Sections.Where(x => x.Id == default(int)))
{
//save new sections
var section = new Section()
{
Name = newSection.Name,
PatrolId = plan.PatrolId,
Color = newSection.Color
};
await _planRepository.InsertSection(section);
var planSection = new PlanSection()
{
PlanId = plan.Id,
SectionId = section.Id
};
await _planRepository.InsertPlanSection(planSection);
foreach (var newLevel in newSection.Levels)
{
var sectionLevel = new SectionLevel()
{
SectionId = section.Id,
ColumnIndex = newLevel.ColumnIndex,
LevelId = newLevel.Level.Id
};
await _planRepository.InsertSectionLevel(sectionLevel);
}
foreach (var newSkill in newSection.Skills)
{
var sectionSkill = new SectionSkill()
{
SectionId = section.Id,
RowIndex = newSkill.RowIndex,
SkillId = newSkill.Skill.Id
};
await _planRepository.InsertSectionSkill(sectionSkill);
}
}
}
/// <summary>
/// create a training plan in the designated patrol, clone the designated plan contents if specified
/// specified plan can be from any patrol, relevant skills/levels will be copied to target patrol as needed
/// </summary>
/// <param name="name"></param>
/// <param name="patrolId"></param>
/// <param name="copyFromPlanId"></param>
/// <returns></returns>
public async Task <Plan> CreatePlan(string name, int patrolId, int?copyFromPlanId)
{
Plan copyFromPlan = null;
if (copyFromPlanId.HasValue)
{
copyFromPlan = await _planRepository.GetPlan(copyFromPlanId.Value);
}
var newPlan = new Plan()
{
PatrolId = patrolId
};
if (!string.IsNullOrEmpty(name))
{
newPlan.Name = name;
}
else if (copyFromPlan != null)
{
newPlan.Name = "Copy of " + copyFromPlan.Name;
}
else
{
newPlan.Name = "New Training Plan";
}
await _planRepository.InsertPlan(newPlan);
var patrolLevels = (await _planRepository.GetLevels(patrolId)).ToList();
var patrolSkills = (await _planRepository.GetSkills(patrolId)).ToList();
var patrolGroups = (await _groupRepository.GetGroupsForPatrol(patrolId)).ToList();
if (copyFromPlanId.HasValue)
{
var sections = await _planRepository.GetSectionsForPlan(copyFromPlanId.Value);
var sectionSkills = await _planRepository.GetSectionSkillsForPlan(copyFromPlanId.Value);
var sectionLevels = await _planRepository.GetSectionLevelsForPlan(copyFromPlanId.Value);
var sectionGroups = await _planRepository.GetSectionGroupsForPlan(copyFromPlanId.Value);
foreach (var section in sections)
{
var newSection = new Section()
{
Name = section.Name,
PatrolId = section.PatrolId,
Color = section.Color
};
await _planRepository.InsertSection(newSection);
var planSection = new PlanSection()
{
PlanId = newPlan.Id,
SectionId = newSection.Id
};
await _planRepository.InsertPlanSection(planSection);
var levels = sectionLevels.Where(x => x.SectionId == section.Id);
foreach (var sectionLevel in levels)
{
int levelId;
if (sectionLevel.Level.PatrolId == patrolId)
{
levelId = sectionLevel.Level.Id;
}
else
{
if (patrolLevels.Any(x => x.Name == sectionLevel.Level.Name))
{
levelId = patrolLevels.First(x => x.Name == sectionLevel.Level.Name).Id;
}
else
{
var newLevel = new Level()
{
Name = sectionLevel.Level.Name,
Description = sectionLevel.Level.Description,
PatrolId = patrolId
};
await _planRepository.InsertLevel(newLevel);
patrolLevels.Add(newLevel);
levelId = newLevel.Id;
}
}
var newSectionLevel = new SectionLevel()
{
ColumnIndex = sectionLevel.ColumnIndex,
LevelId = levelId,
SectionId = newSection.Id
};
await _planRepository.InsertSectionLevel(newSectionLevel);
}
var skills = sectionSkills.Where(x => x.SectionId == section.Id);
foreach (var sectionSkill in skills)
{
int skillId;
if (sectionSkill.Skill.PatrolId == patrolId)
{
skillId = sectionSkill.Skill.Id;
}
else
{
if (patrolSkills.Any(x => x.Name == sectionSkill.Skill.Name))
{
skillId = patrolSkills.First(x => x.Name == sectionSkill.Skill.Name).Id;
}
else
{
var newSkill = new Skill()
{
Name = sectionSkill.Skill.Name,
Description = sectionSkill.Skill.Description,
PatrolId = patrolId
};
await _planRepository.InsertSkill(newSkill);
patrolSkills.Add(newSkill);
skillId = newSkill.Id;
}
}
var newSectionSkill = new SectionSkill()
{
RowIndex = sectionSkill.RowIndex,
SkillId = skillId,
SectionId = newSection.Id
};
await _planRepository.InsertSectionSkill(newSectionSkill);
}
var groups = sectionGroups.Where(x => x.SectionId == section.Id);
foreach (var sectionGroup in groups)
{
int groupid;
if (sectionGroup.Group.PatrolId == patrolId)
{
groupid = sectionGroup.Group.Id;
}
else
{
if (patrolGroups.Any(x => x.Name == sectionGroup.Group.Name))
{
groupid = patrolGroups.First(x => x.Name == sectionGroup.Group.Name).Id;
}
else
{
var newGroup = new Group()
{
PatrolId = patrolId,
Name = sectionGroup.Group.Name
};
await _groupRepository.InsertGroup(newGroup);
patrolGroups.Add(newGroup);
groupid = newGroup.Id;
}
}
var newSectionGroup = new SectionGroup()
{
SectionId = newSection.Id,
GroupId = groupid
};
await _planRepository.InsertSectionGroup(newSectionGroup);
}
}
}
else
{
var section = new Section()
{
Name = "New Section", PatrolId = patrolId, Color = "#00FF00"
};
await _planRepository.InsertSection(section);
var planSection = new PlanSection()
{
PlanId = newPlan.Id, SectionId = section.Id
};
await _planRepository.InsertPlanSection(planSection);
var level = patrolLevels.FirstOrDefault();
if (level == null)
{
level = new Level()
{
Name = "New", PatrolId = patrolId
};
await _planRepository.InsertLevel(level);
}
var sectionLevel = new SectionLevel()
{
SectionId = section.Id, LevelId = level.Id, ColumnIndex = 0
};
await _planRepository.InsertSectionLevel(sectionLevel);
var skill = patrolSkills.FirstOrDefault();
if (skill == null)
{
skill = new Skill()
{
Name = "New", PatrolId = patrolId
};
await _planRepository.InsertSkill(skill);
}
var sectionSkill = new SectionSkill()
{
SectionId = section.Id, SkillId = skill.Id, RowIndex = 0
};
await _planRepository.InsertSectionSkill(sectionSkill);
}
return(newPlan);
}
public async Task InsertPlanSection(PlanSection planSection)
{
planSection.Id = (int)await _connection.InsertAsync(planSection).ConfigureAwait(false);
}
