public ActionResult Index() { var requestClient = new HttpRequestClient(); var resultsFromApi = requestClient.GetFixtureTable(); var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext); using (var clientContext = spContext.CreateUserClientContextForSPAppWeb()) { List teamsList = clientContext.Web.Lists.GetByTitle("Teams"); var itemCreateInfo = new ListItemCreationInformation(); ListItem newTeam = null; //Here we store the results in a sharepoint List foreach (var team in resultsFromApi) { newTeam = teamsList.AddItem(itemCreateInfo); newTeam["Title"] = team.Name; newTeam["Position"] = team.Position; newTeam["Points"] = team.Points; newTeam["Played"] = team.Played; newTeam.Update(); } clientContext.ExecuteQuery(); //Here is an example of how to get the information from the list List list = clientContext.Web.Lists.GetByTitle("Teams"); ListItemCollection listItems = list.GetItems(CamlQuery.CreateAllItemsQuery()); clientContext.Load(listItems); clientContext.ExecuteQuery(); var resultsFromSharepoint = listItems.Select(x => new Team() { Name = x["Title"] + string.Empty, Points = Convert.ToInt32(x["Points"]), Played = Convert.ToInt32(x["Played"]), Position = Convert.ToInt32(x["Position"]) }); var model = new Results() { ResultsFromAPI = resultsFromApi, ResultsFromSharePoint = resultsFromSharepoint }; return View(model); } }
public ActionResult Index() { var requestClient = new HttpRequestClient(); var resultsFromApi = requestClient.GetFixtureTable(); //Write your sharepoint code here var model = new Results() { ResultsFromAPI = resultsFromApi, }; return View(model); }