public int GetUsersCount()
{
using (var db = new UserDbContext())
{
return db.Users.Count();
}
}
public User GetUser(int id)
{
using (var db = new UserDbContext())
{
return db.Users.Find(id);
}
}
public User[] GetUsers(int pageNumber, int pageSize)
{
using (var db = new UserDbContext())
{
return db.Users
.OrderBy(p => p.Id)
.Skip((pageNumber - 1) * pageSize)
.Take(pageSize)
.ToArray();
}
}
public bool DeleteUser(int id)
{
using (var db = new UserDbContext())
{
var currentUser = db.Users.Find(id);
if (currentUser == null)
{
return false;
}
db.Users.Remove(currentUser);
db.SaveChanges();
return true;
}
}
public void SaveUser(User user)
{
using (var db = new UserDbContext())
{
if (user.Id == 0)
{
db.Users.Add(user);
}
else
{
var existingUser = db.Users.Find(user.Id);
existingUser.FirstName = user.FirstName;
existingUser.LastName = user.LastName;
existingUser.Email = user.Email;
}
db.SaveChanges();
}
}
