private void GetTransaction() { var res = Preferences.Get("ContributionsItems", string.Empty); var result = JsonConvert.DeserializeObject <List <UserContributionList> >(res); if (result != null) { foreach (var item in result) { UserContributions.Add(item); } } }
public IEnumerable <UserContributions> GetUserContributionsCountForUser(string email) { var userContributions = new List <UserContributions>(); using (var clientContext = new ClientContext(ConfigurationManager.AppSettings.Get("mClubSiteUrl"))) { var passWord = new SecureString(); foreach (char c in ConfigurationManager.AppSettings.Get("password").ToCharArray()) { passWord.AppendChar(c); } clientContext.Credentials = new SharePointOnlineCredentials(ConfigurationManager.AppSettings.Get("userName"), passWord); var ideaContributionTypesList = clientContext.Web.Lists.GetByTitle("User Contributions - Idea"); var internalProcessInnovationContributionTypesList = clientContext.Web.Lists.GetByTitle("User Contributions - Internal Process Innovation"); var participationInChallengesContributionTypesList = clientContext.Web.Lists.GetByTitle("User Contributions - Participation in Challenges"); var patentContributionTypesList = clientContext.Web.Lists.GetByTitle("User Contributions - Patent"); var poCContributionTypesList = clientContext.Web.Lists.GetByTitle("User Contributions - PoC"); var projectInnovationContributionTypesList = clientContext.Web.Lists.GetByTitle("User Contributions - Project Innovation"); var speakingContributionTypesList = clientContext.Web.Lists.GetByTitle("User Contributions - Speaking"); var thoughtLeadershipContributionTypesList = clientContext.Web.Lists.GetByTitle("User Contributions - Thought Leadership"); var ideaQuery = new CamlQuery() { ViewXml = string.Format("<View><Query><Where><Eq><FieldRef Name='{0}' /><Value Type='Text'>{1}</Value></Eq></Where></Query><OrderBy><FieldRef Name = 'Modified' Ascending = 'FALSE' /></OrderBy></View>", "Idea_x0020_Author_x0020_Email", email) }; var ideaItems = ideaContributionTypesList.GetItems(ideaQuery); var internalQuery = new CamlQuery() { ViewXml = string.Format("<View><Query><Where><Eq><FieldRef Name='{0}' /><Value Type='Text'>{1}</Value></Eq></Where></Query><OrderBy><FieldRef Name = 'Modified' Ascending = 'FALSE' /></OrderBy></View>", "Idea_x0020_Author_x0020_Email", email) }; var internalItems = internalProcessInnovationContributionTypesList.GetItems(internalQuery); var participationInChallengesQuery = new CamlQuery() { ViewXml = string.Format("<View><Query><Where><Eq><FieldRef Name='{0}' /><Value Type='Text'>{1}</Value></Eq></Where></Query><OrderBy><FieldRef Name = 'Modified' Ascending = 'FALSE' /></OrderBy></View>", "Idea_x0020_Author_x0020_Email", email) }; var participationInChallengesItems = participationInChallengesContributionTypesList.GetItems(participationInChallengesQuery); var patentQuery = new CamlQuery() { ViewXml = string.Format("<View><Query><Where><Eq><FieldRef Name='{0}' /><Value Type='Text'>{1}</Value></Eq></Where></Query><OrderBy><FieldRef Name = 'Modified' Ascending = 'FALSE' /></OrderBy></View>", "Idea_x0020_Author_x0020_Email", email) }; var patentItems = patentContributionTypesList.GetItems(patentQuery); var poCQuery = new CamlQuery() { ViewXml = string.Format("<View><Query><Where><Eq><FieldRef Name='{0}' /><Value Type='Text'>{1}</Value></Eq></Where></Query><OrderBy><FieldRef Name = 'Modified' Ascending = 'FALSE' /></OrderBy></View>", "Idea_x0020_Author_x0020_Email", email) }; var poCItems = poCContributionTypesList.GetItems(poCQuery); var projectInnovationQuery = new CamlQuery() { ViewXml = string.Format("<View><Query><Where><Eq><FieldRef Name='{0}' /><Value Type='Text'>{1}</Value></Eq></Where></Query><OrderBy><FieldRef Name = 'Modified' Ascending = 'FALSE' /></OrderBy></View>", "Idea_x0020_Author_x0020_Email", email) }; var projectInnovationItems = projectInnovationContributionTypesList.GetItems(projectInnovationQuery); var speakingQuery = new CamlQuery() { ViewXml = string.Format("<View><Query><Where><Eq><FieldRef Name='{0}' /><Value Type='Text'>{1}</Value></Eq></Where></Query><OrderBy><FieldRef Name = 'Modified' Ascending = 'FALSE' /></OrderBy></View>", "Idea_x0020_Author_x0020_Email", email) }; var speakingItems = speakingContributionTypesList.GetItems(speakingQuery); var thoughtLeadershipQuery = new CamlQuery() { ViewXml = string.Format("<View><Query><Where><Eq><FieldRef Name='{0}' /><Value Type='Text'>{1}</Value></Eq></Where></Query><OrderBy><FieldRef Name = 'Modified' Ascending = 'FALSE' /></OrderBy></View>", "Idea_x0020_Author_x0020_Email", email) }; var thoughtLeadershipItems = thoughtLeadershipContributionTypesList.GetItems(thoughtLeadershipQuery); // Retrieve all items in the ListItemCollection from List.GetItems(Query). clientContext.Load(ideaItems); clientContext.Load(internalItems); clientContext.Load(participationInChallengesItems); clientContext.Load(patentItems); clientContext.Load(poCItems); clientContext.Load(projectInnovationItems); clientContext.Load(speakingItems); clientContext.Load(thoughtLeadershipItems); clientContext.ExecuteQuery(); if (ideaItems.Count > 0) { var ideaContribution = new UserContributions(); ideaContribution.Count = ideaItems.Count; var ideaType = ideaItems[0]["Contribution_x0020_Bucket"] as FieldLookupValue; var latestContribution = Convert.ToString(ideaItems[0]["Title"]); ideaContribution.LatestContribution = latestContribution; if (ideaType != null) { ideaContribution.ID = ideaType.LookupId; ideaContribution.Title = ideaType.LookupValue; ideaContribution.Image = GetImageOfTheContribution(ideaType.LookupId, clientContext); } userContributions.Add(ideaContribution); } if (internalItems.Count > 0) { var internalContribution = new UserContributions(); internalContribution.Count = ideaItems.Count; var ideaType = ideaItems[0]["Contribution_x0020_Bucket"] as FieldLookupValue; var latestContribution = Convert.ToString(ideaItems[0]["Title"]); internalContribution.LatestContribution = latestContribution; if (ideaType != null) { internalContribution.ID = ideaType.LookupId; internalContribution.Title = ideaType.LookupValue; internalContribution.Image = GetImageOfTheContribution(ideaType.LookupId, clientContext); } userContributions.Add(internalContribution); } if (participationInChallengesItems.Count > 0) { var participationContribution = new UserContributions(); participationContribution.Count = ideaItems.Count; var ideaType = ideaItems[0]["Contribution_x0020_Bucket"] as FieldLookupValue; var latestContribution = Convert.ToString(ideaItems[0]["Title"]); participationContribution.LatestContribution = latestContribution; if (ideaType != null) { participationContribution.ID = ideaType.LookupId; participationContribution.Title = ideaType.LookupValue; participationContribution.Image = GetImageOfTheContribution(ideaType.LookupId, clientContext); } userContributions.Add(participationContribution); } if (patentItems.Count > 0) { var patentContribution = new UserContributions(); patentContribution.Count = ideaItems.Count; var ideaType = ideaItems[0]["Contribution_x0020_Bucket"] as FieldLookupValue; var latestContribution = Convert.ToString(ideaItems[0]["Title"]); patentContribution.LatestContribution = latestContribution; if (ideaType != null) { patentContribution.ID = ideaType.LookupId; patentContribution.Title = ideaType.LookupValue; patentContribution.Image = GetImageOfTheContribution(ideaType.LookupId, clientContext); } userContributions.Add(patentContribution); } if (poCItems.Count > 0) { var poCContribution = new UserContributions(); poCContribution.Count = ideaItems.Count; var ideaType = ideaItems[0]["Contribution_x0020_Bucket"] as FieldLookupValue; var latestContribution = Convert.ToString(ideaItems[0]["Title"]); poCContribution.LatestContribution = latestContribution; if (ideaType != null) { poCContribution.ID = ideaType.LookupId; poCContribution.Title = ideaType.LookupValue; poCContribution.Image = GetImageOfTheContribution(ideaType.LookupId, clientContext); } userContributions.Add(poCContribution); } if (projectInnovationItems.Count > 0) { var projectContribution = new UserContributions(); projectContribution.Count = ideaItems.Count; var ideaType = ideaItems[0]["Contribution_x0020_Bucket"] as FieldLookupValue; var latestContribution = Convert.ToString(ideaItems[0]["Title"]); projectContribution.LatestContribution = latestContribution; if (ideaType != null) { projectContribution.ID = ideaType.LookupId; projectContribution.Title = ideaType.LookupValue; projectContribution.Image = GetImageOfTheContribution(ideaType.LookupId, clientContext); } userContributions.Add(projectContribution); } if (speakingItems.Count > 0) { var speakingContribution = new UserContributions(); speakingContribution.Count = ideaItems.Count; var ideaType = ideaItems[0]["Contribution_x0020_Bucket"] as FieldLookupValue; var latestContribution = Convert.ToString(ideaItems[0]["Title"]); speakingContribution.LatestContribution = latestContribution; if (ideaType != null) { speakingContribution.ID = ideaType.LookupId; speakingContribution.Title = ideaType.LookupValue; speakingContribution.Image = GetImageOfTheContribution(ideaType.LookupId, clientContext); } userContributions.Add(speakingContribution); } if (thoughtLeadershipItems.Count > 0) { var thoughtLeadershipContribution = new UserContributions(); thoughtLeadershipContribution.Count = ideaItems.Count; var ideaType = ideaItems[0]["Contribution_x0020_Bucket"] as FieldLookupValue; var latestContribution = Convert.ToString(ideaItems[0]["Title"]); thoughtLeadershipContribution.LatestContribution = latestContribution; if (ideaType != null) { thoughtLeadershipContribution.ID = ideaType.LookupId; thoughtLeadershipContribution.Title = ideaType.LookupValue; thoughtLeadershipContribution.Image = GetImageOfTheContribution(ideaType.LookupId, clientContext); } userContributions.Add(thoughtLeadershipContribution); } } return(userContributions.ToList()); }