public ArrayList GetTwitsOfUser(int user_id) { ArrayList allRecords = new ArrayList(); var ctx = new TwitterDataContext(); IQueryable <Twits> c = from twits in ctx.twits where (twits.user_id == user_id)select new Twits { Id = twits.id, Text = twits.text, UserId = twits.user_id, Sentiment = twits.sentiment, Date = twits.date, CaseId = twits.case_id }; allRecords.AddRange(c.ToArray()); Console.WriteLine("test test" + allRecords); foreach (Twits obj in allRecords) { Console.WriteLine(obj.Date); } return(allRecords); }
/*public List<ITwitterWcfService.twits> GetTweets() * { * var ctx = new TwitterDataContext(); * var query = (from twit in ctx.twits select twit); * return ConvertQueryToList(query); * }*/ /* public string GetTweetText(int id) * { * * var ctx = new TwitterDataContext(); * var c = (from Twit in ctx.twits where Twit.id == id select Twit).SingleOrDefault(); * return c.text; * } * * public List<T> ConvertQueryToList<T>(IQueryable<T> query) * { * return query.ToList(); * } * * public List<Twits> GetTweets() * { * throw new NotImplementedException(); * } */ public ArrayList GetCasesWithSentiment(int fromSent, int toSent) { ArrayList allRecords = new ArrayList(); var ctx = new TwitterDataContext(); IQueryable <Cases> c = from cases in ctx.cases where (cases.overall_sentiment >= fromSent) where (cases.overall_sentiment <= toSent)select new Cases { Id = cases.id, Text = cases.text, Dol = cases.dol, OverallSent = cases.overall_sentiment }; allRecords.AddRange(c.ToArray()); Console.WriteLine("test test" + allRecords); foreach (Cases obj in allRecords) { Console.WriteLine(obj.Id); } return(allRecords); }
public int CountUsersWithSentiment(int fromSent, int toSent) { ArrayList allRecordsInRange = new ArrayList(); var ctx = new TwitterDataContext(); IQueryable <Twits> c = from twits in ctx.twits where (twits.sentiment >= fromSent) where (twits.sentiment <= toSent)select new Twits { Id = twits.id, Text = twits.text, UserId = twits.user_id, Sentiment = twits.sentiment, Date = twits.date, CaseId = twits.case_id }; var m = c.Select(g => g.UserId).Distinct().Count(); /*allRecordsInRange.AddRange(c.ToArray()); * Console.WriteLine("test test" + allRecordsInRange); * foreach (Twits obj in allRecordsInRange) * { * Console.WriteLine(obj.Id); * * } */ return(m); }