public ProfileController( UserManager <ApplicationUser> userManager, SocialNetworkDBContext socialNetworkDBContext) { _userManager = userManager; _socialNetworkDBContext = socialNetworkDBContext; }
private UserProfile GetUser(SocialNetworkDBContext db, UserXmlModel userModel, ICollection <string> usernames) { if (usernames.Contains(userModel.Username)) { return(db.UserProfiles.FirstOrDefault(u => u.UserName == userModel.Username)); } else { usernames.Add(userModel.Username); var user = new UserProfile() { UserName = userModel.Username, RegistrationDate = userModel.RegisteredOn, FirstName = userModel.FirstName, LastName = userModel.LastName }; foreach (var image in userModel.Images) { user.Images.Add(new Image() { Url = image.ImageUrl, FileExtension = image.FileExtension }); } dbContext.UserProfiles.Add(user); dbContext.SaveChanges(); return(user); } }
public SocialNetworkService(SocialNetworkDBContext context) { if (context == null) { throw new ArgumentException("The database context cannot be null!"); } this.context = context; }
public static async void DeletePost(this SocialNetworkDBContext db, Post p, IdentityUser user) { try { db.Post.Remove(p); await db.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public static async void WritePost(this SocialNetworkDBContext db, Post p) { try { await db.Post.AddAsync(p); await db.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
public static async void UpdatePost(this SocialNetworkDBContext db, Post p, IdentityUser user) { try { var post = db.Post.Find(p); post.Body = p.Body; post.PublishDate = DateTime.Now; await db.SaveChangesAsync(); } catch (Exception ex) { throw ex; } }
private void ProceedFriendShip(IEnumerable <FriendshipXmlModel> friendships) { var addedFriendships = 0; var addedUsers = dbContext.UserProfiles.Select(u => u.UserName).ToList(); foreach (var fr in friendships) { var firstUser = GetUser(dbContext, fr.FirstUser, addedUsers); var secondUser = GetUser(dbContext, fr.SecondUser, addedUsers); var friendship = new Friednship() { FirstUser = firstUser, SecondUser = secondUser, ApprovingDate = fr.FriendsSince, IsApproved = fr.Approved }; foreach (var message in fr.Messages) { friendship.Messages.Add(new Message() { Author = message.Author == firstUser.UserName ? firstUser : secondUser, Content = message.Content, SendingDate = message.SentOn, SeeingDate = message.SentOn }); } dbContext.Friendships.Add(friendship); addedFriendships++; if (addedFriendships % 10 == 0) { Console.Write('.'); } if (addedFriendships % 100 == 0) { Console.WriteLine($"Added {addedFriendships} friendships."); dbContext.SaveChanges(); dbContext = new SocialNetworkDBContext(); } } }
private void ProceedPost(IEnumerable <PostXmlModel> posts) { var addedPosts = 0; foreach (var p in posts) { var usernames = p.Users.Split(','); var users = dbContext.UserProfiles.Where(u => usernames.Contains(u.UserName)).ToList(); var post = new Post() { Content = p.Content, PostingDate = p.PostedOn }; foreach (var user in users) { post.TaggedUsers.Add(user); } dbContext.Posts.Add(post); addedPosts++; if (addedPosts % 10 == 0) { Console.Write('.'); } if (addedPosts % 100 == 0) { Console.WriteLine($"Added {addedPosts} posts."); dbContext.SaveChanges(); dbContext = new SocialNetworkDBContext(); } } }
public HomeController(UserManager <ApplicationUser> userManager, IHostingEnvironment IHostingEnvironment, SocialNetworkDBContext socialNetworkDBContext) { _environment = IHostingEnvironment; _userManager = userManager; _socialNetworkDBContext = socialNetworkDBContext; }
public static IEnumerable <Post> GetAllPosts(this SocialNetworkDBContext db, IdentityUser user) { return(db.Post.Where(p => p.Fkuser == user.Id)); }
public static IEnumerable <ApplicationUser> FindAllFollowed(this UserManager <ApplicationUser> um, ApplicationUser user, SocialNetworkDBContext db) { var PPKFKFollowed = db.UserUser.Where(u => user.Id == u.Ppkfkfollowed).Select(u => u.Ppkfkfollower).ToList(); var output = um?.Users?.Where(u => PPKFKFollowed.Contains(u.Id)).ToList(); return(output); }
public static void Main() { var db = new SocialNetworkDBContext(); db.Database.CreateIfNotExists }
public FriendshipRepository(SocialNetworkDBContext context) : base(context) { }
public Repository(SocialNetworkDBContext context) { this.context = context; entities = context.Set <T>(); }