/// <summary>
/// Add a new entry to the EmployeeCheck table
/// </summary>
public static EmployeeCheck Add(int employeeId, double grossAmount,
double federalTax, double stateTax, double localTax, double ficaTax,
double socialSecurityTax, double netAmount)
{
EmployeeCheck result = null;
DateTime issued = DateTime.Now;
SqlConnection cn = GetConnection();
string cmd = "AddEmployeeCheck";
using (SqlCommand sqlCmd = new SqlCommand(cmd, cn))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
BuildSqlParameter(sqlCmd, "@EmployeeCheckEmployeeId", SqlDbType.Int, employeeId);
BuildSqlParameter(sqlCmd, "@EmployeeCheckGrossPay", SqlDbType.Float, grossAmount);
BuildSqlParameter(sqlCmd, "@EmployeeCheckFederalTax", SqlDbType.Float, federalTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckStateTax", SqlDbType.Float, stateTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckLocalTax", SqlDbType.Float, localTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckFicaTax", SqlDbType.Float, ficaTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckSocialSecurityTax", SqlDbType.Float, socialSecurityTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckNetPay", SqlDbType.Float, netAmount);
BuildSqlParameter(sqlCmd, "@EmployeeCheckIssued", SqlDbType.DateTime, issued);
BuildSqlParameter(sqlCmd, "@EmployeeCheckId", SqlDbType.Int, ParameterDirection.ReturnValue);
if (sqlCmd.ExecuteNonQuery() > 0)
{
result = new EmployeeCheck(Convert.ToInt32(sqlCmd.Parameters["@EmployeeCheckId"].Value),
employeeId, grossAmount, federalTax, stateTax, localTax,
ficaTax, socialSecurityTax, netAmount, issued);
}
}
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Update an entry in the EmployeeCheck table
/// </summary>
public static bool Update(EmployeeCheck employeeCheck)
{
bool result = false;
SqlConnection cn = GetConnection();
result = Update(cn, employeeCheck);
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Get an entry from the EmployeeCheck table
/// </summary>
public static EmployeeCheck Get(int id)
{
EmployeeCheck result = null;
SqlConnection cn = GetConnection();
result = Get(cn, id);
FinishedWithConnection(cn);
return(result);
}
private static EmployeeCheck Get(SqlConnection cn, int id)
{
EmployeeCheck result = null;
using (SqlCommand cmd = new SqlCommand("SELECT * FROM EmployeeCheck WHERE EmployeeCheckId=" + id, cn))
{
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = BuildEmployeeCheck(rdr);
}
}
}
return(result);
}
/// <summary>
/// Delete an entry from the EmployeeCheck table
/// </summary>
public static bool Delete(int id)
{
Int32 rowsAffected = 0;
SqlConnection cn = GetConnection();
EmployeeCheck employeeCheck = Get(cn, id);
if (employeeCheck != null)
{
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "DELETE FROM EmployeeCheck WHERE EmployeeCheckId=" + id;
rowsAffected = sqlCmd.ExecuteNonQuery();
}
}
FinishedWithConnection(cn);
return(rowsAffected != 0);
}
private static bool Update(SqlConnection cn, EmployeeCheck employeeCheck)
{
Int32 rowsAffected = 0;
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "UPDATE EmployeeCheck SET EmployeeCheckEmployeeId=@EmployeeCheckEmployeeId,EmployeeCheckGrossPay=@EmployeeCheckGrossPay,EmployeeCheckFederalTax=@EmployeeCheckFederalTax,EmployeeCheckStateTax=@EmployeeCheckStateTax,EmployeeCheckLocalTax=@EmployeeCheckLocalTax,EmployeeCheckFicaTax=@EmployeeCheckFicaTax,EmployeeCheckSocialSecurityTax=@EmployeeCheckSocialSecurityTax,EmployeeCheckNetPay=@EmployeeCheckNetPay,EmployeeCheckIssued=@EmployeeCheckIssued WHERE EmployeeCheckId=@EmployeeCheckId";
BuildSqlParameter(sqlCmd, "@EmployeeCheckId", SqlDbType.Int, employeeCheck.Id);
BuildSqlParameter(sqlCmd, "@EmployeeCheckEmployeeId", SqlDbType.Int, employeeCheck.EmployeeId);
BuildSqlParameter(sqlCmd, "@EmployeeCheckGrossPay", SqlDbType.Float, employeeCheck.GrossAmount);
BuildSqlParameter(sqlCmd, "@EmployeeCheckFederalTax", SqlDbType.Float, employeeCheck.FederalTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckStateTax", SqlDbType.Float, employeeCheck.StateTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckLocalTax", SqlDbType.Float, employeeCheck.LocalTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckFicaTax", SqlDbType.Float, employeeCheck.FicaTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckSocialSecurityTax", SqlDbType.Float, employeeCheck.SocialSecurityTax);
BuildSqlParameter(sqlCmd, "@EmployeeCheckNetPay", SqlDbType.Float, employeeCheck.NetAmount);
BuildSqlParameter(sqlCmd, "@EmployeeCheckIssued", SqlDbType.DateTime, employeeCheck.Issued);
rowsAffected = sqlCmd.ExecuteNonQuery();
}
return(rowsAffected != 0);
}
