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