public void Test_Delete_Existing_EmployeeSkill()
{
//Arrange
SQLEmployees_Skill EmployeeSkill = new SQLEmployees_Skill
{
Id = 2,
Employee_Id = 2,
Skill_Id = 1,
Score_Id = 1
};
//Act
_sqlEmployeeSkillRepository.Delete(EmployeeSkill);
//Assert
//check if record had been deleted from test database
}
public void Test_Update_Existing_EmployeeSkill()
{
//Arrange
SQLEmployees_Skill EmployeeSkill = new SQLEmployees_Skill
{
Id = 1,
Employee_Id = 1,
Skill_Id = 2,
Score_Id = 2
};
//Act
_sqlEmployeeSkillRepository.Update(EmployeeSkill);
//Assert
//Check if EmployeeSkill had been added to test database
}
public void Test_Add_New_EmployeeSkill()
{
//Arrange
SQLEmployees_Skill EmployeeSkill = new SQLEmployees_Skill
{
Id = 1,
Employee_Id = 2,
Skill_Id = 1,
Score_Id = 1
};
//Act
_sqlEmployeeSkillRepository.Add(EmployeeSkill);
//Assert
//Check if EmployeeSkill had been added to test database
}
public void Test_Delete_Existing_EmployeeSkill()
{
//Arrange
SQLEmployees_Skill EmployeeSkill = new SQLEmployees_Skill
{
Id = 4,
Employee_Id = 1,
Skill_Id = 3,
Score_Id = 2
};
_sqlUnitOfWorkMock.Setup(s => s.SQLEmployeeSkillRepository.Delete(EmployeeSkill));
//Act
_sqlEmployeeSkillService.DeleteEmployeeSkill(EmployeeSkill);
//Assert
_sqlUnitOfWorkMock.Verify(v => v.SQLEmployeeSkillRepository.Delete(EmployeeSkill), Times.Once);
}
public void Test_Add_New_EmployeeSkill()
{
//Arrange
SQLEmployees_Skill EmployeeSkill = new SQLEmployees_Skill
{
Id = 4,
Employee_Id = 1,
Skill_Id = 3,
Score_Id = 2
};
_sqlUnitOfWorkMock.Setup(s => s.SQLEmployeeSkillRepository.Add(EmployeeSkill)).Returns(EmployeeSkill.Id);
//Act
var result = _sqlEmployeeSkillService.AddEmployeeSkill(EmployeeSkill);
//Assert
Assert.AreEqual(result, EmployeeSkill.Id);
}
public void Test_Get_EmployeeSkill_By_Id()
{
//Arrange
SQLEmployees_Skill EmployeeSkill = new SQLEmployees_Skill
{
Id = 1,
Employee_Id = 1,
Skill_Id = 1,
Score_Id = 2
};
//Act
var result = _sqlEmployeeSkillRepository.Get(1);
//Assert
Assert.AreEqual(EmployeeSkill.Id, result.Id);
Assert.AreEqual(EmployeeSkill.Employee_Id, result.Employee_Id);
Assert.AreEqual(EmployeeSkill.Skill_Id, result.Skill_Id);
Assert.AreEqual(EmployeeSkill.Score_Id, result.Score_Id);
}
public void Test_Success_Add_New_EmployeeSkill()
{
//Arrange
var employeeSkill = new SQLEmployees_Skill
{
Id = 4,
Employee_Id = 1,
Skill_Id = 3,
Score_Id = 2
};
_sqlEmployeeSkillServiceMock.Setup(s => s.AddEmployeeSkill(employeeSkill)).Returns(employeeSkill.Id);
//Act
var result = _employeeSkillController.Post(employeeSkill);
//Assert
_sqlEmployeeSkillServiceMock.Verify(e => e.AddEmployeeSkill(employeeSkill), Times.Once);
Assert.AreEqual(result, employeeSkill.Id);
}
public void UpdateEmployeeSkill(SQLEmployees_Skill employeeSkill)
{
_SqlsqlunitOfWork.SQLEmployeeSkillRepository.Update(employeeSkill);
}
public long AddEmployeeSkill(SQLEmployees_Skill employeeSkill)
{
return(_SqlsqlunitOfWork.SQLEmployeeSkillRepository.Add(employeeSkill));
}
public void Delete([FromBody] SQLEmployees_Skill employeeSkill)
{
_sqlEmployeeSkillService.DeleteEmployeeSkill(employeeSkill);
}
public void Put([FromBody] SQLEmployees_Skill employeeSkill)
{
_sqlEmployeeSkillService.UpdateEmployeeSkill(employeeSkill);
}
public long Post([FromBody] SQLEmployees_Skill employeeSkill)
{
return(_sqlEmployeeSkillService.AddEmployeeSkill(employeeSkill));
}
