{"action":"created","comment":{"url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/comments/42118196","id":42118196,"diff_hunk":"@@ -0,0 +1,107 @@\n+USE [MinistryPlatform]\n+GO\n+\n+DELETE FROM [dp_Communications] WHERE [Communication_ID] = 12953;\n+\n+SET IDENTITY_INSERT [dbo].[dp_Communications] ON\n+GO\n+\n+INSERT INTO [dp_Communications]\n+  (\n+     [Communication_ID]\n+    ,[Author_User_ID]\n+    ,[Subject]\n+    ,[Body]\n+    ,[Domain_ID]\n+    ,[Start_Date]\n+    ,[From_Contact]\n+    ,[Reply_to_Contact]\n+    ,[Template]\n+    ,[Active]\n+  )\n+VALUES\n+  (\n+     12953\n+    ,5\n+    ,'Trip Application Received'\n+    ,'Your Trip Application has been received.'\n+    ,1\n+    ,CAST('20150801 00:00:00.000' as DATETIME)\n+    ,7\n+    ,7\n+    ,1\n+    ,1\n+  );\n+\n+SET IDENTITY_INSERT [dbo].[dp_Communications] OFF\n+GO\n+\n+DELETE FROM [dp_Communications] WHERE [Communication_ID] = 12954;\n+\n+SET IDENTITY_INSERT [dbo].[dp_Communications] ON\n+GO\n+\n+INSERT INTO [dp_Communications]\n+  (\n+     [Communication_ID]\n+    ,[Author_User_ID]\n+    ,[Subject]\n+    ,[Body]\n+    ,[Domain_ID]\n+    ,[Start_Date]\n+    ,[From_Contact]\n+    ,[Reply_to_Contact]\n+    ,[Template]\n+    ,[Active]\n+  )\n+VALUES\n+  (\n+     12954\n+    ,5\n+    ,'Trip Application Error'\n+    ,'Trip Application Error.'\n+    ,1\n+    ,CAST('20150801 00:00:00.000' as DATETIME)","path":"CI/SQL/US2084-01-Email-Templates","position":64,"original_position":64,"commit_id":"dbc61339dff47ef45f0a8f9654de8f06dcbd5f96","original_commit_id":"dbc61339dff47ef45f0a8f9654de8f06dcbd5f96","user":{"login":"silbermm","id":42816,"avatar_url":"https://avatars.githubusercontent.com/u/42816?v=3","gravatar_id":"","url":"https://api.github.com/users/silbermm","html_url":"https://github.com/silbermm","followers_url":"https://api.github.com/users/silbermm/followers","following_url":"https://api.github.com/users/silbermm/following{/other_user}","gists_url":"https://api.github.com/users/silbermm/gists{/gist_id}","starred_url":"https://api.github.com/users/silbermm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/silbermm/subscriptions","organizations_url":"https://api.github.com/users/silbermm/orgs","repos_url":"https://api.github.com/users/silbermm/repos","events_url":"https://api.github.com/users/silbermm/events{/privacy}","received_events_url":"https://api.github.com/users/silbermm/received_events","type":"User","site_admin":false},"body":"Why hardcode a date here instead of using `getDate()` ?","created_at":"2015-10-15T12:37:46Z","updated_at":"2015-10-15T12:37:46Z","html_url":"https://github.com/crdschurch/crds-angular/pull/971#discussion_r42118196","pull_request_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/971","_links":{"self":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/comments/42118196"},"html":{"href":"https://github.com/crdschurch/crds-angular/pull/971#discussion_r42118196"},"pull_request":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/971"}}},"pull_request":{"url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/971","id":47577508,"html_url":"https://github.com/crdschurch/crds-angular/pull/971","diff_url":"https://github.com/crdschurch/crds-angular/pull/971.diff","patch_url":"https://github.com/crdschurch/crds-angular/pull/971.patch","issue_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/971","number":971,"state":"open","locked":false,"title":"Feature/us2084 email trip participant","user":{"login":"IngageMaddoxT","id":5261149,"avatar_url":"https://avatars.githubusercontent.com/u/5261149?v=3","gravatar_id":"","url":"https://api.github.com/users/IngageMaddoxT","html_url":"https://github.com/IngageMaddoxT","followers_url":"https://api.github.com/users/IngageMaddoxT/followers","following_url":"https://api.github.com/users/IngageMaddoxT/following{/other_user}","gists_url":"https://api.github.com/users/IngageMaddoxT/gists{/gist_id}","starred_url":"https://api.github.com/users/IngageMaddoxT/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/IngageMaddoxT/subscriptions","organizations_url":"https://api.github.com/users/IngageMaddoxT/orgs","repos_url":"https://api.github.com/users/IngageMaddoxT/repos","events_url":"https://api.github.com/users/IngageMaddoxT/events{/privacy}","received_events_url":"https://api.github.com/users/IngageMaddoxT/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-10-13T19:31:04Z","updated_at":"2015-10-15T12:37:46Z","closed_at":null,"merged_at":null,"merge_commit_sha":"02f63979cd573142198549819fc4caff5c0202cd","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/971/commits","review_comments_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/971/comments","review_comment_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/comments{/number}","comments_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/971/comments","statuses_url":"https://api.github.com/repos/crdschurch/crds-angular/statuses/dbc61339dff47ef45f0a8f9654de8f06dcbd5f96","head":{"label":"crdschurch:feature/US2084-email-trip-participant","ref":"feature/US2084-email-trip-participant","sha":"dbc61339dff47ef45f0a8f9654de8f06dcbd5f96","user":{"login":"crdschurch","id":1843144,"avatar_url":"https://avatars.githubusercontent.com/u/1843144?v=3","gravatar_id":"","url":"https://api.github.com/users/crdschurch","html_url":"https://github.com/crdschurch","followers_url":"https://api.github.com/users/crdschurch/followers","following_url":"https://api.github.com/users/crdschurch/following{/other_user}","gists_url":"https://api.github.com/users/crdschurch/gists{/gist_id}","starred_url":"https://api.github.com/users/crdschurch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crdschurch/subscriptions","organizations_url":"https://api.github.com/users/crdschurch/orgs","repos_url":"https://api.github.com/users/crdschurch/repos","events_url":"https://api.github.com/users/crdschurch/events{/privacy}","received_events_url":"https://api.github.com/users/crdschurch/received_events","type":"Organization","site_admin":false},"repo":{"id":26870034,"name":"crds-angular","full_name":"crdschurch/crds-angular","owner":{"login":"crdschurch","id":1843144,"avatar_url":"https://avatars.githubusercontent.com/u/1843144?v=3","gravatar_id":"","url":"https://api.github.com/users/crdschurch","html_url":"https://github.com/crdschurch","followers_url":"https://api.github.com/users/crdschurch/followers","following_url":"https://api.github.com/users/crdschurch/following{/other_user}","gists_url":"https://api.github.com/users/crdschurch/gists{/gist_id}","starred_url":"https://api.github.com/users/crdschurch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crdschurch/subscriptions","organizations_url":"https://api.github.com/users/crdschurch/orgs","repos_url":"https://api.github.com/users/crdschurch/repos","events_url":"https://api.github.com/users/crdschurch/events{/privacy}","received_events_url":"https://api.github.com/users/crdschurch/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/crdschurch/crds-angular","description":"Starting point for angular development at crossroads","fork":false,"url":"https://api.github.com/repos/crdschurch/crds-angular","forks_url":"https://api.github.com/repos/crdschurch/crds-angular/forks","keys_url":"https://api.github.com/repos/crdschurch/crds-angular/keys{/key_id}","collaborators_url":"https://api.github.com/repos/crdschurch/crds-angular/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/crdschurch/crds-angular/teams","hooks_url":"https://api.github.com/repos/crdschurch/crds-angular/hooks","issue_events_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/events{/number}","events_url":"https://api.github.com/repos/crdschurch/crds-angular/events","assignees_url":"https://api.github.com/repos/crdschurch/crds-angular/assignees{/user}","branches_url":"https://api.github.com/repos/crdschurch/crds-angular/branches{/branch}","tags_url":"https://api.github.com/repos/crdschurch/crds-angular/tags","blobs_url":"https://api.github.com/repos/crdschurch/crds-angular/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/crdschurch/crds-angular/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/crdschurch/crds-angular/git/refs{/sha}","trees_url":"https://api.github.com/repos/crdschurch/crds-angular/git/trees{/sha}","statuses_url":"https://api.github.com/repos/crdschurch/crds-angular/statuses/{sha}","languages_url":"https://api.github.com/repos/crdschurch/crds-angular/languages","stargazers_url":"https://api.github.com/repos/crdschurch/crds-angular/stargazers","contributors_url":"https://api.github.com/repos/crdschurch/crds-angular/contributors","subscribers_url":"https://api.github.com/repos/crdschurch/crds-angular/subscribers","subscription_url":"https://api.github.com/repos/crdschurch/crds-angular/subscription","commits_url":"https://api.github.com/repos/crdschurch/crds-angular/commits{/sha}","git_commits_url":"https://api.github.com/repos/crdschurch/crds-angular/git/commits{/sha}","comments_url":"https://api.github.com/repos/crdschurch/crds-angular/comments{/number}","issue_comment_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/comments{/number}","contents_url":"https://api.github.com/repos/crdschurch/crds-angular/contents/{+path}","compare_url":"https://api.github.com/repos/crdschurch/crds-angular/compare/{base}...{head}","merges_url":"https://api.github.com/repos/crdschurch/crds-angular/merges","archive_url":"https://api.github.com/repos/crdschurch/crds-angular/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/crdschurch/crds-angular/downloads","issues_url":"https://api.github.com/repos/crdschurch/crds-angular/issues{/number}","pulls_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls{/number}","milestones_url":"https://api.github.com/repos/crdschurch/crds-angular/milestones{/number}","notifications_url":"https://api.github.com/repos/crdschurch/crds-angular/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/crdschurch/crds-angular/labels{/name}","releases_url":"https://api.github.com/repos/crdschurch/crds-angular/releases{/id}","created_at":"2014-11-19T16:21:09Z","updated_at":"2015-05-08T20:23:10Z","pushed_at":"2015-10-15T12:31:04Z","git_url":"git://github.com/crdschurch/crds-angular.git","ssh_url":"git@github.com:crdschurch/crds-angular.git","clone_url":"https://github.com/crdschurch/crds-angular.git","svn_url":"https://github.com/crdschurch/crds-angular","homepage":null,"size":30012,"stargazers_count":1,"watchers_count":1,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":5,"forks":1,"open_issues":5,"watchers":1,"default_branch":"development"}},"base":{"label":"crdschurch:development","ref":"development","sha":"c2e3c52f57a914b188499e531d4c880d482350d7","user":{"login":"crdschurch","id":1843144,"avatar_url":"https://avatars.githubusercontent.com/u/1843144?v=3","gravatar_id":"","url":"https://api.github.com/users/crdschurch","html_url":"https://github.com/crdschurch","followers_url":"https://api.github.com/users/crdschurch/followers","following_url":"https://api.github.com/users/crdschurch/following{/other_user}","gists_url":"https://api.github.com/users/crdschurch/gists{/gist_id}","starred_url":"https://api.github.com/users/crdschurch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crdschurch/subscriptions","organizations_url":"https://api.github.com/users/crdschurch/orgs","repos_url":"https://api.github.com/users/crdschurch/repos","events_url":"https://api.github.com/users/crdschurch/events{/privacy}","received_events_url":"https://api.github.com/users/crdschurch/received_events","type":"Organization","site_admin":false},"repo":{"id":26870034,"name":"crds-angular","full_name":"crdschurch/crds-angular","owner":{"login":"crdschurch","id":1843144,"avatar_url":"https://avatars.githubusercontent.com/u/1843144?v=3","gravatar_id":"","url":"https://api.github.com/users/crdschurch","html_url":"https://github.com/crdschurch","followers_url":"https://api.github.com/users/crdschurch/followers","following_url":"https://api.github.com/users/crdschurch/following{/other_user}","gists_url":"https://api.github.com/users/crdschurch/gists{/gist_id}","starred_url":"https://api.github.com/users/crdschurch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crdschurch/subscriptions","organizations_url":"https://api.github.com/users/crdschurch/orgs","repos_url":"https://api.github.com/users/crdschurch/repos","events_url":"https://api.github.com/users/crdschurch/events{/privacy}","received_events_url":"https://api.github.com/users/crdschurch/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/crdschurch/crds-angular","description":"Starting point for angular development at crossroads","fork":false,"url":"https://api.github.com/repos/crdschurch/crds-angular","forks_url":"https://api.github.com/repos/crdschurch/crds-angular/forks","keys_url":"https://api.github.com/repos/crdschurch/crds-angular/keys{/key_id}","collaborators_url":"https://api.github.com/repos/crdschurch/crds-angular/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/crdschurch/crds-angular/teams","hooks_url":"https://api.github.com/repos/crdschurch/crds-angular/hooks","issue_events_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/events{/number}","events_url":"https://api.github.com/repos/crdschurch/crds-angular/events","assignees_url":"https://api.github.com/repos/crdschurch/crds-angular/assignees{/user}","branches_url":"https://api.github.com/repos/crdschurch/crds-angular/branches{/branch}","tags_url":"https://api.github.com/repos/crdschurch/crds-angular/tags","blobs_url":"https://api.github.com/repos/crdschurch/crds-angular/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/crdschurch/crds-angular/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/crdschurch/crds-angular/git/refs{/sha}","trees_url":"https://api.github.com/repos/crdschurch/crds-angular/git/trees{/sha}","statuses_url":"https://api.github.com/repos/crdschurch/crds-angular/statuses/{sha}","languages_url":"https://api.github.com/repos/crdschurch/crds-angular/languages","stargazers_url":"https://api.github.com/repos/crdschurch/crds-angular/stargazers","contributors_url":"https://api.github.com/repos/crdschurch/crds-angular/contributors","subscribers_url":"https://api.github.com/repos/crdschurch/crds-angular/subscribers","subscription_url":"https://api.github.com/repos/crdschurch/crds-angular/subscription","commits_url":"https://api.github.com/repos/crdschurch/crds-angular/commits{/sha}","git_commits_url":"https://api.github.com/repos/crdschurch/crds-angular/git/commits{/sha}","comments_url":"https://api.github.com/repos/crdschurch/crds-angular/comments{/number}","issue_comment_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/comments{/number}","contents_url":"https://api.github.com/repos/crdschurch/crds-angular/contents/{+path}","compare_url":"https://api.github.com/repos/crdschurch/crds-angular/compare/{base}...{head}","merges_url":"https://api.github.com/repos/crdschurch/crds-angular/merges","archive_url":"https://api.github.com/repos/crdschurch/crds-angular/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/crdschurch/crds-angular/downloads","issues_url":"https://api.github.com/repos/crdschurch/crds-angular/issues{/number}","pulls_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls{/number}","milestones_url":"https://api.github.com/repos/crdschurch/crds-angular/milestones{/number}","notifications_url":"https://api.github.com/repos/crdschurch/crds-angular/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/crdschurch/crds-angular/labels{/name}","releases_url":"https://api.github.com/repos/crdschurch/crds-angular/releases{/id}","created_at":"2014-11-19T16:21:09Z","updated_at":"2015-05-08T20:23:10Z","pushed_at":"2015-10-15T12:31:04Z","git_url":"git://github.com/crdschurch/crds-angular.git","ssh_url":"git@github.com:crdschurch/crds-angular.git","clone_url":"https://github.com/crdschurch/crds-angular.git","svn_url":"https://github.com/crdschurch/crds-angular","homepage":null,"size":30012,"stargazers_count":1,"watchers_count":1,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":5,"forks":1,"open_issues":5,"watchers":1,"default_branch":"development"}},"_links":{"self":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/971"},"html":{"href":"https://github.com/crdschurch/crds-angular/pull/971"},"issue":{"href":"https://api.github.com/repos/crdschurch/crds-angular/issues/971"},"comments":{"href":"https://api.github.com/repos/crdschurch/crds-angular/issues/971/comments"},"review_comments":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/971/comments"},"review_comment":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/971/commits"},"statuses":{"href":"https://api.github.com/repos/crdschurch/crds-angular/statuses/dbc61339dff47ef45f0a8f9654de8f06dcbd5f96"}}}}