public GradesViewModel DemoPost(GradesViewModel vm) { try { ProjectTokenHelper.CheckValidAccessToken(vm.spHostURL, vm.accessToken); using (ClientContext clientContext = TokenHelper.GetClientContextWithAccessToken(vm.spHostURL, vm.accessToken)) { //vm.Grade.CourseTitle = "API Response: " + vm.Grade.CourseTitle; //vm.Grade.Passed = "API Response: " + vm.Grade.Passed; // The SharePoint web site contains a list called "Student Gradebook" - grab and store it in a List variable. // Linking to the list, like finding a table in a database List studentGradebook = clientContext.Web.Lists.GetByTitle("Student Gradebook"); // Create the list item, and set the property value. ListItemCreationInformation itemCreationInfo = new ListItemCreationInformation(); ListItem newItem = studentGradebook.AddItem(itemCreationInfo); newItem["Title"] = vm.Grade.CourseTitle; newItem["Result"] = vm.Grade.Passed; newItem.Update(); clientContext.ExecuteQuery(); } } catch (Exception) { } return(vm); }
public SampleViewModel DemoPost(SampleViewModel vm) { try { ProjectTokenHelper.CheckValidAccessToken(vm.spHostURL, vm.accessToken); using (ClientContext clientContext = TokenHelper.GetClientContextWithAccessToken(vm.spHostURL, vm.accessToken)) { vm.Title = "API Response: " + vm.Title; vm.Description = "API Response: " + vm.Description; } } catch (Exception) { } return(vm); }
public SampleTokenModel GetMyLogin(SampleTokenModel vm) { SampleTokenModel result = new SampleTokenModel(); try { ProjectTokenHelper.CheckValidAccessToken(vm.spHostURL, vm.accessToken); using (ClientContext clientContext = TokenHelper.GetClientContextWithAccessToken(vm.spHostURL, vm.accessToken)) { User spUser = clientContext.Web.CurrentUser; clientContext.Load(spUser, user => user.Title); clientContext.ExecuteQuery(); result.Name = spUser.Title; } } catch (Exception) { } return(result); }
public GradesViewModel GetMyLogin(GradesViewModel vm) { //TokenModel result = new TokenModel(); try { ProjectTokenHelper.CheckValidAccessToken(vm.spHostURL, vm.accessToken); using (ClientContext clientContext = TokenHelper.GetClientContextWithAccessToken(vm.spHostURL, vm.accessToken)) { User spUser = clientContext.Web.CurrentUser; clientContext.Load(spUser, user => user.Title); clientContext.ExecuteQuery(); //result.Name = spUser.Title; // The SharePoint web site contains a list called "Student Gradebook" - grab and store it in a List variable. // Linking to the list, like finding a table in a database List studentGradebook = clientContext.Web.Lists.GetByTitle("Student Gradebook"); // CAML = Collaborative Application Markup Language // Query allows you to query for specific items from a list, using the ViewXml property. // Using CamlQuery.CreateAllItemsQuery() creates a query that retrieves all list items. CamlQuery query = CamlQuery.CreateAllItemsQuery(); // This line grabs items from the studentGradebook List object based on the specified query, and // stores them all in a ListItemCollection object. ListItemCollection studentGradebookCollection = studentGradebook.GetItems(query); // This line ties the ListItemCollection to the ClientContext object, providing a line of communication // between the program and the SharePoint server. Without this line, the items queried for will // not be retrieved from SharePoint. clientContext.Load(studentGradebookCollection); // Call ExecuteQuery() to perform the query, loading the specified items from SharePoint. clientContext.ExecuteQuery(); //GradesViewModel gradesViewModel = new GradesViewModel(); foreach (ListItem grade in studentGradebookCollection) { string courseTitle = (string)grade["Title"]; string passed = (string)grade["Result"]; vm.GradeBook.Add(new Grade(courseTitle, passed)); } // Call ExecuteQuery to commit changes made to the list. clientContext.ExecuteQuery(); // Changing display ResultColour of Grade Passed string // This is done in the controller because it has direct access to the GradeBook List of Grade objects. foreach (Grade grade in vm.GradeBook) { grade.ResultColor = grade.Passed.ToLower() == "pass" ? "color:Green" : "color:Red"; } } } catch (Exception) { } return(vm); }