private void AddClassification(DataRow row)
{
string classificationCode = row["PaymentClassificationType"].ToString();
LoadPaymentClassificationOperation operation = new LoadPaymentClassificationOperation(employee, classificationCode, connection);
operation.Execute();
employee.Classification = operation.Classification;
}
public void LoadHourlyCommand()
{
operation = new LoadPaymentClassificationOperation(employee, "hourly", null);
operation.Prepare();
SqlCommand command = operation.Command;
Assert.AreEqual("select * from HourlyClassification where EmpId=@EmpId", command.CommandText);
Assert.AreEqual(employee.EmpId, command.Parameters["@EmpId"].Value);
}
public void LoadSalariedCommand()
{
operation = new LoadPaymentClassificationOperation(employee, "salary", null);
operation.Prepare();
var command = operation.Command;
Assert.AreEqual("select * from SalariedClassification where EmpId=@EmpId", command.CommandText);
Assert.AreEqual(employee.EmpId, command.Parameters["@EmpId"].Value);
}
public void LoadHourlyCommand()
{
operation = new LoadPaymentClassificationOperation(employee, "hourly", null);
operation.Prepare();
SqlCommand command = operation.Command;
Assert.AreEqual("select * from HourlyClassification where EmpId=@EmpId", command.CommandText);
Assert.AreEqual(employee.EmpId, command.Parameters["@EmpId"].Value);
}
public void CreateSalariedClassificationFromRow()
{
operation = new LoadPaymentClassificationOperation(employee, "salary", null);
operation.Prepare();
DataRow row = LoadEmployeeOperationTest.ShuntRow("Salary", 2500.00);
operation.CreateClassification(row);
PaymentClassification classification = this.operation.Classification;
Assert.IsTrue(classification is SalariedClassification);
SalariedClassification salariedClassification = classification as SalariedClassification;
Assert.AreEqual(2500.00, salariedClassification.Salary, 0.01);
}
public void CreateDirectDepositMethodFromRow()
{
operation = new LoadPaymentClassificationOperation(employee, "hourly", null);
operation.Prepare();
DataRow row = LoadEmployeeOperationTest.ShuntRow("HourlyRate", 15.45);
operation.CreateClassification(row);
PaymentClassification classification = this.operation.Classification;
Assert.IsTrue(classification is HourlyClassification);
HourlyClassification hourlyClassification = classification as HourlyClassification;
Assert.AreEqual(15.45, hourlyClassification.HourlyRate, 0.01);
}
public void CreateCommisstionedClassificationFromRow()
{
operation = new LoadPaymentClassificationOperation(employee, "commission", null);
operation.Prepare();
DataRow row = LoadEmployeeOperationTest.ShuntRow("Salary,Commission", 999.99, 9.9);
operation.CreateClassification(row);
PaymentClassification classification = this.operation.Classification;
Assert.IsTrue(classification is CommissionClassification);
CommissionClassification commissionClassification = classification as CommissionClassification;
Assert.AreEqual(999.99, commissionClassification.BaseRate, 0.01);
Assert.AreEqual(9.9, commissionClassification.CommissionRate, 0.01);
}
public void CreateSalariedClassificationFromRow()
{
operation = new LoadPaymentClassificationOperation(employee, "salary", null);
operation.Prepare();
var row = LoadEmployeeOperationTest.ShuntRow("Salary", 2500.00);
operation.CreateClassification(row);
var classification = operation.Classification;
Assert.IsTrue(classification is SalariedClassification);
var salariedClassification = classification as SalariedClassification;
Assert.AreEqual(2500.00, salariedClassification.Salary, 0.01);
}
public void CreateDirectDepositMethodFromRow()
{
operation = new LoadPaymentClassificationOperation(employee, "hourly", null);
operation.Prepare();
var row = LoadEmployeeOperationTest.ShuntRow("HourlyRate", 15.45);
operation.CreateClassification(row);
var classification = operation.Classification;
Assert.IsTrue(classification is HourlyClassification);
var hourlyClassification = classification as HourlyClassification;
Assert.AreEqual(15.45, hourlyClassification.HourlyRate, 0.01);
}
public void CreateCommisstionedClassificationFromRow()
{
operation = new LoadPaymentClassificationOperation(employee, "commission", null);
operation.Prepare();
var row = LoadEmployeeOperationTest.ShuntRow("Salary,Commission", 999.99, 9.9);
operation.CreateClassification(row);
var classification = operation.Classification;
Assert.IsTrue(classification is CommissionClassification);
var commissionClassification = classification as CommissionClassification;
Assert.AreEqual(999.99, commissionClassification.BaseRate, 0.01);
Assert.AreEqual(9.9, commissionClassification.CommissionRate, 0.01);
}
private void AddClassification(DataRow row)
{
string classificationCode = row["PaymentClassificationType"].ToString();
LoadPaymentClassificationOperation operation = new LoadPaymentClassificationOperation(employee, classificationCode, connection);
operation.Execute();
employee.Classification = operation.Classification;
}