// Token: 0x060006E8 RID: 1768 RVA: 0x0002BED8 File Offset: 0x0002A0D8 private Oids getOidsFromReader(IDataReader reader, OleDbConnection connection) { Oids oids = new Oids(); while (reader.Read()) { MibDAL.CancellationTokenSource.Token.ThrowIfCancellationRequested(); Oid value = this.CreateOid(reader, connection); oids.Add(value); } return(oids); }
// Token: 0x060006E2 RID: 1762 RVA: 0x0002BB10 File Offset: 0x00029D10 public Oids GetChildOids(string parentOid) { List <string> uniqueChildOids = this.GetUniqueChildOids(parentOid); Oids oids = new Oids(); using (OleDbConnection dbconnection = MibHelper.GetDBConnection()) { dbconnection.Open(); foreach (string oid in uniqueChildOids) { Oid oid2 = this.GetOid(oid, dbconnection, true); if (oid2 == null) { oid2 = this.GetOid(oid, dbconnection, false); } oids.Add(oid2); } } return(oids); }
// Token: 0x060006E7 RID: 1767 RVA: 0x0002BD84 File Offset: 0x00029F84 public Oids GetSearchingOidsByName(string searchCriteria) { new List <string>(); Oids oids = new Oids(); using (OleDbConnection connection = MibHelper.GetDBConnection()) { connection.Open(); MibDAL.CancellationTokenSource = new CancellationTokenSource(); using (OleDbCommand oleDbCommand = new OleDbCommand()) { oleDbCommand.CommandText = string.Format("SELECT TOP 250 {0} FROM Tree WHERE (Primary = -1) AND ( Name LIKE @SearchValue OR Description LIKE '%' + @SearchValue + '%' OR Mib LIKE @SearchValue)", "Index, MIB, Name, Primary, OID, Description, Access, Status, Units, Enum, TypeS"); oleDbCommand.Parameters.AddWithValue("@SearchValue", searchCriteria); using (IDataReader reader = OleDbHelper.ExecuteReader(oleDbCommand, connection)) { foreach (Oid value in Task.Factory.StartNew <Oids>(() => this.getOidsFromReader(reader, connection), MibDAL.CancellationTokenSource.Token).Result) { oids.Add(value); } } } } return(oids); }