/// <summary> /// Update an entry in the EmployeePayRate table /// </summary> public static bool Update(EmployeePayRate employeePayRate) { bool result = false; SqlConnection cn = GetConnection(); result = Update(cn, employeePayRate); FinishedWithConnection(cn); return(result); }
/// <summary> /// Get an entry from the EmployeePayRate table /// </summary> public static EmployeePayRate Get(int id) { EmployeePayRate result = null; SqlConnection cn = GetConnection(); result = Get(cn, id); FinishedWithConnection(cn); return(result); }
private static EmployeePayRate Get(SqlConnection cn, int id) { EmployeePayRate result = null; using (SqlCommand cmd = new SqlCommand("SELECT * FROM EmployeePayRate WHERE EmployeePayRateId=" + id, cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildEmployeePayRate(rdr); } } } return(result); }
private static bool Update(SqlConnection cn, EmployeePayRate employeePayRate) { Int32 rowsAffected = 0; using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "UPDATE EmployeePayRate SET EmployeePayRateEmployeeId=@EmployeePayRateEmployeeId,EmployeePayRateEmployeeJobId=@EmployeePayRateEmployeeJobId,EmployeePayRateWage=@EmployeePayRateWage,EmployeePayRateOvertimeWage=@EmployeePayRateOvertimeWage WHERE EmployeePayRateId=@EmployeePayRateId"; BuildSqlParameter(sqlCmd, "@EmployeePayRateId", SqlDbType.Int, employeePayRate.Id); BuildSqlParameter(sqlCmd, "@EmployeePayRateEmployeeId", SqlDbType.Int, employeePayRate.EmployeeId); BuildSqlParameter(sqlCmd, "@EmployeePayRateEmployeeJobId", SqlDbType.Int, employeePayRate.JobId); BuildSqlParameter(sqlCmd, "@EmployeePayRateWage", SqlDbType.Float, employeePayRate.Wage); BuildSqlParameter(sqlCmd, "@EmployeePayRateOvertimeWage", SqlDbType.Float, employeePayRate.OvertimeWage); rowsAffected = sqlCmd.ExecuteNonQuery(); } return(rowsAffected != 0); }
public static EmployeePayRate GetEmployeePayRateForJob(int employeeId, int jobId) { EmployeePayRate result = null; SqlConnection cn = GetConnection(); using (SqlCommand cmd = new SqlCommand( "SELECT * FROM EmployeePayRate WHERE (EmployeePayRateEmployeeId=" + employeeId + " AND EmployeePayRateEmployeeJobId=" + jobId + ")", cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildEmployeePayRate(rdr); } } } FinishedWithConnection(cn); return(result); }
public static EmployeePayRate Add(int employeeId, int jobId, double wage, double overtimeWage) { EmployeePayRate result = null; SqlConnection cn = GetConnection(); using (SqlCommand sqlCmd = new SqlCommand("AddEmployeePayRate", cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@EmployeePayRateEmployeeId", SqlDbType.Int, employeeId); BuildSqlParameter(sqlCmd, "@EmployeePayRateEmployeeJobId", SqlDbType.Int, jobId); BuildSqlParameter(sqlCmd, "@EmployeePayRateWage", SqlDbType.Float, wage); BuildSqlParameter(sqlCmd, "@EmployeePayRateOvertimeWage", SqlDbType.Float, overtimeWage); BuildSqlParameter(sqlCmd, "@EmployeePayRateId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new EmployeePayRate(Convert.ToInt32(sqlCmd.Parameters["@EmployeePayRateId"].Value), employeeId, jobId, wage, overtimeWage); } } FinishedWithConnection(cn); return(result); }