public void udf_CalculateEmployeeSalary_ValidInput_Success(int age, double lengthOfEmployment, double expectedSalary)
{
// ACT
var result = _employeeDBContext.Employee
.Select(x => new { x.Id, Salary = ABNEmployeeCRMContext.CalculateEmployeeSalary(age, decimal.Parse(lengthOfEmployment.ToString())) }).FirstOrDefault();
// ASSERT
Assert.AreEqual(decimal.Parse(expectedSalary.ToString()), result.Salary);
}
public void SetupData()
{
// Seed the database with 20 employees
int _numberOfEmployees = 20;
_employeeDBContext = new ABNEmployeeCRMContext();
_newEmployees = new List <Employee>();
for (int i = 0; i < _numberOfEmployees; i++)
{
_newEmployees.Add(new Employee
{
Id = 0,
Age = i + 20,
FirstName = $"FirstName {i}",
LastName = $"LastName {i}",
LengthOfEmployment = (i + 1) * 0.5m
});
}
_employeeDBContext.Employee.AddRangeAsync(_newEmployees);
_employeeDBContext.SaveChanges();
}
