private void PrepareToSavePaymentMethod()
{
PaymentMethod method = employee.Method;
if (method is HoldMethod)
{
methodCode = "hold";
}
else if (method is DirectDepositMethod)
{
methodCode = "directdeposit";
DirectDepositMethod ddMethod = method as DirectDepositMethod;
insertPaymentMethodCommand =
CreateInsertDirectDepositCommand(ddMethod);
}
else if (method is MailMethod)
{
methodCode = "mail";
MailMethod mailMethod = method as MailMethod;
insertPaymentMethodCommand =
CreateInsertMailMethodCommand(mailMethod);
}
else
{
methodCode = "unknown";
}
}
private SqlCommand CreateInsertMailMethodCommand(
MailMethod mailMethod)
{
string SQL = "INSERT INTO PaycheckAddress " +
"VALUES (@Address, @EmpId)";
SqlCommand command = new SqlCommand(SQL);
command.Parameters.AddWithValue("@Address", mailMethod.Address);
command.Parameters.AddWithValue("@EmpId", employee.Id);
return(command);
}
