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