public static void AddUserToGroup(int userId, int groupId)
{
var context = new SocialNetworkContext();
var user = context.Users.Find(userId);
var group = context.Groups.Find(groupId);
group.Members.Add(user);
context.SaveChanges();
}
public static void LikeUserPost(int userId, int userPostId)
{
var context = new SocialNetworkContext();
var user = context.Users.Find(userId);
var post = context.UserPosts.Find(userPostId);
var like = new UserPostLike()
{
Author = user,
Post = post
};
context.UserPostLikes.Add(like);
context.SaveChanges();
}
public static void CommentToUserPost(int fromUserId, int toUserPostId, string content)
{
var context = new SocialNetworkContext();
var sender = context.Users.Find(fromUserId);
var userPost = context.Postings.Find(toUserPostId);
var comment = new UserWallPostComment()
{
Content = content,
Author = sender,
PostedOn = DateTime.Now,
UserPost = userPost
};
context.Postings.Add(comment);
context.SaveChanges();
}
public static void Main()
{
// prepare table
var db = new SocialNetworkContext();
db.Database.Delete();
db.Database.Create();
//// task 6 - parsing data from xml
var parser = new XmlParser(db);
parser.ParseFriendShipData();
parser.ParsePostData();
// task 7 - linq requests to database implemented in MySearcher class
MySearcher searcher = new MySearcher(db);
DataSearcher.Search(searcher);
}
public static void AddGroups()
{
var context = new SocialNetworkContext();
var teamGroup = new Group()
{
Name = "Team Quince",
Description = "A great team",
CreatedOn = DateTime.Now
};
var blagoGroup = new Group()
{
Name = "Blagoevgrad",
Description = "A nice city",
CreatedOn = DateTime.Now
};
context.Groups.Add(teamGroup);
context.Groups.Add(blagoGroup);
context.SaveChanges();
}
public static void AddUsers()
{
var context = new SocialNetworkContext();
if (context.Users.Any())
{
return;
}
var straho = new User()
{
Name = "Strahil",
Username = "******"
};
var plamena = new User()
{
Name = "Plamena",
Username = "******"
};
context.Users.Add(straho);
context.Users.Add(plamena);
context.SaveChanges();
}
public BaseController(SocialNetworkContext context)
{
this.Context = context;
}
public BaseApiController(SocialNetworkContext context)
{
this.Data = context;
}
public static void LikeUserPost(int userId, int userPostId)
{
var context = new SocialNetworkContext();
var user = context.Users.Find(userId);
var post = context.Postings.Find(userPostId);
var like = new Like()
{
Author = user,
Posting = post
};
context.Likes.Add(like);
try
{
// Your code...
// Could also be before try if you know the exception occurs in SaveChanges
context.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
private static void CommentToGroupPost(int fromUserId, int groupPostId, string content)
{
var context = new SocialNetworkContext();
var sender = context.Users.Find(fromUserId);
var post = new GroupWallPostComment()
{
Content = content,
Author = sender,
PostedOn = DateTime.Now,
GroupPostId = groupPostId
};
context.Postings.Add(post);
context.SaveChanges();
}
public static void PostToUser(int fromUserId, int toUserId, string content)
{
var context = new SocialNetworkContext();
var sender = context.Users.Find(fromUserId);
var recipient = context.Users.Find(toUserId);
var post = new UserWallPost()
{
Content = content,
Author = sender,
PostedOn = DateTime.Now,
WallOwner = recipient
};
context.Postings.Add(post);
context.SaveChanges();
}
public static void PostToGroup(int fromUserId, int toGroupId, string content)
{
var context = new SocialNetworkContext();
var sender = context.Users.Find(fromUserId);
var recipientGroup = context.Groups.Find(toGroupId);
var post = new GroupWallPost()
{
Content = content,
Author = sender,
PostedOn = DateTime.Now,
GroupId = toGroupId
};
recipientGroup.Postings.Add(post);
context.SaveChanges();
}
public MySearcher(SocialNetworkContext db)
{
this.db = db;
}
public static void Initialize(SocialNetworkContext Context)
{
Context.Database.EnsureCreated();
if (Context.Users.Any())
{
return;
}
var Users = new User[]
{
new User {
Name = "Enrique", LastName = "Bastos", Email = "*****@*****.**", Password = "******", DateBirthday = DateTime.Parse("1998-04-28")
},
new User {
Name = "Alejandro", LastName = "Muñoz", Password = "******", DateBirthday = DateTime.Parse("1998-10-23")
},
new User {
Name = "Daniel", LastName = "Esteban", Password = "******", DateBirthday = DateTime.Parse("1997-01-04")
},
new User {
Name = "Pepe", LastName = "Vaquero", Password = "******", DateBirthday = DateTime.Parse("2000-12-10")
}
};
foreach (User User in Users)
{
Context.Users.Add(User);
}
Context.SaveChanges();
var Musics = new Music[]
{
new Music {
Id = 0, UserId = 1, UrlVideo = ""
},
new Music {
Id = 0, UserId = 3, UrlVideo = ""
},
new Music {
Id = 0, UserId = 4, UrlVideo = ""
},
new Music {
Id = 0, UserId = 2, UrlVideo = ""
}
};
foreach (Music song in Musics)
{
Context.Musics.Add(song);
}
Context.SaveChanges();
}
public static void Main()
{
//AddUsers();
//PostToUser(1, 2, "Hi Plami, Hi are you?");
//CommentToUserPost(2, 1, "I am fine, thank you.");
//LikeUserPost(2, 1);
//AddGroups();
//AddUserToGroup(1, 1);
//AddUserToGroup(2, 1);
//AddUserToGroup(1, 2);
var context = new SocialNetworkContext();
//var posts = context.Users.Find(2).UserPosts;
//foreach (var post in posts)
//{
// Console.WriteLine("User is: {0}", context.Users.Find(2).Name);
// Console.WriteLine("Author: {0}, Target: {1}", post.Author.Name, post.User.Name);
// Console.WriteLine(post.Content);
//}
var group = context.Groups.Find(1);
foreach (var member in group.Members)
{
Console.WriteLine("Member: {0}", member.Name);
}
//PostToGroup(1, 1, "Ho ho ho");
//PostToGroup(2, 1, "Ha ha ha");
foreach (var post in context.Groups.Find(1).Posts)
{
Console.WriteLine("Content: {0}", post.Content);
}
}
