// Token: 0x060006E1 RID: 1761 RVA: 0x0002BA34 File Offset: 0x00029C34
public Dictionary <string, MemoryStream> GetIcons()
{
byte[] buffer = new byte[0];
Dictionary <string, MemoryStream> dictionary = new Dictionary <string, MemoryStream>();
using (OleDbConnection dbconnection = MibHelper.GetDBConnection())
{
using (OleDbCommand oleDbCommand = new OleDbCommand())
{
dbconnection.Open();
oleDbCommand.CommandText = "Select OID, [Small Icon] From Icons";
using (IDataReader dataReader = OleDbHelper.ExecuteReader(oleDbCommand, dbconnection))
{
while (dataReader.Read())
{
if (!(dataReader["Small Icon"] is DBNull))
{
buffer = (byte[])dataReader["Small Icon"];
dictionary.Add(dataReader["OID"].ToString(), new MemoryStream(buffer, true));
}
}
}
}
}
return(dictionary);
}
// Token: 0x060006E4 RID: 1764 RVA: 0x0002BC68 File Offset: 0x00029E68
public OidEnums GetEnums(string enumName)
{
OidEnums oidEnums = new OidEnums();
if (string.IsNullOrEmpty(enumName))
{
return(oidEnums);
}
using (OleDbConnection dbconnection = MibHelper.GetDBConnection())
{
dbconnection.Open();
using (OleDbCommand oleDbCommand = new OleDbCommand())
{
oleDbCommand.CommandText = string.Format("Select {0} from Enums WHERE Name=@name order by Value;", "Name, Value, Enum");
oleDbCommand.Parameters.AddWithValue("name", enumName);
using (IDataReader dataReader = OleDbHelper.ExecuteReader(oleDbCommand, dbconnection))
{
while (dataReader.Read())
{
oidEnums.Add(new OidEnum
{
Id = DatabaseFunctions.GetDouble(dataReader, 1).ToString(),
Name = DatabaseFunctions.GetString(dataReader, 2)
});
}
}
}
}
return(oidEnums);
}
public Oids GetSearchingOidsByName(string searchCriteria)
{
List <string> stringList = 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)", (object)"Index, MIB, Name, Primary, OID, Description, Access, Status, Units, Enum, TypeS");
oleDbCommand.Parameters.AddWithValue("@SearchValue", (object)searchCriteria);
using (IDataReader reader = OleDbHelper.ExecuteReader(oleDbCommand, connection))
{
using (IEnumerator <Oid> enumerator = ((Collection <string, Oid>)Task.Factory.StartNew <Oids>((Func <Oids>)(() => this.getOidsFromReader(reader, connection)), MibDAL.CancellationTokenSource.Token).Result).GetEnumerator())
{
while (((IEnumerator)enumerator).MoveNext())
{
Oid current = enumerator.Current;
((Collection <string, Oid>)oids).Add((object)current);
}
}
}
}
}
return(oids);
}
public OidEnums GetEnums(string enumName)
{
OidEnums oidEnums = new OidEnums();
if (string.IsNullOrEmpty(enumName))
{
return(oidEnums);
}
using (OleDbConnection dbConnection = MibHelper.GetDBConnection())
{
dbConnection.Open();
using (OleDbCommand oleDbCommand = new OleDbCommand())
{
oleDbCommand.CommandText = string.Format("Select {0} from Enums WHERE Name=@name order by Value;", (object)"Name, Value, Enum");
oleDbCommand.Parameters.AddWithValue("name", (object)enumName);
using (IDataReader dataReader = OleDbHelper.ExecuteReader(oleDbCommand, dbConnection))
{
while (dataReader.Read())
{
OidEnum oidEnum = new OidEnum();
oidEnum.set_Id(DatabaseFunctions.GetDouble(dataReader, 1).ToString());
oidEnum.set_Name(DatabaseFunctions.GetString(dataReader, 2));
((Collection <string, OidEnum>)oidEnums).Add((object)oidEnum);
}
}
}
}
return(oidEnums);
}
private Oid GetOid(string oid, bool clean)
{
using (OleDbConnection dbConnection = MibHelper.GetDBConnection())
{
dbConnection.Open();
return(this.GetOid(oid, dbConnection, clean));
}
}
// Token: 0x060006DE RID: 1758 RVA: 0x0002B94C File Offset: 0x00029B4C
private Oid GetOid(string oid, bool clean)
{
Oid oid2;
using (OleDbConnection dbconnection = MibHelper.GetDBConnection())
{
dbconnection.Open();
oid2 = this.GetOid(oid, dbconnection, clean);
}
return(oid2);
}
public Oids GetChildOids(string parentOid)
{
List <string> uniqueChildOids = this.GetUniqueChildOids(parentOid);
Oids oids = new Oids();
using (OleDbConnection dbConnection = MibHelper.GetDBConnection())
{
dbConnection.Open();
foreach (string oid1 in uniqueChildOids)
{
Oid oid2 = this.GetOid(oid1, dbConnection, true) ?? this.GetOid(oid1, dbConnection, false);
((Collection <string, Oid>)oids).Add((object)oid2);
}
}
return(oids);
}
// Token: 0x060006EA RID: 1770 RVA: 0x0002BF20 File Offset: 0x0002A120
private Oid CreateOid(IDataReader reader, OleDbConnection connection)
{
Oid oid = new Oid();
oid.ID = DatabaseFunctions.GetString(reader, 4);
oid.Name = DatabaseFunctions.GetString(reader, 2);
oid.Description = DatabaseFunctions.GetString(reader, 5);
oid.MIB = DatabaseFunctions.GetString(reader, 1);
oid.Access = (AccessType)DatabaseFunctions.GetByte(reader, 6);
oid.Status = (StatusType)DatabaseFunctions.GetByte(reader, 7);
oid.Units = DatabaseFunctions.GetString(reader, 8);
oid.StringType = DatabaseFunctions.GetString(reader, 10);
oid.HasChildren = this.HasChildren(oid.ID, connection);
oid.Enums = this.GetEnums(DatabaseFunctions.GetString(reader, 9));
oid.TreeIndex = DatabaseFunctions.GetInt32(reader, 0).ToString();
MibHelper.CleanupDescription(oid);
MibHelper.SetTypeInfo(oid);
return(oid);
}
private Oid CreateOid(IDataReader reader, OleDbConnection connection)
{
Oid oid = new Oid();
oid.set_ID(DatabaseFunctions.GetString(reader, 4));
oid.set_Name(DatabaseFunctions.GetString(reader, 2));
oid.set_Description(DatabaseFunctions.GetString(reader, 5));
oid.set_MIB(DatabaseFunctions.GetString(reader, 1));
oid.set_Access((AccessType)(int)DatabaseFunctions.GetByte(reader, 6));
oid.set_Status((StatusType)(int)DatabaseFunctions.GetByte(reader, 7));
oid.set_Units(DatabaseFunctions.GetString(reader, 8));
oid.set_StringType(DatabaseFunctions.GetString(reader, 10));
oid.set_HasChildren(this.HasChildren(oid.get_ID(), connection));
oid.set_Enums(this.GetEnums(DatabaseFunctions.GetString(reader, 9)));
oid.set_TreeIndex(DatabaseFunctions.GetInt32(reader, 0).ToString());
MibHelper.CleanupDescription(oid);
MibHelper.SetTypeInfo(oid);
return(oid);
}
// 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: 0x060006E3 RID: 1763 RVA: 0x0002BBB0 File Offset: 0x00029DB0
public List <string> GetUniqueChildOids(string parentOid)
{
List <string> list = new List <string>();
using (OleDbConnection dbconnection = MibHelper.GetDBConnection())
{
dbconnection.Open();
using (OleDbCommand oleDbCommand = new OleDbCommand())
{
oleDbCommand.CommandText = string.Format("Select DISTINCT Name, OID, Index from Tree WHERE Primary = -1 AND ParentOID=@parentOid order by index;", "Index, MIB, Name, Primary, OID, Description, Access, Status, Units, Enum, TypeS");
oleDbCommand.Parameters.AddWithValue("parentOid", parentOid);
using (IDataReader dataReader = OleDbHelper.ExecuteReader(oleDbCommand, dbconnection))
{
while (dataReader.Read())
{
list.Add(DatabaseFunctions.GetString(dataReader, "OID"));
}
}
}
}
return(list);
}
// 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);
}
// Token: 0x060006E9 RID: 1769 RVA: 0x0002BF18 File Offset: 0x0002A118
public bool IsMibDatabaseAvailable()
{
return(MibHelper.IsMIBDatabaseAvailable());
}
