public FilmCreateResponse Add(FilmCreateRequest request)
{
var response = new FilmCreateResponse();
// Get language
var lang = _languageRepository.Get(request.Film.LanguageId);
var origLang = _languageRepository.Get(request.Film.OriginalLanguageId ?? 0);
var film = new en.Film
{
Language = lang,
OriginalLanguage = origLang,
Title = request.Film.Title,
Description = request.Film.Description,
ReleaseYear = request.Film.ReleaseYear,
RentalDuration = request.Film.RentalDuration,
Length = request.Film.Length,
RentalRate = request.Film.RentalRate,
Rating = request.Film.Rating,
SpecialFeatures = request.Film.SpecialFeatures,
ReplacementCost = request.Film.ReplacementCost,
LastUpdate = DateTime.Now
};
_session.Save(film);
_session.Flush();
response.Film = request.Film;
response.Film.Id = film.Id;
response.Film.LastUpdate = film.LastUpdate;
return(response);
}
public FilmSearchResponse Search(FilmSearchRequest request)
{
var response = new FilmSearchResponse();
Film result = null;
en.Film filmAlias = null;
en.Language languageAlias = null;
en.Language originalLanguageAlias = null;
var queryOver =
_session.QueryOver <en.Film>(() => filmAlias)
.JoinAlias(la => la.Language, () => languageAlias)
.JoinAlias(la => la.OriginalLanguage,
() => originalLanguageAlias,
nh.SqlCommand.JoinType.LeftOuterJoin);
if (!string.IsNullOrWhiteSpace(request.Title))
{
queryOver.WhereRestrictionOn(c => c.Title)
.IsInsensitiveLike(request.Title, nh.Criterion.MatchMode.Anywhere);
}
var rowCountQuery =
queryOver.Clone()
.ToRowCountQuery()
.FutureValue <int>();
response.Items =
queryOver
.SelectList(list => list
.Select(() => filmAlias.Id).WithAlias(() => result.Id)
.Select(() => filmAlias.Title).WithAlias(() => result.Title)
.Select(() => filmAlias.ReleaseYear).WithAlias(() => result.ReleaseYear)
.Select(() => filmAlias.RentalDuration).WithAlias(() => result.RentalDuration)
.Select(() => filmAlias.Length).WithAlias(() => result.Length)
.Select(() => languageAlias.Name).WithAlias(() => result.Language)
.Select(() => originalLanguageAlias.Name).WithAlias(() => result.OriginalLanguage)
.Select(() => filmAlias.RentalRate).WithAlias(() => result.RentalRate)
.Select(() => filmAlias.Rating).WithAlias(() => result.Rating)
.Select(() => filmAlias.Description).WithAlias(() => result.Description)
.Select(() => filmAlias.LastUpdate).WithAlias(() => result.LastUpdate)
.Select(() => filmAlias.ReleaseYear).WithAlias(() => result.ReleaseYear)
.Select(() => filmAlias.ReplacementCost).WithAlias(() => result.ReplacementCost)
.Select(() => filmAlias.SpecialFeatures).WithAlias(() => result.SpecialFeatures)
)
.TransformUsing(Transformers.AliasToBean <Film>())
.Skip((request.PageNumber - 1) * request.ItemsPerPage)
.Take(request.ItemsPerPage)
.List <Film>();
response.TotalItems = rowCountQuery.Value;
return(response);
}
private void PopulateFilmDetails(Film film)
{
if (film?.Id == null)
{
return;
}
Actor actorResult = null;
Category categoryResult = null;
en.Actor actorAlias = null;
en.Film filmAlias = null;
en.Category categoryAlias = null;
var actors = _session.QueryOver <en.Actor>(() => actorAlias)
.JoinAlias(fi => fi.Films, () => filmAlias)
.Where(fa => filmAlias.Id == film.Id)
.SelectList
(
list => list
.Select(() => actorAlias.Id).WithAlias(() => actorResult.Id)
.Select(() => actorAlias.FirstName).WithAlias(() => actorResult.FirstName)
.Select(() => actorAlias.LastName).WithAlias(() => actorResult.LastName)
.Select(() => actorAlias.LastUpdate).WithAlias(() => actorResult.LastUpdate)
)
.TransformUsing(Transformers.AliasToBean <Actor>())
.Future <Actor>();
var categories = _session.QueryOver <en.Category>(() => categoryAlias)
.JoinAlias(fi => fi.Films, () => filmAlias)
.Where(fa => filmAlias.Id == film.Id)
.SelectList
(
list => list
.Select(() => categoryAlias.Id).WithAlias(() => categoryResult.Id)
.Select(() => categoryAlias.Name).WithAlias(() => categoryResult.Name)
.Select(() => categoryAlias.LastUpdate).WithAlias(() => categoryResult.LastUpdate)
)
.TransformUsing(Transformers.AliasToBean <Category>())
.List <Category>();
film.Actors = actors.ToList();
film.Categories = categories.ToList();
}
public Category Get(int id)
{
en.Category categoryAlias = null;
en.Film filmAlias = null;
Film result = null;
var repoCategory = _categoryRepository.Get(id);
var category = new Category()
{
Id = repoCategory.Id,
Name = repoCategory.Name,
LastUpdate = repoCategory.LastUpdate
};
category.Films =
_session.QueryOver <en.Category>(() => categoryAlias)
.JoinAlias(ca => ca.Films, () => filmAlias)
.Where(c => c.Id == id)
.SelectList(list => list
.Select(() => filmAlias.Id).WithAlias(() => result.Id)
.Select(() => filmAlias.Title).WithAlias(() => result.Title)
.Select(() => filmAlias.ReleaseYear).WithAlias(() => result.ReleaseYear)
.Select(() => filmAlias.RentalDuration).WithAlias(() => result.RentalDuration)
.Select(() => filmAlias.Length).WithAlias(() => result.Length)
.Select(() => filmAlias.RentalRate).WithAlias(() => result.RentalRate)
.Select(() => filmAlias.Rating).WithAlias(() => result.Rating)
.Select(() => filmAlias.Description).WithAlias(() => result.Description)
.Select(() => filmAlias.LastUpdate).WithAlias(() => result.LastUpdate)
.Select(() => filmAlias.ReleaseYear).WithAlias(() => result.ReleaseYear)
.Select(() => filmAlias.ReplacementCost).WithAlias(() => result.ReplacementCost)
.Select(() => filmAlias.SpecialFeatures).WithAlias(() => result.SpecialFeatures)
)
.TransformUsing(Transformers.AliasToBean <Film>())
.List <Film>();
return(category);
}