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