private void Edit(Project pro) { if (oList != null) { // Edit if (pro.Id != 0) { // Assume there is a list item with ID=1. ListItem listItem = oList.GetItemById(pro.Id); // Write a new value to the Body field of the Announcement item. listItem["ProjectName"] = pro.ProjectName; listItem["ProjDescription"] = pro.Description; listItem["StartDate"] = pro.StartDate; listItem["_EndDate"] = pro.EndDate; listItem["State"] = pro.State; // Leader FieldLookupValue lookup = new FieldLookupValue(); lookup.LookupId = 3; listItem["Leader"] = lookup; // Members List <FieldLookupValue> lvList = new List <FieldLookupValue>(); lvList.Add(lookup); lvList.Add(new FieldLookupValue() { LookupId = 1 }); listItem["Member"] = lvList; listItem.Update(); context.ExecuteQuery(); context.ExecuteQuery(); } // Add new item else { ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem newItem = oList.AddItem(itemCreateInfo); newItem["Title"] = Guid.NewGuid(); newItem["ProjectName"] = pro.ProjectName; newItem["ProjDescription"] = pro.Description; newItem["StartDate"] = pro.StartDate; newItem["_EndDate"] = pro.EndDate; newItem["State"] = pro.State; newItem.Update(); context.ExecuteQuery(); } } }
/* * Applies a value (aka metadata) to a text column for a given item in a document library * Parameters: * 'context' client context object returned from ConnectToSharePoint() * 'documentLibraryName' name of the document library * 'columnName' is the name of the column * 'value' is the string value to apply in the column for the itemId * 'itemId' is the item id of the document (row) in the document library. Use GetItemId() to find this. */ public void ApplyTextColumnMetadataToSharePointFile(ClientContext context, string documentLibraryName, string columnName, string value, int itemId) { try { Web web = context.Web; var list = web.Lists.GetByTitle(documentLibraryName); context.Load(list.Fields); context.ExecuteQuery(); foreach (Field f in list.Fields) { if (f.Title == columnName) //Found a match { string internalColumnName = f.InternalName; Microsoft.SharePoint.Client.List oList = context.Web.Lists.GetByTitle(documentLibraryName); ListItem oListItem = oList.GetItemById(itemId); oListItem[internalColumnName] = value; oListItem.Update(); context.ExecuteQuery(); } else { //No match found } } } catch (Exception ex) { //Handle exception } }
public SP.FileCollection Attachments(SPListItem listItem, SPList list, object value) { if (value == null || !(bool)value) { return(null); } using (var clientContext = new SPContext(list.SPWebUrl, credentials.Get(list.SPWebUrl))) { SP.Web web = clientContext.Web; clientContext.Load(web); SP.List splist = clientContext.ToList(list.Id); clientContext.Load(splist); SP.ListItem splistItem = splist.GetItemById(listItem.Id); clientContext.Load(splistItem); clientContext.ExecuteQuery(); SP.Folder listFolder = splistItem.ParentList.RootFolder; clientContext.Load(listFolder, f => f.ServerRelativeUrl); clientContext.ExecuteQuery(); SP.Folder attachmentsFolder = web.GetFolderByServerRelativeUrl(listFolder.ServerRelativeUrl + "/attachments/" + splistItem.Id.ToString()); clientContext.Load(attachmentsFolder); var attachments = attachmentsFolder.Files; clientContext.Load(attachments); clientContext.ExecuteQuery(); return(attachments); } }
//Delete Documents public string DeleteDocument(string RepoName, string DocId) { string msg; try { ClientContext ctx = new ClientContext(this.objAuth.SiteURL); ctx.RequestTimeout = 50000; ctx.Credentials = this.GetO365Credentials(this.objAuth.UserName, this.objAuth.UserPassword); Web web = ctx.Web; Microsoft.SharePoint.Client.List oList = web.Lists.GetByTitle(RepoName); ListItem DocToDelete = oList.GetItemById(DocId); DocToDelete.DeleteObject(); oList.Update(); if (ctx.HasPendingRequest) { ctx.ExecuteQueryAsync() .Wait(); } msg = "Document Removed from Repository"; } catch (Exception ex) { return("Error:" + ex.Message); } return(msg); }
public int UpdateEntry(EmployeeModel emp, string siteUrl, string ID) { try { using (MSC.ClientContext context = GetContext(siteUrl)) { MSC.List list = context.Web.Lists.GetByTitle("TIM_DailyAttendance"); MSC.ListItem listItem = null; MSC.ListItemCreationInformation itemCreateInfo = new MSC.ListItemCreationInformation(); listItem = list.GetItemById(Convert.ToInt32(ID)); listItem["AttendanceDate"] = Convert.ToDateTime(emp.attendance_date).ToString("dd-MM-yyyy"); listItem["CheckinTime"] = emp.checkin_time; listItem["CheckoutTime"] = emp.checkout_time; listItem["Comment"] = emp.comment; listItem["EmpNo"] = emp.empno; listItem["Hours"] = emp.hours; listItem["EmpName"] = emp.name; listItem["EmpMail"] = emp.office_email; listItem.Update(); context.ExecuteQuery(); } } catch (Exception ex) { } return(0); }
/* * Applies a value (aka metadata) to a text column for a given item in a document library * Parameters: * 'context' client context object returned from ConnectToSharePoint() * 'documentLibraryName' name of the document library * 'columnName' is the name of the column * 'itemId' is the item id of the document (row) in the document library * 'listItemId' is the item id from the lookup list. Use an Id returned from GetLookupListItems() Dictionary. */ public void ApplyLookupColumnMetadataToSharePointFile(ClientContext context, string documentLibraryName, string columnName, int itemId, int listItemId) { try { //Lookup column internal name using DisplayName Web web = context.Web; var list = web.Lists.GetByTitle(documentLibraryName); context.Load(list.Fields); context.ExecuteQuery(); foreach (Field f in list.Fields) { if (f.Title == columnName) //Found a match { string internalColumnName = f.InternalName; Microsoft.SharePoint.Client.List oList = context.Web.Lists.GetByTitle(documentLibraryName); ListItem oListItem = oList.GetItemById(itemId); //Credit to http://sharepoint.stackexchange.com/questions/8017/how-to-set-listitem-lookup-field-value oListItem[internalColumnName] = listItemId; oListItem.Update(); context.ExecuteQuery(); } else { //No match found } } } catch (Exception ex) { //Handle error } }
private void button3_Click(object sender, EventArgs e) { string delete = textBox2.Text; ListItem oListItem = oList.GetItemById(delete); clientContext.ExecuteQuery(); }
static void Main(string[] args) { using (ClientContext context = new ClientContext("https://mySharePointServer/sites/MySite/")) { context.Credentials = new NetworkCredential("myUserName", "myPassword", "MYDOMAIN"); SP.List calendarList = context.Web.Lists.GetByTitle("Calendar"); ListItem cListItem = calendarList.GetItemById(2301); //This is one way to retrieve an item for update. You can also use a Caml Query context.Load(cListItem); cListItem["MetaInfo"] = "Categories:SW|Red Category\r\n"; cListItem.Update(); context.ExecuteQuery(); } }
private void Edit(Employee emp) { if (oList != null) { string lang = GetLanguage(emp.Languages); // Edit if (emp.Id != 0) { // Assume there is a list item with ID=1. ListItem listItem = oList.GetItemById(emp.Id); // Write a new value to the Body field of the Announcement item. listItem["EmailAdd"] = emp.Email; listItem["ShortDesc"] = emp.ShortDescription; listItem["FirstName"] = emp.FirstName; listItem["Title"] = emp.Title; listItem["ProgrammingLanguages"] = lang; listItem.Update(); context.ExecuteQuery(); } // Add new item else { ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem newItem = oList.AddItem(itemCreateInfo); newItem["EmailAdd"] = emp.Email; newItem["ShortDesc"] = emp.ShortDescription; newItem["FirstName"] = emp.FirstName; newItem["Title"] = emp.Title; newItem["ProgrammingLanguages"] = lang; newItem.Update(); context.ExecuteQuery(); } } }
private void btnShred_Click(object sender, EventArgs e) { SP.List docsList = web.Lists.GetByTitle("Documents"); context.Load(docsList); for (int i = 0; i < listFiles.Items.Count; i++) { ListViewItem item = listFiles.Items[i]; if (item.Checked) { ListItem listItem = docsList.GetItemById(i); listItem.DeleteObject(); } } context.ExecuteQuery(); }
private void btndelete_Click(object sender, EventArgs e) { try { Int32 selectedRowCount = gridlist.Rows.GetRowCount(DataGridViewElementStates.Selected); if (selectedRowCount > 1) { throw new Exception("Please select only one record"); } else if (selectedRowCount == 1) { string ID = gridlist.SelectedRows[0].Index.ToString(); string value = gridlist.SelectedRows[0].Cells[1].Value.ToString(); ClientContext clientContext = new ClientContext(siteurl + "//" + subsite); SP.List oList = clientContext.Web.Lists.GetByTitle("Resource_Level"); ListItem oListItem = oList.GetItemById(value); oListItem.DeleteObject(); clientContext.ExecuteQuery(); lblmessage6.Text = "Data deleted succesfully"; lblmessage6.ForeColor = System.Drawing.Color.Green; lblmessage6.Visible = true; btnlist.PerformClick(); } else { throw new Exception("Please select at least one record"); } } catch (Exception ex) { lblmessage6.Text = ex.Message; lblmessage6.ForeColor = System.Drawing.Color.Red; lblmessage6.Visible = true; } }
private void deleteButton_Click(object sender, RoutedEventArgs e) { string UserName = "******", Password = "******"; ClientContext ctx = new ClientContext("https://omisayeduiu.sharepoint.com/sites/sayeddev"); SecureString passWord = new SecureString(); foreach (char c in Password.ToCharArray()) { passWord.AppendChar(c); } ctx.Credentials = new SharePointOnlineCredentials(UserName, passWord); Web myWeb = ctx.Web; Microsoft.SharePoint.Client.List sectionsList = myWeb.Lists.GetByTitle("sectionInfo"); Microsoft.SharePoint.Client.ListItem item = sectionsList.GetItemById(Convert.ToInt32(deleteId.Text.Trim())); item.DeleteObject(); ctx.ExecuteQuery(); this.show(); }
public void UpdateItem(string ListName, TEntity Item) { try { SP.Web web = context.Web; SP.List list = web.Lists.GetByTitle(ListName); var properties = typeof(TEntity).GetProperties(); var id = properties.FirstOrDefault(f => f.Name == "ID"); SP.ListItem item = list.GetItemById(Convert.ToInt32(id.GetValue(Item))); if (item != null) { foreach (var property in properties) { if (property.Name != "ID" && property.Name != "Created" && property.Name != "Author") { item[property.Name] = property.GetValue(Item); } } item.Update(); context.Load(item); context.ExecuteQuery(); } else { throw new Exception("Item does not exist"); } } catch (InvalidCastException ex) { throw new Exception(ex.Message + ". Data model types are invalid, please verify that models are strongly typed and match the SharePoint list column types.", new InvalidCastException()); } catch (Exception ex) { throw new Exception("Error updating SharePoint list data: " + ex.Message); } }
public void DeleteItem(string ListName, int Id) { try { SP.Web web = context.Web; SP.List list = web.Lists.GetByTitle(ListName); SP.ListItem item = list.GetItemById(Id); if (item != null) { item.DeleteObject(); context.ExecuteQuery(); } else { throw new Exception("Item does not exist"); } } catch (Exception ex) { throw new Exception("Error updating SharePoint list data: " + ex.Message); } }
public static void UpdateStatus(int ID, string siteUrl, string ListName) { using (MSC.ClientContext context = CustomSharePointUtility.GetContext(siteUrl)) { if (context != null) { MSC.List list = context.Web.Lists.GetByTitle(ListName); MSC.ListItem listItem = null; MSC.ListItemCreationInformation itemCreateInfo = new MSC.ListItemCreationInformation(); listItem = list.GetItemById(ID); listItem["SystemUpdated"] = "Yes"; listItem.Update(); try { context.ExecuteQuery(); } catch (Exception ex) { } } } }
public ActionResult ScanTemplate() { var spContext = SharePointContextProvider.Current.GetSharePointContext(System.Web.HttpContext.Current); string spListId = this.Request["SPListId"]; string spListItemId = this.Request["SPListItemId"]; string relativeUrl = this.Request["url"]; using (var clientContext = spContext.CreateUserClientContextForSPHost()) { SP.File file = null; SP.Web web = clientContext.Web; clientContext.Load(web); if (string.IsNullOrEmpty(relativeUrl)) { Guid listId = new Guid(spListId); int itemId = Convert.ToInt32(spListItemId); SP.List spList = clientContext.Web.Lists.GetById(listId); clientContext.Load <SP.List>(spList); SP.ListItem item = spList.GetItemById(itemId); clientContext.Load <SP.ListItem>(item); clientContext.ExecuteQuery(); file = item.File; } else { file = web.GetFileByServerRelativeUrl(relativeUrl); } FormInformation info = InfoPathAnalytics.FormInformation(clientContext, file); info.XsnUrl = file.ServerRelativeUrl; return(View(info)); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdateItem_Click(object sender, RoutedEventArgs e) { try { SPClient.List announcementsList = ctx.SPContext.Web.Lists.GetByTitle("MyFirstList"); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem listItem = announcementsList.GetItemById(this.txtBoxId.Text); listItem["Description"] = this.txtBoxDescriptionUpdate.Text; listItem.Update(); ctx.SPContext.ExecuteQuery(); MessageBox.Show("Item inserted"); this.txtBoxId.Text = ""; this.txtBoxDescriptionUpdate.Text = ""; } catch (Exception ex) { RaiseException(ex); } }
public static string GetItemByID(string listName, int ID) { string result = string.Empty; if (clientContext == null) { clientContext = new ClientContext(Proxy.SelectedServiceUri + Proxy.WebSite); } using (clientContext) { //获取列表 Microsoft.SharePoint.Client.List oList = clientContext.Web.Lists.GetByTitle(listName); //通过ID获取Item ListItem listItem = oList.GetItemById(ID); //加载 clientContext.Load(listItem); //执行 clientContext.ExecuteQuery(); #region 获取指定ID文档下的所有文件名称 clientContext.Load(oList.RootFolder.Folders); clientContext.ExecuteQuery(); Folder folderGet = null; foreach (var item in oList.RootFolder.Folders) { if (item.Name.Equals(Proxy.attch)) { clientContext.Load(item.Folders); clientContext.ExecuteQuery(); foreach (var itemChild in item.Folders) { if (itemChild.Name.Equals(ID.ToString())) { folderGet = itemChild; break; } } break; } } if (folderGet != null) { clientContext.Load(folderGet.Files); clientContext.ExecuteQuery(); foreach (var item in folderGet.Files) { var fileName = item.ServerRelativeUrl.Substring(item.ServerRelativeUrl.LastIndexOf('/') + 1); result += fileName + "," + Proxy.SelectedServiceUri + item.ServerRelativeUrl + ";"; } } #endregion } return(result); }