private async Task AddProducersToMovie(MovieDTO movieDTO, Movie movie)
{
foreach (int producerId in movieDTO.MovieProducersId)
{
Producer producer = await _context.Producers.FindAsync(producerId);
MovieProducer movieProducer = new MovieProducer(movie, producer);
movie.Add(movieProducer);
}
}
public void Verify_Add_Should_AddTheEntityToTheContext()
{
// Arrange
Mock<IDbSet<MovieProducer>> mockSetMovieProducers;
var mockContext = MovieProducersMockingSetup.DoMockingSetupForContext(false, out mockSetMovieProducers);
var repository = new MovieProducersRepository(mockContext.Object);
var movieProducers = new MovieProducer { Active = true, CustomKey = "SALVATORE-RAA", };
// Act
repository.Add(movieProducers);
// Assert
mockSetMovieProducers.Verify(x => x.Add(movieProducers), Times.Once);
}
public void Verify_Add_Should_AddTheEntityToTheContext()
{
// Arrange
Mock <IDbSet <MovieProducer> > mockSetMovieProducers;
var mockContext = MovieProducersMockingSetup.DoMockingSetupForContext(false, out mockSetMovieProducers);
var repository = new MovieProducersRepository(mockContext.Object);
var movieProducers = new MovieProducer {
Active = true, CustomKey = "SALVATORE-RAA",
};
// Act
repository.Add(movieProducers);
// Assert
mockSetMovieProducers.Verify(x => x.Add(movieProducers), Times.Once);
}
public void Verify_MapToEntity_WithExistingEntity_AssignsMovieProducerProperties()
{
// Arrange
var mapper = new MovieProducerMapper();
var model = MovieProducersMockingSetup.DoMockingSetupForMovieProducerModel();
// Act
IMovieProducer existingEntity = new MovieProducer {
Id = 1
};
mapper.MapToEntity(model.Object, ref existingEntity);
// Assert
// <None>
// Related Objects
Assert.Equal(model.Object.MovieId, existingEntity.MovieId);
Assert.Equal(model.Object.ProducerId, existingEntity.ProducerId);
// Associated Objects
// <None>
}
private async Task StoreDataInDb(ImdbStoreModel item)
{
using (var dbContext = new MyDbContext("Server=localhost;Database=DeltaX;Trusted_Connection=True;"))
{
dbContext.Movies.Add(item.Movy);
foreach (var actorItem in item.Actors)
{
if (actorItem.ActorId == 0)
{
dbContext.Actors.Add(actorItem);
}
}
if (item.Producer.ProducerId == 0)
{
dbContext.Producers.Add(item.Producer);
}
MovieProducer movieProducer = new MovieProducer
{
MovieId = item.Movy.MovieId,
ProducerId = item.Producer.ProducerId
};
dbContext.MovieProducers.Add(movieProducer);
var res = await dbContext.SaveChangesAsync().ConfigureAwait(false);
foreach (var actorItem in item.Actors)
{
item.Movy.MovieProducerActors.Add(new MovieProducerActor
{
ActorId = actorItem.ActorId,
MovieId = item.Movy.MovieId
});
}
res = await dbContext.SaveChangesAsync().ConfigureAwait(false);
}
}
public void FillDbWithData()
{
Country country1 = new Country {
Name = "Poland"
};
Country country2 = new Country {
Name = "Vietnam"
};
Person director1 = new Person
{
FirstName = "Joe",
LastName = "Doe",
Type = TypeOfPeople.DIRECTOR,
DateOfBirth = DateTime.Now,
DateOfDeath = DateTime.Now,
Sex = TypeOfSex.MALE,
Country = country1
};
Person actor1 = new Person
{
FirstName = "Stefa",
LastName = "Rychu",
Type = TypeOfPeople.ACTOR,
DateOfBirth = DateTime.Now,
DateOfDeath = DateTime.Now,
Sex = TypeOfSex.FEMALE,
Country = country2
};
Person actor2 = new Person
{
FirstName = "Rychu",
LastName = "Peja",
Type = TypeOfPeople.ACTOR,
DateOfBirth = DateTime.Now,
DateOfDeath = DateTime.Now,
Sex = TypeOfSex.MALE,
Country = country1
};
Movie movie1 = new Movie
{
Title = "Snoop doog",
Director = director1,
Genre = TypesOfGenre.COMEDY,
Length = 127,
Year = DateTime.Now,
Country = country2
};
Producer producer1 = new Producer
{
CompanyName = "Test Company",
YearEstablished = DateTime.Now,
EstimatedCompanyValue = 40000000,
Country = country1,
};
MoviePerson moviePerson1 = new MoviePerson(movie1, actor1);
MoviePerson moviePerson2 = new MoviePerson(movie1, actor2);
MovieProducer movieProducer1 = new MovieProducer(movie1, producer1);
movie1.Add(moviePerson1);
movie1.Add(moviePerson2);
movie1.Add(movieProducer1);
_context.Movies.Add(movie1);
_context.SaveChanges();
}
public void Verify_MapToEntity_WithExistingEntity_AssignsMovieProducerProperties()
{
// Arrange
var mapper = new MovieProducerMapper();
var model = MovieProducersMockingSetup.DoMockingSetupForMovieProducerModel();
// Act
IMovieProducer existingEntity = new MovieProducer { Id = 1 };
mapper.MapToEntity(model.Object, ref existingEntity);
// Assert
// <None>
// Related Objects
Assert.Equal(model.Object.MovieId, existingEntity.MovieId);
Assert.Equal(model.Object.ProducerId, existingEntity.ProducerId);
// Associated Objects
// <None>
}
//--------------------------------------------------------------------------------------------- /Добавление фильма
private void button2_Click(object sender, EventArgs e)
{
Movie movie = new Movie
{
Name = null,
Genres = null,
Date = DateTime.Now,
Category = null,
Actors = null,
Producers = null,
Contries = null,
Description = null
};
My.Movies.Add(movie);
My.SaveChanges();
//--------------------------------------------------------------------------------------------- //Жанр фильма
var genres = new Collection <KinoSoft.MovieGenre>();
if (GenreAdd.id != null)
{
foreach (Genre genre in GenreAdd.id)
{
MovieGenre mGenre = new MovieGenre
{
MovieId = movie.Id,
GenreId = genre.Id
};
My.MovieGenre.Add(mGenre);
genres.Add(mGenre);
}
}
//--------------------------------------------------------------------------------------------- //Название фильма
string name = MovieName.Text;
//--------------------------------------------------------------------------------------------- //Дата выпуска фильма
DateTime date = Convert.ToDateTime(Data.Text);
//--------------------------------------------------------------------------------------------- //Категория фильма
string category = Category.Text;
//--------------------------------------------------------------------------------------------- //Режиссёр(-ы) фильма
var producers = new Collection <KinoSoft.MovieProducer>();
if (ProducerAdd.id != null)
{
foreach (Producer producer in ProducerAdd.id)
{
MovieProducer mProducer = new MovieProducer
{
MovieId = movie.Id,
ProducerId = producer.Id
};
My.MoviMovieProducere.Add(mProducer);
producers.Add(mProducer);
}
}
//--------------------------------------------------------------------------------------------- //Актёр(-ы) фильма
var actors = new Collection <KinoSoft.MovieActor>();
if (ActorAdd.id != null)
{
foreach (Actor actor in ActorAdd.id)
{
MovieActor mActor = new MovieActor
{
MovieId = movie.Id,
ActorId = actor.Id
};
My.MovieActors.Add(mActor);
actors.Add(mActor);
}
}
//--------------------------------------------------------------------------------------------- //Страна(-ы), в котором(-ых) снимали фильм
var countrys = new Collection <KinoSoft.MovieCountry>();
if (CountryAdd.id != null)
{
foreach (Country country in CountryAdd.id)
{
MovieCountry mCountry = new MovieCountry
{
MovieId = movie.Id,
CountryId = country.Id
};
My.MovieCountry.Add(mCountry);
countrys.Add(mCountry);
}
}
//--------------------------------------------------------------------------------------------- // Описание фильма
string opisanie = Opisanie.Text;
movie.Name = name;
movie.Genres = genres;
movie.Date = date;
movie.Category = category;
movie.Actors = actors;
movie.Producers = producers;
movie.Contries = countrys;
movie.Description = opisanie;
My.SaveChanges();
ProducerAdd.id = null;
ActorAdd.id = null;
CountryAdd.id = null;
GenreAdd.id = null;
this.Close();
////--------------------------------------------------------------------------------------------- //Жанр фильма
//var genre = new Collection<KinoSoft.MovieGenre>();
//if (GenreAdd.id != null)
// foreach (Genre c in GenreAdd.id)
// {
// int genId = c.Id;
// MovieGenre mGen = My.MovieGenre.Where(k => k.Id == genId).FirstOrDefault();
// mGenres.Add(mGen);
// }
////--------------------------------------------------------------------------------------------- //Название фильма
//string name = MovieName.Text;
////--------------------------------------------------------------------------------------------- //Дата выпуска фильма
//DateTime god = Convert.ToDateTime(Data.Text);
////--------------------------------------------------------------------------------------------- //Категория фильма
//string category = Category.Text;
////--------------------------------------------------------------------------------------------- //Режиссёр(-ы) фильма
//var producers = new Collection<KinoSoft.MovieProducer>();
//if (ProducerAdd.id != null)
// foreach (Producer c in ProducerAdd.id)
// {
// int proId = c.Id ;
// MovieProducer MPro = My.MoviMovieProducere.Where(k => k.Id == proId).FirstOrDefault();
// producers.Add(MPro);
// }
////--------------------------------------------------------------------------------------------- //Актёр(-ы) фильма
//var actors = new Collection<KinoSoft.MovieActor>();
//if (ActorAdd.id != null)
// foreach (Actor c in ActorAdd.id)
// {
// int actId = c.Id;
// MovieActor MAct = My.MovieActors.Where(k => k.Id == actId).FirstOrDefault();
// actors.Add(MAct);
// }
////--------------------------------------------------------------------------------------------- //Страна(-ы), в котором(-ых) снимали фильм
//var countrys = new Collection<KinoSoft.MovieCountry>();
//if (CountryAdd.id != null)
// foreach (Country c in CountryAdd.id)
// {
// int couId = c.Id;
// MovieCountry MCou = My.MovieCountry.Where(k => k.Id == couId).FirstOrDefault();
// countrys.Add(MCou);
// }
////--------------------------------------------------------------------------------------------- // Описание фильма
//string opisanie = Opisanie.Text;
////--------------------------------------------------------------------------------------------- //Функция добавления фильма
//LogicMovie LM = new LogicMovie();
//LM.AddMovie(name, god, category, countrys, producers, actors, genre, opisanie);
////--------------------------------------------------------------------------------------------- //Обнуление
//ProducerAdd.id = null;
//ActorAdd.id = null;
//CountryAdd.id = null;
//GenreAdd.id = null;
//this.Close();
}
//--------------------------------------------------------------------------------------------- /Редактирование фильма
private void button4_Click(object sender, EventArgs e)
{
//--------------------------------------------------------------------------------------------- //Жанр фильма
var genre = new Collection <KinoSoft.MovieGenre>();
if (GenreAdd.id != null)
{
foreach (Genre c in GenreAdd.id)
{
int genId = c.Id;
MovieGenre MGen = My.MovieGenre.Where(k => k.Id == genId).FirstOrDefault();
genre.Add(MGen);
}
}
//--------------------------------------------------------------------------------------------- //Название фильма
string name = MovieName.Text;
//--------------------------------------------------------------------------------------------- //Дата выпуска фильма
DateTime god = Convert.ToDateTime(Data.Text);
//--------------------------------------------------------------------------------------------- //Категория фильма
string category = Category.Text;
//--------------------------------------------------------------------------------------------- //Режиссёр(-ы) фильма
var producers = new Collection <KinoSoft.MovieProducer>();
if (ProducerAdd.id != null)
{
foreach (Producer c in ProducerAdd.id)
{
int proId = c.Id;
MovieProducer MPro = My.MoviMovieProducere.Where(k => k.Id == proId).FirstOrDefault();
producers.Add(MPro);
}
}
//--------------------------------------------------------------------------------------------- //Актёр(-ы) фильма
var actors = new Collection <KinoSoft.MovieActor>();
if (ActorAdd.id != null)
{
foreach (Actor c in ActorAdd.id)
{
int actId = c.Id;
MovieActor MAct = My.MovieActors.Where(k => k.Id == actId).FirstOrDefault();
actors.Add(MAct);
}
}
//--------------------------------------------------------------------------------------------- //Страна(-ы), в котором(-ых) снимали фильм
var countrys = new Collection <KinoSoft.MovieCountry>();
if (CountryAdd.id != null)
{
foreach (Country c in CountryAdd.id)
{
int couId = c.Id;
MovieCountry MCou = My.MovieCountry.Where(k => k.Id == couId).FirstOrDefault();
countrys.Add(MCou);
}
}
//--------------------------------------------------------------------------------------------- // Описание фильма
string opisanie = Opisanie.Text;
//--------------------------------------------------------------------------------------------- // Обновление данных
this.movie.Actors = actors;
this.movie.Category = category;
this.movie.Contries = countrys;
this.movie.Date = god;
this.movie.Description = opisanie;
this.movie.Genres = genre;
this.movie.Name = name;
this.movie.Producers = producers;
My.SaveChanges();
//--------------------------------------------------------------------------------------------- // Обнуление
ProducerAdd.id = null;
ActorAdd.id = null;
CountryAdd.id = null;
GenreAdd.id = null;
this.Close();
}
public void Add(MovieProducer movieProducer)
{
MovieProducers.Add(movieProducer);
}
public void FillDbWithData()
{
Country country1 = new Country {
Name = "Poland"
};
Country country2 = new Country {
Name = "Vietnam"
};
Country country3 = new Country {
Name = "France"
};
Person director1 = new Person
{
FirstName = "Joe",
LastName = "Doe",
Type = TypeOfPeople.DIRECTOR,
DateOfBirth = DateTime.Now,
DateOfDeath = DateTime.Now,
Sex = TypeOfSex.MALE,
Country = country1
};
Person director2 = new Person
{
FirstName = "Coco",
LastName = "Jambo",
Type = TypeOfPeople.DIRECTOR,
DateOfBirth = DateTime.Now,
DateOfDeath = DateTime.Now,
Sex = TypeOfSex.MALE,
Country = country3
};
Person actor1 = new Person
{
FirstName = "Stefa",
LastName = "Rychu",
Type = TypeOfPeople.ACTOR,
DateOfBirth = DateTime.Now,
DateOfDeath = DateTime.Now,
Sex = TypeOfSex.FEMALE,
Country = country2
};
Person actor2 = new Person
{
FirstName = "Rychu",
LastName = "Peja",
Type = TypeOfPeople.ACTOR,
DateOfBirth = DateTime.Now,
DateOfDeath = DateTime.Now,
Sex = TypeOfSex.MALE,
Country = country1
};
Person actor3 = new Person
{
FirstName = "Seba",
LastName = "Przykuc",
Type = TypeOfPeople.ACTOR,
DateOfBirth = DateTime.Now,
DateOfDeath = DateTime.Now,
Sex = TypeOfSex.MALE,
Country = country3
};
Person actor4 = new Person
{
FirstName = "Karyna",
LastName = "Bombelek",
Type = TypeOfPeople.ACTOR,
DateOfBirth = DateTime.Now,
DateOfDeath = DateTime.Now,
Sex = TypeOfSex.MALE,
Country = country3
};
Movie movie1 = new Movie
{
Title = "Snoop doog",
Director = director1,
Genre = TypesOfGenre.COMEDY,
Length = 127,
Year = DateTime.Now,
Country = country2
};
Movie movie2 = new Movie
{
Title = "Kac Krakow",
Director = director2,
Genre = TypesOfGenre.DRAMA,
Length = 101,
Year = DateTime.Now,
Country = country1
};
Movie movie3 = new Movie
{
Title = "Zycie ostre jak maczeta",
Director = director2,
Genre = TypesOfGenre.FANTASY,
Length = 101,
Year = DateTime.Now,
Country = country1
};
Producer producer1 = new Producer
{
CompanyName = "Test Company",
YearEstablished = DateTime.Now,
EstimatedCompanyValue = 40000000,
Country = country1,
};
Producer producer2 = new Producer
{
CompanyName = "Januszex POL",
YearEstablished = DateTime.Now,
EstimatedCompanyValue = 999999999999,
Country = country2,
};
MoviePerson movie1Person1 = new MoviePerson(movie1, actor1);
MoviePerson movie1Person2 = new MoviePerson(movie1, actor2);
MoviePerson movie2Person1 = new MoviePerson(movie2, actor2);
MoviePerson movie2Person2 = new MoviePerson(movie2, actor4);
MoviePerson movie3Person1 = new MoviePerson(movie3, actor3);
MoviePerson movie3Person2 = new MoviePerson(movie3, actor4);
MovieProducer movie1Producer1 = new MovieProducer(movie1, producer1);
MovieProducer movie2Producer1 = new MovieProducer(movie2, producer2);
MovieProducer movie2Producer2 = new MovieProducer(movie2, producer1);
MovieProducer movie3Producer1 = new MovieProducer(movie3, producer2);
movie1.Add(movie1Person1);
movie1.Add(movie1Person2);
movie1.Add(movie1Producer1);
movie2.Add(movie2Person1);
movie2.Add(movie2Person2);
movie2.Add(movie2Producer1);
movie2.Add(movie2Producer2);
movie3.Add(movie3Person1);
movie3.Add(movie3Person2);
movie3.Add(movie3Producer1);
_context.Movies.Add(movie1);
_context.Movies.Add(movie2);
_context.Movies.Add(movie3);
_context.SaveChanges();
}
