public void Insert2(Dictionary <string, object> dicList, string html, int menuID, string imgUri, string filename, string filePath) { if (NeedInsertDB) { string sql1 = string.Format("select * from dbo.SchoolStyle where dbo.SchoolStyle.Description ='{0}'", dicList["Title"]); string error1 = ""; List <cm> cmList = DBManage.ExcuteEntity <cm>(sql1, System.Data.CommandType.Text, out error1); if (cmList.Count < 1) { int modeType = 0; if (dicList.ContainsKey("_x6a21__x7248_")) { if (dicList["_x6a21__x7248_"] != null) { modeType = 1; } } Microsoft.SharePoint.Client.FieldUserValue vvv = dicList["Author"] as Microsoft.SharePoint.Client.FieldUserValue; string creator = vvv.LookupValue; html = html.Replace("'", "''"); string sql = string.Format("insert into SchoolStyle(MenuId,Title,[Description],CreateTime,ImageUrl,ClickNum,ModelType,IsDelete,Creator,FileName,FilePath) values({0},'{1}','{2}','{3}','{4}',{5},{6},{7},'{8}','{9}','{10}')", menuID, dicList["Title"], html, dicList["Created"], imgUri, dicList["Count"], modeType, 0, creator, filename, filePath); string error = ""; DBManage.Transaction(sql, out error); } } }
public static string GetDisplayValue(this SPClient.FieldUserValue value) { if (value == null) { return(string.Empty); } return(string.Format("{0};#{1}", value.LookupId, value.LookupValue)); }
private dynamic ChangeValue(dynamic value) { // Try and lookup object-based fields switch (value.ToString()) { case "Microsoft.SharePoint.Client.FieldUserValue": SP.FieldUserValue uField = (SP.FieldUserValue)value; value = uField.LookupValue.ToString(); break; case "Microsoft.SharePoint.Client.FieldLookupValue[]": value = null; break; } return(value); }
public object FromUser(bool allowMultipleValues, string users) { object value = null; if (!string.IsNullOrEmpty(users)) { if (!allowMultipleValues) { value = SP.FieldUserValue.FromUser(users.Trim(';')); } else { var names = users.Trim(';').Split(';'); var fieldValue = new SP.FieldUserValue[names.Count()]; for (int i = 0; i < names.Length; i++) { fieldValue[i] = SP.FieldUserValue.FromUser(names[i]); } value = fieldValue; } } return(value); }
public static Post QueryPostDetail(string postTitle, string category) { try { Post post = new Post(); Microsoft.SharePoint.Client.ListItemCollection coll = DAT.DataQuery.QueryListItems(string.Format(PostModel.postsSiteUrl, category), PostModel.postsListName, string.Format(PostModel.postDetailCamlQueryByTitle, postTitle)); if (coll.Count > 0 && coll[0] != null) { SP.ListItem item = coll[0]; post.Id = Convert.ToInt32(item["ID"]); SP.FieldUserValue author = (SP.FieldUserValue)item["Author"]; post.Author = author.LookupValue.ToString(); post.Title = postTitle; post.Body = HLP.TransformHtmlStringForGlobalAsax(item["Body"].ToString()); post.PublishedDate = Convert.ToDateTime(item["PublishedDate"]); post.CategoryName = category; } return(post); } catch (Exception) { throw; } }
public void Insert(Dictionary <string, object> dicList, string html, int menuID, string imgUri, string filename, string filePath) { if (NeedInsertDB) { int modeType = 0; if (dicList.ContainsKey("_x6a21__x7248_")) { if (dicList["_x6a21__x7248_"] != null) { modeType = 1; } } Microsoft.SharePoint.Client.FieldUserValue vvv = dicList["Author"] as Microsoft.SharePoint.Client.FieldUserValue; string creator = vvv.LookupValue; html = html.Replace("'", "''"); string sql = string.Format("insert into Advertising(MenuId,[Description], CreativeHTML,CreateTime,ImageUrl,ClickNum,ModelType,IsDelete,Creator,FileName,FilePath,isPush) values({0},'{1}','{2}','{3}','{4}',{5},{6},{7},'{8}','{9}','{10}',{11})", menuID, dicList["Title"], html, dicList["Created"], imgUri, dicList["Count"], modeType, 0, creator, filename, filePath, 1); string error = ""; DBManage.Transaction(sql, out error); } }
private void AddUsers(string siteName, string siteUrl, frm_Data_User userForm) { ClientContext clientContext = SharePoint.GetClient(siteUrl, frm_Main_Menu.username, frm_Main_Menu.password); Web web = clientContext.Web; // Instantiates the User Information List SP.List userList = web.SiteUserInfoList; // Get the current user SP.User user = web.CurrentUser; // Initialise row counter int rowNum = 0; // Create a new Caml Query CamlQuery camlQuery = new CamlQuery(); // Set the XML camlQuery.ViewXml = "<View><Query>{0}</Query></View>"; // Define a collection to store the list items in ListItemCollection collListItem = userList.GetItems(camlQuery); // Load in the items clientContext.Load(collListItem, icol => icol.Include(i => i.ContentType)); clientContext.Load(collListItem); // Attempt to retreive the List Items try { clientContext.ExecuteQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } foreach (SP.ListItem oListItem in collListItem) { // Increment counter rowNum++; int id = (int)oListItem.FieldValues["ID"]; object firstName = oListItem.FieldValues["FirstName"]; object lastName = oListItem.FieldValues["LastName"]; object fullName = oListItem.FieldValues["Title"]; object userName = oListItem.FieldValues["UserName"]; object email = oListItem.FieldValues["EMail"]; object sipAddress = oListItem.FieldValues["SipAddress"]; object isSiteAdmin = oListItem.FieldValues["IsSiteAdmin"]; object deleted = oListItem.FieldValues["Deleted"]; object hidden = oListItem.FieldValues["UserInfoHidden"]; object isActive = oListItem.FieldValues["IsActive"]; string ContentTypeName = oListItem.ContentType.Name; object guid = oListItem.FieldValues["GUID"]; DateTime createDate = Convert.ToDateTime(oListItem.FieldValues["Created"]); SP.FieldUserValue author = (SP.FieldUserValue)oListItem.FieldValues["Author"]; string createUser = author.LookupValue.ToString(); DateTime modifyDate = Convert.ToDateTime(oListItem.FieldValues["Modified"]); SP.FieldUserValue editor = (SP.FieldUserValue)oListItem.FieldValues["Editor"]; string modifyUser = editor.LookupValue.ToString(); if (firstName != null) { //System.Diagnostics.Debugger.Break(); } userForm.AddRow ( rowNum, id, firstName, lastName, fullName, userName, email, sipAddress, isSiteAdmin, deleted, hidden, isActive, ContentTypeName, guid, createDate, createUser, modifyDate, modifyUser ); lbl_Row_Count.Text = rowNum.ToString() + " record(s) found"; lbl_Row_Count.Refresh(); if (rowNum >= nud_Row_Limit.Value && nud_Row_Limit.Value != 0) { break; } } }
public string InsertEmailSubjectSerial(string subject, string status, SubjectTopic subjectTopicValue, SubjectType subjectTypeValue, Microsoft.Office.Interop.Outlook.MailItem mailItem) { try { Guid g = Guid.NewGuid(); string siteUrl = Properties.Settings.Default.ClientContextUrl; using (var clientContext = new AuthenticationManager().GetAppOnlyAuthenticatedContext(siteUrl, Properties.Settings.Default.ClientId, Properties.Settings.Default.ClientSecret)) { Web oWebsite = clientContext.Web; ListCollection collList = oWebsite.Lists; SP.List oList = collList.GetByTitle("EmailSubject_Serial"); ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation(); ListItem oListItem = oList.AddItem(itemCreateInfo); // type section////////////////////////////////////// FieldLookupValue typeFieldLookupValue = new FieldLookupValue(); //GetLookupFieldValue(subjectTypeValue.Title, "EmailSubject_Types"); typeFieldLookupValue.LookupId = subjectTypeValue.ID; if (typeFieldLookupValue != null) { oListItem["ParentType"] = typeFieldLookupValue; } //////////////////////////////////////////////////////////////// // tpoic section////////////////////////////////////// FieldLookupValue topicFieldLookupValue = new FieldLookupValue(); topicFieldLookupValue.LookupId = subjectTopicValue.ID; //FieldLookupValue topicFieldLookupValue = GetLookupFieldValue(subjectTopicValue.Title, "EmailSubject_Topics"); if (topicFieldLookupValue != null) { oListItem["ParentTopic"] = topicFieldLookupValue; } //////////////////////////////////////////////////////////////// // status section////////////////////////////////////// oListItem["Status"] = status; //Pending Comfirmed /////////////////////////////////////////////////////// // user section////////////////////////////////////////// var usr = getEnsureUser(mailItem); if (usr == null) { return(""); } Microsoft.SharePoint.Client.FieldUserValue _userValue = new Microsoft.SharePoint.Client.FieldUserValue(); _userValue.LookupId = usr.Id; oListItem["User"] = _userValue; /////////////////////////////////////////////////////////////// // title section/////////////////////////////////////////////// oListItem["Title"] = g.ToString(); //////////////////////////////////////////////////////////////// oListItem.Update(); clientContext.ExecuteQuery(); int id = oListItem.Id; string subjectToReturn = ""; oListItem["Title"] = string.Format("[{0:D}-{1:D}-{2:D}] {3:D}", subjectTopicValue.Code, subjectTypeValue.Code, id, subject); subjectToReturn = string.Format("[{0:D}-{1:D}-{2:D}] {3:D}", subjectTopicValue.Code, subjectTypeValue.Code, id, subject); oListItem.Update(); clientContext.ExecuteQuery(); return(subjectToReturn); } } catch (Exception ex) { return(""); throw new Exception(ex.ToString()); } }
public static bool EmailData(List <Employee> PendingEmployee, 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); // MSC.UserCollection users = new MSC.UserCollection(); //MSC.FieldUserValue fieldUserValue = new MSC.FieldUserValue(); MSC.FieldUserValue[] userValueCollection = new MSC.FieldUserValue[PendingEmployee.Count]; for (var i = 0; i < PendingEmployee.Count; i++) { MSC.FieldUserValue fieldUserVal = new MSC.FieldUserValue(); fieldUserVal.LookupId = Convert.ToInt32(PendingEmployee[i].EmployeeID); userValueCollection.SetValue(fieldUserVal, i); } //var _From = ""; var _To = ""; //var _Cc = ""; var _Body = ""; var _Subject = ""; _To = "1247"; _Subject = "Sales Estimate is not submitted"; _Body += "Dear User, <br><br>This is to inform you that still your Sales Estimate is not submitted kindly fill and submit on priority.<br><br>Kindly click on below link for submit estimate"; _Body += "<br><a href=" + siteUrl + "/SitePages/NewRequest.aspx>Submit Estimate</ a>"; listItem["ToUser"] = userValueCollection; listItem["SubjectDesc"] = _Subject; listItem["BodyDesc"] = _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); }