public List <RecordSearch> GetPartialRecordSearchesByCriteria(string criteria) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = @"SELECT ID, ICPrefix, ICYear, ICEnumeration, ICSuffix, ProjectName, Status, LastUpdated FROM tblRecordSearches " + criteria; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); List <RecordSearch> returnCollection = new List <RecordSearch>(); while (reader.Read()) { int index = 0; RecordSearch returnValue = new RecordSearch() { ID = reader.GetInt32Safe(index++), ICTypePrefix = reader.GetStringSafe(index++), ICYear = reader.GetStringSafe(index++), ICEnumeration = reader.GetInt32Safe(index++), ICSuffix = reader.GetStringSafe(index++), ProjectName = reader.GetStringSafe(index++), Status = reader.GetStringSafe(index++), LastUpdated = reader.GetDateTimeSafe(index++) }; returnCollection.Add(returnValue); } return(returnCollection); } } }
public RecordSearch GetPartialRecordSearchesByCriteria(int id) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = @"SELECT ID, ICPrefix, ICYear, ICEnumeration, ICSuffix, ProjectName, Status, LastUpdated FROM tblRecordSearches WHERE ID = " + id; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); int index = 0; RecordSearch returnValue = new RecordSearch() { ID = reader.GetInt32Safe(index++), ICTypePrefix = reader.GetStringSafe(index++), ICYear = reader.GetStringSafe(index++), ICEnumeration = reader.GetInt32Safe(index++), ICSuffix = reader.GetStringSafe(index++), ProjectName = reader.GetStringSafe(index++), Status = reader.GetStringSafe(index++), LastUpdated = reader.GetDateTimeSafe(index++) }; return(returnValue); } } }