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();
}
}
}
}
}