private void remove_Button_Click(object sender, EventArgs e)
{
var row = GetFirstSelectedRow();
if (row != null)
{
DomainAccountReservation domainAccountReservation = row.DataBoundItem as DomainAccountReservation;
DialogResult dialogResult = MessageBox.Show($"Removing Domain Account Reservation with session id'{domainAccountReservation.SessionId.Trim()}'. Do you want to continue?", "Delete Domain Account Reservation", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
SessionSummary status = null;
if (dialogResult == DialogResult.Yes)
{
using (DataLogContext logContext = DbConnect.DataLogContext())
{
status = logContext.DbSessions.FirstOrDefault(n => n.SessionId == domainAccountReservation.SessionId && n.Status == "Running");
}
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
if (status == null)
{
DomainAccountReservation asset = context.DomainAccountReservations.FirstOrDefault(n => n.SessionId == domainAccountReservation.SessionId);
context.DomainAccountReservations.Remove(asset);
context.SaveChanges();
}
else
{
MessageBox.Show($"Domain Account Reservation cannot be removed for the session id '{domainAccountReservation.SessionId.Trim()}' as the session is still running", "Session is currently running", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
RefreshItems();
}
}
}
private static List <MobileDevice> GetMobileDevices()
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
return(context.Assets.Include(n => n.Reservations).OfType <MobileDevice>().ToList());
}
}
private static void UpdateInventory()
{
int count = 0;
TraceFactory.Logger.Debug("Synchronizing VM inventory with vSphere server.");
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
using (var vSphereController = GetVSphereController())
{
foreach (VSphereVirtualMachine serverVM in vSphereController.GetVirtualMachines())
{
FrameworkClient inventoryVM = Select(context, serverVM.HostName);
if (inventoryVM != null)
{
VMUsageState currentState = EnumUtil.GetByDescription <VMUsageState>(inventoryVM.UsageState);
if (currentState != VMUsageState.Unavailable &&
currentState != VMUsageState.DoNotSchedule &&
string.IsNullOrEmpty(inventoryVM.SessionId))
{
inventoryVM.PowerState = EnumUtil.GetDescription(GetPowerState(serverVM));
inventoryVM.UsageState = EnumUtil.GetDescription(GetUsageState(serverVM));
inventoryVM.LastUpdated = DateTime.Now;
}
count++;
}
}
}
context.SaveChanges();
}
TraceFactory.Logger.Debug("Syncronization complete. VM Count: {0}".FormatWith(count));
}
/// <summary>
/// Gets a collection of printer products for the specified family from Asset Inventory.
/// </summary>
/// <param name="printerFamily">The printer family.</param>
/// <returns>A collection of printer products.</returns>
public IEnumerable <string> GetPrinterProducts(string printerFamily)
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
return(context.PrinterProducts.Where(n => n.Family == printerFamily).Select(n => n.Name).Distinct().ToList());
}
}
protected override void StartService(CommandLineArguments args)
{
if (args == null)
{
throw new ArgumentNullException("args");
}
FrameworkServiceHelper.LoadSettings(args, autoRefresh: true);
using (EnterpriseTestContext dataContext = new EnterpriseTestContext())
{
GlobalSettings.IsDistributedSystem = dataContext.VirtualResources.Any(r => r.ResourceType == "OfficeWorker");
}
string dispatcherHostName = "localhost";
if (GlobalSettings.IsDistributedSystem)
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
var dispatcher = context.FrameworkServers.FirstOrDefault(x => x.Active && x.ServerTypes.Any(n => n.Name == "BTF"));
if (dispatcher == null)
{
TraceFactory.Logger.Error("Could not find any dispatchers reserved for BTF Execution.");
return;
}
}
}
SessionClient.Instance.Initialize(dispatcherHostName);
SessionClient.Instance.SessionStartupTransitionReceived += Instance_SessionStartupTransitionReceived;
SessionClient.Instance.SessionStateReceived += Instance_SessionStateReceived;
_server = WebApp.Start <Startup>(url: _baseAddress);
_executionTimer.Start();
}
/// <summary>
/// Adds Asset info to the specified <see cref="SystemManifest"/>.
/// </summary>
/// <param name="manifest">The <see cref="SystemManifest"/>.</param>
public void AssignManifestInfo(SystemManifest manifest)
{
manifest.AllAssets.Clear();
manifest.ActivityAssets.Clear();
List <AssetInfo> assetInfoList = new List <AssetInfo>();
var assetIds = _activityAssets.Values.SelectMany(n => n).Distinct().ToList();
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
assetInfoList.AddRange(context.Assets.Where(n => assetIds.Contains(n.AssetId)).ToAssetInfoCollection());
assetInfoList.AddRange(context.BadgeBoxes.Where(n => assetIds.Contains(n.PrinterId)).ToBadgeBoxInfoCollection());
}
foreach (AssetInfo asset in assetInfoList)
{
manifest.AllAssets.Add(asset);
TraceFactory.Logger.Debug("asset: " + asset.AssetId + " Desc: " + asset.Description);
}
foreach (var activityAsset in _activityAssets)
{
manifest.ActivityAssets.Add(activityAsset.Key, activityAsset.Value);
}
}
/// <summary>
/// Initializes a new instance of the <see cref="VirtualMachinePlatformConfigForm"/> class.
/// </summary>
public VirtualMachinePlatformConfigForm()
{
InitializeComponent();
UserInterfaceStyler.Configure(this, FormStyle.SizeableDialog);
_assetInventoryContext = DbConnect.AssetInventoryContext();
_enterpriseTestContext = DbConnect.EnterpriseTestContext();
}
public void LoadPrinters(AssetContractCollection <PrinterContract> printers)
{
_printers = printers;
bool changesMade = false;
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
foreach (var printer in _printers)
{
if (!context.Assets.Any(x => x.Pool.Name.Equals(printer.PoolName)))
{
if (context.AssetPools.Count() > 0)
{
printer.PoolName = context.AssetPools.First().Name;
if (!context.Assets.Any(x => x.AssetId.Equals(printer.AssetId)))
{
context.Assets.Add(ContractFactory.Create(printer, context));
changesMade = true;
}
}
}
}
if (changesMade)
{
context.SaveChanges();
}
}
resolveDataGridView.DataSource = _printers;
CheckItemsResolved();
}
/// <summary>
/// Selects a summary of sessions and their Virtual Machine usage
/// </summary>
/// <returns></returns>
public static dynamic SelectVirtualMachineSessionUsageSummary()
{
List <FrameworkClient> virtualMachines = null;
List <SessionInfo> sessionSummarySet = null;
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
virtualMachines = context.FrameworkClients.ToList();
}
//Get the list of sessions that are currently consuming VMs
IEnumerable <string> sessionIds = virtualMachines.Select(s => s.SessionId).Distinct();
using (DataLogContext context = DbConnect.DataLogContext())
{
sessionSummarySet = context.Sessions.Where(s => sessionIds.Contains(s.SessionId)).ToList();
}
var now = DateTime.Now;
var workingSet =
(
from v in virtualMachines
from s in sessionSummarySet.Where(s => s.SessionId == v.SessionId)
orderby v.SortOrder
select new
{
SessionId = s.SessionId,
ScenarioName = s.SessionName,
Owner = s.Owner,
Status = s.Status,
Dispatcher = s.Dispatcher,
StartDate = s.StartDateTime?.LocalDateTime,
EndDate = s.ProjectedEndDateTime?.LocalDateTime,
TimeRunning = (s.StartDateTime == null ? "Unknown" : "{0:%d} Days {0:%h} Hours".FormatWith(now - s.StartDateTime)),
XP = (v.FrameworkClientHostName != null && v.FrameworkClientHostName.StartsWith("X", StringComparison.OrdinalIgnoreCase)) ? 1 : 0,
W7 = (v.FrameworkClientHostName != null && v.FrameworkClientHostName.StartsWith("W7", StringComparison.OrdinalIgnoreCase)) ? 1 : 0,
W8 = (v.FrameworkClientHostName != null && v.FrameworkClientHostName.StartsWith("W8", StringComparison.OrdinalIgnoreCase)) ? 1 : 0,
}
).ToList();
// summarize the results by grouping and counting
dynamic result = (from f in workingSet
group f by f.SessionId into s
select new
{
SessionId = s.Key,
ScenarioName = s.First().ScenarioName,
Owner = s.First().Owner,
Status = s.First().Status,
Dispatcher = s.First().Dispatcher,
StartDate = s.First().StartDate,
EndDate = s.First().EndDate,
TimeRunning = s.First().TimeRunning,
XPCount = s.Sum(x => x.XP),
WSevCount = s.Sum(x => x.W7),
W8Count = s.Sum(x => x.W8),
}).ToList();
return(result);
}
/// <summary>
/// Initializes this form instance.
/// </summary>
private void Initialize()
{
InitializeComponent();
UserInterfaceStyler.Configure(this, FormStyle.FixedDialog);
ShowIcon = true;
_context = DbConnect.AssetInventoryContext();
// Set up Validation
fieldValidator.RequireValue(assetId_TextBox, assetId_Label);
fieldValidator.RequireSelection(manufacturer_ComboBox, manufacturer_Label);
fieldValidator.RequireSelection(modelName_ComboBox, modelName_Label);
fieldValidator.RequireCustom(address1_Control, () => ValidateIPAddress(address1_Control.Text), "A valid IP Address is required.");
fieldValidator.RequireCustom(printerCapabilites_Label, () => _capabilityControls.Any(n => n.Checked), "At least one capability must be selected.");
fieldValidator.RequireValue(adminPassword_TextBox, adminPassword_Label);
fieldValidator.SetIconAlignment(assetId_TextBox, ErrorIconAlignment.MiddleRight);
fieldValidator.SetIconAlignment(manufacturer_ComboBox, ErrorIconAlignment.MiddleRight);
fieldValidator.SetIconAlignment(modelName_ComboBox, ErrorIconAlignment.MiddleRight);
fieldValidator.SetIconAlignment(address1_Control, ErrorIconAlignment.MiddleRight);
fieldValidator.SetIconAlignment(printerCapabilites_Label, ErrorIconAlignment.MiddleRight);
fieldValidator.SetIconAlignment(adminPassword_TextBox, ErrorIconAlignment.MiddleRight);
_capabilityControls = new List <CheckBox>()
{
print_CheckBox, scan_CheckBox, controlPanel_CheckBox
};
}
private void ResolveDataGridView_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
var printer = resolveDataGridView.Rows[e.RowIndex].DataBoundItem as PrinterContract;
if (printer != null)
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
var entity = context.Assets.FirstOrDefault(x => x.AssetId.Equals(printer.AssetId));
if (entity == null)
{
context.Assets.Add(ContractFactory.Create(printer, context));
}
else
{
entity.Pool = context.AssetPools.FirstOrDefault(n => n.Name == printer.PoolName);
}
context.SaveChanges();
}
}
CheckItemsResolved();
resolveDataGridView.Invalidate();
}
private void BindSettingsToGrid()
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
BindSettingsToGrid(context);
}
}
private void remove_ToolStripButton_Click(object sender, EventArgs e)
{
GridViewRowInfo row = GetFirstSelectedRow();
if (row != null)
{
ServerSetting setting = row.DataBoundItem as ServerSetting;
DialogResult dialogResult = MessageBox.Show
(
$"Removing setting '{setting.Name}'. Do you want to continue?",
"Delete Setting",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question
);
if (dialogResult == DialogResult.Yes)
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
FrameworkServer server = context.FrameworkServers.First(n => n.FrameworkServerId == setting.FrameworkServerId);
server.ServerSettings.Remove(server.ServerSettings.First(n => n.Name == setting.Name));
context.SaveChanges();
BindSettingsToGrid(context);
}
}
}
}
private void ConfigureGrid(string type)
{
assignPlatformGridView.DataSource = null;
List <string> allowedPlatforms = new List <string>();
using (var context = DbConnect.EnterpriseTestContext())
{
allowedPlatforms.AddRange(context.ResourceTypes.Find(type).FrameworkClientPlatforms.Select(n => n.FrameworkClientPlatformId));
}
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
platformColumn.Items.Clear();
var allPlatforms = context.FrameworkClientPlatforms.AsEnumerable();
foreach (var platform in allPlatforms.Where(n => allowedPlatforms.Contains(n.FrameworkClientPlatformId, StringComparer.OrdinalIgnoreCase)))
{
platformColumn.Items.Add(platform);
}
}
SortableBindingList <Item> items = new SortableBindingList <Item>();
foreach (var item in _resources.Where(x => x.ResourceType.Equals(type)))
{
items.Add(new Item(item));
}
assignPlatformGridView.DataSource = items;
}
/// <summary>
/// Reloads all the MonitorConfig items for each monitor running on the current service host.
/// </summary>
public void RefreshConfig()
{
TraceFactory.Logger.Debug("Request received to refresh config.");
List <MonitorConfig> currentConfiguration = null;
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
currentConfiguration = context.MonitorConfigs.Where(n => n.ServerHostName == Environment.MachineName).ToList();
}
lock (_monitors)
{
RemoveStaleMonitors(new HashSet <Guid>(currentConfiguration.Select(c => c.MonitorConfigId)));
}
foreach (MonitorConfig config in currentConfiguration)
{
StfMonitor monitor = _monitors.Where(m => m.MonitorId == config.MonitorConfigId).FirstOrDefault();
if (monitor != null)
{
// Found existing monitor
monitor.RefreshConfig(config);
}
else
{
//Monitor exists in the database config, but is not running on the current service host.
CreateMonitor(config);
}
}
TraceFactory.Logger.Debug("Config refreshed.");
}
private void remove_Button_Click(object sender, EventArgs e)
{
var row = GetFirstSelectedRow();
if (row != null)
{
Printer printer = row.DataBoundItem as Printer;
DialogResult dialogResult = MessageBox.Show
(
"Removing Printer {0}. Do you want to continue?".FormatWith(printer.AssetId),
"Delete Printer",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question
);
if (dialogResult == DialogResult.Yes)
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
Asset asset = context.Assets.FirstOrDefault(n => n.AssetId == printer.AssetId);
context.Assets.Remove(asset);
context.SaveChanges();
}
RefreshItems();
}
}
}
private static AssetIdCollection GetAssetIds(AssetSelectionData selectionData)
{
AssetIdCollection result = new AssetIdCollection();
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
foreach (string assetId in selectionData.SelectedAssets)
{
result.Add(assetId);
//Check to see if the asset has badge boxes
BadgeBox badgeBox = context.BadgeBoxes.FirstOrDefault(n => n.PrinterId == assetId);
if (badgeBox != null)
{
TraceFactory.Logger.Debug($"Asset: {assetId} has associated BadgeBox: {badgeBox.BadgeBoxId}");
result.Add(badgeBox.BadgeBoxId);
}
//Check to see if the asset has cameras
Core.AssetInventory.Camera camera = context.Assets.OfType <Core.AssetInventory.Camera>().FirstOrDefault(c => c.PrinterId == assetId);
if (camera != null)
{
TraceFactory.Logger.Debug($"Asset: {assetId} has associated Camera: {camera.AssetId}");
result.Add(camera.AssetId);
}
}
}
return(result);
}
private static List <Camera> GetCameras()
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
return(context.Assets.Include(n => n.Reservations).OfType <Camera>().ToList());
}
}
protected override void LoadUserPools()
{
userPool_ComboBox.DisplayMember = "Description";
DomainAccountPool selectedPool = null;
List <DomainAccountPool> userPools = null;
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
userPools = context.DomainAccountPools.OrderBy(x => x.Description).ToList();
}
if (userPools.Count > 0)
{
bool testerHasUserPool = !string.IsNullOrEmpty(_tester.UserPool);
if (testerHasUserPool)
{
//If tester has a User Pool setting, select it if it's in the list
if (userPools.Any(x => x.DomainAccountKey.Equals(_tester.UserPool)))
{
selectedPool = userPools.First(x => x.DomainAccountKey.Equals(_tester.UserPool));
}
}
else
{
selectedPool = userPools.First();
}
}
userPool_ComboBox.DataSource = userPools;
userPool_ComboBox.SelectedItem = selectedPool;
}
/// <summary>
/// Populates the dropdown with Printer family and displays the it's Printer names.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void PrinterProductsForm_Load(object sender, EventArgs e)
{
productName_dataGridView.AutoGenerateColumns = false;
productFamily_ComboBox.Refresh();
List <string> familyItems;
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
familyItems = context.PrinterProducts.Select(n => n.Family).Distinct().ToList();
}
if (!familyItems.Any())
{
MessageBox.Show("There are no Product Categories available in the database.\nPlease add the Product Category and try again.", "Product Category Loading Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
foreach (var item in familyItems)
{
productFamily_ComboBox.Items.Add(item);
_products.Add(item, new SortableBindingList <StringValue>());
foreach (var productName in _context.PrinterProducts.Where(n => n.Family == item).Select(n => n.Name).Distinct())
{
_products[item].Add(new StringValue(productName));
}
}
if (productFamily_ComboBox.Items.Count > 0)
{
productFamily_ComboBox.SelectedIndex = 0;
}
}
/// <summary>
/// Retrieves a collection of output monitor destinations of the specified type.
/// </summary>
/// <param name="monitorType">The type of output monitor destinations to retrieve.</param>
/// <returns>A collection of output monitor destinations.</returns>
public IEnumerable <string> GetOutputMonitorDestinations(string monitorType)
{
STFMonitorType stfMonitorType = (STFMonitorType)Enum.Parse(typeof(STFMonitorType), monitorType);
Collection <string> result = new Collection <string>();
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
foreach (MonitorConfig monitorConfig in context.MonitorConfigs.Where(m => m.MonitorType == monitorType))
{
if (monitorConfig.Configuration.StartsWith("<OutputMonitorConfig"))
{
OutputMonitorConfig outputConfig = LegacySerializer.DeserializeXml <OutputMonitorConfig>(monitorConfig.Configuration);
if (stfMonitorType.Equals(STFMonitorType.OutputEmail) || stfMonitorType.Equals(STFMonitorType.DigitalSendNotification))
{
result.Add(outputConfig.MonitorLocation);
}
else
{
result.Add($@"\\{monitorConfig.ServerHostName}\{outputConfig.MonitorLocation}");
}
}
}
}
return(result);
}
private DomainAccountReservationSet GetReservedAccounts(bool mockReserve = false)
{
DomainAccountReservationSet result = new DomainAccountReservationSet(Ticket.SessionId);
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
if (mockReserve)
{
//Build a mock reservation
foreach (var poolType in Quantities.DomainAccountQuantity.Keys)
{
DomainAccountPool pool = DomainAccountService.SelectPool(context, poolType);
result.Add(poolType, pool, 0, Quantities.DomainAccountQuantity[poolType]);
}
}
else
{
foreach (DomainAccountReservation reservation in DomainAccountService.SelectReservationsBySession(context, Ticket.SessionId))
{
DomainAccountPool pool = DomainAccountService.SelectPool(context, reservation.DomainAccountKey);
result.Add(reservation.DomainAccountKey, pool, reservation.StartIndex, reservation.Count);
}
}
}
return(result);
}
/// <summary>
/// Initializes this form instance.
/// </summary>
private void Initialize()
{
InitializeComponent();
UserInterfaceStyler.Configure(this, FormStyle.FixedDialog);
ShowIcon = true;
_context = DbConnect.AssetInventoryContext();
// Set up Validation
fieldValidator.RequireValue(textBox_AssetId, label_AssetId);
fieldValidator.RequireValue(textBox_Product, label_Product);
fieldValidator.RequireValue(textBox_Address, label_Address);
fieldValidator.RequireValue(textBox_VmName, label_VmName);
fieldValidator.RequireCustom(label_Capabilites, () => _capabilityControls.Any(n => n.Checked), "At least one capability must be selected.");
fieldValidator.SetIconAlignment(textBox_AssetId, ErrorIconAlignment.MiddleLeft);
fieldValidator.SetIconAlignment(textBox_Product, ErrorIconAlignment.MiddleLeft);
fieldValidator.SetIconAlignment(textBox_Address, ErrorIconAlignment.MiddleLeft);
fieldValidator.SetIconAlignment(textBox_VmName, ErrorIconAlignment.MiddleLeft);
fieldValidator.SetIconAlignment(label_Capabilites, ErrorIconAlignment.MiddleLeft);
_capabilityControls = new List <CheckBox>()
{
checkBox_Scan, checkBox_ControlPanel, checkBox_Mobile
};
}
/// <summary>
/// Retrieves the simulators listed in table Assets and if available what their reservations are.
/// </summary>
private void GetMasterList()
{
_masterList = new SimReservedList();
using (AssetInventoryContext aie = DbConnect.AssetInventoryContext())
{
var matches = (from ds in aie.Assets.OfType <DeviceSimulator>()
join ar in aie.AssetReservations on ds.AssetId equals ar.AssetId into mgtGroup
from item in mgtGroup.DefaultIfEmpty()
select new
{
ds.AssetId,
ds.Product,
ds.Address,
ds.VirtualMachine,
SessionId = item.SessionId == null ? "" : item.SessionId,
ReservedFor = item.ReservedFor == null ? "" : item.ReservedFor
});
foreach (var m in matches)
{
SimReserved ent = new SimReserved();
ent.AssetId = m.AssetId;
ent.Product = m.Product;
ent.HostAddress = m.Address;
ent.VirtualMachine = m.VirtualMachine;
ent.SessionId = m.SessionId;
ent.ReservedFor = m.ReservedFor;
_masterList.Add(ent);
}
}
}
/// <summary>
/// Creates a new instance of the <see cref="ManifestServerAgent"/> class.
/// </summary>
/// <param name="scenarioId"></param>
public ManifestServerAgent(Guid scenarioId)
{
using (EnterpriseTestContext context = new EnterpriseTestContext())
{
// Retrieve server usage data for all enabled activities in the specified session
var activities = (from serverusage in context.VirtualResourceMetadataServerUsages
let data = serverusage.ServerSelectionData
let metadata = serverusage.VirtualResourceMetadata
let resource = metadata.VirtualResource
where resource.EnterpriseScenarioId == scenarioId &&
resource.Enabled == true &&
metadata.Enabled == true &&
data != null
select new { Id = metadata.VirtualResourceMetadataId, Servers = data }).ToList();
foreach (var activity in activities)
{
ServerSelectionData serverSelectionData = GetSelectionData(activity.Servers);
_activityServers.Add(activity.Id, GetServerIds(serverSelectionData));
}
}
var serverIds = _activityServers.Values.SelectMany(n => n).Distinct().ToList();
using (AssetInventoryContext assetContext = DbConnect.AssetInventoryContext())
{
_servers.AddRange(assetContext.FrameworkServers.Where(n => serverIds.Contains(n.FrameworkServerId)).ToServerInfoCollection());
}
}
/// <summary>
/// Helper to create the camera detail info.
/// </summary>
/// <param name="asset"></param>
/// <param name="camera"></param>
/// <returns></returns>
private static CameraDetail CreateCameraDetail(AssetReservationResult asset, Camera camera)
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
FrameworkServer server = context.FrameworkServers.Include(n => n.ServerSettings).FirstOrDefault(n => n.HostName == camera.CameraServer);
Dictionary <string, string> serverSettings = server?.ServerSettings.ToDictionary(n => n.Name, n => n.Value, StringComparer.OrdinalIgnoreCase);
if (serverSettings == null)
{
// If there are no ServerSettings for the specified camera server, return as much data as we have.
// Even if it's incomplete, we don't want to fail here, we want it to fail later in the process when
// the framework attempts to contact the camera server during the Validate stage. Log a warning.
TraceFactory.Logger.Warn($"Server settings for Camera Server '{camera.CameraServer}' not found in configuration.");
}
return(new CameraDetail(asset.AssetId, asset.AvailabilityStart, asset.AvailabilityEnd)
{
Address = serverSettings?["ServerAPIUrl"] ?? string.Empty,
CameraId = camera.AssetId,
PrinterId = camera.PrinterId,
CameraServer = camera.CameraServer,
ServerUser = serverSettings?["ServerAPIUserName"] ?? string.Empty,
ServerPassword = serverSettings?["ServerAPIPassword"] ?? string.Empty,
Availability = asset.Availability
});
}
}
/// <summary>
/// Handles the Load event of the VirtualMachinePlatformConfigForm control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
private void VirtualMachineGroupConfigForm_Load(object sender, EventArgs e)
{
groups_DataGridView.AutoGenerateColumns = false;
machines_DataGridView.AutoGenerateColumns = false;
Cursor = Cursors.WaitCursor;
platformFilter_ToolStripComboBox.Items.Add("All Platforms");
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
foreach (var item in context.FrameworkClientPlatforms.Where(x => x.Active == true))
{
platformFilter_ToolStripComboBox.Items.Add(item);
}
}
platformFilter_ToolStripComboBox.SelectedIndex = 0;
// Spin off a thread to load each piece of data, then have then sync up through a
// semaphore and come back together in the loadPlatformWorker_RunWorkerCompleted() call
// where a bit more initialization will occur
BackgroundWorker loadMachinesWorker = new BackgroundWorker();
loadMachinesWorker.DoWork += new DoWorkEventHandler(LoadMachines_DoWork);
loadMachinesWorker.RunWorkerAsync();
BackgroundWorker loadGroupsWorker = new BackgroundWorker();
loadGroupsWorker.DoWork += new DoWorkEventHandler(LoadGroups_DoWork);
loadGroupsWorker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(LoadGroups_RunWorkerCompleted);
loadGroupsWorker.RunWorkerAsync();
}
public static IEnumerable <AssetDetail> CreateAssetDetails(IEnumerable <AssetReservationResult> testAssets)
{
List <AssetDetail> assetDetails = new List <AssetDetail>();
List <string> assetIds = testAssets.Select(n => n.AssetId).ToList();
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
List <Asset> assets = context.Assets.Where(n => assetIds.Contains(n.AssetId)).ToList();
foreach (Asset asset in assets)
{
AssetReservationResult testAsset = testAssets.First(n => n.AssetId == asset.AssetId);
AssetDetail assetDetail = CreateAssetDetail(asset, testAsset);
assetDetail.Description = asset.ToAssetInfo().Description;
assetDetails.Add(assetDetail);
}
List <BadgeBox> badgeBoxes = context.BadgeBoxes.Where(n => assetIds.Contains(n.PrinterId)).ToList();
foreach (BadgeBox badgeBox in badgeBoxes)
{
assetDetails.Add(CreateBadgeBoxDetail(badgeBox));
}
}
return(assetDetails);
}
private void toolStripButton_Remove_Click(object sender, EventArgs e)
{
if (simulator_DataGridView.SelectedRows.Count == 1)
{
DeviceSimulator simulator = simulator_DataGridView.SelectedRows[0].DataBoundItem as DeviceSimulator;
var dialogResult = MessageBox.Show
(
$"Removing Device Simulator '{simulator.AssetId}'. Do you want to continue?",
"Delete Device Simulator",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question
);
if (dialogResult == DialogResult.Yes)
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
Asset asset = context.Assets.FirstOrDefault(n => n.AssetId == simulator.AssetId);
context.Assets.Remove(asset);
context.SaveChanges();
}
RefreshData();
}
}
}
/// <summary>
/// Releases the VM reservation.
/// </summary>
/// <param name="hostName">Name of the host.</param>
public static void ReleaseReservation(string hostName)
{
using (AssetInventoryContext context = DbConnect.AssetInventoryContext())
{
SetState(hostName, VMPowerState.PoweredOff, VMUsageState.Available, true, context);
context.SaveChanges();
}
}