/// <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); }