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