public static EmployeeManagerNotesData Load(IdType id)
{
WhereClause w = new WhereClause();
w.And("Id", id.DBValue);
SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for EmployeeManagerNotes.");
}
EmployeeManagerNotesData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
public static IdType Insert(EmployeeManagerNotesData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "ChangeEmployeeName,"
+ "IsAutomated,"
+ "NoteDate,"
+ "Notes,"
+ "Type,"
+ "EmployeeID,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@ChangeEmployeeName,"
+ "@IsAutomated,"
+ "@NoteDate,"
+ "@Notes,"
+ "@Type,"
+ "@EmployeeID,"
;
sql = sql.Substring(0, sql.Length - 1) + ");select Scope_Identity() Id";
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
cmd.Parameters.Add(new SqlParameter("@ChangeEmployeeName", SqlDbType.VarChar, 150, ParameterDirection.Input, false, 0, 0, "ChangeEmployeeName", DataRowVersion.Proposed, data.ChangeEmployeeName.DBValue));
cmd.Parameters.Add(new SqlParameter("@IsAutomated", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsAutomated", DataRowVersion.Proposed, !data.IsAutomated.IsValid ? data.IsAutomated.DBValue : data.IsAutomated.DBValue.Equals("Y") ? 1 : 0));
cmd.Parameters.Add(new SqlParameter("@NoteDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "NoteDate", DataRowVersion.Proposed, data.NoteDate.DBValue));
cmd.Parameters.Add(new SqlParameter("@Notes", SqlDbType.VarChar, 300, ParameterDirection.Input, false, 0, 0, "Notes", DataRowVersion.Proposed, data.Notes.DBValue));
cmd.Parameters.Add(new SqlParameter("@Type", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Type", DataRowVersion.Proposed, data.Type.DBValue));
cmd.Parameters.Add(new SqlParameter("@EmployeeID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "EmployeeID", DataRowVersion.Proposed, data.EmployeeID.DBValue));
// Execute the query
SqlDataReader returnValue = cmd.ExecuteReader();
returnValue.Read();
int returnId = (int)(returnValue.GetDecimal(0));
returnValue.Close();
// Set the output paramter value(s)
return(new IdType(returnId));
}
public static void Update(EmployeeManagerNotesData data)
{
// Create and execute the command
EmployeeManagerNotesData oldData = Load(data.Id);
string sql = "Update " + TABLE + " set ";
if (!oldData.ChangeEmployeeName.Equals(data.ChangeEmployeeName))
{
sql = sql + "ChangeEmployeeName=@ChangeEmployeeName,";
}
if (!oldData.IsAutomated.Equals(data.IsAutomated))
{
sql = sql + "IsAutomated=@IsAutomated,";
}
if (!oldData.NoteDate.Equals(data.NoteDate))
{
sql = sql + "NoteDate=@NoteDate,";
}
if (!oldData.Notes.Equals(data.Notes))
{
sql = sql + "Notes=@Notes,";
}
if (!oldData.Type.Equals(data.Type))
{
sql = sql + "Type=@Type,";
}
if (!oldData.EmployeeID.Equals(data.EmployeeID))
{
sql = sql + "EmployeeID=@EmployeeID,";
}
WhereClause w = new WhereClause();
w.And("Id", data.Id.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.Id.Equals(data.Id))
{
cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Id", DataRowVersion.Proposed, data.Id.DBValue));
}
if (!oldData.ChangeEmployeeName.Equals(data.ChangeEmployeeName))
{
cmd.Parameters.Add(new SqlParameter("@ChangeEmployeeName", SqlDbType.VarChar, 150, ParameterDirection.Input, false, 0, 0, "ChangeEmployeeName", DataRowVersion.Proposed, data.ChangeEmployeeName.DBValue));
}
if (!oldData.IsAutomated.Equals(data.IsAutomated))
{
cmd.Parameters.Add(new SqlParameter("@IsAutomated", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "IsAutomated", DataRowVersion.Proposed, !data.IsAutomated.IsValid ? data.IsAutomated.DBValue : data.IsAutomated.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.NoteDate.Equals(data.NoteDate))
{
cmd.Parameters.Add(new SqlParameter("@NoteDate", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "NoteDate", DataRowVersion.Proposed, data.NoteDate.DBValue));
}
if (!oldData.Notes.Equals(data.Notes))
{
cmd.Parameters.Add(new SqlParameter("@Notes", SqlDbType.VarChar, 300, ParameterDirection.Input, false, 0, 0, "Notes", DataRowVersion.Proposed, data.Notes.DBValue));
}
if (!oldData.Type.Equals(data.Type))
{
cmd.Parameters.Add(new SqlParameter("@Type", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "Type", DataRowVersion.Proposed, data.Type.DBValue));
}
if (!oldData.EmployeeID.Equals(data.EmployeeID))
{
cmd.Parameters.Add(new SqlParameter("@EmployeeID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "EmployeeID", DataRowVersion.Proposed, data.EmployeeID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
private static EmployeeManagerNotesData GetDataObjectFromReader(SqlDataReader dataReader)
{
EmployeeManagerNotesData data = new EmployeeManagerNotesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("Id")))
{
data.Id = IdType.UNSET;
}
else
{
data.Id = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("Id")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ChangeEmployeeName")))
{
data.ChangeEmployeeName = StringType.UNSET;
}
else
{
data.ChangeEmployeeName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ChangeEmployeeName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsAutomated")))
{
data.IsAutomated = BooleanType.UNSET;
}
else
{
data.IsAutomated = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsAutomated")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NoteDate")))
{
data.NoteDate = DateType.UNSET;
}
else
{
data.NoteDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("NoteDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Notes")))
{
data.Notes = StringType.UNSET;
}
else
{
data.Notes = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Notes")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Type")))
{
data.Type = IntegerType.UNSET;
}
else
{
data.Type = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Type")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeID")))
{
data.EmployeeID = IntegerType.UNSET;
}
else
{
data.EmployeeID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("EmployeeID")));
}
return(data);
}
