public ErrorTypes GetChanges(string sKey, out List<DocsChange> aChanges) { aChanges = new List<DocsChange>(); ErrorTypes eErrorTypes = ErrorTypes.NoError; try { using (IDbConnection sqlCon = GetDbConnection()) { sqlCon.Open(); using (IDbCommand oSelCommand = sqlCon.CreateCommand()) { oSelCommand.CommandText = GetSELECTString(sKey); using (IDataReader oReader = oSelCommand.ExecuteReader()) { while (true == oReader.Read()) { DocsChange oDocsChange = new DocsChange(); oDocsChange.data = Convert.ToString(oReader["dc_data"]); oDocsChange.userid = Convert.ToString(oReader["dc_user_id_original"]); oDocsChange.username = Convert.ToString(oReader["dc_user_name"]); oDocsChange.date = Convert.ToDateTime(oReader["dc_date"]); aChanges.Add(oDocsChange); } } } } } catch { eErrorTypes = ErrorTypes.EditorChanges; } return eErrorTypes; }
public ErrorTypes GetChanges(string sKey, out List <DocsChange> aChanges) { aChanges = new List <DocsChange>(); ErrorTypes eErrorTypes = ErrorTypes.NoError; try { using (IDbConnection sqlCon = GetDbConnection()) { sqlCon.Open(); using (IDbCommand oSelCommand = sqlCon.CreateCommand()) { oSelCommand.CommandText = GetSELECTString(sKey); using (IDataReader oReader = oSelCommand.ExecuteReader()) { while (true == oReader.Read()) { DocsChange oDocsChange = new DocsChange(); oDocsChange.data = Convert.ToString(oReader["dc_data"]); oDocsChange.userid = Convert.ToString(oReader["dc_user_id_original"]); oDocsChange.username = Convert.ToString(oReader["dc_user_name"]); oDocsChange.date = Convert.ToDateTime(oReader["dc_date"]); aChanges.Add(oDocsChange); } } } } } catch { eErrorTypes = ErrorTypes.EditorChanges; } return(eErrorTypes); }