public void Dada_a_consulta_deve_retornar_tarefas_apenas_do_id_correto() { var ID = _items.FirstOrDefault().Id; var result = _items.AsQueryable().Where(TodoQueries.GetById(ID, "usuarioA")); Assert.AreEqual(1, result.Count()); }
public IEnumerable <TodoItem> GetAllUndone(string user) { return(_context.Todos .AsNoTracking() .Where(TodoQueries.GetAllUndone(user)) .OrderBy(x => x.Date)); }
public void Dada_a_consulta_deve_retornar_tarefas_apenas_do_periodo_correto() { var date = _items.FirstOrDefault().Date; var result = _items.AsQueryable().Where(TodoQueries.GetByPeriod("usuarioA", date, false)); Assert.AreEqual(2, result.Count()); }
public void Retornar_apenas_tarefas_do_usuario1() { var result = _items.AsQueryable() .Where(TodoQueries.GetAll("Usuario 1")); Assert.AreEqual(1, result.Count()); }
public void DeveRetornarTarefasApenasDoUsuarioInformadoPeloPeriodo() { _items.FirstOrDefault().MarkAsDone(); var result = _items.AsQueryable().Where(TodoQueries.GetByPeriod("Usuario1", DateTime.Now, true)); Assert.AreEqual(1, result.Count()); }
public void GetAllDone() { _items[0].MarkAsDone(); var result = _items.AsQueryable().Where(TodoQueries.GetAllDone("*****@*****.**")); Assert.AreEqual(1, result.Count()); }
public IEnumerable <TodoItem> GetByPeriod(string user, DateTime date, bool done) { return(_context.Todos .AsNoTracking() .Where(TodoQueries.GetByPeriod(user, date, done)) .OrderBy(x => x.Date)); }
public async Task <IActionResult> Index(string sortQuery) { if (ViewBag.addressBag == null) { ViewBag.addressBag = new AddressViewModel(); } var currentUser = await _userManager.GetUserAsync(User); if (currentUser == null) { return(Challenge()); } if (sortQuery == null) { sortQuery = "IncompleteByTitleAsc"; } TodoQueries query = (TodoQueries)Enum.Parse(typeof(TodoQueries), sortQuery); var items = await _todoItemService.GetIncompleteItemsAsync(currentUser, query); var model = new TodoViewModel() { Items = items, Me = currentUser.UserName }; return(View(model)); }
public void Dada_a_consulta_deve_restornar_tarefas_apenas_do_usuario() { var result = _itens.AsQueryable().Where(TodoQueries.GetAll("Matheus")); Assert.AreEqual(2, result.Count()); }
public IEnumerable <TodoItem> GetAllUndone(string email) { return(_context.Todos .AsNoTracking() .Where(TodoQueries.GetAllUndone(email)) .OrderBy(t => t.Date)); }
public TodoItem GetById(Guid id, string usuario) { return(_dataContext.Todos .AsNoTracking() .Where(TodoQueries.GetAll(usuario)) .OrderBy(x => x.Date)); }
public IEnumerable <TodoItem> GetByPeriod(string email, DateTime date, bool done) { return(_context.Todos .AsNoTracking() .Where(TodoQueries.GetAllByPeriod(email, date, done)) .OrderBy(t => t.Date)); }
public async Task <TodoItem[]> GetIncompleteItemsAsync(ApplicationUser user, TodoQueries query) { var getAllIncompleteTodoItems = from todo in _context.Items where todo.IsDone == false && todo.UserId == user.Id select todo; switch ((int)query) { case (int)TodoQueries.IncompleteByTitleAsc: return(await getAllIncompleteTodoItems.OrderBy(i => i.Title).ToArrayAsync()); case (int)TodoQueries.IncompleteByTitleDesc: return(await getAllIncompleteTodoItems.OrderByDescending(i => i.Title).ToArrayAsync()); case (int)TodoQueries.IncompleteByDateAsc: return(await getAllIncompleteTodoItems.OrderBy(i => i.DueAt).ToArrayAsync()); case (int)TodoQueries.IncompleteByDateDesc: return(await getAllIncompleteTodoItems.OrderByDescending(i => i.DueAt).ToArrayAsync()); case (int)TodoQueries.IncompleteByAddressAsc: return(await getAllIncompleteTodoItems.OrderBy(i => i.Address).ToArrayAsync()); case (int)TodoQueries.IncompleteByAddressDesc: return(await getAllIncompleteTodoItems.OrderByDescending(i => i.Address).ToArrayAsync()); default: return(new TodoItem[0]); } }
public void DeveRetornarTarefasApenasDoUsuarioInformadoQueEstejamIncompletas() { _items.FirstOrDefault().MarkAsDone(); var result = _items.AsQueryable().Where(TodoQueries.GetAllUndone("Usuario1")); Assert.AreEqual(3, result.Count()); }
public IEnumerable <TodoItem> GetAll(string user) { //AsNoTracking = usar quando não vai fazer um update ou delete no objeto, elimina um passo e deixa mais rapido return(_context.Todos .AsNoTracking() .Where(TodoQueries.GetAll(user)) .OrderBy(x => x.Date)); }
public void DeveRetornarTarefasApenasDoUsuarioInformadoPeloId() { var usuario = _items.FirstOrDefault(); var result = _items.AsQueryable().Where(TodoQueries.GetById(usuario.Id, usuario.User)); Assert.AreEqual(1, result.Count()); }
public async Task <IEnumerable <TodoItem> > GetByPeriodAsync(string user, DateTime date, bool done) { return(await _context.Todos .AsNoTracking() .Where(TodoQueries.GetByPeriod(user, date, done)) .OrderBy(x => x.Date) .ToListAsync()); }
public async Task <IEnumerable <TodoItem> > GetAllUndoneAsync(string user) { return(await _context.Todos .AsNoTracking() .Where(TodoQueries.GetAllUndone(user)) .OrderBy(x => x.Date) .ToListAsync()); }
public IEnumerable <TodoItem> GetAll(string user) { //AsNoTracking: Desabilitando o proxy (versões dos dados em memória). Usar somente quando for retornar algo para tela, sem modificação. return(_context.Todos .AsNoTracking() .Where(TodoQueries.GetAll(user)) .OrderBy(x => x.Date)); }
public TodoItem GetById(Guid id, string user) { var result = _context.Tarefas .AsNoTracking() .FirstOrDefault(TodoQueries.GetById(id, user)); return(result); }
public void WhenConsultSholdReturnTodoByUserAdmin() { var result = _items .AsQueryable() .Where(TodoQueries.GetAll("Admin")); Assert.AreEqual(2, result.Count()); }
public void Dada_a_consulta_deve_retornar_tarefas_apenas_do_usuario_andrebaltieri() { var result = _items.AsQueryable().Where(TodoQueries.GetAll("andrebaltieri")); foreach (var item in result) { Assert.AreEqual("andrebaltieri", item.User); } }
public IEnumerable <TodoItem> GetAllUndone(string user) { var result = _context.Tarefas .AsNoTracking() .Where(TodoQueries.GetAllUnDone(user)) .OrderBy(x => x.Date); return(result); }
public void GetAll() { var result = _items.AsQueryable().Where(TodoQueries.GetAll("*****@*****.**")); Assert.AreEqual(2, result.Count()); result = _items.AsQueryable().Where(TodoQueries.GetAll("*****@*****.**")); Assert.AreEqual(2, result.Count()); }
public void GetAllByDate() { _items[0].MarkAsDone(); var result = _items.AsQueryable().Where(TodoQueries.GetAllByPeriod("*****@*****.**", true, DateTime.Now)); Assert.AreEqual(1, result.Count()); result = _items.AsQueryable().Where(TodoQueries.GetAllByPeriod("*****@*****.**", false, DateTime.Now)); Assert.AreEqual(1, result.Count()); }
public void Dada_a_consulta_deve_retonar_tarefas_completas_de_um_periodo_do_usuario_felipemachado() { var result = _items.AsQueryable() .Where( TodoQueries.GetByPeriod( "felipemachado", new DateTime(2010, 02, 02, 00, 00, 00), true) ); Assert.True(result.Count() == 0); }
public IEnumerable <TodoItem> GetByPeriod(string refUser, DateTime date, bool done) { return(_items.AsQueryable(). Where(TodoQueries.GetPeriod(refUser, date, done)).OrderBy(x => x.Date)); }
public IEnumerable <TodoItem> GetAllUndone(string refUser) { return(_items.AsQueryable(). Where(TodoQueries.GetAllUndone(refUser)).OrderBy(x => x.Date)); }
public void Dada_a_conslta_deve_retornar_tarefas_apenas_do_diego_rodrigo() { var result = _items.AsQueryable().Where(TodoQueries.GelAllUser("Diego Rodrigo")); Assert.AreEqual(2, result.Count()); }
public void When_execute_query_should_return_only_user_done_tasks() { var result = _items.AsQueryable().Where(TodoQueries.GetAllDone("UserTest3")); Assert.AreEqual(0, result.Count()); }