public void ItemAddedToListEventHandler(ClientContext clientContext, Guid listId, int listItemId) { try { List news = clientContext.Web.Lists.GetById(listId); ListItem item = news.GetItemById(listItemId); clientContext.Load(item); clientContext.ExecuteQuery(); string itemTitle = item["Title"].ToString(); string itemBody = item["Body"].ToString(); string itemArticle = item["Article"].ToString(); string itemDate = item["Date"].ToString(); var storageAccount = CloudStorageAccount.Parse( CloudConfigurationManager.GetSetting("StorageConnectionString")); var client = storageAccount.CreateCloudTableClient(); var stebraTable = client.GetTableReference("StebraNyhetsList"); if (!stebraTable.Exists()) { stebraTable.Create(); } var newsEntry = new StebraEntity("Nyhet", itemTitle, itemBody, itemArticle, itemDate); var batchOperation = new TableBatchOperation(); batchOperation.Insert(newsEntry); stebraTable.ExecuteBatch(batchOperation); Global.globalError += "242-"; } catch (Exception oops) { System.Diagnostics.Trace.WriteLine(oops.Message); Global.globalError += "248-"; } Global.globalError += "250-"; }
public void FirstTimeInstall(ClientContext clientContext) { List nyhetsLista = clientContext.Web.Lists.GetByTitle(LIST_TITLE); CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = "<View><Query><Where><IsNotNull><FieldRef Name='Title'/>" + "</IsNotNull></Where></Query></View>"; ListItemCollection items = nyhetsLista.GetItems(camlQuery); clientContext.Load(items); clientContext.ExecuteQuery(); //foreach (ListItem item in items) //{ if (Global.globalX != items.Count) { var storageAccount = CloudStorageAccount.Parse( CloudConfigurationManager.GetSetting("StorageConnectionString")); var client = storageAccount.CreateCloudTableClient(); var stebraTable = client.GetTableReference("StebraNyhetsList"); if (!stebraTable.Exists()) { stebraTable.Create(); } int i = 0; for (i = 0; i < items.Count; i++) { ListItem item = items[i]; string itemTitle = item["Title"].ToString(); string itemBody = item["Body"].ToString(); string itemArticle = item["Article"].ToString(); string itemDate = item["Date"].ToString(); var newsEntry = new StebraEntity("Nyhet", itemTitle, itemBody, itemArticle, itemDate); var batchOperation = TableOperation.InsertOrReplace(newsEntry); stebraTable.Execute(batchOperation); Global.globalX++; } } }