public async Task <ActionResult> Create(string selectedSharePointList)
{
using (var cc = ContextProvider.GetWebApplicationClientContext(Settings.SiteCollection))
{
if (cc != null)
{
// Hookup event to capture access token
cc.ExecutingWebRequest += Cc_ExecutingWebRequest;
ListCollection lists = cc.Web.Lists;
Guid listId = new Guid(selectedSharePointList);
IEnumerable <List> sharePointLists = cc.LoadQuery <List>(lists.Where(lst => lst.Id == listId));
cc.Load(cc.Web, w => w.Url);
cc.ExecuteQueryRetry();
WebHookManager webHookManager = new WebHookManager();
var res = await webHookManager.AddListWebHookAsync(cc.Web.Url, listId.ToString(), CloudConfigurationManager.GetSetting("WebHookEndPoint"), this.accessToken);
// persist the latest changetoken of the list when we create a new webhook. This allows use to only grab the changes as of web hook creation when the first notification comes in
using (SharePointWebHooks dbContext = new SharePointWebHooks())
{
dbContext.ListWebHooks.Add(new ListWebHooks()
{
Id = new Guid(res.Id),
ListId = listId,
LastChangeToken = sharePointLists.FirstOrDefault().CurrentChangeToken.StringValue,
});
var saveResult = await dbContext.SaveChangesAsync();
}
}
}
return(RedirectToAction("Index", "Home"));
}
public async Task <ActionResult> Delete(string id = null, string listId = null)
{
using (var cc = ContextProvider.GetWebApplicationClientContext(Settings.SiteCollection))
{
if (cc != null)
{
// Hookup event to capture access token
cc.ExecutingWebRequest += Cc_ExecutingWebRequest;
// Just load the Url property to trigger the ExecutingWebRequest event handler to fire
cc.Load(cc.Web, w => w.Url);
cc.ExecuteQueryRetry();
WebHookManager webHookManager = new WebHookManager();
// delete the web hook
if (await webHookManager.DeleteListWebHookAsync(cc.Web.Url, listId, id, this.accessToken))
{
using (SharePointWebHooks dbContext = new SharePointWebHooks())
{
var webHookRow = await dbContext.ListWebHooks.FindAsync(new Guid(id));
if (webHookRow != null)
{
dbContext.ListWebHooks.Remove(webHookRow);
var saveResult = await dbContext.SaveChangesAsync();
}
}
}
}
}
return(RedirectToAction("Index", "Home"));
}
private void RegisterAddingWebHookEvent(ClientContext cc)
{
btnCreate.Click += async(s, args) =>
{
// Hookup event to capture access token
cc.ExecutingWebRequest += Cc_ExecutingWebRequest;
var lists = cc.Web.Lists;
Guid listId = new Guid(ListDropDown.SelectedItem.Text.Split(new string[] { "||" }, StringSplitOptions.None)[1]);
IEnumerable <List> sharePointLists = cc.LoadQuery <List>(lists.Where(lst => lst.Id == listId));
cc.Load(cc.Web, w => w.Url);
cc.ExecuteQueryRetry();
WebHookManager webHookManager = new WebHookManager();
var res = await webHookManager.AddListWebHookAsync(cc.Web.Url, listId.ToString(),
"https://pnpwebhooksdemo.azurewebsites.net/api/webhooks", this.accessToken);
// persist the latest changetoken of the list when we create a new webhook. This allows use to only grab the changes as of web hook creation when the first notification comes in
using (SharePointWebHooks dbContext = new SharePointWebHooks("pnpwebhooksdemoEntities"))
{
dbContext.ListWebHooks.Add(new ListWebHook()
{
Id = new Guid(res.Id),
StartingUrl = cc.Web.Url,
ListId = listId,
LastChangeToken = sharePointLists.FirstOrDefault().CurrentChangeToken.StringValue,
});
var saveResult = await dbContext.SaveChangesAsync();
}
};
}
public async Task <ActionResult> Delete(string id = null, string listId = null)
{
var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext);
using (var cc = spContext.CreateUserClientContextForSPHost())
{
if (cc != null)
{
// Hookup event to capture access token
cc.ExecutingWebRequest += Cc_ExecutingWebRequest;
// Just load the Url property to trigger the ExecutingWebRequest event handler to fire
cc.Load(cc.Web, w => w.Url);
cc.ExecuteQueryRetry();
var webHookManager = new WebHookManager();
// delete the web hook
if (await webHookManager.DeleteListWebHookAsync(cc.Web.Url, listId, id, this.accessToken))
{
using (var dbContext = new SharePointWebHooks())
{
var webHookRow = await dbContext.ListWebHooks.FindAsync(new Guid(id));
if (webHookRow != null)
{
dbContext.ListWebHooks.Remove(webHookRow);
var saveResult = await dbContext.SaveChangesAsync();
}
}
}
}
}
return(RedirectToAction($"Index", $"Home", new { SPHostUrl = Request.QueryString[$"SPHostUrl"] }));
}
private async Task ReactToWebHookDeletion()
{
string target = Request["__EVENTTARGET"];
if (target == "deletewebhook")
{
using (var cc = spContext.CreateAppOnlyClientContextForSPAppWeb())
{
string[] parameters = Request["__EVENTARGUMENT"].Split(new string[] { "||" }, StringSplitOptions.None);
string id = parameters[0];
string listId = parameters[1];
// Hookup event to capture access token
cc.ExecutingWebRequest += Cc_ExecutingWebRequest;
// Just load the Url property to trigger the ExecutingWebRequest event handler to fire
cc.Load(cc.Web, w => w.Url);
cc.ExecuteQueryRetry();
WebHookManager webHookManager = new WebHookManager();
// delete the web hook
if (await webHookManager.DeleteListWebHookAsync(cc.Web.Url, listId, id, this.accessToken))
{
using (SharePointWebHooks dbContext = new SharePointWebHooks())
{
var webHookRow = await dbContext.ListWebHooks.FindAsync(new Guid(id));
if (webHookRow != null)
{
dbContext.ListWebHooks.Remove(webHookRow);
var saveResult = await dbContext.SaveChangesAsync();
}
}
}
}
}
}
