/// <summary>
/// Return a table of the intances of the specified application
/// </summary>
/// <param name="applicationID"></param>
/// <returns></returns>
public DataTable GetApplicationInstances(int applicationID)
{
if (isDebugEnabled)
{
logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " in");
}
DataTable applicationsTable = new DataTable(TableNames.APPLICATION_INSTANCES);
if (compactDatabaseType)
{
try
{
using (SqlCeCommand command = new SqlCeCommand("SELECT APPLICATION_INSTANCES._INSTANCEID ,APPLICATION_INSTANCES._APPLICATIONID ,APPLICATION_INSTANCES._ASSETID ,APPLICATION_INSTANCES._PRODUCTID ,APPLICATION_INSTANCES._CDKEY " +
",APPLICATIONS._NAME ,APPLICATIONS._VERSION ,APPLICATIONS._PUBLISHER ,APPLICATIONS._GUID ,APPLICATIONS._IGNORED ,APPLICATIONS._ALIASED_TOID ,APPLICATIONS._USER_DEFINED " +
",ASSETS._NAME AS ASSETNAME " +
",ASSET_TYPES._ICON AS ASSETICON " +
",LOCATIONS._FULLNAME AS FULLLOCATIONNAME " +
",LOCATIONS._NAME AS LOCATIONNAME " +
",DOMAINS._NAME AS DOMAINNAME " +
"FROM APPLICATION_INSTANCES " +
"LEFT JOIN APPLICATIONS ON (APPLICATION_INSTANCES._APPLICATIONID = APPLICATIONS._APPLICATIONID) " +
"LEFT JOIN ASSETS ON (APPLICATION_INSTANCES._ASSETID = ASSETS._ASSETID) " +
"LEFT JOIN ASSET_TYPES ON (ASSETS._ASSETTYPEID = ASSET_TYPES._ASSETTYPEID) " +
"LEFT JOIN LOCATIONS ON (ASSETS._LOCATIONID = LOCATIONS._LOCATIONID) " +
"LEFT JOIN DOMAINS ON (ASSETS._DOMAINID = DOMAINS._DOMAINID) " +
"WHERE APPLICATION_INSTANCES._APPLICATIONID = @applicationID " +
"AND ASSETS._STOCK_STATUS <> 3", DatabaseConnection.OpenCeConnection()))
{
command.Parameters.AddWithValue("@applicationID", applicationID);
new SqlCeDataAdapter(command).Fill(applicationsTable);
}
}
catch (SqlCeException ex)
{
Utility.DisplayErrorMessage("A database error has occurred in AuditWizard." + Environment.NewLine + Environment.NewLine +
"Please see the log file for further details.");
logger.Error("Exception in " + System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
}
catch (Exception ex)
{
Utility.DisplayErrorMessage("A database error has occurred in AuditWizard." + Environment.NewLine + Environment.NewLine +
"Please see the log file for further details.");
logger.Error("Exception in " + System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
}
}
else
{
AuditWizardDataAccess lAuditWizardDataAccess = new AuditWizardDataAccess();
applicationsTable = lAuditWizardDataAccess.GetApplicationInstances(applicationID);
}
if (isDebugEnabled)
{
logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " out");
}
return(applicationsTable);
}
/// <summary>
/// Load this Application with it's instances and licenses
/// </summary>
public void LoadData()
{
// Read instances of this application
AuditWizardDataAccess lwDataAccess = new AuditWizardDataAccess();
DataTable instancesTable = lwDataAccess.GetApplicationInstances(_applicationID);
LoadInstances(instancesTable);
// Read licenses for this application if any
DataTable licensesTable = lwDataAccess.GetApplicationLicenses(_applicationID);
LoadLicenses(licensesTable);
}
/// <summary>
/// Load this Application with it's instances and licenses
/// </summary>
public void LoadData()
{
// Read instances of this application
AuditWizardDataAccess lwDataAccess = new AuditWizardDataAccess();
DataTable instancesTable = lwDataAccess.GetApplicationInstances(_osid);
LoadInstances(instancesTable);
// Read licenses for this application if any
DataTable licensesTable = lwDataAccess.GetApplicationLicenses(_osid);
LoadLicenses(licensesTable);
// Flag that the data has already been loaded
_dataLoaded = true;
}