public UnitOfWork(BenefitsDbContext dbContext)
{
_context = dbContext;
Employees = new EmployeeRepository(_context);
Benefits = new BenefitRepository(_context);
}
public void WhenIInquireAMemberCurrentOOPAmount()
{
try
{
// Action & Asserion
using (var context = new BenefitDbContext(_options))
{
var benefitDb = new BenefitRepository(context);
var benefit = new MultiTierBenefit(benefitDb);
_claimTotalMember1 = benefit.GetOopMaxMet("X0001");
_claimTotalMember2 = benefit.GetOopMaxMet("X0002");
}
}
catch (Exception e)
{
// Any exception occurs, it should be considered testing failed.
e.Message.Should().BeNullOrEmpty();
}
finally
{
if (_conn.State != ConnectionState.Closed)
{
_conn.Close();
}
_conn.Dispose();
}
}
public void TestGetDeductibleDdQueryOperation()
{
var deduct1 = new Deductible()
{
ProductId = "ABC00001", Level = 1, Amount = 2000
};
var deduct2 = new Deductible()
{
ProductId = "ABC00001", Level = 2, Amount = 3000
};
var conn = new SqliteConnection("DataSource=:memory:");
var options = new DbContextOptionsBuilder <BenefitDbContext>().UseSqlite(conn).Options;
try
{
conn.Open();
// Arrange
using (var context = new BenefitDbContext(options))
{
// Create the schema and exit to force it to create immediately
context.Database.EnsureCreated();
}
// Action
using (var context = new BenefitDbContext(options))
{
// Add records to Deductible table for assertion
context.Deductibles.Add(deduct1);
context.Deductibles.Add(deduct2);
var writeCount = context.SaveChanges();
}
// Action & Asserion
using (var context = new BenefitDbContext(options))
{
var benefitDb = new BenefitRepository(context);
var deduct = benefitDb.GetDeductible("ABC00001");
deduct.FirstOrDefault <Deductible>().ProductId.Should().Be("ABC00001");
}
}
catch (Exception e)
{
e.Message.Should().BeEmpty();
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
conn.Dispose();
}
}
public List <BenefitView> GetAllBenefits()
{
using (var bus = new BenefitRepository())
{
return(bus.GetAll().Select(x => new BenefitView()
{
benefitID = x.benefitID,
Name = x.Name,
}).ToList());
}
}
public void UpdateBenefit(BenefitView model)
{
using (var prepo = new BenefitRepository())
{
Benefit p = prepo.GetById(model.benefitID);
if (p != null)
{
p.Name = model.Name;
prepo.Update(p);
}
}
}
//benefits
public void AddBenefit(BenefitView model)
{
using (var prepo = new BenefitRepository())
{
var ben = new Benefit();
{
if (GetByName(model.Name).Name == null)
{
ben.Name = model.Name;
prepo.Insert(ben);
}
};
}
}
public BenefitView GetBenefitById(int id)
{
using (var b = new BenefitRepository())
{
Benefit ben = b.GetById(id);
var model = new BenefitView();
if (ben != null)
{
model.benefitID = ben.benefitID;
model.Name = ben.Name;
}
return(model);
}
}
public void GetAllEmployeesAsyncTest()
{
var options = SetupWithEmployeeAndDependent();
using (var context = new BenefitContext(options))
{
var benefitRepository = new BenefitRepository(context);
var employees = benefitRepository.GetAllEmployeesAsync().Result;
Assert.IsNotNull(employees);
context.Database.EnsureDeleted();
}
}
public void GetEmployeeDetailsAsyncTest()
{
var options = SetupWithEmployeeAndDependent();
using (var context = new BenefitContext(options))
{
var benefitRepository = new BenefitRepository(context);
var employeeDetails = benefitRepository.GetEmployeeDetailsAsync(1).Result;
Assert.AreEqual("Rick", employeeDetails.FirstName);
context.Database.EnsureDeleted();
}
}
public BenefitView GetBenefitByName(string name)
{
using (var b = new BenefitRepository())
{
var model = new BenefitView();
foreach (Benefit ben in b.GetAll())
{
if (ben.Name == name)
{
model.benefitID = ben.benefitID;
model.Name = ben.Name;
}
}
return(model);
}
}
public void EditEmployeeTest()
{
var options = SetupWithEmployeeAndDependent();
using (var context = new BenefitContext(options))
{
var benefitRepository = new BenefitRepository(context);
var employeeToEdit = benefitRepository.GetEmployeeToEdit(1).Result;
employeeToEdit.FirstName = "RickX";
var employeeThatHadEditSaved = benefitRepository.EditEmployee(employeeToEdit).Result;
Assert.AreEqual("RickX", employeeThatHadEditSaved.FirstName);
context.Database.EnsureDeleted();
}
}
public void WhenIInquireAMemberCurrentOOPAmount()
{
try
{
// Action & Asserion
using (var context = new BenefitDbContext(_options))
{
var benefitDb = new BenefitRepository(context);
var benefit = new MultiTierBenefit(benefitDb);
_claimTotal = benefit.GetClaimTotal("X0002");
}
}
catch (Exception e)
{
}
finally
{
if (_conn.State != ConnectionState.Closed)
{
_conn.Close();
}
_conn.Dispose();
}
}
public void CreateNewEmployeeTest()
{
var options = SetupDbContextOnly();
var newEmployee = new Employee
{
FirstName = "Test",
LastName = "User",
EmployeeId = 2,
CreatedOn = DateTime.UtcNow,
UpdatedOn = DateTime.UtcNow
};
using (var context = new BenefitContext(options))
{
var benefitRepository = new BenefitRepository(context);
var employee = benefitRepository.CreateNewEmployee(newEmployee).Result;
Assert.AreEqual("Test", employee.FirstName);
context.Database.EnsureDeleted();
}
}
public BenefitController(ApplicationDbContext context)
{
_benefitRepository = new BenefitRepository(context);
}
