public static void AddNewPhoto(string nameImg, string path, int idAlbum)
{
Lab_7Entities13 context = new Lab_7Entities13();
Images image = new Images();
image.Path = path;
context.Images.Add(image);
context.SaveChanges();
int idPage = (from u in context.Images
where u.Path == path
select u.Id).FirstOrDefault();
int idUser = WorkWithDb.getInformationActiveUser().Id;
UsersImages users = new UsersImages();
users.IdUser = idUser;
users.IdImage = idPage;
users.Name = nameImg;
context.UsersImages.Add(users);
context.SaveChanges();
int idPost = (from posts in context.UsersImages
select posts.Id).ToList().Last();
UserAlbumPosts userAlbumPosts = new UserAlbumPosts();
userAlbumPosts.IdUsersAlbum = idAlbum;
userAlbumPosts.IdPost = idPost;
context.UserAlbumPosts.Add(userAlbumPosts);
context.SaveChanges();
}
public static void AddNewUser(Users user)
{
Lab_7Entities13 context = new Lab_7Entities13();
context.Users.Add(user);
context.SaveChanges();
Users.ActiveUser = (from u in context.Users
select u.Id).ToList().Last();
}
public static int AddAlbum(int idUser, string nameAlbum)
{
Lab_7Entities13 context = new Lab_7Entities13();
Album album = new Album();
album.NameOfAlbum = nameAlbum;
context.Album.Add(album);
context.SaveChanges();
int idAlbum = (from u in context.Album
select u.Id).ToList().Last();
UserAlbum userAlbum = new UserAlbum();
userAlbum.UserId = idUser;
userAlbum.AlbumId = idAlbum;
context.UserAlbum.Add(userAlbum);
context.SaveChanges();
return(idAlbum);
}
public static void AddComment(int idPost, string text)
{
Lab_7Entities13 context = new Lab_7Entities13();
int activeUserId = WorkWithDb.getInformationActiveUser().Id;
UsersImagesComments comment = new UsersImagesComments();
comment.IdPost = idPost;
comment.IdUser = activeUserId;
comment.Comment = text;
context.UsersImagesComments.Add(comment);
context.SaveChanges();
}
public static void DeletePhoto(string nameOfPhoto, int idAlbum)
{
Lab_7Entities13 context = new Lab_7Entities13();
int idUser = WorkWithDb.getInformationActiveUser().Id;
UsersImages user = (from image in context.UsersImages
join albums in context.UserAlbumPosts on image.Id equals albums.IdPost
where image.Name == nameOfPhoto && image.IdUser == Users.ActiveUser && albums.IdUsersAlbum == idAlbum
select image).FirstOrDefault();
context.UsersImages.Attach(user);
context.UsersImages.Remove(user);
context.SaveChanges();
}
