public IEnumerable <TweetDto> GetTweetsByTime()
{
try
{
var tweets = AppDbHelper <TweetRaw> .FetchTweetInTime(new DateTime(2019, 3, 29, 0, 0, 0), new DateTime(2019, 3, 31, 23, 59, 59), true);
return(tweets);
}
catch (Exception ex)
{
return(null);
}
}
public IEnumerable <UserDto> MoreActives(int skip, int take)
{
try
{
var users = AppDbHelper <TweetRaw> .MoreActives(skip, take);
return(users);
}
catch (Exception ex)
{
return(null);
}
}
public WordSentiment AvgWord(string word)
{
try
{
var avgWord = AppDbHelper <TweetRaw> .WordSentiment(word);
return(avgWord);
}
catch (Exception ex)
{
return(null);
}
}
public IEnumerable <HashtagsCount> GetHashtags()
{
try
{
var hashtags = AppDbHelper <TweetRaw> .GroupbyHashtags();
return(hashtags);
}
catch (Exception ex)
{
return(null);
}
}
public IEnumerable <TweetDto> TweetsByHashtags([FromBody] ApiRequest apiRequest)
{
try
{
var tweets = AppDbHelper <TweetRaw> .FetchContains(apiRequest.hashtags, apiRequest.page, apiRequest.itemPerPage, true, apiRequest.OrderSentiment);
return(tweets);
}
catch (Exception ex)
{
return(null);
}
}
public IEnumerable <HashtagsGrouped> GetGroupedHashtagsBySentiment()
{
try
{
var groupedHashtags = AppDbHelper <HashtagsGrouped> .GroupSentimentByHashtags();
return(groupedHashtags);
}
catch (Exception ex)
{
return(null);
}
}
public IEnumerable <TagCloud> TagClouds()
{
try
{
var tagClouds = AppDbHelper <TweetRaw> .TagWord();
return(tagClouds);
}
catch (Exception ex)
{
return(null);
}
}
public List <GroupedTweetsGeo> GeoTweets()
{
try
{
var geoTweets = AppDbHelper <TweetRaw> .TweetsGeoCode();
return(geoTweets);
}
catch (Exception ex)
{
return(null);
}
}
public string AvgSentiments()
{
try
{
var avgs = AppDbHelper <TweetRaw> .AvgHashtags();
var json = Newtonsoft.Json.JsonConvert.SerializeObject(avgs, new JsonSerializerSettings
{
ContractResolver = new CamelCasePropertyNamesContractResolver()
});
return(json);
}
catch (Exception ex)
{
return(null);
}
}
