/// <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); } }