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 }); }