/// <summary>
/// Loads the tree by asset.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="assetId">The asset unique identifier.</param>
public void LoadByAsset(EnterpriseTestEntities entities, string assetId)
{
EntityName = assetId;
// For every item that is associated with the given Asset, create a tree hierarchy that
// contains the Scenario, Virtual Resource and then the Metadata that is associated with
// the Asset
foreach (var item in GetAssetUsages(entities, assetId))
{
// First look for the given scenario name
var scenario = Children.Where(e => e.EntityId.Equals(item.ScenarioId)).FirstOrDefault();
if (scenario == null)
{
// From the inside out, add a Scenario node, then a child resource node, then a
// child metadata node
AddMetadataNode(AddResourceNode(AddScenarioNode(item), item), item);
}
else
{
// Scenario exists, see if the resource exists.
var resource = scenario.Children.Where(e => e.EntityId.Equals(item.ResourceId)).FirstOrDefault();
if (resource == null)
{
// If the resource doesn't exist, add it, then a child metadata node
AddMetadataNode(AddResourceNode(scenario, item), item);
}
else
{
// Just add a child metadata node to the existing resource node
AddMetadataNode(resource, item);
}
}
}
}
private void HandleObjectChange(EnterpriseTestEntities entities, EntityObject entity)
{
// Get a node that is representative of this item
EnterpriseTestMapNode node = EnterpriseTestMapNode.Create(entity);
if (node != null)
{
switch (entity.EntityState)
{
case EntityState.Added:
_databaseMap.Add(node);
OnNodeAdded(node);
break;
case EntityState.Modified:
_databaseMap.Update(node);
OnNodeModified(node);
break;
case EntityState.Deleted:
_databaseMap.Remove(node);
OnNodeRemoved(node);
break;
}
}
}
private static IEnumerable <AssetUsageData> GetAssetUsages(EnterpriseTestEntities entities, string assetId)
{
return(from mau in entities.VirtualResourceMetadataAssetUsages.AsEnumerable()
where mau.AssetSelectionData.Contains(assetId)
join vrm in entities.VirtualResourceMetadataSet
on mau.VirtualResourceMetadataId equals vrm.VirtualResourceMetadataId into Metadata
from m in Metadata
join vr in entities.VirtualResources
on m.VirtualResourceId equals vr.VirtualResourceId into Resources
from r in Resources
join es in entities.EnterpriseScenarios
on r.EnterpriseScenarioId equals es.EnterpriseScenarioId into Scenarios
from s in Scenarios
select new AssetUsageData
{
AssetId = assetId,
ScenarioName = s.Name,
ScenarioId = s.EnterpriseScenarioId,
ResourceName = r.Name,
ResourceType = r.ResourceType,
ResourceId = m.VirtualResourceId,
MetadataDescription = m.Name,
MetadataType = m.MetadataType,
MetadataId = m.VirtualResourceMetadataId,
});
}
public static void RemoveChild(EnterpriseTestEntities entities, int parentId, int childId)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
ResourceWindowsCategory componentToRemove = ResourceWindowsCategory.SelectById(entities, childId);
EntityCollection <ResourceWindowsCategory> parentList = componentToRemove.Parents;
int count = 0;
int deleteIndex = 0;
foreach (ResourceWindowsCategory parent in parentList)
{
if (parent.CategoryId == parentId)
{
deleteIndex = count;
}
count++;
}
componentToRemove.Parents.Remove(componentToRemove.Parents.ElementAt(deleteIndex));
if (componentToRemove.Parents.Count < 1)
{
entities.DeleteObject(componentToRemove);
entities.SaveChanges();
}
}
private static IQueryable <SoftwareInstaller> SelectSoftwareInstallers(EnterpriseTestEntities entities, Guid packageId)
{
return(from p in entities.SoftwareInstallerPackages
where p.PackageId == packageId
from s in p.SoftwareInstallerSettings
orderby s.InstallOrderNumber
select s.SoftwareInstaller);
}
private void LoadGroups(EnterpriseTestEntities entities)
{
foreach (UserGroup group in entities.UserGroups.OrderBy(x => x.GroupName))
{
var selected = _scenario.UserGroups.Any(x => x.GroupName.Equals(group.GroupName));
editorGroups_CheckedListBox.Items.Add(group, selected);
}
}
/// <summary>
/// Gets the next Id for ResourceWindowsCategory.
/// </summary>
/// <param name="entities"></param>
/// <returns></returns>
private static int NextId(EnterpriseTestEntities entities)
{
int maxId = -1;
maxId = (from c in entities.ResourceWindowsCategories
select c.CategoryId).Max();
return(maxId + 1);
}
private static IQueryable <SoftwareInstaller> SelectInstallersByResourceType(EnterpriseTestEntities entities, string resourceTypeName)
{
return(from t in entities.ResourceTypes
from p in t.SoftwareInstallerPackages
from s in p.SoftwareInstallerSettings
where t.Name == resourceTypeName
orderby s.InstallOrderNumber
select s.SoftwareInstaller);
}
/// <summary>
/// Initializes a new instance of the <see cref="VirtualMachinePlatformConfigForm"/> class.
/// </summary>
public VirtualMachineUserViewForm()
{
InitializeComponent();
UserInterfaceStyler.Configure(this, FormStyle.SizeableDialog);
_entities = new EnterpriseTestContext();
platformFilter_ToolStripComboBox.ComboBox.DisplayMember = "Name";
platformFilter_ToolStripComboBox.ComboBox.ValueMember = "FrameworkClientPlatformId";
}
/// <summary>
/// Selects a disctinct list of Category types
/// </summary>
/// <param name="entities"></param>
/// <returns></returns>
public static IQueryable <String> SelectDistinctCategoryTypes(EnterpriseTestEntities entities)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return((from c in entities.ResourceWindowsCategories
select c.CategoryType).Distinct());
}
/// <summary>
/// Initializes a new instance of the <see cref="VirtualMachinePlatformConfigForm"/> class.
/// </summary>
public VirtualMachineGroupConfigForm()
{
InitializeComponent();
UserInterfaceStyler.Configure(this, FormStyle.SizeableDialog);
_entities = new EnterpriseTestContext();
//bind the virtual machine list to the combobox, the display will always the name
// and the value will be the platformId
platformFilter_ToolStripComboBox.ComboBox.DisplayMember = "Name";
platformFilter_ToolStripComboBox.ComboBox.ValueMember = "FrameworkClientPlatformId";
}
/// <summary>
/// Selects all <see cref="ConfigurationTreeFolder"/>s.
/// </summary>
/// <param name="entities"></param>
/// <returns></returns>
public static IQueryable <ConfigurationTreeFolder> Select(EnterpriseTestEntities entities)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return(from n in entities.ConfigurationTreeFolders
select n);
}
/// <summary>
/// Selects ResourceWindowsCategory for the given category type.
/// </summary>
/// <param name="entities">The data context.</param>
/// <param name="categoryType">The category type.</param>
/// <returns></returns>
public static IQueryable <ResourceWindowsCategory> Select(EnterpriseTestEntities entities, string categoryType)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return(from c in entities.ResourceWindowsCategories.Include("Children")
where c.CategoryType == categoryType orderby(c.CategoryType)
select c);
}
/// <summary>
/// Selects an <see cref="EnterpriseScenario"/> by its id.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="scenarioId">The scenario Id.</param>
/// <returns></returns>
public static EnterpriseScenario Select(EnterpriseTestEntities entities, Guid scenarioId)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return((from n in entities.EnterpriseScenarios
where n.EnterpriseScenarioId == scenarioId
select n).FirstOrDefault());
}
public static ResourceWindowsCategory SelectByName(EnterpriseTestEntities entities, string name, string categoryType)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return((from c in entities.ResourceWindowsCategories
where c.Name == name && c.CategoryType == categoryType
select c).First());
}
/// <summary>
/// Selects the distinct companies from all <see cref="EnterpriseScenario"/>s.
/// </summary>
/// <param name="entities">The entities.</param>
/// <returns></returns>
public static IQueryable <string> SelectDistinctCompany(EnterpriseTestEntities entities)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return((from n in entities.EnterpriseScenarios
where n.Company != null
select n.Company).Distinct());
}
public static IQueryable <ResourceWindowsCategory> SelectParent(EnterpriseTestEntities entities, string categoryType)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return(from c in entities.ResourceWindowsCategories
where c.CategoryType == categoryType && c.Parents.Count == 0
select c);
}
/// <summary>
/// Selects a <see cref="ConfigurationTreeFolder"/> by its id.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="id">The id.</param>
/// <returns></returns>
public static ConfigurationTreeFolder Select(EnterpriseTestEntities entities, Guid id)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return((from n in entities.ConfigurationTreeFolders
where n.ConfigurationTreeFolderId == id
select n).FirstOrDefault());
}
/// <summary>
/// Selects a <see cref="VirtualResourceMetadata"/> by its id.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="id">The id.</param>
/// <returns></returns>
public static VirtualResourceMetadata Select(EnterpriseTestEntities entities, Guid id)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return((from n in entities.VirtualResourceMetadataSet
where n.VirtualResourceMetadataId == id
select n).FirstOrDefault());
}
/// <summary>
/// Selects all <see cref="VirtualResourceMetadata"/> objects with ids in the specified list.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="ids">The ids.</param>
/// <returns></returns>
public static IQueryable <VirtualResourceMetadata> Select(EnterpriseTestEntities entities, IEnumerable <Guid> ids)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return(from n in entities.VirtualResourceMetadataSet
where ids.Contains(n.VirtualResourceMetadataId)
select n);
}
/// <summary>
/// Selects ResourceWindowsCategory for the given category type and category name.
/// </summary>
/// <param name="entities">The data context.</param>
/// <param name="categoryType">The category name.</param>
/// <param name="categoryName">The instance name.</param>
/// <returns></returns>
public static IQueryable <ResourceWindowsCategory> Select(EnterpriseTestEntities entities, string categoryType, string categoryName)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return(from c in entities.ResourceWindowsCategories.Include("Children")
where c.CategoryType.Equals(categoryType, StringComparison.InvariantCultureIgnoreCase) && c.Name.Equals(categoryName, StringComparison.InvariantCultureIgnoreCase)
select c);
}
/// <summary>
/// Selects all <see cref="ConfigurationTreeFolder"/> objects with ids in the specified list.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="ids">The ids.</param>
/// <returns></returns>
public static IQueryable <ConfigurationTreeFolder> Select(EnterpriseTestEntities entities, IEnumerable <Guid> ids)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return(from n in entities.ConfigurationTreeFolders
where ids.Contains(n.ConfigurationTreeFolderId)
select n);
}
public static ResourceWindowsCategory SelectById(EnterpriseTestEntities entities, int id)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return((from c in entities.ResourceWindowsCategories
where c.CategoryId == id
select c).FirstOrDefault());
}
public static bool InScenarioEditors(EnterpriseTestEntities entities, string userName)
{
return
((
from g in entities.UserGroups
where g.GroupName.Equals("Scenario Editors")
select g into editors
from e in editors.Users
where e.UserName.Equals(userName)
select e
).Any());
}
/// <summary>
/// Selects the name of the given assembly.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="name">The name of the assembly</param>
/// <returns>AssemblyName string if found, empty string otherwise.</returns>
/// <exception cref="System.ArgumentNullException">entities</exception>
/// <exception cref="System.InvalidOperationException">If more than one assembly matches name.</exception>
public static string SelectAssemblyName(EnterpriseTestEntities entities, string name)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return
((from n in entities.MetadataTypes
where n.Name == name
select n.AssemblyName).SingleOrDefault() ?? string.Empty);
}
/// <summary>
/// Selects all <see cref="EnterpriseScenario"/> objects with ids in the specified list.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="ids">The ids.</param>
/// <returns></returns>
public static IQueryable <EnterpriseScenario> Select(EnterpriseTestEntities entities, IEnumerable <Guid> ids)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return(from n in entities.EnterpriseScenarios
where ids.Contains(n.EnterpriseScenarioId)
orderby n.Name ascending
select n);
}
/// <summary>
/// Selects a collection of <see cref="VirtualResourceMetadata"/> by its VirtualResourceType
/// </summary>
/// <param name="entities">The data context</param>
/// <param name="resourceType">The VirtualResourceType.</param>
/// <returns></returns>
public static IQueryable <VirtualResourceMetadata> Select(EnterpriseTestEntities entities, VirtualResourceType resourceType)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
string resourceTypeString = resourceType.ToString();
return(from n in entities.VirtualResourceMetadataSet
where n.ResourceType.Equals(resourceTypeString, StringComparison.OrdinalIgnoreCase)
select n);
}
/// <summary>
/// Selects an <see cref="EnterpriseScenario"/> by its id, including all children.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="id">The id.</param>
/// <returns></returns>
public static EnterpriseScenario SelectWithAllChildren(EnterpriseTestEntities entities, Guid id)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return((from n in entities.EnterpriseScenarios
.Include("VirtualResources.VirtualResourceMetadataSet")
.Include("UserGroups")
where n.EnterpriseScenarioId == id
select n).FirstOrDefault());
}
/// <summary>
/// Selects an <see cref="EnterpriseScenario"/> by Scenario name.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="scenarioName">Name of the scenario.</param>
/// <returns></returns>
/// <exception cref="System.ArgumentNullException">entities</exception>
public static EnterpriseScenario Select(EnterpriseTestEntities entities, string scenarioName)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return
((
from n in entities.EnterpriseScenarios.Include("VirtualResources.VirtualResourceMetadataSet")
where n.Name.Equals(scenarioName, StringComparison.OrdinalIgnoreCase)
select n
).FirstOrDefault());
}
/// <summary>
/// Selects a <see cref="VirtualResourceMetadata"/> by its id.
/// Loads all Asset, Document, Server and PrintQueue usages before returning.
/// </summary>
/// <param name="entities">The entities.</param>
/// <param name="id">The id.</param>
/// <returns></returns>
public static VirtualResourceMetadata SelectWithUsage(EnterpriseTestEntities entities, Guid id)
{
if (entities == null)
{
throw new ArgumentNullException("entities");
}
return((from n in entities.VirtualResourceMetadataSet
.Include("AssetUsage")
.Include("DocumentUsage")
.Include("PrintQueueUsage")
.Include("ServerUsage")
where n.VirtualResourceMetadataId == id
select n).FirstOrDefault());
}
