/// <summary>
/// Returns 0 if no patches were installed.
/// </summary>
/// <param name="major"></param>
/// <param name="minor"></param>
/// <param name="patch"></param>
/// <param name="installDate"></param>
/// <returns></returns>
public static int GetApplicationSystemVersion(out int major, out int minor, out int patch, out DateTime installDate)
{
int retval = 0;
major = 0;
minor = 0;
patch = 0;
installDate = DateTime.MinValue;
DataCommand command = CoreDataHelper.CreateDataCommand();
command.CommandText = "GetApplicationSchemaVersionNumber";
DataResult result = DataService.LoadDataSet(command);
if (result.DataSet != null)
{
if (result.DataSet.Tables.Count > 0 && result.DataSet.Tables[0].Rows.Count > 0)
{
DataRow row = result.DataSet.Tables[0].Rows[0];
major = (int)row["Major"];
minor = (int)row["Minor"];
patch = (int)row["Patch"];
installDate = (DateTime)row["InstallDate"];
}
}
return(retval);
}
void IndexApplication(string applicationName)
{
_Log.Info(String.Format("Starting to rotate encryption keys job for \"{0}\" application.", applicationName));
try
{
DataCommand cmd = CoreDataHelper.CreateDataCommand();
cmd.CommandText = String.Format("mdpsp_sys_RotateEncryptionKeys");
DataService.ExecuteNonExec(cmd);
_Log.Info("Successfully completed.");
}
catch (Exception ex)
{
_Log.Error("Rotating encryption keys failed.", ex);
}
}
