public async Task<User> Authenticate(string email, string password) { using (var dbContext = new Context.ToDoContext()) { var user = await dbContext.User.FirstOrDefaultAsync(n => n.Email.Equals(email) && n.Password.Equals(password) && n.Active); return await Task.Run(() => user); } }
public async Task <User> Authenticate(string email, string password) { using (var dbContext = new Context.ToDoContext()) { var user = await dbContext.User.FirstOrDefaultAsync(n => n.Email.Equals(email) && n.Password.Equals(password) && n.Active); return(await Task.Run(() => user)); } }
public async Task Delete(Guid userId) { using (var dbContext = new Context.ToDoContext()) { var userModel = await dbContext.User.FirstOrDefaultAsync(n => n.UserId.Equals(userId)); userModel.Active = false; await dbContext.SaveChangesAsync(); } }
public async Task Delete(Guid todoId) { using (var dbContext = new Context.ToDoContext()) { var todo = await dbContext.ToDo.FirstOrDefaultAsync(n => n.ToDoId.Equals(todoId)); todo.Active = false; todo.UpDatedAt = DateTime.Now; await dbContext.SaveChangesAsync(); } }
public async Task<User> Put(Guid userId, User user) { using (var dbContext = new Context.ToDoContext()) { var userModel = await dbContext.User.FirstOrDefaultAsync(n => n.UserId.Equals(userId)); userModel.Name = user.Name; userModel.Email = user.Email; userModel.UpDatedAt = DateTime.Now; await dbContext.SaveChangesAsync(); user.UserId = userModel.UserId; return await Task.Run(() => user); } }
public async Task<User> Post(User user) { using (var dbContext = new Context.ToDoContext()) { user.UserId = Guid.NewGuid(); user.Active = true; user.CreatedAt = DateTime.Now; user.UpDatedAt = DateTime.Now; dbContext.User.Add(user); await dbContext.SaveChangesAsync(); return await Task.Run(() => user); } }
public async Task<User> Get(Guid userId) { using (var dbContext = new Context.ToDoContext()) { var user = await dbContext.User.FirstOrDefaultAsync(n => n.UserId.Equals(userId) && n.Active) ?? new User(); var userReturn = new User { UserId = user.UserId, Name = user.Name, Email = user.Email, }; return await Task.Run(() => userReturn); } }
public async Task<ToDo> Get(Guid todoId, Guid userId) { using (var dbContext = new Context.ToDoContext()) { var todo = await dbContext.ToDo.FirstOrDefaultAsync(n => n.ToDoId.Equals(todoId) && !n.Completed && n.UserId.Equals(userId) && n.Active) ?? new ToDo(); var todoReturn = new ToDo { ToDoId = todo.ToDoId, Description = todo.Description, Completed = todo.Completed, UserId = todo.UserId }; return await Task.Run(() => todoReturn); } }
public async Task <User> Put(Guid userId, User user) { using (var dbContext = new Context.ToDoContext()) { var userModel = await dbContext.User.FirstOrDefaultAsync(n => n.UserId.Equals(userId)); userModel.Name = user.Name; userModel.Email = user.Email; userModel.UpDatedAt = DateTime.Now; await dbContext.SaveChangesAsync(); user.UserId = userModel.UserId; return(await Task.Run(() => user)); } }
public async Task <User> Post(User user) { using (var dbContext = new Context.ToDoContext()) { user.UserId = Guid.NewGuid(); user.Password = user.Password; user.Active = true; user.CreatedAt = DateTime.Now; user.UpDatedAt = DateTime.Now; dbContext.User.Add(user); await dbContext.SaveChangesAsync(); return(await Task.Run(() => user)); } }
public async Task <User> Get(Guid userId) { using (var dbContext = new Context.ToDoContext()) { var user = await dbContext.User.FirstOrDefaultAsync(n => n.UserId.Equals(userId) && n.Active) ?? new User(); var userReturn = new User { UserId = user.UserId, Name = user.Name, Email = user.Email, }; return(await Task.Run(() => userReturn)); } }
public async Task <ToDo> Get(Guid todoId, Guid userId) { using (var dbContext = new Context.ToDoContext()) { var todo = await dbContext.ToDo.FirstOrDefaultAsync(n => n.ToDoId.Equals(todoId) && !n.Completed && n.UserId.Equals(userId) && n.Active) ?? new ToDo(); var todoReturn = new ToDo { ToDoId = todo.ToDoId, Description = todo.Description, Completed = todo.Completed, UserId = todo.UserId }; return(await Task.Run(() => todoReturn)); } }
public async Task <ToDo> Put(Guid todoId, ToDo todo) { using (var dbContext = new Context.ToDoContext()) { var todoModel = await dbContext.ToDo.FirstOrDefaultAsync(n => n.ToDoId.Equals(todoId)); todoModel.Description = todo.Description; todoModel.Completed = todo.Completed; todoModel.UpDatedAt = DateTime.Now; await dbContext.SaveChangesAsync(); todo.Completed = todoModel.Completed; todo.ToDoId = todoModel.ToDoId; todo.UserId = todoModel.UserId; return(await Task.Run(() => todo)); } }
public async Task<ICollection<User>> Get() { var usersReturn = new List<User>(); using (var dbContext = new Context.ToDoContext()) { var users = await dbContext.User.Where(n => n.Active).ToListAsync(); foreach (var user in users) { usersReturn.Add(new User { UserId = user.UserId, Name = user.Name, Email = user.Email, }); } return await Task.Run(() => usersReturn); } }
public async Task<ToDo> Post(Guid userId, ToDo todo) { using (var dbContext = new Context.ToDoContext()) { dbContext.ToDo.Add(new Entities.ToDo { ToDoId = todo.ToDoId = Guid.NewGuid(), Description = todo.Description, Completed = false, Active = true, UserId = todo.UserId = userId, CreatedAt = DateTime.Now, UpDatedAt = DateTime.Now }); await dbContext.SaveChangesAsync(); return await Task.Run(() => todo); } }
public async Task<ICollection<ToDo>> Get(Guid userId) { var doingsReturn = new List<ToDo>(); using (var dbContext = new Context.ToDoContext()) { var doings = await dbContext.ToDo.Include(n => n.User).Where(n => n.User.UserId.Equals(userId) && !n.Completed && n.Active).ToListAsync(); foreach (var todo in doings) { doingsReturn.Add(new ToDo { ToDoId = todo.ToDoId, Description = todo.Description, Completed = todo.Completed, UserId = todo.UserId }); } return await Task.Run(() => doingsReturn); } }
public async Task <ICollection <User> > Get() { var usersReturn = new List <User>(); using (var dbContext = new Context.ToDoContext()) { var users = await dbContext.User.Where(n => n.Active).ToListAsync(); foreach (var user in users) { usersReturn.Add(new User { UserId = user.UserId, Name = user.Name, Email = user.Email, }); } return(await Task.Run(() => usersReturn)); } }
public async Task <ToDo> Post(Guid userId, ToDo todo) { using (var dbContext = new Context.ToDoContext()) { dbContext.ToDo.Add(new Entities.ToDo { ToDoId = todo.ToDoId = Guid.NewGuid(), Description = todo.Description, Completed = false, Active = true, UserId = todo.UserId = userId, CreatedAt = DateTime.Now, UpDatedAt = DateTime.Now }); await dbContext.SaveChangesAsync(); return(await Task.Run(() => todo)); } }
public async Task <ICollection <ToDo> > Get(Guid userId) { var doingsReturn = new List <ToDo>(); using (var dbContext = new Context.ToDoContext()) { var doings = await dbContext.ToDo.Include(n => n.User).Where(n => n.User.UserId.Equals(userId) && !n.Completed && n.Active).ToListAsync(); foreach (var todo in doings) { doingsReturn.Add(new ToDo { ToDoId = todo.ToDoId, Description = todo.Description, Completed = todo.Completed, UserId = todo.UserId }); } return(await Task.Run(() => doingsReturn)); } }
public async Task<ToDo> Put(Guid todoId, ToDo todo) { using (var dbContext = new Context.ToDoContext()) { var todoModel = await dbContext.ToDo.FirstOrDefaultAsync(n => n.ToDoId.Equals(todoId)); todoModel.Description = todo.Description; todoModel.Completed = todo.Completed; todoModel.UpDatedAt = DateTime.Now; await dbContext.SaveChangesAsync(); todo.Completed = todoModel.Completed; todo.ToDoId = todoModel.ToDoId; todo.UserId = todoModel.UserId; return await Task.Run(() => todo); } }