/// <summary>
/// Add a new entry to the EmployeeTimesheetChangeLog table
/// </summary>
public static EmployeeTimesheetChangeLog Add(int employeeTimesheetId, int employeeId,
DateTime?oldStartTime, DateTime?oldEndTime, int?oldJob, double?oldTips,
double?oldDriverCompensation)
{
EmployeeTimesheetChangeLog result = null;
DateTime changeDate = DateTime.Now;
SqlConnection cn = GetConnection();
string cmd = "AddEmployeeTimesheetChangeLog";
using (SqlCommand sqlCmd = new SqlCommand(cmd, cn))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogEmployeeTimesheetId", SqlDbType.Int, employeeTimesheetId);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogEmployeeId", SqlDbType.Int, employeeId);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogChangeDate", SqlDbType.DateTime, changeDate);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldStartTime", SqlDbType.DateTime, oldStartTime);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldEndTime", SqlDbType.DateTime, oldEndTime);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldJob", SqlDbType.SmallInt, oldJob);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldTips", SqlDbType.Float, oldTips);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldDriverComp", SqlDbType.Float, oldDriverCompensation);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogId", SqlDbType.Int, ParameterDirection.ReturnValue);
if (sqlCmd.ExecuteNonQuery() > 0)
{
result = new EmployeeTimesheetChangeLog(Convert.ToInt32(sqlCmd.Parameters["@EmployeeTimesheetChangeLogId"].Value),
employeeTimesheetId, employeeId, changeDate, oldStartTime,
oldEndTime, oldJob, oldTips, oldDriverCompensation);
}
}
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Update an entry in the EmployeeTimesheetChangeLog table
/// </summary>
public static bool Update(EmployeeTimesheetChangeLog employeeTimesheetChangeLog)
{
bool result = false;
SqlConnection cn = GetConnection();
result = Update(cn, employeeTimesheetChangeLog);
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Get an entry from the EmployeeTimesheetChangeLog table
/// </summary>
public static EmployeeTimesheetChangeLog Get(int id)
{
EmployeeTimesheetChangeLog result = null;
SqlConnection cn = GetConnection();
result = Get(cn, id);
FinishedWithConnection(cn);
return(result);
}
private static EmployeeTimesheetChangeLog Get(SqlConnection cn, int id)
{
EmployeeTimesheetChangeLog result = null;
using (SqlCommand cmd = new SqlCommand("SELECT * FROM EmployeeTimesheetChangeLog WHERE EmployeeTimesheetChangeLogId=" + id, cn))
{
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = BuildEmployeeTimesheetChangeLog(rdr);
}
}
}
return(result);
}
/// <summary>
/// Delete an entry from the EmployeeTimesheetChangeLog table
/// </summary>
public static bool Delete(int id)
{
Int32 rowsAffected = 0;
SqlConnection cn = GetConnection();
EmployeeTimesheetChangeLog employeeTimesheetChangeLog = Get(cn, id);
if (employeeTimesheetChangeLog != null)
{
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "DELETE FROM EmployeeTimesheetChangeLog WHERE EmployeeTimesheetChangeLogId=" + id;
rowsAffected = sqlCmd.ExecuteNonQuery();
}
}
FinishedWithConnection(cn);
return(rowsAffected != 0);
}
private static bool Update(SqlConnection cn, EmployeeTimesheetChangeLog employeeTimesheetChangeLog)
{
Int32 rowsAffected = 0;
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "UPDATE EmployeeTimesheetChangeLog SET EmployeeTimesheetChangeLogEmployeeTimesheetId=@EmployeeTimesheetChangeLogEmployeeTimesheetId,EmployeeTimesheetChangeLogEmployeeId=@EmployeeTimesheetChangeLogEmployeeId,EmployeeTimesheetChangeLogEmployeeId=@EmployeeTimesheetChangeLogEmployeeId,EmployeeTimesheetChangeLogOldStartTime=@EmployeeTimesheetChangeLogOldStartTime,EmployeeTimesheetChangeLogOldEndTime=@EmployeeTimesheetChangeLogOldEndTime,EmployeeTimesheetChangeLogOldJob=@EmployeeTimesheetChangeLogOldJob,EmployeeTimesheetChangeLogOldTips=@EmployeeTimesheetChangeLogOldTips,EmployeeTimesheetChangeLogOldDriverComp=@EmployeeTimesheetChangeLogOldDriverComp WHERE EmployeeTimesheetChangeLogId=@EmployeeTimesheetChangeLogId";
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogId", SqlDbType.Int, employeeTimesheetChangeLog.Id);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogEmployeeTimesheetId", SqlDbType.Int, employeeTimesheetChangeLog.EmployeeTimesheetId);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogEmployeeId", SqlDbType.Int, employeeTimesheetChangeLog.EmployeeId);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogChangeDate", SqlDbType.DateTime, employeeTimesheetChangeLog.ChangeDate);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldStartTime", SqlDbType.DateTime, employeeTimesheetChangeLog.OldStartTime);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldEndTime", SqlDbType.DateTime, employeeTimesheetChangeLog.OldEndTime);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldJob", SqlDbType.SmallInt, employeeTimesheetChangeLog.OldJob);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldTips", SqlDbType.Float, employeeTimesheetChangeLog.OldTips);
BuildSqlParameter(sqlCmd, "@EmployeeTimesheetChangeLogOldDriverComp", SqlDbType.Float, employeeTimesheetChangeLog.OldDriverCompensation);
rowsAffected = sqlCmd.ExecuteNonQuery();
}
return(rowsAffected != 0);
}
