public List <_vw_mc_filme_visto> FindWatched(MovieField order, bool isAscending)
{
if (order == MovieField.period)
{
if (isAscending)
{
return(_context.vw_mc_filme_visto.OrderBy(p => p.periodo).ToList());
}
else
{
return(_context.vw_mc_filme_visto.OrderByDescending(p => p.periodo).ToList());
}
}
else
{
if (isAscending)
{
return(_context.vw_mc_filme_visto.OrderBy(p => p.titulo).ToList());
}
else
{
return(_context.vw_mc_filme_visto.OrderByDescending(p => p.titulo).ToList());
}
}
}
public List <_vw_mc_filme_ver> FindAvailable(MovieField order, bool isAscending)
{
if (order == MovieField.rating)
{
if (isAscending)
{
return(_context.vw_mc_filme_ver.OrderBy(p => p.rating).ToList());
}
else
{
return(_context.vw_mc_filme_ver.OrderByDescending(p => p.rating).ToList());
}
}
else
{
if (isAscending)
{
return(_context.vw_mc_filme_ver.OrderBy(p => p.titulo).ToList());
}
else
{
return(_context.vw_mc_filme_ver.OrderByDescending(p => p.titulo).ToList());
}
}
}
public List <T> FindMovieCount(MovieField order, bool isAscending)
{
if (order == MovieField.name)
{
if (isAscending)
{
return(dataset.OrderBy(p => p.nome).ToList());
}
else
{
return(dataset.OrderByDescending(p => p.nome).ToList());
}
}
else
{
if (isAscending)
{
return(dataset.OrderBy(p => p.filmes).ToList());
}
else
{
return(dataset.OrderByDescending(p => p.filmes).ToList());
}
}
}
public List <T> FindMovieByName(string name, MovieField order, bool isAscending)
{
name = name.Replace(" ", " ");
if (order == MovieField.title)
{
if (isAscending)
{
return(dataset.Where(a => a.nome == name).OrderBy(p => p.titulo).ToList());
}
else
{
return(dataset.Where(a => a.nome == name).OrderByDescending(p => p.titulo).ToList());
}
}
else
{
if (isAscending)
{
return(dataset.Where(a => a.nome == name).OrderBy(p => p.rating).ToList());
}
else
{
return(dataset.Where(a => a.nome == name).OrderByDescending(p => p.rating).ToList());
}
}
}
public List <T> FindMovieById(long id, MovieField order)
{
if (order == MovieField.name)
{
return(dataset.Where(a => a.id == id).OrderBy(p => p.nome).ToList());
}
else
{
return(dataset.Where(a => a.id == id).OrderByDescending(p => p.titulo).ToList());
}
}
private bool ReadField(ObjectReader objectReader, Dictionary <MovieField, int> fieldValues, MovieField field)
{
switch (field)
{
case MovieField.End:
return(false);
case MovieField.UnknownByte19:
case MovieField.UnknownByte20:
case MovieField.UnknownByte21:
case MovieField.UnknownByte22:
case MovieField.UnknownByte23:
case MovieField.UnknownByte24:
InfoText += $"{field}: {objectReader.ReadByte()}\n";
return(true);
case MovieField.UnknownInt16:
case MovieField.UnknownInt17:
case MovieField.UnknownInt18:
case MovieField.Width:
case MovieField.Height:
case MovieField.UnknownInt52:
InfoText += $"{field}: {objectReader.ReadInt32()}\n";
return(true);
case MovieField.UnknownArray32:
InfoText += $"{field}: [{string.Join(", ", Enumerable.Range(0, objectReader.ReadInt32()).Select(i => objectReader.ReadByte()))}]\n";
return(true);
default:
throw new NotImplementedException();
}
}
public PagedSearchDTO <_vw_mc_filme_por_ator> FindMovieByIdPagedSearch(long id, int pageSize, int page, MovieField order, bool isAscending)
{
var filters = new Dictionary <string, object>()
{
{ "id", id.ToString() }
};
return(_vmbrep.FindPagedSearch("vw_mc_filme_por_ator", ref filters, pageSize, page, order, isAscending));
}
public PagedSearchDTO <_vw_mc_ator> FindMovieCountPagedSearch(string name, int pageSize, int page, MovieField order, bool isAscending)
{
var filters = new Dictionary <string, object>()
{
{ "nome", name }
};
return(_vrep.FindPagedSearch("vw_mc_ator", ref filters, pageSize, page, order, isAscending));
}
public List <_vw_mc_filme_por_ator> FindMovieByName(string name, MovieField order, bool isAscending)
{
return(_vmbrep.FindMovieByName(name, order, isAscending));
}
public List <_vw_mc_filme_por_ator> FindMovieById(long id, MovieField order)
{
return(_vmbrep.FindMovieById(id, order));
}
public List <_vw_mc_ator> FindMovieCount(MovieField order, bool isAscending)
{
return(_vrep.FindMovieCount(order, isAscending));
}
public PagedSearchDTO <_vw_mc_filme_visto> FindWatchedPagedSearch(string name, int pageSize, int page, MovieField order, bool isAscending)
{
var filters = new Dictionary <string, object>()
{
{ "titulo", name }
};
var sort = isAscending ? "asc" : "desc";
var sortFields = string.Empty;
var query = Query.BuildSelect("vw_mc_filme_visto", ref filters, sort, pageSize, page, order, ref sortFields);
var countQuery = Query.BuildCount("vw_mc_filme_visto", filters);
var pagedResults = _repository.FindWatchedPagedSearch(query);
int totalResults = _repository.GetCount(countQuery);
return(new PagedSearchDTO <_vw_mc_filme_visto>
{
CurrentPage = page + 1,
List = pagedResults,
PageSize = pageSize,
SortDirections = sort,
TotalResults = totalResults
});
}
public List <_vw_mc_filme_ver> FindAvailable(MovieField order, bool isAscending)
{
return(_repository.FindAvailable(order, isAscending));
}
public List <_vw_mc_filme_visto> FindWatched(MovieField order, bool isAscending)
{
return(_repository.FindWatched(order, isAscending));
}
public PagedSearchDTO <T> FindPagedSearch(string view, ref Dictionary <string, object> filters, int pageSize, int page, MovieField order, bool isAscending)
{
var sort = isAscending ? "asc" : "desc";
var sortFields = string.Empty;
var query = Query.BuildSelect(view, ref filters, sort, pageSize, page, order, ref sortFields);
var countQuery = Query.BuildCount(view, filters);
var pagedResults = dataset.FromSqlRaw <T>(query).ToList();
int totalResults = GetCount(countQuery);
return(new PagedSearchDTO <T>
{
CurrentPage = page,
List = pagedResults,
PageSize = pageSize,
SortFields = sortFields,
SortDirections = sort,
Filters = filters,
TotalResults = totalResults
});
}
