public bool Equals(ResourceDiscipline other)
{
if (other is null)
{
return(false);
}
else
{
return(this.Name == other.Name && this.YearsOfExperience == other.YearsOfExperience);
}
}
private IEnumerable <ResourceDiscipline> createResourceDisciplinesFromProfile(IEnumerable <ResourceDisciplineResource> disciplines, string userId)
{
var result = Enumerable.Empty <ResourceDiscipline>();
foreach (var discipline in disciplines)
{
var disc = new ResourceDiscipline
{
ResourceId = userId,
Name = discipline.Discipline,
YearsOfExperience = discipline.YearsOfExp
};
result = result.Append(disc);
}
return(result);
}
private void Setup_AllRepo_UpdateUser(ResourceDiscipline discipline, IEnumerable <ResourceDiscipline> dbDisciplines,
OutOfOffice availability, IEnumerable <OutOfOffice> dbAvailability, ResourceSkill skill, IEnumerable <ResourceSkill> dbSkills)
{
// Disciplines Repo
Setup_DisciplinesRepo_GetUserDisciplines_Default(dbDisciplines);
Setup_DisciplinesRepo_DeleteResourceDiscipline_Default(discipline);
Setup_DisciplinesRepo_InsertResourceDiscipline_Default(discipline);
// OutOfOffice repo
Setup_OutOfOfficeRepo_GetAllOutOfOfficeForUser_Default(dbAvailability);
Setup_OutOfOffice_InsertOutOfOffice_Default(availability);
Setup_OutOfOfficeRepo_DeleteOutOfOffice_Default(availability);
// Skills repo
Setup_SkillsRepo_GetUserSkills_Default(dbSkills);
Setup_SkillsRepo_DeleteResourceSkill_Default(skill);
Setup_SkillsRepo_InsertResourceSkill_Default(skill);
}
public async Task <ResourceDiscipline> InsertResourceDiscipline(ResourceDiscipline discipline)
{
var sql = @"
insert into ResourceDiscipline
values (@ResourceId,
(select Id from Disciplines where Name = @DisciplineName),
@YearsOfExperience)
;";
using var connection = new SqlConnection(connectionString);
connection.Open();
await connection.QueryFirstOrDefaultAsync(sql, new
{
ResourceId = discipline.ResourceId,
DisciplineName = discipline.Name,
YearsOfExperience = discipline.YearsOfExperience
});
return(discipline);
}
public async Task <ResourceDiscipline> DeleteResourceDiscipline(ResourceDiscipline discipline)
{
var sql = @"
delete from ResourceDiscipline
where ResourceId = @ResourceId
AND DisciplineId = (select Id
from Disciplines
where Name = @DisciplineName)
;";
using var connection = new SqlConnection(connectionString);
connection.Open();
await connection.QueryAsync <ResourceDiscipline>(sql, new
{
ResourceId = discipline.ResourceId,
DisciplineName = discipline.Name
});
return(discipline);
}
private void Setup_DisciplinesRepo_DeleteResourceDiscipline_Default(ResourceDiscipline returnVal)
{
_mockDisciplinesRepo.Setup(
repo => repo.DeleteResourceDiscipline(It.IsAny <ResourceDiscipline>())
).ReturnsAsync(returnVal);
}
