public void CalculateTotalBenefitsCostTest()
{
var context = new BenefitsContext();
var paycheckCalc = new PaycheckCalc();
context.Employees.Add(new Employee {
EmployeeName = "Ali", BenefitCost = 900
});
context.SaveChanges();
var employeeRec = context.Employees.Where(e => e.EmployeeName == "Ali").SingleOrDefault();
context.Dependents.Add(new Dependent {
DependentName = "Az", BenefitCost = 450, Employee = employeeRec
});
context.Dependents.Add(new Dependent {
DependentName = "JJ", BenefitCost = 500, Employee = employeeRec
});
context.SaveChanges();
paycheckCalc.CalculateTotalBenefitsCost("Ali");
employeeRec = context.Employees.Where(e => e.EmployeeName == "Ali").SingleOrDefault();
Assert.AreEqual(71, employeeRec.TotalBenefitCosts);
Assert.AreEqual(1850, employeeRec.YearlyTotalBenefitsCost);
}
public void SaveEmployee(string employeeName, double employeeCost)
{
context.Employees.Add(new Employee {
EmployeeName = employeeName.ToUpper(), BenefitCost = employeeCost
});
context.SaveChanges();
}
public void Seed_Database()
{
using (BenefitsContext db = new BenefitsContext())
{
var employeeFamily = new Employee()
{
EmployeeName = "Bob",
BenefitCost = 1000,
Dependents = new List <Dependent>
{
new Dependent {
DependentName = "Judy", BenefitCost = 500
},
new Dependent {
DependentName = "Alfred", BenefitCost = 450
},
new Dependent {
DependentName = "Susan", BenefitCost = 500
}
}
};
// save data to db
db.SaveChanges();
db.Dispose();
}
}
public void Handle(AddNewEmployee employee)
{
var addNewEmployee = _mapper.Map <AddNewEmployee, Employee>(employee);
_db.Add(addNewEmployee);
_db.SaveChanges();
}
public void CalculateYearlySalaryInfo()
{
var context = new BenefitsContext();
var paycheckCalc = new PaycheckCalc();
context.Employees.Add(new Employee {
EmployeeName = "Ali", YearlyTotalBenefitsCost = 1850
});
context.SaveChanges();
paycheckCalc.CalculateYearlySalaryInfo("Ali");
var employeeRec = context.Employees.Where(e => e.EmployeeName == "Ali").SingleOrDefault();
Assert.AreEqual(52000, employeeRec.YearlySalary);
Assert.AreEqual(52000 - 1850, employeeRec.YearlyNetPay);
}
public void CalculateSalaryInfoTest()
{
var context = new BenefitsContext();
var paycheckCalc = new PaycheckCalc();
context.Employees.Add(new Employee {
EmployeeName = "Ali", TotalBenefitCosts = 71
});
context.SaveChanges();
paycheckCalc.CalculateSalaryInfo("Ali");
var employeeRec = context.Employees.Where(e => e.EmployeeName == "Ali").SingleOrDefault();
Assert.AreEqual(2000, employeeRec.Salary);
Assert.AreEqual(2000 - 71, employeeRec.NetPay);
}
private void PrepareData()
{
using (var db = new BenefitsContext())
{
db.Database.CreateIfNotExists();
db.Employees.Add(new Employee()
{
FirstName = "FirstName",
LastName = "LastName"
});
db.Employees.Add(new Employee()
{
FirstName = "FirstName",
LastName = "LastName"
});
db.SaveChanges();
}
}
public void CalculateDependentBenefitsCostTest()
{
var context = new BenefitsContext();
var paycheckCalc = new PaycheckCalc();
context.Employees.Add(new Employee {
EmployeeName = "Ali", BenefitCost = 900
});
context.SaveChanges();
var familyList = new List <string>();
familyList.Add("Az");
familyList.Add("JJ");
paycheckCalc.CalculateDependentBenefitsCost("Ali", familyList);
var dependentRecs = context.Dependents.Where(e => e.Employee.EmployeeName == "Ali");
var dependentsArray = dependentRecs.ToArray();
Assert.AreEqual(450, dependentsArray[0].BenefitCost);
Assert.AreEqual(500, dependentsArray[1].BenefitCost);
}
public bool Save()
{
return(_ctx.SaveChanges() >= 0);
}
private void SeedData(BenefitsContext ctx)
{
var People = new List <Person>()
{
new Person()
{
PersonId = 1,
FirstName = "Fred",
LastName = "Flintstone",
DateOfBirth = DateTime.Parse("1/2/1960"),
IsEmployee = true,
PayPeriods = 26,
Salary = 2000
},
new Person()
{
PersonId = 2,
FirstName = "Wilma",
LastName = "Flintstone",
DateOfBirth = DateTime.Parse("1/2/1965"),
IsEmployee = true,
PayPeriods = 26,
Salary = 2000
},
new Person()
{
PersonId = 3,
FirstName = "Barney",
LastName = "Rubble",
DateOfBirth = DateTime.Parse("1/2/1962"),
IsEmployee = true,
PayPeriods = 26,
Salary = 2000
},
new Person()
{
PersonId = 4,
FirstName = "Conrad",
LastName = "Hailstone",
DateOfBirth = DateTime.Parse("1/2/1995"),
IsEmployee = true,
PayPeriods = 26,
Salary = 2000
},
new Person()
{
PersonId = 5,
FirstName = "Stony",
LastName = "Curtis",
DateOfBirth = DateTime.Parse("3/2/1965"),
IsEmployee = true,
PayPeriods = 26,
Salary = 2000
},
new Person()
{
PersonId = 6,
FirstName = "Rock",
LastName = "Hudstone",
DateOfBirth = DateTime.Parse("4/2/1965"),
IsEmployee = true,
PayPeriods = 26,
Salary = 2000
},
new Person()
{
PersonId = 7,
FirstName = "Daisy",
LastName = "Kilgranite",
DateOfBirth = DateTime.Parse("5/2/1985"),
IsEmployee = true,
PayPeriods = 26,
Salary = 2000
},
new Person()
{
PersonId = 8,
FirstName = "Jackie",
LastName = "Kennerock",
DateOfBirth = DateTime.Parse("6/2/1975"),
IsEmployee = true,
PayPeriods = 26,
Salary = 2000
}
};
ctx.People.AddRange(People);
var RecipTypes = new List <BenefitRecipientType>()
{
new BenefitRecipientType()
{
BenefitRecipientTypeId = 1,
Cost = 1000,
Description = "Employee annual benefit cost",
Label = "Employee"
},
new BenefitRecipientType()
{
BenefitRecipientTypeId = 2,
Cost = 500,
Description = "Dependent annual benefit cost",
Label = "Dependent"
}
};
ctx.BenefitRecipientTypes.AddRange(RecipTypes);
var Discs = new List <Discount>()
{
new Discount()
{
DiscountId = 1,
DiscountName = "Name begins with 'A'",
Condition = "startswith('A')",
Field = "name",
Expression = "{cost} - ({cost} * .1)",
DiscountAmount = 0.1m
}
};
ctx.Discounts.AddRange(Discs);
ctx.Meta.Add(new Meta());
ctx.SaveChanges();
}
