public bool DeleteFriends()
{
using (flickr_tablesEntities1 db = new flickr_tablesEntities1())
{
try
{
var friends = db.friends.ToList();
foreach (friend item in friends)
{
db.friends.Remove(item);
}
db.SaveChanges();
return(true);
}
catch (Exception) { return(false); }
}
}
public bool UpdateFriendsTags()
{
using (flickr_tablesEntities1 db = new flickr_tablesEntities1())
{
try
{
List <friend> friends = db.friends.ToList();
Flickr f = GetInstance();
List <string> tags = new List <string>();
var users = db.users.ToList();
foreach (var user in users)
{
Console.WriteLine("Looking for tags for users");
var tagsUser = f.TagsGetListUser(user.UserId).GroupBy(x => x.TagName).OrderByDescending(g => g.Count()).Take(10).Select(gg => gg.Key).ToList();
foreach (string tagU in tagsUser)
{
usertag utag = new usertag()
{
UserId = user.UserId,
Tag = tagU
};
db.usertags.Add(utag);
}
;
db.SaveChanges();
foreach (var tagItem in tagsUser) //select all tags from the list for iterated friend
{
var result = (from wordP in db.words
where wordP.Word1 == tagItem
select wordP).ToList(); //check if for the iterated friend we have some tags like in ourdatabase
foreach (var itemRes in result) //check the above result...if Yes then we add the friend to the specific category of tags
{
linkusercategory catLink = new linkusercategory()
{
Category = itemRes.CategoryId,
UserId = user.UserId,
Tag = itemRes.Word1
};
db.linkusercategories.Add(catLink);
}
}
db.SaveChanges();
}
Dictionary <string, List <string> > tagsList = new System.Collections.Generic.Dictionary <string, System.Collections.Generic.List <string> >();
foreach (var user in friends)
{
Console.WriteLine("Foreach friend it will be retreived all the tags...");
tags = f.TagsGetListUser(user.IdFriend).GroupBy(x => x.TagName).OrderByDescending(g => g.Count()).Take(10).Select(gg => gg.Key).ToList();
tagsList.Add(user.IdFriend, tags);
foreach (string tafg in tags)
{
friendtag ftag = new friendtag()
{
FriendId = user.IdFriend,
Tag = tafg,
};
db.friendtags.Add(ftag);
}
user.Tags = 1;
}
db.SaveChanges();
try
{
foreach (var item in tagsList) //select list of tags foreach firends
{
foreach (var tagItem in item.Value) //select all tags from the list for iterated friend
{
var result = (from wordP in db.words
where wordP.Word1 == tagItem
select wordP).ToList(); //check if for the iterated friend we have some tags like in ourdatabase
foreach (var itemRes in result) //check the above result...if Yes then we add the friend to the specific category of tags
{
linkfriendcategory catLink = new linkfriendcategory()
{
IdCategory = itemRes.CategoryId,
IdFriend = item.Key,
Tag = itemRes.Word1
};
db.linkfriendcategories.Add(catLink);
}
}
}
db.SaveChanges();
Console.WriteLine("Tagging proccess complete...");
}
catch (Exception)
{
}
return(true);
}
catch (Exception)
{
db.Dispose();
return(false);
}
}
}
public bool UpdateFriends()
{
using (flickr_tablesEntities1 db = new flickr_tablesEntities1())
{
try
{
List <user> users = db.users.ToList();
Console.WriteLine(users.Count + " users in database...");
Console.WriteLine("START UPDATE");
Console.WriteLine("Deleting all friends...");
DeleteFriends();
foreach (var item in users)
{
Flickr f = GetInstance();
FlickrNet.ContactCollection friends = f.ContactsGetPublicList(item.UserId);
string realName = ""; string description = "";
int count = friends.Count;
int contor = 0;
foreach (var itemFr in friends)
{
var person = f.PeopleGetInfo(itemFr.UserId);
if (person.RealName != null)
{
realName = person.RealName;
}
else
{
realName = "";
}
if (person.Description.Length > 50)
{
description = Truncate(person.Description, 50) + "...";
}
else
{
description = person.Description;
}
itemFr.PathAlias = itemFr.BuddyIconUrl;
friend fr = new friend
{
FullName = realName,
IdFriend = itemFr.UserId,
UserName = itemFr.UserName,
PhotoUrl = itemFr.BuddyIconUrl,
Description = description
};
linkfriend link = new linkfriend
{
IdUser = item.UserId,
IdFriend = itemFr.UserId
};
try
{
if (db.friends.Where(a => a.IdFriend == fr.IdFriend).Count() == 0)
{
db.friends.Add(fr);
db.SaveChanges();
}
db.linkfriends.Add(link);
db.SaveChanges();
Console.WriteLine("Saving friends:");
if (contor >= count / 4)
{
Console.Write("---25%---");
}
if (contor >= count / 3)
{
Console.Write("---32%---");
}
if (contor >= count / 2)
{
Console.Write("---50%---");
}
if (contor == count / 1.5)
{
Console.Write("---80%---");
}
contor++;
}
catch (Exception)
{
}
}
}
Console.WriteLine("Update friends complete...");
return(true);
}
catch (Exception) { return(false); }
}
}
public bool UpdateComments()
{
flickr_tablesEntities1 dbo = new flickr_tablesEntities1();
int contor = 0;
try {
var friends = dbo.friends.ToList();
var users = dbo.users.ToList();
Flickr f = GetInstance();
var commentsAll = dbo.commentsusers.ToList();
foreach (var item in commentsAll)
{
dbo.commentsusers.Remove(item);
}
dbo.SaveChanges();
Console.WriteLine("All cleared");
foreach (var item in friends)
{
Console.WriteLine("Added " + contor + " friend");
FlickrNet.PhotoCollection items = f.PeopleGetPublicPhotos(item.IdFriend);
foreach (var itemx in items)
{
FlickrNet.PhotoCommentCollection comments = f.PhotosCommentsGetList(itemx.PhotoId);
foreach (var comm in comments)
{
commentsuser commu = new commentsuser()
{
CommentatorId = comm.AuthorUserId,
Comment = comm.AuthorRealName,
PhotoId = itemx.PhotoId,
UserId = item.IdFriend
};
dbo.commentsusers.Add(commu);
}
}
contor++;
}
foreach (var item in users)
{
Console.WriteLine("Added " + contor + " friend");
FlickrNet.PhotoCollection items = f.PeopleGetPublicPhotos(item.UserId);
foreach (var itemx in items)
{
FlickrNet.PhotoCommentCollection comments = f.PhotosCommentsGetList(itemx.PhotoId);
foreach (var comm in comments)
{
commentsuser commu = new commentsuser()
{
CommentatorId = comm.AuthorUserId,
Comment = comm.AuthorRealName,
PhotoId = itemx.PhotoId,
UserId = item.UserId
};
dbo.commentsusers.Add(commu);
dbo.SaveChanges();
}
}
contor++;
}
dbo.SaveChanges();
Console.WriteLine("Data saved...");
}
catch (Exception) { }
return(true);
}