public void addProfileToUser(String user_id, String profilePath)
{
var newProfile = new Profile
{
age = this.age,
firstname = this.firstname,
lastname = this.lastname,
Id = user_id,
gender = this.gender.ToString(),
privacy = this.privacy ? 1 : 0
};
var databaseEntities = new FacebookDatabaseEntities();
databaseEntities.Profiles.Add(newProfile);
var album = databaseEntities.Albums.Add(new Album {
user_id = user_id, name = "ProfileAlbum", date = DateTime.Now
});
var picture = databaseEntities.Pictures.Add(new Picture {
album_id = album.album_id, path = profilePath, date = DateTime.Now, description = "ProfilePicture"
});
var post = databaseEntities.Posts.Add(new Post {
picture_id = picture.picture_id, sender_id = user_id, date = DateTime.Now, content = "I changed my profile picture"
});
databaseEntities.SaveChanges();
}
public void saveToDatabase(string administrator, HttpServerUtilityBase server, FacebookDatabaseEntities toDataBase)
{
Album newAlbum = new Album();
newAlbum.date = DateTime.Now;
newAlbum.name = name;
newAlbum.user_id = administrator;
toDataBase.Albums.Add(newAlbum);
toDataBase.SaveChanges();
}
public void addCommentFrom(AspNetUser user, FacebookDatabaseEntities toDataBase, string actualUserID)
{
var actualPost = toDataBase.Posts.Where(x => x.post_id == post_id).FirstOrDefault();
var status = CommentStatus.pending;
if (actualPost.sender_id == actualUserID)
{
status = CommentStatus.accepted;
}
user.Comments.Add(new Comment {
post_id = post_id, user_id = user.Id, date = DateTime.Now, content = inputComment, Status = (int)status
});
toDataBase.SaveChanges();
}
public int saveToDatabase(string administrator, HttpServerUtilityBase server)
{
var databaseEntities = new FacebookDatabaseEntities();
var relativePath = FilesHandler.saveImage(picture, server);
var group = databaseEntities.Groups.Add(new Group {
name = name, administrator = administrator, picture_path = relativePath
});
var user = databaseEntities.AspNetUsers.Find(administrator);
group.AspNetUsers.Add(user);
databaseEntities.SaveChanges();
return(group.group_id);
}
static public void addPostFrom(string user_id, FacebookDatabaseEntities toDataBase, String picturePath, string content, int albumID, Nullable <int> group_id = null, bool isProfilePicture = false)
{
Album album = null;
if (isProfilePicture)
{
album = toDataBase.Albums.Where(x => x.name.Equals("ProfileAlbum") && x.user_id == user_id).FirstOrDefault();
}
else
{
if (albumID != -1) //if we have an album to add the post to
{
album = toDataBase.Albums.Where(x => x.album_id == albumID).FirstOrDefault();
}
if (album == null) //if we have not specified the id put it to posted pictures
{
album = toDataBase.Albums.Where(x => x.name.Equals("PostedPicturesAlbum") && x.user_id == user_id).FirstOrDefault();
}
if (album == null) //if we have not specified the album and we also do not have the posted picture album created
{
album = toDataBase.Albums.Add(new Album {
user_id = user_id, name = "PostedPicturesAlbum", date = DateTime.Now
});
}
}
var aspNetUser = toDataBase.AspNetUsers.Find(user_id);
Picture profilePicture = new Picture();
profilePicture.album_id = album.album_id;
profilePicture.path = picturePath;
profilePicture.date = DateTime.Now;
profilePicture.description = "ProfilePicture";
toDataBase.Pictures.Add(profilePicture);
Post newPost = new Post();
newPost.group_id = group_id;
newPost.content = content;
newPost.AspNetUser = aspNetUser;
newPost.Picture = profilePicture;
newPost.date = DateTime.Now;
toDataBase.Posts.Add(newPost);
toDataBase.SaveChanges();
}