/// <summary>
/// Gets the SQL-servers, excluding marked as deleted.
/// </summary>
/// <returns>The DataTable that contains SQL-servers.</returns>
public static MasterDataSet.DatabaseServerDataTable GetDatabaseServers()
{
using (DatabaseServerTableAdapter adapter = new DatabaseServerTableAdapter())
{
return(adapter.GetDatabaseServers());
}
}
public static void UpdateDatabaseServer(Guid databaseServerId, string name, string instanceName, int port, string description, Guid websiteId)
{
using (DatabaseServerTableAdapter adapter = new DatabaseServerTableAdapter())
{
adapter.Update(databaseServerId, name, instanceName, port, description, websiteId, false);
}
}
public static MasterDataSet.DatabaseServerRow GetDatabaseServerRow(Guid databaseServerId)
{
using (DatabaseServerTableAdapter adapter = new DatabaseServerTableAdapter())
{
MasterDataSet.DatabaseServerDataTable table = adapter.GetDatabaseServer(databaseServerId);
return((table.Count > 0) ? table[0] : null);
}
}
public static Guid InsertDatabaseServer(string name, string instanceName, int port, string description, Guid websiteId)
{
Guid databaseServerId = Guid.NewGuid();
using (DatabaseServerTableAdapter adapter = new DatabaseServerTableAdapter())
{
adapter.Insert(databaseServerId, name, instanceName, port, description, websiteId, false);
}
return(databaseServerId);
}
/// <summary>
/// Marks as deleted the specified SQL-server.
/// </summary>
/// <param name="databaseServerId">Specifies the SQL-server's identifier.</param>
public static void DeleteDatabaseServer(Guid databaseServerId)
{
MasterDataSet.DatabaseServerRow row = GetDatabaseServerRow(databaseServerId);
if (row == null)
{
return;
}
row.Deleted = true;
using (DatabaseServerTableAdapter adapter = new DatabaseServerTableAdapter())
{
adapter.Update(row);
}
}
