public IEnumerable<User> GetAll(int page = 1, int size = 10) { using(var ctx = new AlfasoftDBContext()){ return ctx.Set<User>() .OrderBy(u=>u.Name) .Skip((page-1) * (size)) .Take(size) .ToList(); } }
public User RemoveUser(RemoveUserStateModal removeUser) { using(var ctx = new AlfasoftDBContext()){ User user = ctx.Users.SingleOrDefault(u => u.Name.Equals(removeUser.Name)); if(user!=null){ ctx.Users.Remove(user); ctx.SaveChanges(); return user; } return null; } }
public User AddUser(NewUserStateModal newUser) { using(var ctx = new AlfasoftDBContext()){ if(!ctx.Users.Any(u => u.Name.Equals(newUser.Name) || u.Number == newUser.Id)){ var user = newUser.getModel(); ctx.Users.Add(user); ctx.SaveChanges(); return user; } } return null; }