public virtual bool Add(T entity)
{
entity.CreateDate = DateTime.Now;
Entity.Add(entity);
return(context.SaveChanges() > 0);
}
public ActionResult Follow()
{
var _user = SessionSet <User> .Get("login");
int FriendId = Convert.ToInt32(RouteData.Values["id"]);
int myId = _user.Id;
UserFriends uf = new UserFriends();
uf.UserId = myId;
uf.FriendId = FriendId;
uf.CreateDate = DateTime.Now;
var result = loginRepo.Query <UserFriends>().Where(k => (k.UserId == uf.UserId) && (k.FriendId == uf.FriendId)).FirstOrDefault();
if (result == null)
{
db.UserFriends.Add(uf);
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
public static void Main(string[] args)
{
// Wait to call .Run() on BuildWebHost until after stream is setup
// or stream logic will not be called
var host = BuildWebHost(args);
// Getting scope to allow retrieval of DbContext
var scope = host.Services.GetService <IServiceScopeFactory>().CreateScope();
context = scope.ServiceProvider.GetRequiredService <TweetDbContext>();
// Set up your credentials (https://apps.twitter.com)
// Applies credentials for the current thread.If used for the first time, set up the ApplicationCredentials
Auth.SetUserCredentials("5Za8wv3dg9cL1JpMkZ69xHiYR", "q3ieBRSIQGJOXzXjtAuSySHcFQwiKHgKCEccDSbyMYxGc5GbbT", "858816969759444992-ZOBHLzMEq4V9TV6XbYVFk9z9auNRt8v", "gEUnPo24s7dMUbvr0QyfHCbFKbWbzF8XV6F9WXtaudRYc");
var user = User.GetAuthenticatedUser();
// Enable Automatic RateLimit handling
RateLimit.RateLimitTrackerMode = RateLimitTrackerMode.TrackAndAwait;
var stream = Tweetinvi.Stream.CreateFilteredStream();
/* Filter for API stream
* Max 400 char per track but can add multiple tracks
* example: stream.AddTrack("#TBT #tbt #TbT")
*/
stream.AddTrack("#TBT");
stream.MatchingTweetReceived += (sender, recievedTweet) =>
{
Language tweetLanguage;
// if language is in DB retrieve it else create new langauge object and save to DB
if (GetLanguage(recievedTweet.Tweet.Language.ToString()) != null)
{
tweetLanguage = GetLanguage(recievedTweet.Tweet.Language.ToString());
tweetLanguage.TimesUsed += 1;
}
else
{
Language newLanguage = new Language
{
Name = recievedTweet.Tweet.Language.ToString()
};
context.Languages.Add(newLanguage);
context.SaveChanges();
tweetLanguage = newLanguage;
}
// Create new tweet object and add to db
Models.Tweet newTweet = new Models.Tweet
{
Language = tweetLanguage,
DateTime = recievedTweet.Tweet.CreatedAt
};
context.Tweets.Add(newTweet);
context.SaveChanges();
// if hashtag is in DB retrieve it else create new hashtag object and save to DB
List <Hashtag> hashtagList = new List <Hashtag>();
foreach (var hashtag in recievedTweet.Tweet.Hashtags)
{
if (GetHashtag(hashtag.ToString()) != null)
{
Hashtag tweetHashtag = GetHashtag(hashtag.ToString());
hashtagList.Add(tweetHashtag);
tweetHashtag.TimesUsed += 1;
}
else
{
Hashtag newHashtag = new Hashtag
{
Name = hashtag.ToString()
};
context.Hashtags.Add(newHashtag);
context.SaveChanges();
hashtagList.Add(newHashtag);
}
}
//TODO - TweetHashtag is not connecting Tweet and Hashtag classes and ID is not auto - incrementing
// Create TweetHashtag object for each hashtag
//foreach (var hashtag in hashtagList)
//{
// TweetHashtag tweetHashtag = new TweetHashtag
// {
// Tweet = newTweet,
// TweetID = newTweet.ID,
// Hashtag = hashtag,
// HashtagID = hashtag.ID
// };
// context.TweetHashtags.Add(tweetHashtag);
// context.SaveChanges();
//}
};
/* Using Async version of StartStreamMatchingAnyCondition method
* without Async the API stream will hold up the stack
* shifting it onto another thread allows host.run() to be called
* and the web app to run normally
*/
stream.StartStreamMatchingAnyConditionAsync();
// host.Run() must be called after creation of stream or stream will not be set up
host.Run();
// Checks DB for existing hashtag with same name
Hashtag GetHashtag(string hashtag)
{
// FirstorDefault returns null if nothing is found
Hashtag existingHashtag = context.Hashtags.FirstOrDefault(h => h.Name == hashtag);
return(existingHashtag);
}
// Checks DB for existing language with same name
Language GetLanguage(string language)
{
// FirstOrDefault returns null if nothing is found
Language existingLangauge = context.Languages.FirstOrDefault(l => l.Name == language);
return(existingLangauge);
}
}