// ===================================================================================== /// <summary> /// This method gets an ArrayList contain the DatabaseUpdates objects /// </summary> /// <param name="Version">EvDataBaseUpdate.UpdateVersionList: A sorting order of the list</param> /// <param name="OrderBy">EvDataBaseUpdate.DataBaseUpdateOrderBy: A sorting order of the list</param> /// <returns>List of EvDataBaseUpdate: a list of database update objects</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Execute the method for retrieving a selection list of Application event objects. /// /// 2. Return the selection list. /// </remarks> // ------------------------------------------------------------------------------------- public List <EvDataBaseUpdate> getUpdateList( EvDataBaseUpdate.UpdateVersionList Version, EvDataBaseUpdate.UpdateOrderBy OrderBy) { this.LogMethod("getUpdateList method. "); // // Execute the selectionList method. // List <EvDataBaseUpdate> view = this._DalDatabaseUpdates.getUpdateList(Version, OrderBy); this.LogClass(this._DalDatabaseUpdates.Log); this.LogMethodEnd("getUpdateList"); return(view); } //End getMilestoneList method.
}// End readDataRow method. #endregion #region Class Query method section // ================================================================================== /// <summary> /// This class gets a List containing a selectionList of ApplicationEvent data objects. /// </summary> /// <param name="Version">EvDataBaseUpdate.UpdateVersionList: A sorting order of the list</param> /// <param name="OrderBy">EvDataBaseUpdate.DataBaseUpdateOrderBy: The sorting order enumeration.</param> /// <returns>List of EvDataBaseUpdate: a view of database update list</returns> /// <remarks> /// This method consists of the following steps: /// /// 1. Initialize a status string and a return view of database update list. /// /// 2. Define the query string. /// /// 3. Execute the query against the database. /// /// 4. Iterate through the results extracting the role information. /// /// 5. Extract the table row /// /// 6. Append the value to the visit /// /// 7. Return the view /// </remarks> // ---------------------------------------------------------------------------------- public List <EvDataBaseUpdate> getUpdateList( EvDataBaseUpdate.UpdateVersionList Version, EvDataBaseUpdate.UpdateOrderBy OrderBy) { // // Initialize a status string and a return database update view list. // this.LogMethod("getUpdateList method. "); this.LogDebug("Version: " + Version); this.LogDebug("OrderBy: " + OrderBy); List <EvDataBaseUpdate> view = new List <EvDataBaseUpdate> ( ); // // Define the query string. // string sqlQueryString = _sqlQuery_View; switch (Version) { case EvDataBaseUpdate.UpdateVersionList.Version_2: { sqlQueryString += "WHERE DBU_Version LIKE '%R2%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_3: { sqlQueryString += "WHERE DBU_Version LIKE '%R3%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_4: { sqlQueryString += "WHERE DBU_Version LIKE '%R4%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_4_1: { sqlQueryString += "WHERE DBU_Version LIKE '%R4.1%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_4_2: { sqlQueryString += "WHERE DBU_Version LIKE '%R4.2%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_4_3: { sqlQueryString += "WHERE DBU_Version LIKE '%R4.3%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_4_4: { sqlQueryString += "WHERE DBU_Version LIKE '%R4.4%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_4_5: { sqlQueryString += "WHERE DBU_Version LIKE '%R4.5%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_4_6: { sqlQueryString += "WHERE DBU_Version LIKE '%R4.6%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_4_7: { sqlQueryString += "WHERE DBU_Version LIKE '%R4.7%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_4_8: { sqlQueryString += "WHERE DBU_Version LIKE '%R4.8%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_5: { sqlQueryString += "WHERE DBU_Version LIKE '%R5%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_6: { sqlQueryString += "WHERE DBU_Version LIKE '%R6%' \r\n"; break; } case EvDataBaseUpdate.UpdateVersionList.Version_7: { sqlQueryString += "WHERE DBU_Version LIKE '%R7%' \r\n"; break; } } switch (OrderBy) { case EvDataBaseUpdate.UpdateOrderBy.Date: { sqlQueryString += " ORDER BY DBU_Update_Date, DBU_Update_No ;"; break; } case EvDataBaseUpdate.UpdateOrderBy.Version: { sqlQueryString += " ORDER BY DBU_Version, DBU_Update_Date ;"; break; } default: { sqlQueryString += " ORDER BY DBU_Update_No ;"; break; } } this.LogDebug(sqlQueryString); // // Execute the query against the database. // using (DataTable table = EvSqlMethods.RunQuery(sqlQueryString, null)) { // // Iterate through the results extracting the role information. // for (int Count = 0; Count < table.Rows.Count; Count++) { // // Extract the table row // DataRow row = table.Rows [Count]; EvDataBaseUpdate update = this.readDataRow(row); // // Append the value to the visit // view.Add(update); } //END interation loop. } //END Using statement // // Pass back the result arrray. // return(view); }//END getView method.