public static int RetrieveUserId(string key) { var ctx = SharePointOnlineHelper.GetElevatedContext(); using (ctx) { var user = ctx.Web.EnsureUser(key); ctx.Load(user); ctx.ExecuteQuery(); return(user.Id); } }
public static User GetUser(string key) { var ctx = SharePointOnlineHelper.GetElevatedContext(); using (ctx) { var user = ctx.Web.EnsureUser(key); ctx.Load(user); ctx.ExecuteQuery(); return(new User() { value = user.LoginName, text = user.Title }); } }
public static ListItem ToSPListItem(Talent talent, ListItem listItem) { //var Names = talent.Name.text.Split(ConfigurationManager.AppSettings["name_delimiter"][0]); //var firstNamePosition = int.Parse(ConfigurationManager.AppSettings["first_name_position"].ToString()); //var lastNamePosition = int.Parse(ConfigurationManager.AppSettings["last_name_position"].ToString()); int firstNamePosition, lastNamePosition = default(int); string forename, surname = default(string); string[] Names = default(string[]); if (!string.IsNullOrEmpty(talent.Name.value)) { Names = talent.Name.text.Split(ConfigurationManager.AppSettings["name_delimiter"][0]); firstNamePosition = int.Parse(ConfigurationManager.AppSettings["first_name_position"].ToString()); lastNamePosition = int.Parse(ConfigurationManager.AppSettings["last_name_position"].ToString()); forename = Names[firstNamePosition]; surname = Names[lastNamePosition]; } else { forename = talent.Name.ForeName; surname = talent.Name.Surname; } listItem[KTPConstants.Talent_Record_Division] = talent.Division; listItem[KTPConstants.Talent_Record_Business_Stream] = talent.Stream; listItem[KTPConstants.Talent_Record_Business_Unit] = talent.Unit; listItem[KTPConstants.Talent_Record_Business_Risk] = talent.BusinessRisk; listItem[KTPConstants.Talent_Record_Development_Notes] = talent.Notes; listItem[KTPConstants.Talent_Record_Employee_Id] = talent.EmployeeId; listItem[KTPConstants.Talent_Record_Flight_Risk] = talent.FlightRisk; listItem[KTPConstants.Talent_Record_Function] = talent.Function; listItem[KTPConstants.Talent_Record_Grade] = talent.Grade; listItem[KTPConstants.Talent_Record_Location] = talent.Location; listItem[KTPConstants.Talent_Record_Movement] = talent.Movement; listItem[KTPConstants.Talent_Record_Performance] = talent.Performance; listItem[KTPConstants.Talent_Record_Potential] = talent.Potential; listItem[KTPConstants.Talent_Record_Submission_Year] = talent.SubmissionYear; listItem[KTPConstants.Talent_Record_Position] = talent.Position; listItem[KTPConstants.Talent_Record_Title] = talent.EmployeeId; listItem[KTPConstants.Talent_Record_Gender] = talent.Gender; listItem[KTPConstants.Talent_Record_ReportingUnit] = talent.ReportingUnit; listItem[KTPConstants.Talent_Record_IsLeaver] = talent.IsLeaver; listItem[KTPConstants.Talent_Record_Is_Current_Submission] = talent.IsCurrentSubmission; //listItem[KTPConstants.Talent_Record_AreaHeadName] = talent.AreaHeadName; listItem[KTPConstants.Talent_Record_Manager_Name] = talent.ManagerName; listItem[KTPConstants.Talent_Record_Area_Head] = (talent.AreaHead != null) ? SharePointOnlineHelper.ResolveUser(talent.AreaHead.value) : null; if (talent.AreaHead != null) { if (string.IsNullOrEmpty(talent.AreaHead.value)) { listItem[KTPConstants.Talent_Record_AreaHeadName] = talent.AreaHead.Surname + ", " + talent.AreaHead.ForeName; } else { listItem[KTPConstants.Talent_Record_AreaHeadName] = talent.AreaHead.text; } } listItem[KTPConstants.Talent_Record_Manager] = SharePointOnlineHelper.ResolveUser(talent.Manager.value); if (!string.IsNullOrEmpty(talent.Name.value)) { listItem[KTPConstants.Talent_Record_Employee] = SharePointOnlineHelper.ResolveUser(talent.Name.value); } listItem[KTPConstants.Talent_Record_Manager] = SharePointOnlineHelper.ResolveUser(talent.Manager.value); if (string.IsNullOrEmpty(talent.Manager.value)) { listItem[KTPConstants.Talent_Record_Manager_Name] = talent.Manager.Surname + ", " + talent.Manager.ForeName; } else { listItem[KTPConstants.Talent_Record_Manager_Name] = talent.Manager.text; } listItem[KTPConstants.Talent_Record_First_Name] = forename.Trim(); listItem[KTPConstants.Talent_Record_Last_Name] = surname.Trim(); listItem[KTPConstants.Talent_Record_Grid_Rating] = talent.CalculateGridRating(); listItem[KTPConstants.Talent_Record_First_Development_Requirement_Category] = talent.Requirements_01_category; listItem[KTPConstants.Talent_Record_First_Development_Requirement_SubCategory] = talent.Requirements_01_subcategory; listItem[KTPConstants.Talent_Record_First_Development_Requirement_Title] = talent.Requirements_01_title; listItem[KTPConstants.Talent_Record_Second_Development_Requirement_Category] = talent.Requirements_02_category; listItem[KTPConstants.Talent_Record_Second_Development_Requirement_SubCategory] = talent.Requirements_02_subcategory; listItem[KTPConstants.Talent_Record_Second_Development_Requirement_Title] = talent.Requirements_02_title; listItem[KTPConstants.Talent_Record_Position] = talent.Position; //listItem["ID"] = talent.Id; return(listItem); /* * i:0#.f|membership|[email protected] * i: 0#.f|membership|[email protected] */ }
public static Talent FromSPListItem(ListItem item) { var talent = new Talent(); talent.Division = (item[KTPConstants.Talent_Record_Division] != null) ? item[KTPConstants.Talent_Record_Division].ToString() : ""; talent.Stream = (item[KTPConstants.Talent_Record_Business_Stream] != null) ? item[KTPConstants.Talent_Record_Business_Stream].ToString() : ""; talent.Unit = (item[KTPConstants.Talent_Record_Business_Unit] != null) ? item[KTPConstants.Talent_Record_Business_Unit].ToString() : ""; talent.BusinessRisk = (item[KTPConstants.Talent_Record_Business_Risk] != null) ? item[KTPConstants.Talent_Record_Business_Risk].ToString() : ""; talent.Notes = (item[KTPConstants.Talent_Record_Development_Notes] != null) ? item[KTPConstants.Talent_Record_Development_Notes].ToString() : ""; talent.EmployeeId = (item[KTPConstants.Talent_Record_Employee_Id] != null) ? item[KTPConstants.Talent_Record_Employee_Id].ToString() : ""; talent.FlightRisk = (item[KTPConstants.Talent_Record_Flight_Risk] != null) ? item[KTPConstants.Talent_Record_Flight_Risk].ToString() : ""; talent.Function = (item[KTPConstants.Talent_Record_Function] != null) ? item[KTPConstants.Talent_Record_Function].ToString() : ""; talent.Grade = (item[KTPConstants.Talent_Record_Grade] != null) ? item[KTPConstants.Talent_Record_Grade].ToString() : ""; talent.Location = (item[KTPConstants.Talent_Record_Location] != null) ? item[KTPConstants.Talent_Record_Location].ToString() : ""; talent.Movement = (item[KTPConstants.Talent_Record_Movement] != null) ? item[KTPConstants.Talent_Record_Movement].ToString() : ""; talent.Performance = (item[KTPConstants.Talent_Record_Performance] != null) ? item[KTPConstants.Talent_Record_Performance].ToString() : ""; talent.Potential = (item[KTPConstants.Talent_Record_Potential] != null) ? item[KTPConstants.Talent_Record_Potential].ToString() : ""; talent.IsCurrentSubmission = (item[KTPConstants.Talent_Record_Is_Current_Submission] != null) ? bool.Parse(item[KTPConstants.Talent_Record_Is_Current_Submission].ToString()) : false; talent.SubmissionYear = (item[KTPConstants.Talent_Record_Submission_Year] != null) ? int.Parse(item[KTPConstants.Talent_Record_Submission_Year].ToString()) : -1; talent.Id = (item["ID"] != null) ? int.Parse(item["ID"].ToString()) : -1; talent.ManagerName = (item[KTPConstants.Talent_Record_Manager_Name] != null) ? item[KTPConstants.Talent_Record_Manager_Name].ToString() : ""; talent.AreaHeadName = (item[KTPConstants.Talent_Record_AreaHeadName] != null) ? item[KTPConstants.Talent_Record_AreaHeadName].ToString() : ""; //talent.Name = string.Concat(surname, ", " + forename); talent.Name = (item[KTPConstants.Talent_Record_Employee] != null) ? SharePointOnlineHelper.GetUser(((FieldUserValue)item[KTPConstants.Talent_Record_Employee]).Email.ToString()) : new User(); if (talent.Name != null) { talent.Name.ForeName = (item[KTPConstants.Talent_Record_First_Name] != null) ? item[KTPConstants.Talent_Record_First_Name].ToString() : string.Empty; talent.Name.Surname = (item[KTPConstants.Talent_Record_Last_Name] != null) ? item[KTPConstants.Talent_Record_Last_Name].ToString() : string.Empty; } talent.AreaHead = (item[KTPConstants.Talent_Record_Area_Head] != null) ? SharePointOnlineHelper.GetUser(((FieldUserValue)item[KTPConstants.Talent_Record_Area_Head]).Email.ToString()) : new User(); talent.Manager = (item[KTPConstants.Talent_Record_Manager] != null) ? SharePointOnlineHelper.GetUser(((FieldUserValue)item[KTPConstants.Talent_Record_Manager]).Email.ToString()) : new User(); talent.Requirements_01_category = (item[KTPConstants.Talent_Record_First_Development_Requirement_Category] != null) ? item[KTPConstants.Talent_Record_First_Development_Requirement_Category].ToString() : ""; talent.Requirements_01_subcategory = (item[KTPConstants.Talent_Record_First_Development_Requirement_SubCategory] != null) ? item[KTPConstants.Talent_Record_First_Development_Requirement_SubCategory].ToString() : ""; talent.Requirements_01_title = (item[KTPConstants.Talent_Record_First_Development_Requirement_Title] != null) ? item[KTPConstants.Talent_Record_First_Development_Requirement_Title].ToString() : ""; talent.Requirements_02_category = (item[KTPConstants.Talent_Record_Second_Development_Requirement_Category] != null) ? item[KTPConstants.Talent_Record_Second_Development_Requirement_Category].ToString() : ""; talent.Requirements_02_subcategory = (item[KTPConstants.Talent_Record_Second_Development_Requirement_SubCategory] != null) ? item[KTPConstants.Talent_Record_Second_Development_Requirement_SubCategory].ToString() : ""; talent.Requirements_02_title = (item[KTPConstants.Talent_Record_Second_Development_Requirement_Title] != null) ? item[KTPConstants.Talent_Record_Second_Development_Requirement_Title].ToString() : ""; talent.Position = (item[KTPConstants.Talent_Record_Position] != null) ? item[KTPConstants.Talent_Record_Position].ToString() : ""; talent.GridRating = (item[KTPConstants.Talent_Record_Grid_Rating] != null) ? item[KTPConstants.Talent_Record_Grid_Rating].ToString() : ""; talent.ReportingUnit = (item[KTPConstants.Talent_Record_ReportingUnit] != null) ? item[KTPConstants.Talent_Record_ReportingUnit].ToString() : ""; talent.Gender = (item[KTPConstants.Talent_Record_Gender] != null) ? item[KTPConstants.Talent_Record_Gender].ToString() : ""; talent.IsLeaver = (item[KTPConstants.Talent_Record_IsLeaver] != null) ? bool.Parse(item[KTPConstants.Talent_Record_IsLeaver].ToString()) : false; return(talent); }