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