public static void UpdateDatabase(Guid databaseId, string name, string description, string userName, string password, bool Private, Guid databaseServerId)
{
using (DatabaseTableAdapter adapter = new DatabaseTableAdapter())
{
adapter.Update(databaseId, name, description, userName, password, databaseServerId, Private, false);
}
}
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);
}
/// <summary>
/// Gets the databases, excluding marked as deleted.
/// </summary>
/// <returns>The table that contains databases.</returns>
public static MasterDataSet.DatabaseDataTable GetDatabases()
{
using (DatabaseTableAdapter adapter = new DatabaseTableAdapter())
{
return(adapter.GetDatabases());
}
}
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);
}
}
public static Guid InsertDatabase(string name, string description, string userName, string password, bool Private, Guid databaseServerId)
{
Guid databaseId = Guid.NewGuid();
using (DatabaseTableAdapter adapter = new DatabaseTableAdapter())
{
adapter.Insert(databaseId, name, description, userName, password, databaseServerId, Private, false);
}
return(databaseId);
}
public static void DeleteDatabase(Guid databaseId)
{
MasterDataSet.DatabaseRow row = GetDatabaseRow(databaseId);
if (row == null)
{
return;
}
row.Deleted = true;
using (DatabaseTableAdapter adapter = new DatabaseTableAdapter())
{
adapter.Update(row);
}
}
