public async Task DeleteAsync_given_non_existing_actorId_returns_false()
{
using (var connection = await CreateConnectionAsync())
using (var context = await CreateContextAsync(connection))
{
var repository = new ActorRepository(context);
var deleted = await repository.DeleteAsync(42);
Assert.False(deleted);
}
}
public void TestAddNewActor_Returns_True()
{
ActorRepository actors = new ActorRepository();
actors.Add(new Actor("Emilia", "Lviv", 5, 1));
actors.Add(new Actor("John", "Lviv", 5, 3));
actors.Add(new Actor("Billy", "Kyiv", 5, 10));
bool result = actors.HasElement(new Actor("Emilia", "Lviv", 5, 1));
//assert
Assert.IsTrue(result);
}
public UnitOfWork(CinemaContext context)
{
_context = context;
Actors = new ActorRepository(_context);
CinemaOwners = new CinemaOwnerRepository(_context);
Cinemas = new CinemaRepository(_context);
CinemaScreens = new CinemaScreenRepository(_context);
MovieCategories = new MovieCategoryRepository(_context);
Movies = new MovieRepository(_context);
Producers = new ProducerRepository(_context);
ShowTimes = new ShowTimeRepository(_context);
}
public void Should_Succeed_When_Create_Actor()
{
var actorRepository = new ActorRepository();
var createActorUseCase = new CreateActorUseCase(actorRepository);
var input = new CreateActorInput();
input.PosId = "Pos 100";
var output = new CreateActorOutput();
createActorUseCase.Execute(input, output);
Assert.NotNull(output.ID);
Assert.AreEqual("Pos 100", actorRepository.FindById(output.ID).PosId);
}
public BaseController()
{
string cnnString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
var dbContext = new CinemaDbContext(cnnString);
var actorsRepo = new ActorRepository(dbContext);
_actorService = new ActorService(actorsRepo);
var genreRepo = new GenreRepository(dbContext);
_genreService = new GenreService(genreRepo);
var hallRepo = new HallRepository(dbContext);
_hallService = new HallService(hallRepo);
var movieRepo = new MovieRepository(dbContext);
_movieService = new MovieService(movieRepo, actorsRepo);
}
/// <summary>
/// 查詢明細
/// </summary>
/// <param name="detailRequest"></param>
/// <returns></returns>
public DetailViewModel QueryDetail(DetailRequestViewModel detailRequest)
{
#region 參數宣告
DetailViewModel detail = new DetailViewModel();
IActorRepository actorRp = new ActorRepository();
#endregion
#region 流程
detail = actorRp.QueryDetail(detailRequest);
return(detail);
#endregion
}
public void TestSizeOfActorList_Returns_SizeList()
{
IRepository <Actor> actors = new ActorRepository();
actors.Add(new Actor("Emilia", "Lviv", 5, 1));
actors.Add(new Actor("John", "Lviv", 6, 3));
actors.Add(new Actor("Billy", "Kyiv", 10, 10));
int sizeActual = actors.GetSizeArr();
int sizeExpected = actors.Array().Count;
//assert
Assert.AreEqual(sizeActual, sizeExpected);
}
public bool DeleteSLAForActor(int SLAId)
{
log.Info(string.Format(LogMessages.RequestMethod, RequestContext.Principal.Identity.Name, "Actor\\DeleteSLAForActor"));
ActorRepository actorRepository = new ActorRepository();
if (actorRepository.DeleteSLA(SLAId) > 0)
{
return(true);
}
else
{
throw HttpMessageExceptionBuilder.Build(HttpStatusCode.InternalServerError, HttpMessageType.Error, JsonConvert.SerializeObject(string.Empty), Messages.DeleteSLAForActor, Messages.DeleteSLAForActorHeader);
}
}
/// <summary>
/// 查詢列表
/// </summary>
/// <param name="searchInfo"></param>
/// <returns></returns>
public SearchListViewModel QuerySearchList(SearchInfoViewModel searchInfo)
{
#region 參數宣告
SearchListViewModel searchList = new SearchListViewModel();
IActorRepository actorRp = new ActorRepository();
#endregion
#region 流程
searchList = actorRp.QuerySearchList(searchInfo);
return(searchList);
#endregion
}
public void TestTheMostPopularActor_Returns_ActorwithTheBiggestRatting()
{
ActorRepository actors = new ActorRepository();
actors.Add(new Actor("Emilia", "Lviv", 5, 1));
actors.Add(new Actor("John", "Lviv", 5, 3));
actors.Add(new Actor("Billy", "Kyiv", 5, 10));
string thisResult = actors.PopularObjStr();
string expectedResult = actors.ReturnActorInArrByIndex(2).ToString();
//assert
Assert.AreEqual(thisResult, expectedResult);
}
/// <summary>
/// 新增明細
/// </summary>
/// <param name="detail"></param>
/// <returns></returns>
public bool AddDetail(DetailViewModel detail)
{
#region 參數宣告
bool result = false;
ActorModel actor = new ActorModel();
IActorRepository actorRp = new ActorRepository();
#endregion
#region 流程
actor = PropertyCopy.Convert <DetailViewModel, ActorModel>(detail);
result = actorRp.AddActor(actor);
return(result);
#endregion
}
public async void GetAllActors_validData_true()
{
// Arrange
IList <Actor> actors = GenerateActors();
var movieContextMock = new Mock <MovieContext>();
movieContextMock.Setup(d => d.Actors).ReturnsDbSet(actors);
var logger = Mock.Of <ILogger <ActorRepository> >();
var actorRepository = new ActorRepository(movieContextMock.Object, logger);
// Act
var allActors = await actorRepository.GetAllActors();
// Assert
Assert.Equal(3, allActors.Count);
}
public async Task UpdateAsync_given_non_existing_dto_returns_false()
{
using (var connection = await CreateConnectionAsync())
using (var context = await CreateContextAsync(connection))
{
var repository = new ActorRepository(context);
var dto = new ActorCreateUpdateDTO
{
Id = 0,
Name = "Lauren Tom"
};
var updated = await repository.UpdateAsync(dto);
Assert.False(updated);
}
}
public void TestRemoveActorByIndex_Returns_False()
{
ActorRepository actors = new ActorRepository();
actors.Add(new Actor("Emilia", "Lviv", 5, 1));
actors.Add(new Actor("John", "Lviv", 5, 3));
actors.Add(new Actor("Billy", "Kyiv", 5, 10));
actors.RemoveByIndex(1);// will be removed index=0
Actor actorTemp = new Actor("Emilia", "Lviv", 5, 1);
bool result = actors.IsExist(actorTemp);
//assert
Assert.IsFalse(result);
}
public async Task CreateAsync_given_dto_returns_created_Actor()
{
using (var connection = await CreateConnectionAsync())
using (var context = await CreateContextAsync(connection))
{
var repository = new ActorRepository(context);
var dto = new ActorCreateUpdateDTO
{
Name = "Katey Sagal"
};
var actor = await repository.CreateAsync(dto);
Assert.Equal(1, actor.Id);
Assert.Equal("Katey Sagal", actor.Name);
}
}
public Auctioneer(Fiber fiber, Scheduler scheduler, ActorRepository <Seller, string> sellerRepository)
{
_fiber = fiber;
_sellerRepository = sellerRepository;
_registerSeller = new DefaultMailbox <RegisterSeller>(fiber, scheduler);
_input = new ChannelAdapter();
_subscriptions = _input.Connect(x =>
{
x.Consume <RegisterSeller>()
.Using(message => _registerSeller.Send(message));
});
_registerSeller.Receive(OnRegisterSeller);
}
public async Task <ActionResult <ActorModel[]> > GetActorsAssociatedWithMovie(int movieId)
{
try
{
var results = await ActorRepository.GetActorsByMovieIdAsync(movieId);
if (!results.Any())
{
return(NotFound("No actors found associated with the movie."));
}
return(Ok(_mapper.Map <ActorModel[]>(results)));
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, ex.Message));
}
}
public async Task DeleteAsync_NoActor_DoesNothing()
{
// Arrange
await using var host = await SubDomainIntegrationTestHost.InitializeAsync().ConfigureAwait(false);
var scope = host.BeginScope();
var container = scope.GetInstance <IActorRepositoryContainer>();
var target = new ActorRepository(container);
var actorId = Guid.NewGuid();
var externalId = Guid.NewGuid();
var actor = new Actor(new ActorId(actorId), new ExternalActorId(externalId));
// Act + Assert
await target.DeleteAsync(actor).ConfigureAwait(false);
}
public async Task DeleteAsync_given_existing_actorId_deletes_and_returns_true()
{
using (var connection = await CreateConnectionAsync())
using (var context = await CreateContextAsync(connection))
{
var entity = new Actor {
Name = "Lauren Tom"
};
context.Actors.Add(entity);
await context.SaveChangesAsync();
var id = entity.Id;
var repository = new ActorRepository(context);
var deleted = await repository.DeleteAsync(id);
Assert.True(deleted);
}
}
public IActionResult CreatedMovieOverview(HomeCreateMovieVm vm)
{
ActorRepository actorRepo = new ActorRepository();
DirectorRepository directorRepo = new DirectorRepository();
HomeShowMovieVM vmToShow = new HomeShowMovieVM();
Movie createdMovie = new Movie();
createdMovie.Actors = vm.ActorCheckboxes.Where(checkbox => checkbox.IsSelected)
.Select(checkbox =>
{
return(actorRepo.GetActors().FirstOrDefault(a => checkbox.ActorId == a.Id));
}).ToList();
createdMovie.Title = vm.Title;
createdMovie.Directors = new List <Director>()
{
directorRepository.GetDirectors().FirstOrDefault(d => d.Id == vm.SelectedDirector)
};
vmToShow.Movie = createdMovie;
return(View(vmToShow));
}
public async Task GetActorAsync_NoExternalActorId_ReturnsNull()
{
// Arrange
await using var host = await SubDomainIntegrationTestHost.InitializeAsync().ConfigureAwait(false);
var scope = host.BeginScope();
var container = scope.GetInstance <IActorRepositoryContainer>();
var target = new ActorRepository(container);
var externalId = Guid.NewGuid();
// Act
var actual = await target
.GetActorAsync(new ExternalActorId(externalId))
.ConfigureAwait(false);
// Assert
Assert.Null(actual);
}
public async Task Read_returns_projection_of_all_actors()
{
using (var connection = await CreateConnectionAsync())
using (var context = await CreateContextAsync(connection))
{
var entity = new Actor {
Name = "Billy West"
};
context.Actors.AddRange(entity);
await context.SaveChangesAsync();
var repository = new ActorRepository(context);
var actors = repository.Read();
var actor = await actors.SingleAsync();
Assert.Equal(1, actor.Id);
Assert.Equal("Billy West", actor.Name);
}
}
public void AddActorToDB()
{
// Arrange
Actor aniston = new Actor()
{
Id = 1, Name = "Jennifer Aniston"
};
var context = new AppContext();
if (context.Database.GetPendingMigrations().Any())
{
context.Database.Migrate();
}
ActorRepository repo = new ActorRepository(context);
ActorManager manager = new ActorManager(repo);
// Act
manager.AddActor(aniston);
// Assert
Assert.Single(manager.GetAllActors());
}
public ActorController()
{
service = new ActorService();
repository = new ActorRepository();
}
static void Main(string[] args)
{
ActorRepository actorRepos = new ActorRepository();
CountryRepository countryRepos = new CountryRepository();
SeriesRepository seriesRepos = new SeriesRepository();
ProductionCompanyRepository productionCompanyRepos = new ProductionCompanyRepository();
GenreRepository genreRepos = new GenreRepository();
EpisodeRepository episodeRepos = new EpisodeRepository();
/// <summary>
/// Jag har valt att använda async i min applikation för att simulera hur min seriedatabas
/// skulle kunna användas som del av en webbapplikation. Man kan då tänka sig att man inte vill
/// att webbsidan ska låsas helt tills en viss databasoperation har returnerat ett resultat,
/// t.ex. en lista av skådespelare. För att hantera detta scenario lämpar sig async väl,
/// det finns troligen inget behov av att utnyttja mer resurser för att skapa ytterligare
/// trådar i detta scenario (då det att skapa fler trådar är resurskrävande). Ett annat
/// argument för att välja async framför att skapa flera trådar är att man med async har
/// bättre kontroll över flödet, det går att på ett enklare sätt spåra i koden när en
/// specifik Task kommer att exekveras vilket gör att race conditions ej uppstår lika lätt.
/// </summary>
//var result = actorRepos.GetAllActorsAsync();
//Console.WriteLine("Waiting for list of actors. Adding a series while waiting.");
//seriesRepos.Add(new Series { Title = "Gilmore girls", ProductionCompanyId = 9 });
//Console.WriteLine("Waiting for series to be added.");
//var actors = actorRepos.FindActorByInitialsAsync("sk");
//Console.WriteLine("Waiting for findactorbyinitialasync method to finish.");
//foreach(var actor in actors.Result)
//{
// Console.WriteLine("Actors with given initials:" + actor.FirstName + " " + actor.LastName);
//}
//foreach (var a in result.Result)
//{
// Console.WriteLine(a.FirstName + " " + a.LastName);
//}
//genreRepos.DeleteSeriesGenreConnection(1, 3);
//genreRepos.UpdateGenreForOneSeries(1, 2, 3);
//try
//{
// seriesRepos.DeleteConnectionsBetweenActorAndSpecifiedSeries(35, new List<int> { 3 });
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// countryRepos.DeleteCountriesByNameOrCode("Denmark");
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//catch(ItemNotPossibleToDeleteException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// seriesRepos.DeleteManySeriesActors(35, new List<int> { 3, 27 });
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//genreRepos.UpdateGenreForOneSeries(3, 4, 2);
//genreRepos.DeleteSeriesGenreConnection(3, 2);
//try
//{
// seriesRepos.DeleteSeriesActorByActorId(35);
//}
//catch(NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// var country = countryRepos.GetCountryByCountryName("swe");
// Console.WriteLine(country.Name);
//}
//catch (NullReferenceException e)
//{
// Console.WriteLine(e.Message);
//}
//actorRepos.Delete(new Actor { FirstName = "Stellan", LastName = "Skarsgård", Birthday = new DateTime (1951, 6, 13)});
//actorRepos.DeleteManyActorsByIds(new List<int> { 24, 25 });
//try
//{
// var country = countryRepos.GetCountryByCountryName("sw");
// Console.WriteLine(country.Name);
//}
//catch(NullReferenceException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// var countries = countryRepos.GetAllCountriesByGenre("drama");
// foreach (var c in countries)
// {
// Console.WriteLine(c.Name);
// }
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// var country = countryRepos.GetCountryForActor("stellan", "skarsgård");
// Console.WriteLine("Actor comes from: " + country.Name);
//}
//catch(NullReferenceException)
//{
// Console.WriteLine ("No actor with that name is found in database");
//}
//try
//{
// actorRepos.DeleteActorsByCountry("Germany");
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//countryRepos.AddRange(new Country { Name = "Denmark", CountryCode = "DK"});
//productionCompanyRepos.Add(new ProductionCompany { Name = "Nimbus Film", CountryId = 10 });
//actorRepos.AddRange(new List<Actor>
//{
// new Actor { FirstName = "Zooey", LastName = "Deschanel", Birthday = new DateTime(1980, 1, 17), CountryId = 7 },
// new Actor { FirstName = "Jake", LastName = "Johnson", Birthday = new DateTime(1978, 5, 28), CountryId = 7 },
// new Actor { FirstName = "Max", LastName = "GreenField", Birthday = new DateTime(1980, 9, 4), CountryId = 7 },
//// new Actor { FirstName = "Stellan", LastName = "Skarsgård", Birthday = new DateTime(1951, 6, 13), CountryId = 3},
//// new Actor { FirstName = "Erin", LastName = "Karpluk", Birthday = new DateTime(1978, 10, 17), CountryId = 1},
//// new Actor { FirstName = "Hugh", LastName = "Bonneville", Birthday = new DateTime(1963, 11, 10), CountryId = 2 },
//// new Actor { FirstName = "Laura", LastName = "Carmichael", Birthday = new DateTime(1986, 7, 16), CountryId = 2 },
//// new Actor { FirstName = "Jim", LastName = "Carter", Birthday = new DateTime(1948, 8, 19), CountryId = 2 },
//// new Actor { FirstName = "Michelle", LastName = "Dockery", Birthday = new DateTime(1981, 12, 15), CountryId = 2}
//});
//productionCompanyRepos.AddRange(new List<ProductionCompany>
//{
// new ProductionCompany {Name = "BBC", CountryId = 2},
// new ProductionCompany {Name = "Fox", CountryId = 4},
// new ProductionCompany {Name = "Produktion i Väst", CountryId = 3 },
// new ProductionCompany {Name = "Buccaner Media", CountryId = 2},
// new ProductionCompany {Name = "UFA Fiction", CountryId = 5},
// new ProductionCompany {Name = "Temple Street Productions", CountryId = 1}
//});
// productionCompanyRepos.Add(new ProductionCompany { Name = "Gallery Picture", CountryId = 2 });
//seriesRepos.AddRange(new List<Series>
//{
// new Series {Title = "Being Erica", ProductionCompanyId = 6 },
// new Series {Title = "Downton Abbey", ProductionCompanyId = 1},
// new Series {Title = "River", ProductionCompanyId = 7},
// new Series {Title = "New Girl", ProductionCompanyId = 2},
// new Series {Title = "Silent Hours", ProductionCompanyId = 8},
// new Series {Title = "Deutschland 83", ProductionCompanyId = 5}
//});
//var country = countryRepos.FindBy(c => c.Name.StartsWith("G"));
//foreach (var c in country)
//{
// Console.WriteLine(c.Name);
//}
//countryRepos.UpdateById(7, c => {
// c.CountryCode = "US";
// return c;
// });
//seriesActorRepos.ConnectActorToSeries(4, new List<int> { 6 });
//countryRepos.AddRange(new List<Country>
//{
// new Country{Name = "Canada", CountryCode = "CA"},
// new Country{Name = "Great Britain", CountryCode = "GB"},
// new Country{Name = "Sweden", CountryCode = "SE"},
// new Country{Name = "United States of America", CountryCode = "USA"},
// new Country{Name = "Germany", CountryCode = "DE"}
//});
//foreach (var result in seriesRepos.GetSeriesWithGenres(new List<int> { 2, 3 }))
//{
// Console.WriteLine(result.Item1.Title);
// foreach (var g in result.Item2)
// {
// Console.WriteLine(g.Name);
// }
//}
//var result = genreRepos.GetAllGenresWithAllSeries();
//if (null != result)
//{
// foreach(var s in result)
// {
// Console.WriteLine(s.Item1.Name);
// foreach(var g in s.Item2)
// {
// Console.WriteLine(g.Title);
// }
// }
//}
//try
//{
// var result = seriesRepos.GetSeriesByGenre("River");
// foreach (var s in result)
// {
// Console.WriteLine(s.Title);
// }
//}
//catch(NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// var s = seriesRepos.GetSeriesByReleaseYear(2008);
// foreach (var se in s)
// {
// if(null != se.Title)
// {
// Console.WriteLine(se.Title);
// }
// }
//}
//catch(NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// seriesRepos.ConnectActorToSeries( 24, new List<int> { 27});
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//var result = seriesRepos.GetAllSeriesByActorNameAndCountryName("Michelle", "Great Britain");
//foreach(var s in result)
//{
// Console.WriteLine(s.Title);
//}
//var a = seriesRepos.ProjectionLoadSeries("Downton abbey");
//Console.WriteLine("Title of series: " + a.Title + "\tProductioncompany: " +
// a.ProductionCompany.Name + "\tCountry for productioncompany: " + a.ProductionCompany.Country.Name);
// var result = episodeRepos.GetEpisodesForOneSeries("Being Erica");
// Console.WriteLine(result.Item1.Title);
// foreach (var e in result.Item2)
// {
// Console.WriteLine(e.Title);
// }
//}
//catch(NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
// {
// episodeRepos.DeleteEpisodesBySeriesID(90);
// }
// catch(NoSuchItemException e)
// {
// Console.WriteLine(e.Message);
// }
//episodeRepos.AddRange(new List<Episode>
//{
// new Episode{SeriesId = 2, SeasonNumber = 1, ReleaseDate = new DateTime(2010, 9, 26)},
// new Episode{Title = "Dr. Tom", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 1, 9)},
// new Episode{SeriesId = 2, SeasonNumber = 1, ReleaseDate = new DateTime(2010, 10, 3)},
// new Episode{SeriesId = 2, SeasonNumber = 1, ReleaseDate = new DateTime(2010, 10, 10)},
// new Episode{SeriesId = 2, SeasonNumber = 1, ReleaseDate = new DateTime(2010, 10, 17)},
// new Episode{SeriesId = 2, SeasonNumber = 1, ReleaseDate = new DateTime(2010, 10, 24)},
// new Episode{SeriesId = 2, SeasonNumber = 1, ReleaseDate = new DateTime(2010, 10, 31)},
// new Episode{SeriesId = 2, SeasonNumber = 1, ReleaseDate = new DateTime(2010, 11, 7)},
// new Episode{Title = "What I am is what I am", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 2, 26)},
// new Episode{Title = "Plenty of fish", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 3, 5)},
// new Episode{Title = "The secret of now", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 3, 12)},
// new Episode{Title = "Adultescence", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 3, 19)},
// new Episode{Title = "Til death", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 3, 26)},
// new Episode{Title = "Such a perfect day", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 4, 2)},
// new Episode{Title = "This be the verse", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 4, 9)},
// new Episode{Title = "Everything she wants", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 4, 16)},
// new Episode{Title = "Mi casa su casa loma", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 4, 23)},
// new Episode{Title = "She's lost control", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 4, 30)},
// new Episode{Title = "Erica the vampire slayer", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 5, 7)},
// new Episode{Title = "Leo", SeriesId = 1, SeasonNumber = 1, ReleaseDate = new DateTime(2009, 5, 14)},
//});
//try
//{
// var genres = genreRepos.GetGenresForSeries(new List<int> { 98 });
// foreach (var g in genres)
// {
// Console.WriteLine("Genre: " + g.Name);
// }
//}
//catch(NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// var series = genreRepos.GetOneGenreWithSeries("Romance");
// Console.WriteLine(series.Item1.Name + " series: ");
// foreach (var s in series.Item2)
// {
// Console.WriteLine(s.Title);
// }
//}
//catch(NullReferenceException)
//{
// Console.WriteLine("No such genre in database");
//}
//var seriesGenres = genreRepos.GetAllGenresWithAllSeries();
//foreach(var g in seriesGenres)
//{
// Console.WriteLine("Genre: " + g.Item1.Name);
// foreach(var s in g.Item2)
// {
// Console.WriteLine("Series: " + s.Title);
// }
//}
//try
//{
// var result = seriesRepos.GetSeriesByGenreAndCountry("comedy", "great brin");
// foreach (var a in result)
// {
// Console.WriteLine(a.Title);
// }
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//var result = productionCompanyRepos.GetAllProductionCompaniesInCountry("Sweden");
//foreach(var p in result)
//{
// Console.WriteLine(p.Name);
//}
//productionCompanyRepos.UpdateProductionCompanyCountry(8,
// 7);
//try
//{
// seriesRepos.DeleteSeriesByGenre("drama");
//}
//catch(NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// seriesRepos.AddConnectionBetweenOneSeriesAndOneGenre(45, 2);
//}
//catch(DbUpdateException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// seriesRepos.ConnectSeriesToActors(new List<int> { 27 }, new List<int> { 37});
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// var actors = actorRepos.FindActorsByInitials("ze");
// foreach (var a in actors)
// {
// Console.WriteLine(a.FirstName + " " + a.LastName);
// }
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// var result = actorRepos.GetActorsWithNationality();
// foreach(var a in result)
// {
// Console.WriteLine(a.FirstName + " " + a.LastName);
// Console.WriteLine(a.Country.Name);
// }
//}
//catch(NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// actorRepos.DeleteActorById(21);
// Console.WriteLine("Actor deleted as well as connected posts in actorseries table.");
//}
//catch(NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//actorRepos.UpdateActorLastName("bonneville", "boville");
// seriesRepos.ConnectSeriesToActor(2, new List<int> { 24, 37});
//try
//{
// seriesRepos.DeleteSeriesByTitle("ghhd");
//}
//catch(NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
//try
//{
// productionCompanyRepos.UpdateProductionCompanyForSeries(7, 11);
//}
//catch (NoSuchItemException e)
//{
// Console.WriteLine(e.Message);
//}
}
public void Init(ActorRepository repo, ActorViewModel.Factory factory, ActorSpawner spawner)
{
_factory = factory;
_spawner = spawner;
Init(repo.Actors);
}
public ActorsController()
{
_actorRepository = new ActorRepository();
}
void Start()
{
actors = FindObjectOfType <ActorRepository>();
exorcistHandler = FindObjectOfType <ExorcistHandler>();
GhostProximityDetector.Initialize(EffectRange, ActivationRange, actors, Auras);
}
public ActorViewModel()
{
Actors = ActorRepository.ActorList();
}
static void Main(string[] args)
{
using (MyDatabase db = new MyDatabase())
{
MovieRepository movieRepo = new MovieRepository();
var lista = movieRepo.GetAll().Where(x => x.Title.Contains("e"));
foreach (var movie in lista)
{
Console.WriteLine(movie.Title);
foreach (var actor in movie.Actors) // de douleuei
{
Console.WriteLine(actor.FirstName);
}
}
Console.WriteLine("wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww");
var lista2 = movieRepo.GetAll().Where(x => x.Title.Contains("a"));
foreach (var movie in lista2)
{
Console.WriteLine(movie.Title);
foreach (var actor in movie.Actors)
{
Console.WriteLine(actor.FirstName);
}
}
movieRepo.Dispose();
//AUTO gia ton allo tropo Sta Services!!!!!!!!!!1 chack it out
//giati mporo na anoigokeliso to service opote opote opote goustarw
//ALLA an eisai LAzy Loading sthn GetAll PREPEI na kanw include(x=>x. ... ) tou les fere kai auto
ActorRepository actorRepository = new ActorRepository();
foreach (var item in actorRepository.GetAll()) // de douleuei
{
Console.WriteLine(item.FirstName);
}
actorRepository.Dispose();
//var movies = db.Movies; //san I quirable interfase // tha steilei SQL QUERY STI BASI //zitao ka8e fora apo toservar na mou stelnei thn katallili pliroforia // de me endiaferei gia ena sugkekrimeno query sti basi kai exo para polu RAM
//foreach (var movie in movies)
//{
// Console.WriteLine("{0,-6}{0,-15}", movie.MovieId, movie.Title);
//}
//var movies = db.Movies.ToList(); //simbato me IEnumerable //tha stalei query sti basi poy 8a sou ferei ol aosa xxreiazomai sato run time
////tha to xrismopoiiso gia polla//tha ferei osa xreiazomai sto run time
////fere mou AUTOO apo ti basi, stoxeuMENA!!!!! me linq
//Console.WriteLine("====================================");
//Goldennn.Services.MovieRepository movieRepository = new MovieRepository();
//var movies1 = movieRepository.GetAll().Where(x => x.Title.Contains("e"));
////auti ti stigmi i linq psaxnei sto run, momeory (oxi ston sql server, auto einai allos dromos).
//foreach (var movie in movies1)
//{
// Console.WriteLine("{0,-6}{0,-15}", movie.MovieId, movie.Title);
//}
////App.PrintMoviess();
//Console.WriteLine("psakse tainia");
//string choice = Console.ReadLine();
//int id;
//if (Int32.TryParse(choice, out id))
//{
// App.PrintById(2);
//}
//else
//{
// App.PrintById(null);
//}
////app.PrintMovies()
//Movie m = new Movie() { MovieId = 10, Title = "Battleship Potemkin" };
//movieRepository.Insert(m);
//App.PrintMovies(); // kai ektipono gt exo ftiaksei auton ton mixanismo
//Console.WriteLine("=================================================");
//movieRepository.Insert(m);
//App.PrintMovies();
////app.PrintMovies()
//Movie m1 = new Movie() { MovieId = 10, Title = "Amelie" };
//movieRepository.Update(m);
//App.PrintMovies(); // kai ektipono gt exo ftiaksei auton ton mixanismo
//Console.WriteLine("=================================================");
//movieRepository.Insert(m);
//App.PrintMovies();
////app.PrintMovies()
//Movie m3 = new Movie() { Title = "Lion Kings" };
//var movie3 = movieRepository.GetById(10);
//if (!(movie3 is null))
//{
// movie3.Title = m3.Title;
//}
//movieRepository.Update(movie3);
//App.PrintById(10);
//App.PrintMovies();
//Console.WriteLine("=========================================");
}
Console.ReadKey();
}
private void onOk(object sender, EventArgs e)
{
if (formValidator.Validate())
{
try
{
using (ActorRepository repo = new ActorRepository())
{
actor = repo.SaveNew(actor);
}
}
catch (BusinessEntityRepositoryException ex)
{
MessageBox.Show(this, ex.Message + ":\n\n" + ex.InnerException.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
DialogResult = DialogResult.None;
return;
}
DialogResult = DialogResult.OK;
}
}
public HungerController(ActorRepository repo)
{
_actorRepo = repo;
}
