public void TestChangeSalaryTransaction()
{
int empId = 4;
AddCommissionedEmployee t =
new AddCommissionedEmployee(
empId, "Lance", "Home", 2500, 3.2, database);
t.Execute();
ChangeSalariedTransaction cst =
new ChangeSalariedTransaction(empId, 3000.00, database);
cst.Execute();
Employee e = database.GetEmployee(empId);
Assert.IsNotNull(e);
PaymentClassification pc = e.Classification;
Assert.IsNotNull(pc);
Assert.IsTrue(pc is SalariedClassification);
SalariedClassification sc = pc as SalariedClassification;
Assert.AreEqual(3000.00, sc.Salary, .001);
PaymentSchedule ps = e.Schedule;
Assert.IsTrue(ps is MonthlySchedule);
}
public void TestAddSalariedEmployee()
{
int empId = 1;
AddSalariedEmployee t =
new AddSalariedEmployee(empId, "Bob", "Home", 1000.00, database);
t.Execute();
Employee e = database.GetEmployee(empId);
Assert.AreEqual("Bob", e.Name);
PaymentClassification pc = e.Classification;
Assert.IsTrue(pc is SalariedClassification);
SalariedClassification sc = pc as SalariedClassification;
Assert.AreEqual(1000.00, sc.Salary, .001);
PaymentSchedule ps = e.Schedule;
Assert.IsTrue(ps is MonthlySchedule);
PaymentMethod pm = e.Method;
Assert.IsTrue(pm is HoldMethod);
}
private void PrepareToSavePaymentClassification()
{
PaymentClassification classification = employee.Classification;
if (classification is SalariedClassification)
{
classificationCode = "salaried";
SalariedClassification salariedClassification =
classification as SalariedClassification;
insertClassificationCommand =
CreateInsertSalariedClassificationCommand(
salariedClassification);
}
else if (classification is HourlyClassification)
{
classificationCode = "hourly";
}
else if (classification is CommissionedClassification)
{
classificationCode = "commissioned";
}
else
{
classificationCode = "unknown";
}
}
private SqlCommand CreateInsertSalariedClassificationCommand(
SalariedClassification salariedClassification)
{
string SQL = "INSERT INTO SalariedClassification " +
"VALUES (@Salary, @EmpId)";
SqlCommand command = new SqlCommand(SQL);
command.Parameters.AddWithValue("@Salary", salariedClassification.Salary);
command.Parameters.AddWithValue("@EmpId", employee.Id);
return(command);
}
