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