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