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(); } } }
private void CreateNovoContacto(ClientContext siteContexto, List listaTelefonica, ItemListaTelefonicaProperties itemListaTelefonicaProperties) { try { ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem addItem = listaTelefonica.AddItem(itemCreateInfo); addItem["Title"] = itemListaTelefonicaProperties.PreferredName; addItem["FirstName"] = itemListaTelefonicaProperties.FirstName; addItem["LastName"] = itemListaTelefonicaProperties.LastName; addItem["Email"] = itemListaTelefonicaProperties.Email; addItem["PagerNumber"] = itemListaTelefonicaProperties.Pager; addItem["Department"] = itemListaTelefonicaProperties.Department; addItem["CellPhone"] = itemListaTelefonicaProperties.CellPhone; addItem["PictureURL"] = itemListaTelefonicaProperties.PictureURL; addItem["Office"] = itemListaTelefonicaProperties.Office; addItem["WorkFax"] = itemListaTelefonicaProperties.WorkFax; addItem["WorkPhone"] = itemListaTelefonicaProperties.WorkPhone; addItem["WorkState"] = itemListaTelefonicaProperties.WorkState; addItem["WorkCity"] = itemListaTelefonicaProperties.WorkCity; addItem["WorkCountry"] = itemListaTelefonicaProperties.WorkCountry; addItem["WorkZip"] = itemListaTelefonicaProperties.WorkZip; addItem["IpPhone"] = itemListaTelefonicaProperties.IpPhone; addItem["WorkAddress"] = itemListaTelefonicaProperties.WorkAddress; addItem["AboutMe"] = itemListaTelefonicaProperties.AboutMe; addItem["JobTitle"] = itemListaTelefonicaProperties.JobTitle; addItem["Company"] = itemListaTelefonicaProperties.Company; addItem.Update(); siteContexto.ExecuteQuery(); } catch (Exception ex) { _log.Error($"-> CreateNovoContacto no processo: SharepointSyncJob: {ex}", ex); } }
private void ProductEditorDialog_AddClosed(object sender, EventArgs e) { ProductEditor dialog = (ProductEditor)sender; // stop if they clicked cancel if (dialog.DialogResult == false) { return; } StatusBarPanel.BeginUpdateMessage("Creating new item..."); SP.List products = Globals.ClientContext.Web.Lists.GetByTitle("Products"); SP.ListItemCreationInformation newProductInfo = new SP.ListItemCreationInformation(); SP.ListItem newProduct = products.AddItem(newProductInfo); newProduct["Title"] = dialog.ProductNameTextBox.Text; newProduct["Product_x0020_Number"] = dialog.ProductNumberTextBox.Text; newProduct["Price"] = dialog.ProductPriceTextBox.Text; SP.FieldLookupValue fieldValue = new SP.FieldLookupValue(); foreach (SP.ListItem item in Globals.ProductCategories) { if (item["Title"].ToString() == ((SP.ListItem)dialog.ProductCategoryComboBox.SelectedItem)["Title"].ToString()) { fieldValue.LookupId = item.Id; } } newProduct["Category"] = fieldValue; newProduct.Update(); Globals.ClientContext.ExecuteQuery(); this.Dispatcher.BeginInvoke(new Action(OnProducteditorAddUIUpdater), DispatcherPriority.Normal); }
public int InsertEntry(EmployeeModel emp, string siteUrl) { 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.AddItem(itemCreateInfo); 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); }
private void button4_Click(object sender, EventArgs e) { ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = oList.AddItem(itemCreateInfo); var box = comboBox1.SelectedItem; string boxx = box.ToString(); if (boxx == null) { this.label5.Text = "Add genre"; } var box2 = comboBox2lang.SelectedItem; var tex1 = textBox3title.Text; var tex2 = textBox5pages.Text; var tex4 = textBox4.Text; oListItem["Title"] = tex1; try { oListItem["Genre"] = new SPFieldLookupValue(boxx); } catch (ArgumentException) { } oListItem["Pages"] = tex2; oListItem["Author4"] = tex4; oListItem["Language"] = box2; oListItem.Update(); clientContext.ExecuteQuery(); }
public async Task <bool> AddItemToList(string listName, SharepointListItem item) { try { // Authentication. using (var context = GetSharepointSiteContext()) { Microsoft.SharePoint.Client.List eventList = context.Web.Lists.GetByTitle(listName); ListItemCreationInformation itemInfo = new ListItemCreationInformation(); ListItem listItemToAdd = eventList.AddItem(itemInfo); foreach (var field in item) { listItemToAdd[field.Key] = field.Value; } listItemToAdd.Update(); await context.ExecuteQueryAsync(); return(true); } } catch (Exception e) { Console.WriteLine("An unexpected error occurred while adding an item."); Console.WriteLine(e.Message); return(false); } }
private void createButton_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"); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); Microsoft.SharePoint.Client.ListItem newItem = sectionsList.AddItem(itemCreateInfo); newItem["sectionName"] = sectionBox.Text.Trim().ToString(); newItem["sectionWeight"] = Convert.ToInt32(weightBox.Text.Trim()); newItem.Update(); ctx.ExecuteQuery(); this.show(); }
public void InsertarElemento(Persona persona, HttpContextBase HttpContext) { //string siteUrl = "https://latinshare.sharepoint.com/sites/dev/"; //ClientContext clientContext = new ClientContext(siteUrl); var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext); //var creds = new SharePointOnlineCredentials("*****@*****.**", password); // Requires SecureString() for password //context.Credentials = creds; using (var clientContext = spContext.CreateUserClientContextForSPHost()) { SP.List oList = clientContext.Web.Lists.GetByTitle("Persona"); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = oList.AddItem(itemCreateInfo); oListItem["Title"] = persona.Id; oListItem["Nombre"] = persona.Nombre; oListItem["Comuna"] = persona.Comuna; oListItem["Direccion"] = persona.Direccion; oListItem["FechaNacimiento"] = persona.FechaNacimiento; oListItem["EsHumano"] = persona.EsHumano; oListItem.Update(); clientContext.ExecuteQuery(); } }
public async Task <bool> AddItemToList(string listName, SharepointListItem item) { try { // Authentication. using (var context = _authenticationManager.GetContext(_sharepointUrl)) { Microsoft.SharePoint.Client.List eventList = context.Web.Lists.GetByTitle(listName); ListItemCreationInformation itemInfo = new ListItemCreationInformation(); ListItem listItemToAdd = eventList.AddItem(itemInfo); foreach (var field in item) { listItemToAdd[field.Key] = field.Value; } listItemToAdd.Update(); await context.ExecuteQueryAsync(); return(true); } } catch (Exception e) { Console.WriteLine("An unexpected error occurred while adding an item."); Console.WriteLine(e.Message); return(false); } // When add item to list, the target list may not exist. // Then it should be created and set privilege. // Should modify code here and with the help of create list function. }
/// <summary> /// Insert a new list item to a specific list /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnInsertItem_Click(object sender, RoutedEventArgs e) { try { SPClient.List announcementsList = ctx.SPContext.Web.Lists.GetByTitle("MyFirstList"); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem newItem = announcementsList.AddItem(itemCreateInfo); newItem["Title"] = this.txtBoxTitle.Text; newItem["Description"] = this.txtBoxDescription.Text; newItem.Update(); ctx.SPContext.ExecuteQuery(); MessageBox.Show("Item inserted"); this.txtBoxTitle.Text = ""; this.txtBoxDescription.Text = ""; } catch (Exception ex) { RaiseException(ex); } }
protected void btnAddTask_Click(object sender, EventArgs e) { string SiteCollectionURL = txtSiteCollection.Text; CLOM.ClientContext context = new CLOM.ClientContext(SiteCollectionURL); CLOM.List taskList = context.Web.Lists.GetByTitle("Tasks"); CLOM.CamlQuery query = new CamlQuery(); CLOM.ListItemCollection myTaskList = taskList.GetItems(query); context.Load(myTaskList, itms => itms.ListItemCollectionPosition, itms => itms.Include( itm => itm["Title"], itm => itm["Body"], itm => itm["DueDate"])); context.ExecuteQuery(); ListItemCreationInformation newTask = new ListItemCreationInformation(); CLOM.ListItem newTaskItem = taskList.AddItem(newTask); newTaskItem["Title"] = txtTitle.Text; newTaskItem["Body"] = txtDesc.Text; newTaskItem["DueDate"] = Calendar1.SelectedDate; newTaskItem.Update(); context.ExecuteQuery(); lblResult.Text = "Added Task " + txtTitle.Text; }
private void btnsave_Click(object sender, EventArgs e) { try { if (String.IsNullOrEmpty(siteurl)) { throw new Exception("Plase choose site collection in previous tab"); } String title = txttitle.Text; String name = txtname.Text; String allowance = txtallowance.Text; String level = txtlevel.Text; if (String.IsNullOrEmpty(title) || String.IsNullOrEmpty(name) || String.IsNullOrEmpty(allowance) || String.IsNullOrEmpty(level)) { throw new Exception("Please fill all data"); } ClientContext clientContext = new ClientContext(siteurl + "//" + subsite); SP.List oList = clientContext.Web.Lists.GetByTitle("Resource_Level"); /** for "edit" function **/ //ListItem oListItem = oList.GetItemById(title); /** Uncomment below code for "add" function **/ ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = oList.AddItem(itemCreateInfo); oListItem["Title"] = title; oListItem["Name"] = name; oListItem["Allowance"] = allowance; oListItem["Level"] = level; oListItem.Update(); clientContext.ExecuteQuery(); txttitle.Text = ""; txtname.Text = ""; txtallowance.Text = ""; txtlevel.Text = ""; lblmessage5.Text = "Data saved successfully"; lblmessage4.Visible = false; lblmessage5.Visible = true; } catch (Exception ex) { lblmessage4.Text = ex.Message; lblmessage5.Visible = false; lblmessage4.Visible = true; } }
private void button1_Click(object sender, RoutedEventArgs e) { CLOM.ClientContext context = new CLOM.ClientContext(CLOM.ApplicationContext.Current.Url); CLOM.List taskList = context.Web.Lists.GetByTitle("Tasks"); CLOM.ListItemCreationInformation itemCreateInfo = new CLOM.ListItemCreationInformation(); CLOM.ListItem newItem = taskList.AddItem(itemCreateInfo); newItem["Title"] = textBox1.Text; newItem["DueDate"] = calendar1.SelectedDate.Value.ToShortDateString(); newItem.Update(); context.ExecuteQueryAsync(ClientRequestSucceeded, ClientRequestFailed); }
/// <summary> /// リストにアイテムを追加します。 /// </summary> /// <param name="this">SharePoint リスト</param> /// <param name="leafName">新しいリストアイテムの名前</param> /// <param name="isFolder">追加するアイテムがフォルダかどうか</param> /// <param name="folderPath"> /// <para>追加先のフォルダのパス。</para> /// <para>絶対パス、又は相対パスを指定します。</para> /// <para>指定しない場合はリスト直下にアイテムが追加されます。</para> /// </param> /// <param name="processItem">追加したアイテムを加工するメソッド</param> /// <returns>リストに追加したアイテムを返します。</returns> public static void AddItem(this SP.List @this, string leafName, bool isFolder, string folderPath, Action <ListItem> processItem = null) { var item = @this.AddItem(new ListItemCreationInformation { FolderUrl = folderPath, LeafName = leafName, UnderlyingObjectType = isFolder ? FileSystemObjectType.Folder : FileSystemObjectType.File, }); processItem?.Invoke(item); item.Update(); }
private async Task Update_List(string candidateID, string dob) { try { ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem newItem = CandList.AddItem(itemCreateInfo); lblStatus.Text = "Uploading Results"; progressBar1.PerformStep(); FieldLookupValue lval = await GetLookupValue(ctx, jobName, "Job", "JobFullName", "Text", false); newItem["CandidateID"] = CandID; newItem["First_name"] = candidate_name.Split('_')[0]; newItem["Last_name"] = candidate_name.Split('_')[1]; newItem["JobSite"] = lval; newItem["DOB"] = dob; newItem["Job"] = jobName; // double percent = Convert.ToDouble(no_of_passes) / Convert.ToDouble(dt.Rows.Count); // string hireStatus = ""; newItem["Hire_Status"] = hireStatus; //if (percent >= 0.7 && percent < 1.0) //{ // newItem["Hire_Status"] = hireStatus; // // hireStatus = "Conditional Hire"; //} //else //{ // newItem["Hire_Status"] = "Hired"; // hireStatus = "Hired"; //} string tempFolderurl = docFolder.ServerRelativeUrl; FieldUrlValue _url = new FieldUrlValue(); _url.Url = tempFolderurl.Substring(0, tempFolderurl.LastIndexOf('/'));; _url.Description = "View Tests"; newItem["FolderUrl"] = _url; newItem["Remaining_Test"] = remaining_test; newItem["Category"] = pos_category; //newItem["FolderUrl"] = folder.ServerRelativeUrl; newItem.Update(); ctx.Load(CandList); ctx.ExecuteQuery(); await Task.Delay(1000); } catch (Exception ex) { throw ex; } }
static void Main() { string siteUrl = "http://MyServer/sites/MySiteCollection"; ClientContext clientContext = new ClientContext(siteUrl); SP.List oList = clientContext.Web.Lists.GetByTitle("Announcements"); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = oList.AddItem(itemCreateInfo); oListItem["Title"] = "My New Item!"; oListItem["Body"] = "Hello World!"; oListItem.Update(); clientContext.ExecuteQuery(); }
public void MigrarDatos(List <Persona> ListPersona, HttpContextBase HttpContext) { LimpiarTabla(HttpContext); foreach (Persona persona in ListPersona) { var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext); using (var clientContext = spContext.CreateUserClientContextForSPHost()) { //var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext); //ClientContext clientContext = new ClientContext(siteUrl); SP.List oList = clientContext.Web.Lists.GetByTitle("Persona"); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = oList.AddItem(itemCreateInfo); oListItem["Title"] = persona.Id; oListItem["Nombre"] = persona.Nombre; oListItem["Comuna"] = persona.Comuna; oListItem["Direccion"] = persona.Direccion; oListItem["FechaNacimiento"] = persona.FechaNacimiento; oListItem["EsHumano"] = persona.EsHumano; oListItem.Update(); clientContext.ExecuteQuery(); if (persona.Id % 2 == 0) { oListItem.BreakRoleInheritance(false, false); User spUser = clientContext.Web.CurrentUser; clientContext.Load(spUser, user => user.LoginName); clientContext.ExecuteQuery(); //spUser.LoginName User oUser = clientContext.Web.SiteUsers.GetByLoginName("i:0#.f|membership|[email protected]"); RoleDefinitionBindingCollection collRoleDefinitionBinding = new RoleDefinitionBindingCollection(clientContext); collRoleDefinitionBinding.Add(clientContext.Web.RoleDefinitions.GetByType(RoleType.Reader)); oListItem.RoleAssignments.Add(oUser, collRoleDefinitionBinding); clientContext.ExecuteQuery(); } } } }
private static void InsertIntoList(DataTable listTable, string contactListName) { string siteUrl = ConfigurationManager.AppSettings["SharePointURL"]; bool isBatchUpdate = Convert.ToBoolean(ConfigurationManager.AppSettings["IsBatchUpdate"]); using (Microsoft.SharePoint.Client.ClientContext context = ClaimClientContext.GetAuthenticatedContext(siteUrl)) { string strListName = ConfigurationManager.AppSettings["TargetSharePointListName"]; int counter = 0; Console.WriteLine(string.Format("\nContent type updation would be performed for url - {0}\n", siteUrl)); Web site = context.Web; context.Load(site); context.Load(site.Lists, lists => lists.Include(list => list.Title, // For each list, retrieve Title and Id. list => list.Id)); context.ExecuteQuery(); Microsoft.SharePoint.Client.List GlossaryList = site.Lists.GetByTitle(strListName); for (int iRow = 0; iRow < listTable.Rows.Count; iRow++) { ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = GlossaryList.AddItem(itemCreateInfo); //the column name below is the absolute name of the column which can be seen in List Settings-->List columns //Modify the below rows as per your target list columns oListItem["Title"] = Convert.ToString(listTable.Rows[iRow][0]); //List Title oListItem["r9dw"] = Convert.ToString(listTable.Rows[iRow][2]); //Definition oListItem["gpqr"] = Convert.ToString(listTable.Rows[iRow][3]); //TermCategory counter++; oListItem.Update(); if (isBatchUpdate == true) { if ((counter % 10) == 0) //for batch batch by batch updation in multiples of 10 { context.ExecuteQuery(); counter = 0; //reset the counter } } else { context.ExecuteQuery(); //Either use this if you want to update every item one by one } } } }
public static SP.ListItem AddItemToList(SP.ClientContext context, SP.List list, Dictionary <string, string> item) { try { SP.ListItemCreationInformation itemCreationInfo = new SP.ListItemCreationInformation(); SP.ListItem newItem = list.AddItem(itemCreationInfo); foreach (KeyValuePair <string, string> entry in item) { newItem[entry.Key] = entry.Value; } newItem.Update(); context.Load(newItem); context.ExecuteQuery(); return(newItem); } catch (Exception e) { MessageBox.Show($"Error in SharepointMethods.AddItemToList: {e}"); return(null); } }
public void CreateNewEventOnWSS(WorkItem wi) { ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); oListItem = oList.AddItem(itemCreateInfo); oListItem["Title"] = wi.DisplayName; oListItem["Description"] = wi.Description; oListItem["EventDate"] = wi.ScheduledStartDate; oListItem["EndDate"] = wi.ScheduledEndDate; oListItem.Update(); try { clientContext.ExecuteQuery(); } catch { Console.WriteLine("Can't create event on the sharepoint calendar"); Environment.Exit(3); } }
public int AddItem(string ListName, TEntity Item) { try { SP.Web web = context.Web; SP.List list = web.Lists.GetByTitle(ListName); SP.ListItemCreationInformation createInfo = new SP.ListItemCreationInformation(); SP.ListItem item = list.AddItem(createInfo); var properties = typeof(TEntity).GetProperties(); foreach (var property in properties) { if (property.PropertyType == typeof(bool?)) { item[property.Name] = property.GetValue(Item) != null?property.GetValue(Item) : -1; } else if (property.Name != "ID" && property.Name != "Created" && property.Name != "Author") { item[property.Name] = property.GetValue(Item); } } item.Update(); context.Load(item); context.ExecuteQuery(); return(item.Id); } 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) { Debug.Write(ex.Message); throw new Exception("Error getting SharePoint list data: " + ex.Message); } }
static void SharepointWorker() { string userName = "******"; string password = "******"; string siteUrl = "https://archimatika.sharepoint.com/sites/TestSiteForCustomization"; ClientContext clientContext = new ClientContext(siteUrl); //Simple auth System.Security.SecureString ssPass = new System.Security.SecureString(); foreach (char c in password) { ssPass.AppendChar(c); } ssPass.MakeReadOnly(); clientContext.Credentials = new SharePointOnlineCredentials(userName, ssPass); clientContext.Load(clientContext.Web, web => web.Title); clientContext.ExecuteQuery(); //Get List SP.List oList = clientContext.Web.Lists.GetByTitle("TestList"); var listFields = oList.Fields; clientContext.Load(listFields, fields => fields.Include(field => field.Title, field => field.InternalName)); clientContext.ExecuteQuery(); //Add record to list ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = oList.AddItem(itemCreateInfo); oListItem["Title"] = "PRJ-STG-BLD-R-SBS-001"; oListItem["GDrive_x002d_GUID"] = "530EC012-0AEC-4C13-B613-152F65416E37"; oListItem.Update(); clientContext.ExecuteQuery(); }
/// <summary> /// CreateFolder - create a folder in a document library using SharePoint Online CSOM /// </summary> /// <param name="web"></param> /// <param name="list"></param> /// <param name="folderRelativePath"></param> /// <param name="folderName"></param> /// <returns></returns> private static Microsoft.SharePoint.Client.Folder CreateFolder(Web web, Microsoft.SharePoint.Client.List list, string folderRelativePath, string folderName) { Microsoft.SharePoint.Client.Folder currentFolder = null; try { list.EnableFolderCreation = true; list.Update(); web.Context.ExecuteQuery(); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); itemCreateInfo.UnderlyingObjectType = FileSystemObjectType.Folder; itemCreateInfo.LeafName = folderName; Microsoft.SharePoint.Client.ListItem newFolder = list.AddItem(itemCreateInfo); newFolder["Title"] = folderName; newFolder.Update(); web.Context.ExecuteQuery(); Microsoft.SharePoint.Client.Folder rootFolder = list.RootFolder; web.Context.Load(rootFolder); web.Context.ExecuteQuery(); FolderCollection folders = rootFolder.Folders; web.Context.Load(folders); web.Context.ExecuteQuery(); currentFolder = list.RootFolder.Folders[list.RootFolder.Folders.Count - 1]; } catch (Exception ex) { Console.WriteLine("Error creating new folder named {0}", folderName); Console.WriteLine("Exception: {0}", ex.Message); return(null); } return(currentFolder); }
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(); } } }
public void sentdatatoSPLIst() { int sem = 0; int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem); int iYear = Year; int iSem = sem; string sSemester = LibraryMOD.GetSemesterString(iSem); string login = "******"; //give your username here string password = "******"; //give your password var securePassword = new SecureString(); foreach (char c in password) { securePassword.AppendChar(c); } string siteUrl = "https://ectacae.sharepoint.com/sites/ECTPortal/eservices/studentservices"; ClientContext clientContext = new ClientContext(siteUrl); Microsoft.SharePoint.Client.List myList = clientContext.Web.Lists.GetByTitle("Students_Requests"); ListItemCreationInformation itemInfo = new ListItemCreationInformation(); Microsoft.SharePoint.Client.ListItem myItem = myList.AddItem(itemInfo); string refno = Create16DigitString(); myItem["Title"] = refno; //myItem["RequestID"] = refno; myItem["Year"] = iYear; myItem["Semester"] = iSem; myItem["Request"] = "<b>Service ID:</b> " + lbl_ServiceID.Text + "<br/> <b>Service Name:</b> " + lbl_ServiceNameEn.Text + " (" + lbl_ServiceNameAr.Text + " )"; myItem["RequestNote"] = txt_Remarks.Text.Trim(); myItem["ServiceID"] = lbl_ServiceID.Text; myItem["Fees"] = hdf_Price.Value; //myItem["Requester"] = clientContext.Web.EnsureUser(hdf_StudentEmail.Value); myItem["Requester"] = clientContext.Web.EnsureUser("*****@*****.**"); myItem["StudentID"] = lbl_StudentID.Text; myItem["StudentName"] = lbl_StudentName.Text; myItem["Contact"] = lbl_StudentContact.Text; myItem["Finance"] = clientContext.Web.EnsureUser("*****@*****.**"); myItem["FinanceAction"] = "Initiate"; myItem["FinanceNote"] = ""; myItem["Host"] = clientContext.Web.EnsureUser("*****@*****.**"); myItem["HostAction"] = "Initiate"; myItem["HostNote"] = ""; //myItem["Provider"] = ""; myItem["ProviderAction"] = "Initiate"; myItem["ProviderNote"] = ""; myItem["Status"] = "Finance Approval Needed"; //myItem["Modified"] = DateTime.Now; //myItem["Created"] = DateTime.Now; //myItem["Created By"] = hdf_StudentEmail.Value; //myItem["Modified By"] = hdf_StudentEmail.Value; try { myItem.Update(); //if (flp_Upload.HasFile) //{ // var attachment = new AttachmentCreationInformation(); // flp_Upload.SaveAs(Server.MapPath("~/Upload/" + flp_Upload.FileName)); // string FileUrl = Server.MapPath("~/Upload/" + flp_Upload.FileName); // string filePath = FileUrl; // attachment.FileName = Path.GetFileName(filePath); // attachment.ContentStream = new MemoryStream(System.IO.File.ReadAllBytes(filePath)); // Attachment att = myItem.AttachmentFiles.Add(attachment); //} var onlineCredentials = new SharePointOnlineCredentials(login, securePassword); clientContext.Credentials = onlineCredentials; clientContext.ExecuteQuery(); //string FileUrls = Server.MapPath("~/Upload/" + flp_Upload.FileName); //System.IO.File.Delete(FileUrls); lbl_Msg.Text = "Request (ID# " + refno + ") Generated Successfully"; lbl_Msg.Visible = true; div_msg.Visible = true; lnk_Generate.Enabled = false; } catch (Exception e) { Console.WriteLine(e.Message); } //Console.ReadLine(); }
public void addAllData(string listTitle) { Web web = mClientContext.Web; SP.List projList = mClientContext.Web.Lists.GetByTitle(listTitle); Dictionary <int, Milestone> milestoneDict = mProg.getMilestoneObjMap(); bool isOrdered = false; Console.WriteLine("the error code is: " + this.mEmailError.getErrorCode()); if (this.mIsNewList == false) { readData(listTitle); isOrdered = milestonesAreOrdered(milestoneDict, false); inputMilestoneAddCommands(milestoneDict); } else { isOrdered = milestonesAreOrdered(milestoneDict, true); inputMilestoneAddCommands(milestoneDict); } if ((this.mEmailError.getErrorCode() == 0 || this.mEmailError.getErrorCode() == -1) && isOrdered == true) { ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = projList.AddItem(itemCreateInfo); Console.WriteLine("milestone size is: " + mProg.getMMilestoneSize()); oListItem["Estimated_x0020_Start_x0020_Time"] = mProg.getMEstStartTime(); oListItem["Estimated_x0020_Start_x0020_Date"] = mProg.getMEstStartDate(); oListItem["Estimated_x0020_End_x0020_Time"] = mProg.getMEstEndTime(); oListItem["Estimated_x0020_End_x0020_Date"] = mProg.getMEstEndDate(); oListItem["Actual_x0020_Start_x0020_Time"] = mProg.getMActualStartTime(); oListItem["Actual_x0020_Start_x0020_Date"] = mProg.getMActualStartDate(); oListItem["Time_x0020_Spent"] = mProg.getMTimeSpent(); oListItem["Resources"] = mProg.getMResources(); oListItem["Current_x0020_Status"] = mProg.getMCurrentStatus(); oListItem["Current_x0020_Status_x0020_Reaso"] = mProg.getMStatusReason(); List <int> addCommand = new List <int>(); List <int> updateCommand = new List <int>(); List <int> removeCommand = new List <int>(); //if(this.mIsNewList == true) //{ // foreach (var pair in mProg.getMilestoneObjMap().OrderBy(i => i.Key)) // { // Milestone milestone = pair.Value; // Console.WriteLine("the milestone command is: " + milestone.getCommand().Trim()); // if (milestone.getCommand().Trim() == "Add") // { // milestoneAddHandler(projList, oListItem, milestone); // } // } //} if (this.milestonesWithAddCommands.Count > 0) { for (int i = 0; i < this.milestonesWithAddCommands.Count; i++) { milestoneDict.TryGetValue(this.milestonesWithAddCommands[i], out Milestone milestone); if (milestone != null) { milestoneAddHandler(projList, oListItem, milestone); //if (milestone.getCommand().Trim() == "Update") //{ // updateCommand.Add(milestone.getNumber()); //} //if (milestone.getCommand().Trim() == "Remove") //{ // removeCommand.Add(milestone.getNumber()); //} } } } //foreach (var pair in mProg.getMilestoneObjMap().OrderBy(i => i.Key)) //{ // Milestone milestone = pair.Value; // Console.WriteLine("the milestone command is: " + milestone.getCommand().Trim()); // if (milestone.getCommand().Trim() == "Add") // { // addCommand.Add(milestone.getNumber()); // milestoneCommandHandler(projList, oListItem, milestone); // } // else if (milestone.getCommand().Trim() == "Update") // { // updateCommand.Add(milestone.getNumber()); // } // else if (milestone.getCommand().Trim() == "Remove") // { // removeCommand.Add(milestone.getNumber()); // } //} //updateMilestones(projList, updateCommand, removeCommand, addCommand); //Console.WriteLine("the milestone number is: " + mProg.getMMilestoneNum(pair.Key)); //} //}else if(milestone.getCommand().Trim() == "Update" || milestone.getCommand().Trim() == "Remove") //{s // milestoneCommandHandler(projList, oListItem, milestone); //} //oListItem.Update(); //mClientContext.ExecuteQuery(); //oListItem.Update(); //SP.CamlQuery myQuery = new SP.CamlQuery(); //myQuery.ViewXml = " < Where > < Eq > < FieldRef Name = 'Milestone_x0020_Number' /> <Value Type = 'Text'> 2 </Value> </ Eq > </ Where ></ View >"; //SP.ListItemCollection collectItems = projList.GetItems(myQuery); //mClientContext.Load(collectItems); Console.WriteLine("MUST UPDATE"); this.mInitialMilestoneRowCount = 0; oListItem.Update(); mClientContext.ExecuteQuery(); } else { this.mEmailError.setErrorCheck(true); if (isOrdered == false) { string mailboxAddress = mProg.getMailItem().mMailboxAddress; mEmailError.sendMilestoneTooLargeErrorEmail(mailboxAddress); this.mEmailError.setErrorCode(3); } } }
private async Task upload_new_Candidates(DataRow row, Microsoft.SharePoint.Client.ClientContext context, Microsoft.SharePoint.Client.List doclist, Microsoft.SharePoint.Client.List list) { try { Microsoft.SharePoint.Client.ListItemCollection listitems = list.GetItems(Microsoft.SharePoint.Client.CamlQuery.CreateAllItemsQuery()); context.Load(listitems); context.ExecuteQuery(); string candID; if (listitems.Count > 0) { candID = Convert.ToString(get_nextCandidateID(listitems) + 1); } else { candID = "1000"; } // row["Current_Status"] = "Creating Folders"; Folder folder = CreateFolderInternal(context.Web, doclist.RootFolder, candID + "_" + row["First_Name"] + "_" + row["Last_Name"] + "/" + row["Job"]); //row["Current_Status"] = "Uploading Files"; string[] files = Directory.GetFiles(Convert.ToString(row["Folder_path"])); await Task.Delay(1000); foreach (string filename in files) { using (var fs = new FileStream(filename, FileMode.Open)) { var fi = new FileInfo(filename); //var list = clientContext.Web.Lists.GetByTitle(listTitle); Folder targetFolder = context.Web.GetFolderByServerRelativeUrl(folder.ServerRelativeUrl); context.Load(targetFolder); context.ExecuteQuery(); var fileUrl = String.Format("{0}/{1}", targetFolder.ServerRelativeUrl, fi.Name); Microsoft.SharePoint.Client.File.SaveBinaryDirect(context, fileUrl, fs, true); } } // row["Current_Status"] = "Adding Item"; ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem newItem = list.AddItem(itemCreateInfo); FieldLookupValue lval = await GetLookupValue(ctx, Convert.ToString(row["Job"]), "Job", "JobFullName", "Text", false); newItem["CandidateID"] = candID; newItem["First_name"] = Convert.ToString(row["First_Name"]); newItem["Last_name"] = Convert.ToString(row["Last_Name"]); newItem["JobSite"] = lval; newItem["Job"] = Convert.ToString(row["Job"]); newItem["DOB"] = Convert.ToString(row["DOB"]); // double percent = Convert.ToDouble(no_of_passes) / Convert.ToDouble(dt.Rows.Count); // string hireStatus = ""; newItem["Hire_Status"] = Convert.ToString(row["Pass_Status"]); //if (percent >= 0.7 && percent < 1.0) //{ // newItem["Hire_Status"] = hireStatus; // // hireStatus = "Conditional Hire"; //} //else //{ // newItem["Hire_Status"] = "Hired"; // hireStatus = "Hired"; //} string tempFolderurl = folder.ServerRelativeUrl; FieldUrlValue _url = new FieldUrlValue(); _url.Url = tempFolderurl.Substring(0, tempFolderurl.LastIndexOf('/'));; _url.Description = "View Tests"; newItem["FolderUrl"] = _url; newItem["Remaining_Test"] = Convert.ToString(row["Remaining_Test"]); newItem["Category"] = Convert.ToString(row["Position"]);; //newItem["FolderUrl"] = folder.ServerRelativeUrl; newItem.Update(); context.Load(list); context.ExecuteQuery(); await Task.Delay(1000); // row["Current_Status"] = "Uploaded"; XmlNode deleteNode = read_local_data_store(xmlDoc, row); if (deleteNode != null) { deleteNode.ParentNode.RemoveChild(deleteNode); } await Task.Delay(1000); xmlDoc.Save(get_local_data_path() + cmbxJobList.SelectedValue + "\\" + "History.xml"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static bool EmailData(List <ITAssets> updationList, string siteUrl, string listName) { bool retValue = false; try { using (MSC.ClientContext context = CustomSharePointUtility.GetContext(siteUrl)) { //List<Mailing> varx = new List<Mailing>(); MSC.List list = context.Web.Lists.GetByTitle(listName); for (var i = 0; i < updationList.Count; i++) { var updateList = updationList.Skip(i).Take(1).ToList(); if (updateList != null && updateList.Count > 0) { foreach (var updateItem in updateList) { MSC.ListItem listItem = null; MSC.ListItemCreationInformation itemCreateInfo = new MSC.ListItemCreationInformation(); listItem = list.AddItem(itemCreateInfo); var obj = new Object(); //Mailing data = new Mailing(); //var _From = ""; var _To = ""; //var _Cc = ""; var _Body = ""; var _Subject = ""; if (updateItem.StatusId == "0") { _To = updateItem.FunctionalHead; } else { _To = updateItem.AssignedApprover; } _Subject = "Gentle Reminder"; // + updateItem.ExpVoucherNo + " Travel Voucher Approval is Pending _Body += "Dear User, <br><br>This is to inform you that below request is pending for your Approval."; _Body += "<br><b>Workflow Name :</b> IT Asset Requisition "; _Body += "<br><b>Request No :</b> " + updateItem.RequisitionNo; _Body += "<br><b>Date of Requisition :</b> " + updateItem.StartOn; _Body += "<br><b>Requested By : </b> " + updateItem.EmployeeName; _Body += "<br><b>Location :</b> " + updateItem.Location; _Body += "<br><b>Department :</b> " + updateItem.Department; _Body += "<br><b>Designation :</b> " + updateItem.Designation; _Body += "<br><b>Buisness :</b> " + updateItem.Business; _Body += "<br><b>Reporting to :</b> " + updateItem.ReportingTo; if (updateItem.Asset == "Desktop") { _Body += "<br><b>IT Asset Request for :</b> " + updateItem.Asset; } else { _Body += "<br><b>Based on Work Level :</b> " + updateItem.Asset; } _Body += "<br><b>New Joinee Employee :</b> " + updateItem.NewJoineeEmpName; _Body += "<br><b>New Employee designation :</b> " + updateItem.NewEmployeeDesignation; _Body += "<br><b>Replacement Of :</b> " + updateItem.ReplacementEmployeeName; if (updateItem.StatusId == "0") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "1") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "4") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "5") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "6") { _Body += "<br><b>Status :</b> " + updateItem.Status; } else if (updateItem.StatusId == "7") { _Body += "<br><b>Status :</b> " + updateItem.Status; } _Body += "<br><h3>Kindly provide your approval</h3>"; _Body += "<br><h3>For Approval Please Click in the below link</h3>"; if (updateItem.StatusId == "0") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "1") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "4") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "5") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "6") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } else if (updateItem.StatusId == "7") { _Body += "<br><a href=\"https://aparindltd.sharepoint.com/ITAssetRequisition/SitePages/PendingForMe.aspx?StatusId=" + updateItem.StatusId + "&RequisitionNo=\">View Link</a>"; } //data.MailTo = _From; //data.MailTo = _To; //data.MailCC = _Cc; //data.MailSubject = _Subject; //data.MailBody = _Body; //varx.Add(data); listItem["ToUser"] = _To; listItem["MailSubject"] = _Subject; listItem["MailBody"] = _Body; listItem.Update(); } try { context.ExecuteQuery(); retValue = true; } catch (Exception ex) { CustomSharePointUtility.WriteLog(string.Format("Error in InsertUpdate_EmployeeMaster ( context.ExecuteQuery();): Error ({0}) ", ex.Message)); return(false); //continue; } } } } } catch (Exception ex) { CustomSharePointUtility.WriteLog(string.Format("Error in InsertUpdate_EmployeeMaster: Error ({0}) ", ex.Message)); } return(retValue); }
public static bool EmailData(PurchaseOrder updationList, string FunctionalHeadEmail, string PurchaseHead, string PlantHead, string MD, string siteUrl, string listName) { bool retValue = false; try { using (MSC.ClientContext context = CustomSharePointUtility.GetContext(siteUrl)) { //List<Mailing> varx = new List<Mailing>(); MSC.List list = context.Web.Lists.GetByTitle(listName); //for (var i = 0; i < updationList.Count; i++) //{ //var updateList = updationList.Skip(i).Take(1).ToList(); //if (updateList != null && updateList.Count > 0) //{ // foreach (var updateItem in updateList) // { MSC.ListItem listItem = null; MSC.ListItemCreationInformation itemCreateInfo = new MSC.ListItemCreationInformation(); listItem = list.AddItem(itemCreateInfo); var obj = new Object(); //Mailing data = new Mailing(); //var _From = ""; var _To = ""; //var _Cc = ""; var _Body = ""; var _Subject = ""; if (updationList.ApprovalStatus == "Submitted" && updationList.LocationType == "Office") { _To = FunctionalHeadEmail; } else if (updationList.ApprovalStatus == "Approved By Functional Head" && updationList.LocationType == "Office") { _To = MD; } else if (updationList.ApprovalStatus == "Submitted" && updationList.LocationType == "Plant") { _To = PurchaseHead; } else if (updationList.ApprovalStatus == "Approved By Purchase Head" && updationList.LocationType == "Plant") { _To = PlantHead; } else if (updationList.ApprovalStatus == "Approved By Plant Head" && Convert.ToInt32(updationList.POCost) > 50000 && updationList.LocationType == "Plant") { _To = MD; } _Subject = "Gentle Reminder"; _Body += "Dear User, <br><br>This is to inform you that below request is pending for your Approval."; _Body += "<br><b>Workflow Name :</b> Purchase Order "; _Body += "<br><b>Voucher No :</b> " + updationList.POReferenceNumber; _Body += "<br><b>Date of Creation :</b> " + updationList.Created; _Body += "<br><b>Employee : </b> " + updationList.Author; _Body += "<br><b>Department :</b> " + updationList.DepartmentName; _Body += "<br><b>Location :</b> " + updationList.LocationName; _Body += "<br><b>PO No : </b> " + updationList.PONumber; _Body += "<br><b> PO Amount : </b> " + updationList.POCost; _Body += "<br><b> Material Details : </b> " + updationList.MaterialDetails; if (updationList.ApprovalStatus == "Submitted" && updationList.LocationType == "Office") { _Body += "<br><b>Status :</b> Pending With Functional Head"; } else if (updationList.ApprovalStatus == "Approved By Functional Head" && updationList.LocationType == "Office") { _Body += "<br><b>Status :</b> Pending With MD"; } else if (updationList.ApprovalStatus == "Submitted" && updationList.LocationType == "Plant") { _Body += "<br><b>Status :</b> Pending With Purchase Head"; } else if (updationList.ApprovalStatus == "Approved By Purchase Head" && updationList.LocationType == "Plant") { _Body += "<br><b>Status :</b> Pending With Plant Head"; } else if (updationList.ApprovalStatus == "Approved By Plant Head" && Convert.ToInt32(updationList.POCost) > 50000 && updationList.LocationType == "Plant") { _Body += "<br><b>Status :</b> Pending With MD"; } _Body += "<br><h3>Kindly provide your approval</h3>"; _Body += "<br><h3>For Approval Please Click in the below link</h3>"; if (updationList.ApprovalStatus == "Submitted" && updationList.LocationType == "Office") { // _Body += "<br><a href=\"https://aparindltd.sharepoint.com/PurchaseOrder/SitePages/PendingWithFunctionalHead.aspx\">View Link</a>"; } else if (updationList.ApprovalStatus == "Approved By Functional Head" && updationList.LocationType == "Office") { // _Body += "<br><a href=\"https://aparindltd.sharepoint.com/PurchaseOrder/SitePages/PendingWithMD.aspx\">View Link</a>"; } else if (updationList.ApprovalStatus == "Submitted" && updationList.LocationType == "Plant") { // _Body += "<br><a href=\"https://aparindltd.sharepoint.com/PurchaseOrder/SitePages/PendingWithPurchaseHead.aspx\">View Link</a>"; } else if (updationList.ApprovalStatus == "Approved By Purchase Head" && updationList.LocationType == "Plant") { // _Body += "<br><a href=\"https://aparindltd.sharepoint.com/PurchaseOrder/SitePages/PendingWithPlantHead.aspx\">View Link</a>"; } else if (updationList.ApprovalStatus == "Approved By Plant Head" && updationList.LocationType == "Plant") { // _Body += "<br><a href=\"https://aparindltd.sharepoint.com/PurchaseOrder/SitePages/PendingWithManagingDirector.aspx\">View Link</a>"; } //data.MailTo = _From; //data.MailTo = _To; //data.MailCC = _Cc; //data.MailSubject = _Subject; //data.MailBody = _Body; //varx.Add(data); listItem["ToUser"] = _To; listItem["SubjectDesc"] = _Subject; listItem["BodyDesc"] = _Body; if (_To != "") { listItem.Update(); } try { context.ExecuteQuery(); retValue = true; } catch (Exception ex) { CustomSharePointUtility.WriteLog(string.Format("Error in InsertUpdate_EmployeeMaster ( context.ExecuteQuery();): Error ({0}) ", ex.Message)); return(false); //continue; } } // } // } //} //} } catch (Exception ex) { CustomSharePointUtility.WriteLog(string.Format("Error in InsertUpdate_EmployeeMaster: Error ({0}) ", ex.Message)); } return(retValue); }
public static bool EmailDataPlant(PurchaseOrder updationList, string siteUrl, string listName) { bool retValue = false; try { using (MSC.ClientContext context = CustomSharePointUtility.GetContext(siteUrl)) { //List<Mailing> varx = new List<Mailing>(); MSC.List list = context.Web.Lists.GetByTitle(listName); MSC.ListItem listItem = null; MSC.ListItemCreationInformation itemCreateInfo = new MSC.ListItemCreationInformation(); listItem = list.AddItem(itemCreateInfo); var obj = new Object(); var _To = ""; var _Body = ""; var _Subject = ""; _To = updationList.CurrentApprover; _Subject = "Gentle Reminder"; _Body += "Dear User, <br><br>This is to inform you that below request is pending for your Approval."; _Body += "<br><b>Workflow Name :</b> Purchase Order "; _Body += "<br><b>Voucher No :</b> " + updationList.POReferenceNumber; _Body += "<br><b>Date of Creation :</b> " + updationList.Created; _Body += "<br><b>Employee : </b> " + updationList.Author; _Body += "<br><b>Department :</b> " + updationList.DepartmentName; _Body += "<br><b>Location :</b> " + updationList.LocationName; _Body += "<br><b>PO No : </b> " + updationList.PONumber; _Body += "<br><b> PO Amount : </b> " + updationList.POCost; _Body += "<br><b> Material Details : </b> " + updationList.MaterialDetails; if (updationList.NewStatus == "1") { _Body += "<br><b>Status :</b> Pending With Purchase Head"; } else if (updationList.NewStatus == "2") { _Body += "<br><b>Status :</b> Pending With Plant Head"; } _Body += "<br><h3>Kindly provide your approval</h3>"; _Body += "<br><h3>For Approval Please Click in the below link</h3>"; if (updationList.NewStatus == "1") { /// _Body += "<br><a href=\"https://aparindltd.sharepoint.com/PurchaseOrder/SitePages/PendingWithApprover.aspx\">View Link</a>"; } else if (updationList.NewStatus == "2") { /// _Body += "<br><a href=\"https://aparindltd.sharepoint.com/PurchaseOrder/SitePages/PendingWithManagingDirector.aspx\">View Link</a>"; } listItem["ToUser"] = _To; listItem["SubjectDesc"] = _Subject; listItem["BodyDesc"] = _Body; if (_To != "") { listItem.Update(); } try { context.ExecuteQuery(); retValue = true; } catch (Exception ex) { CustomSharePointUtility.WriteLog(string.Format("Error in InsertUpdate_EmployeeMaster ( context.ExecuteQuery();): Error ({0}) ", ex.Message)); return(false); //continue; } } } catch (Exception ex) { CustomSharePointUtility.WriteLog(string.Format("Error in InsertUpdate_EmployeeMaster: Error ({0}) ", ex.Message)); } return(retValue); }