public static List <string> PathPhoto(int id, int idAlbum) { Lab_7Entities13 context = new Lab_7Entities13(); int?[] idPosts = (from posts in context.UserAlbumPosts where posts.IdUsersAlbum == idAlbum select posts.IdPost).ToArray(); string[] photoPath = (from page in context.Images join user in context.UsersImages on page.Id equals user.IdImage where user.IdUser == id && idPosts.Contains(user.Id) select page.Path).ToArray(); string[] namePhoto = (from page in context.UsersImages join user in context.Images on page.IdImage equals user.Id where page.IdUser == id select page.Name).ToArray(); int i = 0; List <string> resultList = new List <string>(); foreach (string str in photoPath) { resultList.Add(str); resultList.Add(namePhoto[i]); i++; } return(resultList); }
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 Users getInformationActiveUser() { Lab_7Entities13 context = new Lab_7Entities13(); Users aktiveUser = (from u in context.Users where u.Id == Users.ActiveUser select u).FirstOrDefault(); return(aktiveUser); }
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(); }
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 bool DefineUser(string email, string password) { Lab_7Entities13 context = new Lab_7Entities13(); IEnumerable <Users> listUsers = from u in context.Users select u; foreach (Users us in listUsers) { if (us.Email == email) { if (us.Password == password) { Users.ActiveUser = us.Id; return(true); } } } return(false); }
public static List <string> SearchAlbum(int idUser) { Lab_7Entities13 context = new Lab_7Entities13(); UserAlbum[] userAlbum = (from u in context.UserAlbum where u.UserId == idUser select u).ToArray(); string[] nameAlbum = (from albumName in context.Album join userAlbums in context.UserAlbum on albumName.Id equals userAlbums.AlbumId where userAlbums.UserId == idUser select albumName.NameOfAlbum).ToArray(); var index = 0; List <string> listIdAlbumAndNameAlbum = new List <string>(); foreach (UserAlbum album in userAlbum) { listIdAlbumAndNameAlbum.Add(album.Id.ToString()); listIdAlbumAndNameAlbum.Add(nameAlbum[index]); index++; } return(listIdAlbumAndNameAlbum); }
public static List <string> AuthorNameAndImagePath(int idPost) { Lab_7Entities13 context = new Lab_7Entities13(); string autorPost = (from author in context.Users join post in context.UsersImages on author.Id equals post.IdUser where post.Id == idPost select author.Name).FirstOrDefault(); int authorId = (from author in context.Users join post in context.UsersImages on author.Id equals post.IdUser where post.Id == idPost select author.Id).FirstOrDefault(); string imagePath = (from path in context.Images join post in context.UsersImages on path.Id equals post.IdImage where post.Id == idPost select path.Path).FirstOrDefault(); List <string> list = new List <string>(); list.Add(autorPost); list.Add(imagePath); list.Add(authorId.ToString()); return(list); }
public static List <string> SearchComments(int idPost) { Lab_7Entities13 context = new Lab_7Entities13(); string[] listUsers = (from userName in context.Users join postId in context.UsersImagesComments on userName.Id equals postId.IdUser where idPost == postId.IdPost select userName.Name).ToArray(); string[] listComments = (from comment in context.UsersImagesComments where idPost == comment.IdPost select comment.Comment).ToArray(); List <string> listCommentsUsers = new List <string>(); int i = 0; foreach (string str in listUsers) { listCommentsUsers.Add(str); listCommentsUsers.Add(listComments[i]); i++; } return(listCommentsUsers); }
public static List <string> SearchPosts() { Lab_7Entities13 context = new Lab_7Entities13(); string[] authors = (from user in context.Users join userPage in context.UsersImages on user.Id equals userPage.IdUser select user.Name).ToArray(); authors.Reverse(); string[] paths = (from imageImg in context.Images join imageUsImg in context.UsersImages on imageImg.Id equals imageUsImg.IdImage select imageImg.Path).ToArray(); int[] idPosts = (from podtsId in context.UsersImages select podtsId.Id).ToArray(); int[] idUser = (from podtsId in context.UsersImages select podtsId.IdUser).ToArray(); int?[] idAlbum = (from albums in context.UserAlbumPosts join post in context.UsersImages on albums.IdPost equals post.Id select albums.IdUsersAlbum).ToArray(); idUser.Reverse(); idPosts.Reverse(); paths.Reverse(); idAlbum.Reverse(); int index = 0; List <string> posts = new List <string>(); foreach (string author in authors) { posts.Add(idPosts[index].ToString()); posts.Add(author); posts.Add(paths[index]); posts.Add(idUser[index].ToString()); posts.Add(idAlbum[index].ToString()); index++; } return(posts); }