public List <Movie> FindMoviesOfUser(int idUser) { List <Movie> movies = new List <Movie>(); try { DbMovieNetEntities entities = new DbMovieNetEntities(); var query = (from n in entities.MovieSets where n.UserSet.Id == idUser select n).ToList(); List <MovieSet> list = query.ToList(); foreach (MovieSet mv in list) { movies.Add(new Movie { IdGetSet = mv.Id, TitleGetSet = mv.Title, DurationGetSet = mv.Duration, GenreGetSet = mv.Genre, SummaryGetSet = mv.Summary, ImageGetSet = mv.Image });; } } catch (SqlException ex) { throw new FaultException("Erreur Finding note of user " + ex.Errors); } return(movies); }
public bool CreateMovie(string _title, string _duration, string _genre, string _summary, string _image, int _UserSet_id) { try { using (var entities = new DbMovieNetEntities()) { entities.MovieSets.Add(new MovieSet() { Title = _title, Duration = _duration, Genre = _genre, Summary = _summary, Image = _image, User_Id = _UserSet_id }); entities.SaveChanges(); } } catch (SqlException ex) { NewMethodException(ex); } return(true); }
public bool UpdateUser(int _Id, string _title, string _duration, string _genre, string _summary, string _image) { try { using (var entities = new DbMovieNetEntities()) { MovieSet MovieUpdate = null; MovieUpdate = (from mv in entities.MovieSets where mv.Id == _Id select mv).FirstOrDefault(); if (MovieUpdate == null) { return(false); } else { MovieUpdate.Title = _title; MovieUpdate.Duration = _duration; MovieUpdate.Genre = _genre; MovieUpdate.Summary = _summary; MovieUpdate.Image = _image; entities.SaveChanges(); } } } catch (SqlException ex) { NewMethodException(ex); } return(true); }
public IReadOnlyCollection <Note> FindNotesOfUser(int idUser) { IReadOnlyCollection <Note> FindNoteUserCollection = default(IReadOnlyCollection <Note>); IList <Note> FindNoteUserList = new List <Note>(); NoteSet resultFindUserNoteSet = null; try { using (DbMovieNetEntities entities = new DbMovieNetEntities()) { resultFindUserNoteSet = (from nt in entities.NoteSets where nt.UserSet.Id == idUser select nt).FirstOrDefault(); } FindNoteUserList.Add(new Note { ScoreGetSet = resultFindUserNoteSet.Score, CommentGetSet = resultFindUserNoteSet.Comment, Movie_idGetSet = resultFindUserNoteSet.Movie_Id, User_idGetSet = resultFindUserNoteSet.User_Id }); } catch (SqlException ex) { NewMethodException(ex); } return(FindNoteUserCollection = new ReadOnlyCollection <Note>(FindNoteUserList)); }
public ObservableCollection <Movie> FindMovieByTitle(string titleSet) { ObservableCollection <Movie> MovieCollec = null; try { using (var entities = new DbMovieNetEntities()) { MovieCollec = new ObservableCollection <Movie>(entities.MovieSets.Where(movie => movie.Title.Contains(titleSet)).Select( movie => new Movie() { IdGetSet = movie.Id, TitleGetSet = movie.Title, DurationGetSet = movie.Duration, GenreGetSet = movie.Genre, SummaryGetSet = movie.Summary, ImageGetSet = movie.Image, })); } } catch (SqlException ex) { NewMethodException(ex); } return(MovieCollec); }
public User LoginUser(string _Login, string _Password) { UserSet userset = null; User user = null; try { using (var entities = new DbMovieNetEntities()) { userset = (from u in entities.UserSets where u.Login == _Login && u.Password == _Password select u).FirstOrDefault(); if (userset == null) { return(null); } } user = new User { LoginGetSet = userset.Login, PasswordGetSet = userset.Password }; } catch (SqlException ex) { NewMethodException(ex); } return(user); }
public ObservableCollection <User> GetUsersFind(int id) { ObservableCollection <User> searchUser = null; try { using (var entities = new DbMovieNetEntities()) { searchUser = new ObservableCollection <User>(entities.UserSets.Where(u => u.Id == id).Select( user => new User() { IdGetSet = user.Id, FirstnameGetSet = user.Firstname, LastnameGetSet = user.Lastname, LoginGetSet = user.Login, PasswordGetSet = user.Password }));; } return(searchUser); } catch (SqlException ex) { throw new FaultException("Erreur GetUsers: " + ex.Errors); } }
public ObservableCollection <User> GetUsersFindByLogin(string login) { ObservableCollection <User> searchUser = null; try { using (var entities = new DbMovieNetEntities()) { searchUser = new ObservableCollection <User>(entities.UserSets.Where(u => u.Login == login).Select( user => new User() { IdGetSet = user.Id, FirstnameGetSet = user.Firstname, LastnameGetSet = user.Lastname, LoginGetSet = user.Login, PasswordGetSet = user.Password })); } } catch (SqlException ex) { NewMethodException(ex); } return(searchUser); #endregion }
public IReadOnlyCollection <Note> GetNote(int id) { IReadOnlyCollection <Note> NoteCollection = default(IReadOnlyCollection <Note>); IList <Note> NoteList = new List <Note>(); NoteSet resultNoteSet = null; try { using (var entities = new DbMovieNetEntities()) { resultNoteSet = entities.NoteSets.Where(note => note.Id == id).FirstOrDefault(); } NoteList.Add(new Note { ScoreGetSet = resultNoteSet.Score, CommentGetSet = resultNoteSet.Comment, Movie_idGetSet = resultNoteSet.Movie_Id }); } catch (SqlException ex) { NewMethodException(ex); } return(NoteCollection = new ReadOnlyCollection <Note>(NoteList)); }
public bool UpdateUser(string _nom, string _prenom, string _login, string _password) { try { using (DbMovieNetEntities entities = new DbMovieNetEntities()) { UserSet UserUpdate = null; UserUpdate = (from u in entities.UserSets where u.Login == _login select u).FirstOrDefault(); if (UserUpdate == null) { return(false); } else { UserUpdate.Firstname = _nom; UserUpdate.Lastname = _prenom; UserUpdate.Login = _login; UserUpdate.Password = _password; entities.SaveChanges(); } } } catch (SqlException ex) { NewMethodException(ex); } return(true); }
public IReadOnlyCollection <Note> GetAllNote() { IReadOnlyCollection <Note> movieCollection = default(IReadOnlyCollection <Note>); IList <Note> NoteList = new List <Note>(); var resultNoteSet = (dynamic)null; try { using (var entities = new DbMovieNetEntities()) { resultNoteSet = (from nt in entities.NoteSets select nt).ToList(); } foreach (NoteSet mv in resultNoteSet) { NoteList.Add(new Note { ScoreGetSet = mv.Score, CommentGetSet = mv.Comment, Movie_idGetSet = mv.Movie_Id }); } movieCollection = new ReadOnlyCollection <Note>(NoteList); } catch (SqlException ex) { NewMethodException(ex); } return(movieCollection); }
public bool UpdateNote(Note noteSet) { try { using (var entities = new DbMovieNetEntities()) { var NoteUpdate = entities.NoteSets.FirstOrDefault(movie => movie.Score == noteSet.ScoreGetSet && movie.Comment == noteSet.CommentGetSet); if (NoteUpdate != null) { NoteUpdate.Score = noteSet.ScoreGetSet; NoteUpdate.Comment = noteSet.CommentGetSet; entities.SaveChanges(); } } } catch (SqlException ex) { NewMethodException(ex); } return(true); }
public IReadOnlyCollection <Movie> FindMovieByGenre(string genreSet) { IReadOnlyCollection <Movie> movieCollectGenre = default(IReadOnlyCollection <Movie>); IList <Movie> movieList = new List <Movie>(); IList <MovieSet> resultMovieSet = default(IList <MovieSet>); try { using (var entities = new DbMovieNetEntities()) { resultMovieSet = entities.MovieSets.Where(movie => movie.Genre.Contains(genreSet)).ToList(); } foreach (MovieSet mv in resultMovieSet) { movieList.Add(new Movie { TitleGetSet = mv.Title, DurationGetSet = mv.Duration, GenreGetSet = mv.Genre, SummaryGetSet = mv.Summary, ImageGetSet = mv.Image }); } movieCollectGenre = new ReadOnlyCollection <Movie>(movieList); } catch (SqlException ex) { NewMethodException(ex); } return(movieCollectGenre); }
public ObservableCollection <User> GetUsers() { ObservableCollection <User> UserCollec = null; using (var entities = new DbMovieNetEntities()) { UserCollec = new ObservableCollection <User>(entities.UserSets.Select( user => new User() { FirstnameGetSet = user.Firstname, LastnameGetSet = user.Lastname, LoginGetSet = user.Login, PasswordGetSet = user.Password })); } return(UserCollec); }
public bool DeleteUser(User user) { try { using (var entities = new DbMovieNetEntities()) { var Userdelete = entities.UserSets.Where(userSet => userSet.Login == user.LoginGetSet).ToArray(); entities.UserSets.RemoveRange(entities: Userdelete); entities.SaveChanges(); } } catch (SqlException ex) { NewMethodException(ex); } return(true); }
/* #region GetMovieID * * public IReadOnlyCollection<Movie> GetMovie(int idSet) * { * IReadOnlyCollection<Movie> movieCollection = default(IReadOnlyCollection<Movie>); * IList<Movie> movieList = new List<Movie>(); * MovieSet resultMovieSet = null; * * try * { * using (var entities = new DbMovieNetEntities()) * { * resultMovieSet = entities.MovieSets.Where(movie => movie.Id == idSet).FirstOrDefault(); * } * * * movieList.Add(new Movie * { * TitleGetSet = resultMovieSet.Title, * DurationGetSet = resultMovieSet.Duration, * GenreGetSet = resultMovieSet.Genre, * SummaryGetSet = resultMovieSet.Summary * * }); * * * movieCollection = new ReadOnlyCollection<Movie>(movieList); * * } * catch (SqlException ex) * { * NewMethodException(ex); * } * * return movieCollection; * } #endregion */ #region Movie by Id public ObservableCollection <Movie> GetAllMoviesById(int idSet) { ObservableCollection <Movie> MovieCollec = null; using (var entities = new DbMovieNetEntities()) { MovieCollec = new ObservableCollection <Movie>(entities.MovieSets.Where(movie => movie.Id == idSet).Select( movie => new Movie() { TitleGetSet = movie.Title, DurationGetSet = movie.Duration, GenreGetSet = movie.Genre, SummaryGetSet = movie.Summary, ImageGetSet = movie.Image, UserSet_idGetSet = movie.UserSet.Id })); } return(MovieCollec); }
public bool DeleteNote(Note note) { try { using (var entities = new DbMovieNetEntities()) { var Notedelete = entities.NoteSets.Where(nt => nt.Id == note.IdGetSet).ToArray(); entities.NoteSets.RemoveRange(Notedelete); entities.SaveChanges(); } } catch (SqlException ex) { NewMethodException(ex); } return(true); }
public bool DeleteMovie(int idSet) { try { using (var entities = new DbMovieNetEntities()) { var Moviedelete = entities.MovieSets.Where(movie => movie.Id == idSet).ToArray(); entities.MovieSets.RemoveRange(Moviedelete); entities.SaveChanges(); } } catch (SqlException ex) { NewMethodException(ex); } return(true); }
public bool CreateUser(string _Firstname, string _Lastname, string _Login, string _Password) { try { using (var entities = new DbMovieNetEntities()) { entities.UserSets.Add(new UserSet() { Firstname = _Firstname, Lastname = _Lastname, Login = _Login, Password = _Password }); entities.SaveChanges(); } } catch (SqlException ex) { NewMethodException(ex); } return(true); }
public bool CreateNote(int _note, string _comment, int _idUser, int _idMovie) { try { using (var entities = new DbMovieNetEntities()) { entities.NoteSets.Add(new NoteSet() { Score = _note, Comment = _comment, Movie_Id = _idMovie, User_Id = _idUser }); entities.SaveChanges(); } } catch (SqlException ex) { NewMethodException(ex); } return(true); }
public ObservableCollection <Note> FindNotesOfMovie(int idMovie) { ObservableCollection <Note> FindNoteList = null; try { using (var entities = new DbMovieNetEntities()) { FindNoteList = new ObservableCollection <Note>(entities.NoteSets.Where(note => note.Movie_Id == idMovie).Select( note => new Note() { ScoreGetSet = note.Score, CommentGetSet = note.Comment, Movie_idGetSet = note.Movie_Id }).ToList()); } } catch (SqlException ex) { NewMethodException(ex); } return(FindNoteList); }