private static string GetConnectionString(Guid organizationId) { string connectionString = null; DatabaseTableAdapter adapter = null; MasterDataSet.DatabaseDataTable table = null; MasterDataSet.DatabaseRow row = null; try { adapter = new DatabaseTableAdapter(); table = adapter.GetDatabaseByOrganizationId(organizationId); row = table[0]; connectionString = CreateConnectionString(row.DatabaseName, row.UserName, row.Password, row.ServerName, row.ServerInstanceName, row.Port); } finally { if (adapter != null) { adapter.Dispose(); } if (table != null) { table.Dispose(); } } return(connectionString); }
private static DataTable GetPublicDatabases(Guid organizationId, bool includeAdditionalInfo) { DataTable table = new MasterDataSet.DatabaseDataTable(); foreach (MasterDataSet.DatabaseRow row in GetDatabases()) { if (row.Private) { if (organizationId != Guid.Empty) { Organization org = OrganizationProvider.GetOrganization(organizationId); if (org != null) { if (org.DatabaseId == row.DatabaseId) { table.ImportRow(row); } } } } else { table.ImportRow(row); } } if (includeAdditionalInfo) { IncludeAdditionalInfo(ref table); } table.AcceptChanges(); return(table); }
private static MasterDataSet.DatabaseRow GetDatabaseRowByOrganizationId(Guid organizationId) { using (DatabaseTableAdapter adapter = new DatabaseTableAdapter()) { MasterDataSet.DatabaseDataTable table = adapter.GetDatabaseByOrganizationId(organizationId); return((table.Count > 0) ? table[0] : null); } }
public static MasterDataSet.DatabaseRow GetDatabaseRow(Guid databaseId) { using (DatabaseTableAdapter adapter = new DatabaseTableAdapter()) { MasterDataSet.DatabaseDataTable table = adapter.GetDatabase(databaseId); return((table.Count > 0) ? table[0] : null); } }