public User GetUser(Guid Id)
{
using (var db = new NitkaContext())
{
return(db.Users.FirstOrDefault(c => c.Id == Id));
}
}
public void UpdateUser(User user)
{
using (var db = new NitkaContext())
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
}
public void AddUser(User user)
{
using (var db = new NitkaContext())
{
db.Users.Add(user);
db.SaveChanges();
}
}
public double GetUsersSalarySum()
{
using (var db = new NitkaContext())
{
if (db.Users.Any())
{
return(db.Users.Sum(c => c.Salary));
}
return(0);
}
}
public IEnumerable <User> GetUsers(int pageNumber, int pageCount)
{
using (var db = new NitkaContext())
{
return(db.Users
.OrderBy(c => c.FirstName)
.Skip((pageNumber - 1) * pageCount)
.Take(pageCount)
.ToList());
}
}
public void DeleteUser(Guid Id)
{
using (var db = new NitkaContext())
{
var user = db.Users.FirstOrDefault(c => c.Id == Id);
if (user != null)
{
db.Users.Remove(user);
db.SaveChanges();
}
}
}
static void Main(string[] args)
{
var db = new NitkaContext();
db.Database.CreateIfNotExists();
}
