private int GetCurrentlyInstalledPackageVersion(string packageName) { var installedPackages = InstalledPackageService.GetInstalledPackages().OrderBy(p => p.PackageName).OrderByDescending(p => p.InstallDateTime); foreach (var installedPackage in installedPackages) { if (installedPackage.PackageName == packageName) { return(installedPackage.VersionId); } } return(-1); }
/// <summary> /// Operations to be performed during the upgrade process. /// </summary> public override void Up() { Sql( @"DELETE FROM [PluginMigration] WHERE [PluginAssemblyName] = 'org.sparkdevnetwork.PrayerRequestWorkflowAction'"); var installedPackages = InstalledPackageService.GetInstalledPackages(); if (installedPackages != null && installedPackages.Any(a => a.PackageId == 131)) { installedPackages.RemoveAll(a => a.PackageId == 131); var packageFile = HostingEnvironment.MapPath("~/App_Data/InstalledStorePackages.json"); var packagesAsJson = installedPackages.ToJson(); System.IO.File.WriteAllText(packageFile, packagesAsJson); } }
/// <summary> /// SK: Add Campaign Connection /// </summary> private void AddCampaignConnection() { RockMigrationHelper.AddPage(true, "9CC19684-7AD2-4D4E-A7C4-10DAE56E7FA6", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Connection Campaigns", "", "B252FAA6-0E9D-41CD-A00D-E7159E881714", ""); // Site:Rock RMS RockMigrationHelper.AddPage(true, "B252FAA6-0E9D-41CD-A00D-E7159E881714", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Campaign Configuration", "", "A22133B5-B5C6-455A-A300-690F7926356D", ""); // Site:Rock RMS RockMigrationHelper.AddPageRoute("B252FAA6-0E9D-41CD-A00D-E7159E881714", "CampaignConfiguration", "57CEB84D-5EC7-4AE2-AA4C-CFE045F78456"); // for Page:Connection Campaigns RockMigrationHelper.UpdateBlockType("Add Campaign Requests", "Adds Campaign Connection Requests", "~/Blocks/Connection/AddCampaignRequests.ascx", "Connection Campaign", "11630BB9-E685-4582-91F8-620448AA34B0"); RockMigrationHelper.UpdateBlockType("Campaign Configuration", "Block used for Campaign Connection configuration which is also used by job.", "~/Blocks/Connection/CampaignConfiguration.ascx", "Connection Campaign", "9E6C4174-5F2B-4A78-9781-55D7DD209B6C"); RockMigrationHelper.UpdateBlockType("Campaign List", "Block for viewing list of campaign connection configurations.", "~/Blocks/Connection/CampaignList.ascx", "Connection Campaign", "6BA9D764-E30F-48D1-AB20-8991371B6316"); // Add Block to Page: Connections Site: Rock RMS RockMigrationHelper.AddBlock(true, "530860ED-BC73-4A43-8E7C-69533EF2B6AD".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "11630BB9-E685-4582-91F8-620448AA34B0".AsGuid(), "Add Campaign Requests", "Main", @"", @"", 0, "BF39BE49-B4F6-4A5B-BDA2-EB343FC80CCA"); // Add Block to Page: Connection Campaigns Site: Rock RMS RockMigrationHelper.AddBlock(true, "B252FAA6-0E9D-41CD-A00D-E7159E881714".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "6BA9D764-E30F-48D1-AB20-8991371B6316".AsGuid(), "Campaign List", "Main", @"", @"", 0, "3A62AD36-5031-4C62-BCC1-7800AE43F78B"); // Add Block to Page: Campaign Configuration Site: Rock RMS RockMigrationHelper.AddBlock(true, "A22133B5-B5C6-455A-A300-690F7926356D".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "9E6C4174-5F2B-4A78-9781-55D7DD209B6C".AsGuid(), "Campaign Configuration", "Main", @"", @"", 0, "5DC2943E-EFBD-4F25-B1D7-738CB86AB628"); // update block order for pages with new blocks if the page,zone has multiple blocks Sql(@"UPDATE [Block] SET [Order] = 0 WHERE [Guid] = 'BF39BE49-B4F6-4A5B-BDA2-EB343FC80CCA'"); // Page: Connections, Zone: Main, Block: Add Campaign Requests Sql(@"UPDATE [Block] SET [Order] = 1 WHERE [Guid] = '80710A2C-9B90-40AE-B887-B885AAA43538'"); // Page: Connections, Zone: Main, Block: My Connection Opportunities // Attrib for BlockType: Campaign List:Detail Page RockMigrationHelper.UpdateBlockTypeAttribute("6BA9D764-E30F-48D1-AB20-8991371B6316", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Detail Page", "DetailPage", "", @"", 0, @"", "0932CBC5-11E8-40AC-8707-F0472D1BCD31"); // Attrib Value for Block:Campaign List, Attribute:Detail Page Page: Connection Campaigns, Site: Rock RMS RockMigrationHelper.AddBlockAttributeValue("3A62AD36-5031-4C62-BCC1-7800AE43F78B", "0932CBC5-11E8-40AC-8707-F0472D1BCD31", @"a22133b5-b5c6-455a-a300-690f7926356d"); // Attrib Value for Block:Campaign List, Attribute:core.CustomGridEnableStickyHeaders Page: Connection Campaigns, Site: Rock RMS RockMigrationHelper.AddBlockAttributeValue("3A62AD36-5031-4C62-BCC1-7800AE43F78B", "393DAC13-0626-47B1-ADB7-C7D3B481EFB1", @"False"); // Add Campaign Manager Job Sql(@" IF NOT EXISTS ( SELECT [Id] FROM [ServiceJob] WHERE [Guid] = '27D1BE06-1BC0-468D-8DE9-748BAFFF2F1A') BEGIN INSERT INTO [dbo].[ServiceJob] ( [IsSystem] ,[IsActive] ,[Name] ,[Description] ,[Class] ,[CronExpression] ,[NotificationStatus] ,[Guid] ) VALUES ( 0 ,1 ,'Campaign Manager' ,'Handles processing all configured campaigns, creating new connection requests and assigning them to connectors as needed.' ,'Rock.Jobs.CampaignManager' ,'0 0 7 1/1 * ? *' ,1 ,'27D1BE06-1BC0-468D-8DE9-748BAFFF2F1A' ) END"); Sql(@"DELETE FROM [PluginMigration] WHERE [PluginAssemblyName] = 'org.sparkdevnetwork.ConnectionCampaign'"); var installedPackages = InstalledPackageService.GetInstalledPackages(); if (installedPackages != null && installedPackages.Any(a => a.PackageId == 129)) { installedPackages.RemoveAll(a => a.PackageId == 129); string packageFile = HostingEnvironment.MapPath("~/App_Data/InstalledStorePackages.json"); string packagesAsJson = installedPackages.ToJson(); System.IO.File.WriteAllText(packageFile, packagesAsJson); } }
/// <summary> /// Sends to spark. /// </summary> /// <returns></returns> public static List <Notification> SendToSpark(RockContext rockContext) { var notifications = new List <Notification>(); var installedPackages = InstalledPackageService.GetInstalledPackages(); var sparkLinkRequest = new SparkLinkRequestV2(); sparkLinkRequest.RockInstanceId = Rock.Web.SystemSettings.GetRockInstanceId(); sparkLinkRequest.VersionIds = installedPackages.Select(i => i.VersionId).ToList(); sparkLinkRequest.RockVersion = VersionInfo.VersionInfo.GetRockSemanticVersionNumber(); var globalAttributes = GlobalAttributesCache.Get(); sparkLinkRequest.OrganizationName = globalAttributes.GetValue("OrganizationName"); sparkLinkRequest.PublicUrl = globalAttributes.GetValue("PublicApplicationRoot"); sparkLinkRequest.NumberOfActiveRecords = new PersonService(rockContext).Queryable(includeDeceased: false, includeBusinesses: false).Count(); // Fetch the organization address var organizationAddressLocationGuid = globalAttributes.GetValue("OrganizationAddress").AsGuid(); if (!organizationAddressLocationGuid.Equals(Guid.Empty)) { var location = new LocationService(rockContext).Get(organizationAddressLocationGuid); if (location != null) { sparkLinkRequest.OrganizationLocation = new SparkLinkLocation(location); } } var sparkLinkRequestJson = JsonConvert.SerializeObject(sparkLinkRequest); var client = new RestClient("https://www.rockrms.com/api/SparkLink/update"); //var client = new RestClient( "http://localhost:57822/api/SparkLink/update" ); var request = new RestRequest(Method.POST); request.AddParameter("application/json", sparkLinkRequestJson, ParameterType.RequestBody); IRestResponse response = client.Execute(request); if (response.StatusCode == HttpStatusCode.OK || response.StatusCode == HttpStatusCode.Accepted) { foreach (var notification in JsonConvert.DeserializeObject <List <Notification> >(response.Content)) { notifications.Add(notification); } } if (sparkLinkRequest.VersionIds.Any()) { client = new RestClient("https://www.rockrms.com/api/Packages/VersionNotifications"); //client = new RestClient( "http://localhost:57822/api/Packages/VersionNotifications" ); request = new RestRequest(Method.GET); request.AddParameter("VersionIds", sparkLinkRequest.VersionIds.AsDelimited(",")); response = client.Execute(request); if (response.StatusCode == HttpStatusCode.OK || response.StatusCode == HttpStatusCode.Accepted) { foreach (var notification in JsonConvert.DeserializeObject <List <Notification> >(response.Content)) { notifications.Add(notification); } } } return(notifications); }
/// <summary> /// Executes the specified context. /// </summary> /// <param name="context">The context.</param> public virtual void Execute(IJobExecutionContext context) { JobDataMap dataMap = context.JobDetail.JobDataMap; var groupGuid = dataMap.Get("NotificationGroup").ToString().AsGuid(); var rockContext = new RockContext(); var group = new GroupService(rockContext).Get(groupGuid); if (group != null) { var installedPackages = InstalledPackageService.GetInstalledPackages(); var sparkLinkRequest = new SparkLinkRequest(); sparkLinkRequest.RockInstanceId = Rock.Web.SystemSettings.GetRockInstanceId(); sparkLinkRequest.OrganizationName = GlobalAttributesCache.Value("OrganizationName"); sparkLinkRequest.VersionIds = installedPackages.Select(i => i.VersionId).ToList(); sparkLinkRequest.RockVersion = VersionInfo.VersionInfo.GetRockSemanticVersionNumber(); var notifications = new List <Notification>(); var sparkLinkRequestJson = JsonConvert.SerializeObject(sparkLinkRequest); var client = new RestClient("https://www.rockrms.com/api/SparkLink/update"); //var client = new RestClient( "http://localhost:57822/api/SparkLink/update" ); var request = new RestRequest(Method.POST); request.AddParameter("application/json", sparkLinkRequestJson, ParameterType.RequestBody); IRestResponse response = client.Execute(request); if (response.StatusCode == HttpStatusCode.OK || response.StatusCode == HttpStatusCode.Accepted) { foreach (var notification in JsonConvert.DeserializeObject <List <Notification> >(response.Content)) { notifications.Add(notification); } } if (sparkLinkRequest.VersionIds.Any()) { client = new RestClient("https://www.rockrms.com/api/Packages/VersionNotifications"); //client = new RestClient( "http://localhost:57822/api/Packages/VersionNotifications" ); request = new RestRequest(Method.GET); request.AddParameter("VersionIds", sparkLinkRequest.VersionIds.AsDelimited(",")); response = client.Execute(request); if (response.StatusCode == HttpStatusCode.OK || response.StatusCode == HttpStatusCode.Accepted) { foreach (var notification in JsonConvert.DeserializeObject <List <Notification> >(response.Content)) { notifications.Add(notification); } } } if (notifications.Count == 0) { return; } var notificationService = new NotificationService(rockContext); foreach (var notification in notifications.ToList()) { if (notificationService.Get(notification.Guid) == null) { notificationService.Add(notification); } else { notifications.Remove(notification); } } rockContext.SaveChanges(); var notificationRecipientService = new NotificationRecipientService(rockContext); foreach (var notification in notifications) { foreach (var member in group.Members) { if (member.Person.PrimaryAliasId.HasValue) { var recipientNotification = new Rock.Model.NotificationRecipient(); recipientNotification.NotificationId = notification.Id; recipientNotification.PersonAliasId = member.Person.PrimaryAliasId.Value; notificationRecipientService.Add(recipientNotification); } } } rockContext.SaveChanges(); } }