/// <summary>
/// Return a table containing all of the license which have been declared for the
/// specified application
/// </summary>
/// <param name="applicationID"></param>
/// <returns></returns>
public DataTable GetApplicationLicenses(int applicationID)
{
//if (isDebugEnabled) logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " in");
DataTable licensesTable = new DataTable(TableNames.LICENSES);
if (compactDatabaseType)
{
try
{
//using (SqlCeConnection conn = DatabaseConnection.CreateOpenCEConnection())
//{
string commandText =
"SELECT LICENSES._LICENSEID, LICENSES._LICENSETYPEID ,LICENSES._COUNT " +
",LICENSES._APPLICATIONID ,LICENSES._SUPPORTED, LICENSES._SUPPORT_EXPIRES ,LICENSES._SUPPORT_ALERTDAYS " +
",LICENSES._SUPPORT_ALERTBYEMAIL ,LICENSES._SUPPORT_ALERTRECIPIENTS " +
",LICENSES._SUPPLIERID " +
",LICENSE_TYPES._NAME AS LICENSE_TYPES_NAME ,LICENSE_TYPES._COUNTED " +
",APPLICATIONS._NAME AS APPLICATION_NAME " +
",SUPPLIERS._NAME AS SUPPLIER_NAME " +
"FROM LICENSES " +
"LEFT JOIN LICENSE_TYPES ON (LICENSES._LICENSETYPEID = LICENSE_TYPES._LICENSETYPEID) " +
"LEFT JOIN APPLICATIONS ON (LICENSES._APPLICATIONID = APPLICATIONS._APPLICATIONID) " +
"LEFT JOIN SUPPLIERS ON (LICENSES._SUPPLIERID = SUPPLIERS._SUPPLIERID) " +
"WHERE LICENSES._APPLICATIONID = @applicationID";
using (SqlCeCommand command = new SqlCeCommand(commandText, DatabaseConnection.OpenCeConnection()))
{
command.Parameters.AddWithValue("@applicationID", applicationID);
new SqlCeDataAdapter(command).Fill(licensesTable);
}
//}
}
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();
licensesTable = lAuditWizardDataAccess.GetApplicationLicenses(applicationID);
}
//if (isDebugEnabled) logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " out");
return(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(_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;
}