Beispiel #1
0
 /// <summary>
 /// Returns list of all genres by id
 /// </summary>
 /// <param name="key">id</param>
 /// <returns>context.GenreData_Get</returns>
 public Model.Genres.Genre FindAll(int key)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         return(context.GenreData_Get(key).SingleOrDefault().MapToModel());
     }
 }
Beispiel #2
0
 /// <summary>
 /// Adds object into db
 /// </summary>
 /// <param name="item">Model.Genres.Genre</param>
 /// <returns>context.Genre_Insert</returns>
 public int Add(Model.Genres.Genre item)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         return(context.Genre_Insert(item.Name, item.Description, item.UserCreated?.Id));
     }
 }
 /// <summary>
 /// Finds movies by param key
 /// </summary>
 /// <param name="key"></param>
 /// <returns>Context.MovieData_Get</returns>
 public Model.Movies.Movie FindAll(int key)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         return(context.MovieData_Get(key).FirstOrDefault().MapToModel());
     }
 }
 /// <summary>
 /// Adds items for insertion into db
 /// </summary>
 /// <returns>
 /// context.Movie_Insert
 /// </returns>
 /// <param name="item">Model.Movies.Movie</param>
 public int Add(Model.Movies.Movie item)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         return(context.Movie_Insert(item.Name, item.ReleaseDate, item.Description, item.UserCreated.Id, item.PosterUrl, item.IMDBUrl, item.Rating));
     }
 }
Beispiel #5
0
 /// <summary>
 /// Adds object with items to POST request
 /// </summary>
 /// <param name="item">Model.MovieRatings.MovieRating object</param>
 /// <returns>context.Rating_Insert</returns>
 public int Add(Model.MovieRatings.MovieRating item)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         return(context.Rating_Insert(item.MovieId, item.UserRatedId, item.UserCreated?.Id, item.Rating));
     }
 }
Beispiel #6
0
 /// <summary>
 /// Adds object for POST request
 /// </summary>
 /// <param name="item">Model.MoviePersons.MoviePerson</param>
 /// <returns>context.MoviePerson_Insert</returns>
 public int Add(Model.MoviePersons.MoviePerson item)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         return(context.MoviePerson_Insert(item.FirstName, item.LastName, item.Birthday, item.BirthPlace, item.Biography,
                                           item.UserCreated?.Id, item.PhotoUrl, item.IMDBUrl, item.Popularity));
     }
 }
Beispiel #7
0
 /// <summary>
 /// Adds object to UPDATE request
 /// </summary>
 /// <param name="item"></param>
 /// <returns>Model.MovieRatings.MovieRating</returns>
 public Model.MovieRatings.MovieRating Save(Model.MovieRatings.MovieRating item)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         context.Rating_Save(item.MovieId, item.UserRatedId, item.Rating);
         return(item);
     }
 }
Beispiel #8
0
 /// <summary>
 /// Saves genre into db
 /// </summary>
 /// <param name="item">Model.Genres.Genre</param>
 /// <returns>Model.Genres.Genre</returns>
 public Model.Genres.Genre Save(Model.Genres.Genre item)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         context.Genre_Save(item.Id, item.Name, item.Description,
                            item.UserLastModified?.Id);
         return(item);
     }
 }
 /// <summary>
 /// Adds items for updating existing item
 /// </summary>
 /// <returns>
 /// context.Movie_Save
 /// </returns>
 /// <param name="item">Model.Movies.Movie</param>
 public Model.Movies.Movie Save(Model.Movies.Movie item)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         context.Movie_Save(item.Id, item.Name, item.ReleaseDate, item.Description, item.PosterUrl,
                            item.IMDBUrl, item.Rating, item.UserLastModified?.Id);
         return(item);
     }
 }
Beispiel #10
0
 /// <summary>
 /// Adds id for UPDATE request
 /// </summary>
 /// <param name="item">Model.MoviePersons.MoviePerson</param>
 /// <returns>Model.MoviePersons.MoviePerson</returns>
 public Model.MoviePersons.MoviePerson Save(Model.MoviePersons.MoviePerson item)
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         context.MoviePerson_Save(item.Id, item.FirstName, item.LastName,
                                  item.BirthPlace, item.Birthday, item.Biography,
                                  item.PhotoUrl, item.IMDBUrl, item.Popularity,
                                  item.UserLastModified?.Id);
         return(item);
     }
 }
Beispiel #11
0
 /// <summary>
 /// Adds object for GET request
 /// </summary>
 /// <returns>List<Model.MoviePersons.MoviePerson></returns>
 public List <Model.MoviePersons.MoviePerson> FindAll()
 {
     using (var context = new AngularJsSampleDbEntities()) {
         List <Model.MoviePersons.MoviePerson> list = new List <Model.MoviePersons.MoviePerson>();
         foreach (var item in context.MoviePerson_Get().ToList())
         {
             list.Add(item.MapToModels());
         }
         return(list);
     }
 }
Beispiel #12
0
 /// <summary>
 /// Returns list of all genres
 /// </summary>
 /// <returns>List<Model.Genres.Genre></returns>
 public List <Model.Genres.Genre> FindAll()
 {
     using (var context = new AngularJsSampleDbEntities())
     {
         List <Model.Genres.Genre> list = new List <Model.Genres.Genre>();
         foreach (var item in context.Genres_Get().ToList())
         {
             list.Add(item.MapToModels());
         }
         return(list);
     }
 }
Beispiel #13
0
 /// <summary>
 /// Adds object for DELETE request
 /// </summary>
 /// <param name="item">Model.MoviePersons.MoviePerson</param>
 /// <returns>System.Boolean</returns>
 public bool Delete(Model.MoviePersons.MoviePerson item)
 {
     try
     {
         using (var context = new AngularJsSampleDbEntities())
         {
             context.MoviePerson_Delete(item.Id, item.UserLastModified?.Id);
             return(true);
         }
     }
     catch (Exception e)
     {
         Console.WriteLine($"The exception is: '{e}'");
         return(false);
     }
 }
Beispiel #14
0
 /// <summary>
 /// Adds id for GET request
 /// </summary>
 /// <param name="key">MoviePerson id</param>
 /// <returns>Model.MoviePersons.MoviePerson</returns>
 public Model.MoviePersons.MoviePerson FindAll(int key)
 {
     using (var context = new AngularJsSampleDbEntities()) {
         return(context.MoviePersonData_Get(key).SingleOrDefault().MapToModel());
     }
 }