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