public IEnumerable <GetMoviesResult> Execute(GetMovies query)
{
var c = RepositoryFactory.GetInstance <TBL_MOVIES>().GetAll().ToList();
// selects the distinct movie names
var d = c.GroupBy(car => car.Name).Select(g => g.First()).ToList();
return((from rows in d
select new GetMoviesResult()
{
MovieId = rows.MovieId,
Name = rows.Name,
ActorId = rows.ActorId,
Plot = rows.Plot,
YearofRelease = rows.YearofRelease,
ProducerName = GetProducerById.GetName(rows.ProducerId)
}).OrderBy(data => data.MovieId));
}
public GetMoviesResult Execute(GetMovieById query)
{
List <TBL_ACTORS> _ACTORS = new List <TBL_ACTORS>();
var entity = RepositoryFactory.GetInstance <TBL_MOVIES>().GetAllWith(filter => filter.MovieId == query.MovieId).FirstOrDefault();
var c = RepositoryFactory.GetInstance <TBL_MOVIES>().GetAllWith(filter => filter.Name == entity.Name).ToList();
foreach (var item in c)
{
var d = RepositoryFactory.GetInstance <TBL_ACTORS>().GetAllWith(filter => filter.ActorId == item.ActorId).FirstOrDefault();
_ACTORS.Add(new TBL_ACTORS()
{
Name = d.Name,
Bio = d.Bio,
Sex = d.Sex,
DOB = d.DOB,
ActorId = d.ActorId
});
}
int count = _ACTORS.Count();
int[] actors = new int[count];
for (int i = 0; i < count; i++)
{
actors[i] = _ACTORS[i].ActorId;
}
return(new GetMoviesResult()
{
Name = entity.Name,
ActorId = entity.ActorId,
Plot = entity.Plot,
ProducerName = GetProducerById.GetName(entity.ProducerId),
YearofRelease = entity.YearofRelease,
ProducerId = entity.ProducerId,
Actors = _ACTORS,
ActorsId = actors
});
}
