public static void RemoveMovie(MovieDTO m) { m.Removed = true; JobServiceDB.removeMovie(m); }
public void DeleteMovie(MovieDTO MovieId) { throw new NotImplementedException(); }
public async Task GetMovieFromDB() { ApiHandler api = new ApiHandler(client); FetchedMovie = await api.GetSpecificMovieAsync(MovieId); }
protected void btnNew_Click(object sender, EventArgs e) { string id = txtMovieID.Text.Trim(); //check id null if (id.Equals("")) { SetMessageTextAndColor("MovieID cannot be null", Color.Red); return; } string title = txtMovieTitle.Text.Trim(); if (title.Equals("")) { SetMessageTextAndColor("Movie Title cannot be null", Color.Red); return; } int year = 0, length = 0; float rating = 0; try { length = Convert.ToInt32(txtLength.Text); if (length < 0) { SetMessageTextAndColor("Movie length cannot be negative", Color.Red); return; } } catch { SetMessageTextAndColor("Length must be a number", Color.Red); } try { year = Convert.ToInt32(txtYear.Text); if (year < 0) { SetMessageTextAndColor("Year cannot be negative", Color.Red); return; } } catch { SetMessageTextAndColor("Year must be a number", Color.Red); } try { rating = float.Parse(txtRating.Text); if (rating < 0) { SetMessageTextAndColor("Rating cannot be negative", Color.Red); return; } } catch { SetMessageTextAndColor("Rating must be a number", Color.Red); } string producer = txtProducer.Text.Trim(); string poster = txtPoster.Text.Trim(); string trailer = txtTrailer.Text.Trim(); DateTime startDate = new DateTime(); try { startDate = DateTime.Parse(txtStartDate.Text); } catch { SetMessageTextAndColor("Start Date is wrong format , format must be MM/dd/yyyy", Color.Red); } int genre = ReturnGenreID(dlGenre.SelectedValue); MovieDTO dto = new MovieDTO { MovieID = id, MovieTitle = title, Length = length, Rating = rating, StartDate = startDate, Poster = poster, LinkTrailer = trailer, Producer = producer, Year = year, Genre = genre }; try { if (MovieDao.AddNewMovie(dto)) { List <MovieDTO> list = (List <MovieDTO>)Session["MovieList"]; list.Add(dto); gvStaffList.DataSource = list; gvStaffList.DataBind(); SetMessageTextAndColor("Successfully added", Color.Green); btnDelete.Enabled = true; btnUpdate.Enabled = true; } else { SetMessageTextAndColor("Failed to add", Color.Red); } } catch { SetMessageTextAndColor("Movie ID is already existed", Color.Red); } }
public IHttpActionResult Put(MovieDTO movie) { // Do some work (not shown). return(Content(HttpStatusCode.Accepted, movie)); }
/// <inheritdoc cref="IUpdatable{TDto}.UpdateAsync(TDto)"/> public async Task <MovieDTO> UpdateAsync(MovieDTO dto) { return(await _repository.UpdateAsync(dto)); }
//Henter alt fra et tablenavn public List <object> GetAll(string TableName, string ColumnToCheckName = null, string ValueToMatch = null, Type Type = null) { List <object> LisReturn = new List <object>(); string FilterString = string.Empty; if (ColumnToCheckName != null && ValueToMatch != null && Type != null) { if (Type == typeof(decimal)) { FilterString = (" WHERE " + ColumnToCheckName + " = " + ValueToMatch.Replace(",", ".")); } else if (Type == typeof(string)) { FilterString = (" WHERE " + ColumnToCheckName + " = '" + ValueToMatch + "'"); } else if (Type == typeof(bool)) { FilterString = (" WHERE " + ColumnToCheckName + " = " + (Convert.ToBoolean(ValueToMatch) ? 1 : 0)); } else if (Type == typeof(DateTime)) { FilterString = (" WHERE " + ColumnToCheckName + " = '" + Convert.ToDateTime(ValueToMatch).ToString("yyyy-MM-dd HH:mm:ss.fffffff") + "'"); } else if (Type == typeof(int)) { FilterString = (" WHERE " + ColumnToCheckName + " = " + ValueToMatch); } } try { using (SqlConnection Con = new SqlConnection(ConfigConnectionString)) { Con.Open(); string CommandString = "SELECT * FROM " + TableName + FilterString; using (SqlCommand Com = new SqlCommand(CommandString, Con)) { using (SqlDataReader reader = Com.ExecuteReader()) { while (reader.Read()) { bool Skip = false; object ObjReturn = new object(); switch (TableName) { case "Movie": MovieDTO Movie = new MovieDTO(); ObjReturn = Movie; break; case "Reservation": ReservationDTO Reservation = new ReservationDTO(); ObjReturn = Reservation; break; case "Resource": ResourceDTO Resource = new ResourceDTO(); ObjReturn = Resource; break; case "Screening": ScreeningDTO Screening = new ScreeningDTO(); ObjReturn = Screening; break; case "Seat": SeatDTO Seat = new SeatDTO(); ObjReturn = Seat; break; case "Theater": TheaterDTO Theater = new TheaterDTO(); ObjReturn = Theater; break; case "MovieScreening": MovieScreeningDTO MovieScreening = new MovieScreeningDTO(); ObjReturn = MovieScreening; break; case "ResourceScreening": ResourceScreeningDTO ResourceScreening = new ResourceScreeningDTO(); ObjReturn = ResourceScreening; break; default: ObjReturn = null; Skip = true; break; } if (!Skip) { //Løber igennem properties og sætter property til værdien den finder i rækkens felt med samme kolonnenavn som propertyname foreach (PropertyInfo pi in ObjReturn.GetType().GetProperties()) { pi.SetValue(ObjReturn, reader.GetValue(reader.GetOrdinal(pi.Name))); } LisReturn.Add(ObjReturn); } } } } } } catch (Exception Ex) { LisReturn.Add(Ex); } return(LisReturn); }
//DTO? public void CreateMovie(MovieDTO movieDTO) { movieCollectionDAL.CreateMovie(movieDTO); }
public void UpdateMovie(MovieDTO movieDTO) { movieDAL.Update(movieDTO, movieDTO.ID); }
public static void quitMovie(ActorDTO actorDTO, MovieDTO movieDTO) { JobServiceDB.getMovieById(movieDTO.Id).Job.assigned = false; JobServiceDB.getMovieById(movieDTO.Id).idActor = null; JobServiceDB.DBaccess.SaveChanges(); }
public void SaveMovie([FromBody] MovieDTO movie, Guid movieId) { _movieManagement.AddOrUpdate(movie); }
public void Post([FromBody] MovieDTO dto, [FromServices] ICreateMovieCommand command) { executor.ExecuteCommand(command, dto); }
// Check if movie exist in database public bool movieExist(MovieDTO mdt) { return(_DB.Movies.Any(m => m.title == mdt.Title)); }
public static void AssignMovie(MovieDTO m, ActorDTO a) { m.Assigned = true; a.MovieList.Add(m); JobServiceDB.assignMovie(m, a); }
/// <summary> /// Use this method for your mainlinks. Eg CRUD, just add /// more links to your CRUD methods inside /// Wollter /// </summary> /// <param name="movie"></param> /// <returns></returns> internal MovieDTO HateoasGetAllMethodLinks(MovieDTO movieDto) { movieDto.Links.Add(UrlLink("_self", "GetIdAsync", new { id = movieDto.MovieID })); return(movieDto); }
public async Task <MovieDTO> PutMovie(int id, MovieDTO movieDTO) { if (movieDTO == null) { throw new ArgumentNullException(nameof(movieDTO)); } try { Movie movie = await _context.Movies.Include(s => s.MovieActors) .Include(s => s.MovieGenres).FirstOrDefaultAsync(s => s.Id == id).ConfigureAwait(false); movie.Name = movieDTO.Name; movie.Synopsis = movieDTO.Synopsis; movie.Director = movieDTO.Director; movie.Aired = movieDTO.Aired; movie.Duration = movieDTO.Duration; movie.Score = movieDTO.Score; movie.Image = movieDTO.Image; _context.MovieActors.RemoveRange(movie.MovieActors); foreach (MovieActorDTO movieActorDTO in movieDTO.MovieActorDTOs) { Actor actor = _context.Actors.Find(movieActorDTO.ActorId); movie.MovieActors.Add(new MovieActor() { MovieId = movie.Id, Movie = movie, ActorId = actor.Id, Actor = actor }); } _context.MovieGenres.RemoveRange(movie.MovieGenres); foreach (MovieGenreDTO movieGenreDTO in movieDTO.MovieGenreDTOs) { Genre genre = _context.Genres.Find(movieGenreDTO.GenreId); movie.MovieGenres.Add(new MovieGenre() { MovieId = movie.Id, Movie = movie, GenreId = genre.Id, Genre = genre }); } await _context.SaveChangesAsync().ConfigureAwait(false); } catch (DbUpdateConcurrencyException) { if (!MovieExists(id)) { return(null); } else { throw; } } return(movieDTO); }
public void Execute(MovieDTO request) { throw new NotImplementedException(); }
public IActionResult Add(MovieDTO model, string name, string descreption, string categoryName) { movieService.Add(model, name, descreption, categoryName); return(new JsonResult("")); }
//Henter en række fra et tablenavn hvor id findes public object Get(string TableName, int Id) { object ObjReturn = new object(); switch (TableName) { case "Movie": MovieDTO Movie = new MovieDTO(); ObjReturn = Movie; break; case "Reservation": ReservationDTO Reservation = new ReservationDTO(); ObjReturn = Reservation; break; case "Resource": ResourceDTO Resource = new ResourceDTO(); ObjReturn = Resource; break; case "Screening": ScreeningDTO Screening = new ScreeningDTO(); ObjReturn = Screening; break; case "Seat": SeatDTO Seat = new SeatDTO(); ObjReturn = Seat; break; case "Theater": TheaterDTO Theater = new TheaterDTO(); ObjReturn = Theater; break; case "MovieScreening": MovieScreeningDTO MovieScreening = new MovieScreeningDTO(); ObjReturn = MovieScreening; break; default: ObjReturn = null; break; } if (ObjReturn != null) { try { using (SqlConnection con = new SqlConnection(ConfigConnectionString)) { con.Open(); using (SqlCommand com = new SqlCommand("SELECT * FROM " + TableName + " where id = " + Id.ToString(), con)) { using (SqlDataReader reader = com.ExecuteReader()) { while (reader.Read()) { //Løber igennem properties og sætter property til værdien den finder i rækkens felt med samme kolonnenavn som propertyname foreach (PropertyInfo pi in ObjReturn.GetType().GetProperties()) { pi.SetValue(ObjReturn, reader.GetValue(reader.GetOrdinal(pi.Name))); } } } } } } catch (Exception Ex) { return(Ex); } } return(ObjReturn); }
public IActionResult Edit(MovieDTO model, int Id, string name, string descreption, string categoryName, string[] IdToAdd) { movieService.Update(model, Id, name, descreption, categoryName, IdToAdd); return(new JsonResult("")); }
protected void btnUpdate_Click(object sender, EventArgs e) { string id = txtMovieID.Text.Trim(); //check id null if (id.Equals("")) { SetMessageTextAndColor("MovieID cannot be null", Color.Red); return; } string title = txtMovieTitle.Text.Trim(); if (title.Equals("")) { SetMessageTextAndColor("Movie Title cannot be null", Color.Red); return; } int year = 0, length = 0; float rating = 0; try { length = Convert.ToInt32(txtLength.Text); if (length < 0) { SetMessageTextAndColor("Movie length cannot be negative", Color.Red); return; } } catch { SetMessageTextAndColor("Length must be a number", Color.Red); } try { year = Convert.ToInt32(txtYear.Text); if (year < 0) { SetMessageTextAndColor("Year cannot be negative", Color.Red); return; } } catch { SetMessageTextAndColor("Year must be a number", Color.Red); } try { rating = float.Parse(txtRating.Text); if (rating < 0) { SetMessageTextAndColor("Rating cannot be negative", Color.Red); return; } } catch { SetMessageTextAndColor("Rating must be a number", Color.Red); } string producer = txtProducer.Text.Trim(); string poster = txtPoster.Text.Trim(); string trailer = txtTrailer.Text.Trim(); DateTime startDate = new DateTime(); try { startDate = DateTime.Parse(txtStartDate.Text); } catch { SetMessageTextAndColor("Start Date is wrong format , format must be MM/dd/yyyy", Color.Red); } int genre = ReturnGenreID(dlGenre.SelectedValue); MovieDTO dto = new MovieDTO { MovieID = id, MovieTitle = title, Length = length, Rating = rating, StartDate = startDate, Poster = poster, LinkTrailer = trailer, Producer = producer, Year = year, Genre = genre }; try { if (MovieDao.UpdateMovie(dto)) { List <MovieDTO> list = (List <MovieDTO>)Session["AdminMovieSearch"]; foreach (MovieDTO item in list) { if (item.MovieID.Equals(id)) { item.MovieTitle = dto.MovieTitle; item.Year = dto.Year; item.Length = dto.Length; item.Rating = dto.Rating; item.Producer = dto.Producer; item.Poster = dto.Poster; item.LinkTrailer = dto.LinkTrailer; item.StartDate = dto.StartDate; item.Genre = dto.Genre; } } gvStaffList.DataSource = list; gvStaffList.DataBind(); SetMessageTextAndColor("Successfully updated", Color.Green); } else { SetMessageTextAndColor("Failed to update", Color.Red); } } catch { SetMessageTextAndColor("Server encounter a fatal error please try again later.", Color.Red); } }
public void AddMovie(MovieDTO movie) { Add <Movie>(mapper.Map <Movie>(movie)); Save(); }
public IActionResult GetMovieById(int id) { MovieDTO objectList = _moviesService.GetMovieById(id); return(Ok(objectList)); }
public void EditMovie(MovieDTO movie) { Edit <Movie>(mapper.Map <Movie>(movie)); Save(); }
/// <summary> /// Adds the provided Movie and all associated information (Actors, Directors, Genres, /// Languages, Tags) to the provided context. Assumes the all Movie information is /// unique, GetRandomMovie() provides a Movie with information that is astronomically /// unlikely to repeat. /// </summary> /// <param name="context"></param> /// <param name="movieDTO"></param> public static void AddMovieDTOToDatabase(Cinephiliacs_MovieContext context, MovieDTO movieDTO) { Movie movie = new Movie(); movie.ImdbId = movieDTO.ImdbId; movie.Title = movieDTO.Title; Rating newRating = new Rating(); newRating.RatingName = movieDTO.RatingName; context.Ratings.Add(newRating); context.SaveChanges(); movie.RatingId = context.Ratings.FirstOrDefault(r => r.RatingName == movieDTO.RatingName).RatingId; movie.ReleaseDate = DateTime.ParseExact(movieDTO.ReleaseDate, "yyyy-MM-dd", CultureInfo.InvariantCulture); movie.IsReleased = true; movie.ReleaseCountry = movieDTO.ReleaseCountry; movie.RuntimeMinutes = movieDTO.RuntimeMinutes; movie.Plot = movieDTO.Plot; movie.PosterUrl = movieDTO.PosterURL; context.Movies.Add(movie); context.SaveChanges(); foreach (var movieActorName in movieDTO.MovieActors) { Actor newActor = new Actor(); newActor.ActorName = movieActorName; context.Actors.Add(newActor); context.SaveChanges(); Actor actor = context.Actors.FirstOrDefault(a => a.ActorName == movieActorName); MovieActor movieActor = new MovieActor(); movieActor.ImdbId = movieDTO.ImdbId; movieActor.ActorId = actor.ActorId; context.MovieActors.Add(movieActor); context.SaveChanges(); } foreach (var movieDirectorName in movieDTO.MovieDirectors) { Director newDirector = new Director(); newDirector.DirectorName = movieDirectorName; context.Directors.Add(newDirector); context.SaveChanges(); Director director = context.Directors.FirstOrDefault(d => d.DirectorName == movieDirectorName); MovieDirector movieDirector = new MovieDirector(); movieDirector.ImdbId = movieDTO.ImdbId; movieDirector.DirectorId = director.DirectorId; context.MovieDirectors.Add(movieDirector); context.SaveChanges(); } foreach (var movieGenreName in movieDTO.MovieGenres) { Genre newGenre = new Genre(); newGenre.GenreName = movieGenreName; context.Genres.Add(newGenre); context.SaveChanges(); Genre genre = context.Genres.FirstOrDefault(a => a.GenreName == movieGenreName); MovieGenre movieGenre = new MovieGenre(); movieGenre.ImdbId = movieDTO.ImdbId; movieGenre.GenreId = genre.GenreId; context.MovieGenres.Add(movieGenre); context.SaveChanges(); } foreach (var movieLanguageName in movieDTO.MovieLanguages) { Language newLanguage = new Language(); newLanguage.LanguageName = movieLanguageName; context.Languages.Add(newLanguage); context.SaveChanges(); Language language = context.Languages.FirstOrDefault(a => a.LanguageName == movieLanguageName); MovieLanguage movieLanguage = new MovieLanguage(); movieLanguage.ImdbId = movieDTO.ImdbId; movieLanguage.LanguageId = language.LanguageId; context.MovieLanguages.Add(movieLanguage); context.SaveChanges(); } foreach (var movieTagName in movieDTO.MovieTags) { Tag newTag = new Tag(); newTag.TagName = movieTagName; newTag.IsBanned = false; context.Tags.Add(newTag); context.SaveChanges(); MovieTag movieTag = new MovieTag(); movieTag.ImdbId = movieDTO.ImdbId; movieTag.TagName = movieTagName; movieTag.VoteSum = 1; context.MovieTags.Add(movieTag); context.SaveChanges(); } }
public static void QuitMovie(ActorDTO a, MovieDTO m) { m.Assigned = false; a.MovieList.Remove(a.MovieList.FirstOrDefault(x => x.Id == m.Id)); UserServiceDB.quitMovie(a, m); }
public void EditMovie(MovieDTO dto) { throw new NotImplementedException(); }
public void Put(int id, MovieDTO value) { Movie model = IMovieRepository.Get(id); if (value.Title != null) { model.Title = value.Title; } if (value.ReleaseDate != null) { model.ReleaseDate = value.ReleaseDate; } if (value.RunTime != 0) { model.RunTime = value.RunTime; } if (value.Vote != 0) { model.Vote = value.Vote; } IMovieRepository.Update(model); if (value.ActorId != null) { IEnumerable <MovieActor> MyMovieActors = IMovieActorRepository.GetAll().Where(x => x.MovieId == id); foreach (MovieActor MyMovieActor in MyMovieActors) { IMovieActorRepository.Delete(MyMovieActor); } for (int i = 0; i < value.ActorId.Count; i++) { MovieActor MovieActor = new MovieActor() { MovieId = model.Id, ActorId = value.ActorId[i] }; IMovieActorRepository.Create(MovieActor); } } if (value.CompanyId != null) { IEnumerable <MovieCompany> MyMovieCompanies = IMovieCompanyRepository.GetAll().Where(x => x.MovieId == id); foreach (MovieCompany MyMovieCompany in MyMovieCompanies) { IMovieCompanyRepository.Delete(MyMovieCompany); } for (int i = 0; i < value.CompanyId.Count; i++) { MovieCompany MovieCompany = new MovieCompany() { MovieId = model.Id, CompanyId = value.CompanyId[i] }; IMovieCompanyRepository.Create(MovieCompany); } } if (value.GenreId != null) { IEnumerable <MovieGenre> MyMovieGenres = IMovieGenreRepository.GetAll().Where(x => x.MovieId == id); foreach (MovieGenre MyMovieGenre in MyMovieGenres) { IMovieGenreRepository.Delete(MyMovieGenre); } for (int i = 0; i < value.GenreId.Count; i++) { MovieGenre MovieGenre = new MovieGenre() { MovieId = model.Id, GenreId = value.GenreId[i] }; IMovieGenreRepository.Create(MovieGenre); } } }
public ActionResult Create([Bind(Include = "MovieID,Name,SmallPictureUrl,LargePictureUrl,HasReleased,LanguageID")] MovieDTO movie) { throw new NotImplementedException(); }
public static void EditMovie(MovieDTO m) { JobServiceDB.editMovie(m); }