/// <summary> /// Creates a new instance of the Sol_WS_ErrorCodes class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_WS_ErrorCode MakeSol_WS_ErrorCode(SqlDataReader dataReader) { Sol_WS_ErrorCode sol_WS_ErrorCode = new Sol_WS_ErrorCode(); sol_WS_ErrorCode.ErrorNumber = SqlClientUtility.GetInt32(dataReader, "ErrorNumber", 0); sol_WS_ErrorCode.ErrorDescription = SqlClientUtility.GetString(dataReader, "ErrorDescription", String.Empty); sol_WS_ErrorCode.MessageToClient = SqlClientUtility.GetBoolean(dataReader, "MessageToClient", false); sol_WS_ErrorCode.Notes = SqlClientUtility.GetString(dataReader, "Notes", String.Empty); return(sol_WS_ErrorCode); }
/// <summary> /// Updates a record in the Sol_WS_ErrorCodes table. /// </summary> public virtual void Update(Sol_WS_ErrorCode sol_WS_ErrorCode) { ValidationUtility.ValidateArgument("sol_WS_ErrorCode", sol_WS_ErrorCode); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ErrorNumber", sol_WS_ErrorCode.ErrorNumber), new SqlParameter("@ErrorDescription", sol_WS_ErrorCode.ErrorDescription), new SqlParameter("@MessageToClient", sol_WS_ErrorCode.MessageToClient), new SqlParameter("@Notes", sol_WS_ErrorCode.Notes) }; SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_WS_ErrorCodes_Update", parameters); }
/// <summary> /// Selects all records from the Sol_WS_ErrorCodes table. /// </summary> public virtual List <Sol_WS_ErrorCode> SelectAll() { using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_WS_ErrorCodes_SelectAll")) { List <Sol_WS_ErrorCode> sol_WS_ErrorCodeList = new List <Sol_WS_ErrorCode>(); while (dataReader.Read()) { Sol_WS_ErrorCode sol_WS_ErrorCode = MakeSol_WS_ErrorCode(dataReader); sol_WS_ErrorCodeList.Add(sol_WS_ErrorCode); } return(sol_WS_ErrorCodeList); } }