public void BdForCsh() { using (var bd = new MyTwitterBdClass()) { var ListTop50 = bd.Tweets.Select(t => new TwitterStatus { Text = t.Text, CreatedDate = t.TimeOfTweet.Value, User = new TwitterUser { Name = t.User.FullName, ScreenName = t.User.ScreenName } }).OrderByDescending(x => x.CreatedDate).Take(50).ToList(); testTweet = ListTop50; newList = TweetTenPage(); DataForMainPage(); } }
private void AddToBdTweet() { using (var bd = new MyTwitterBdClass()) { var dbListTweets = bd.Tweets.Select(t => t.Text).ToList(); var dbListUsers = bd.Users.Select(t => t.Name).ToList(); foreach (var tweet in testTweet) { if (dbListTweets.IndexOf(tweet.Text) < 0) { var UserIN = new TwitterUsersForBd { Name = tweet.User.Name, FullName = tweet.User.Name, ScreenName = tweet.User.ScreenName }; var tweetIN = new TweetsForBd { Text = tweet.Text, TimeOfTweet = tweet.CreatedDate }; var FFCIN = new FollowersFriendsForBd { Followers = tweet.User.FollowersCount, Friends = tweet.User.FriendsCount }; if (dbListUsers.IndexOf(tweet.User.Name) < 0) { dbListUsers.Add(tweet.User.Name); bd.Users.Add(UserIN); bd.SaveChanges(); var UserFromBdFirst = bd.Users.Where(a => a.Name == tweet.User.Name).Single(); UserFromBdFirst.Tweets.Add(tweetIN); UserFromBdFirst.FFC.Add(FFCIN); bd.SaveChanges(); } else { var UserFromBd = bd.Users.Where(a => a.Name == tweet.User.Name).Single(); UserFromBd.Tweets.Add(tweetIN); UserFromBd.FFC.Add(FFCIN); bd.SaveChanges(); } } } } }