public void DatabasesTest()
{
ServerData target = new ServerData();
DatabaseList expected = new DatabaseList();
expected.Add(new DatabaseItem());
DatabaseList actual;
target.Databases = expected;
actual = target.Databases;
Assert.AreEqual(expected, actual);
Assert.AreEqual(1, actual.Count);
}
public void ReadDatabases()
{
using (SqlConnection connection = new SqlConnection(GetSqlConString()))
{
SqlCommand command = new SqlCommand("select NAME from SYS.DATABASES", connection);
command.Connection.Open();
using (var oReader = command.ExecuteReader())
{
while (oReader.HasRows && oReader.Read())
{
DatabaseList.Add((string)oReader["NAME"]);
}
}
}
}
public void SquareBracketOperator()
{
Int32 databaseIndex;
DatabaseList newDatabaseList, oldDatabaseList;
oldDatabaseList = GetDatabases(true);
newDatabaseList = new DatabaseList();
for (databaseIndex = 0; databaseIndex < oldDatabaseList.Count; databaseIndex++)
{
newDatabaseList.Add(oldDatabaseList[oldDatabaseList.Count - databaseIndex - 1]);
}
for (databaseIndex = 0; databaseIndex < oldDatabaseList.Count; databaseIndex++)
{
Assert.AreEqual(newDatabaseList[databaseIndex], oldDatabaseList[oldDatabaseList.Count - databaseIndex - 1]);
}
}
private void LoadRevitElements()
{
try
{
DirectoryInfo dinfo = new DirectoryInfo(FilePath);
FileInfo[] files = dinfo.GetFiles("*.sdb");
foreach (FileInfo file in files)
{
DatabaseList.Add(file);
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
//SQLDB.readElements(FilePath);
//revitElements = SQLDB.observableRevitElements;
//MessageBox.Show($"load {FilePath}");
}