public User FindUserToEdit(int id)
{
using (UserAPIEntities entities = new UserAPIEntities())
{
return(entities.Users.Find(id));
}
}
public Leaderboard FindEntryToEdit(int id)
{
using (UserAPIEntities entities = new UserAPIEntities())
{
return(entities.Leaderboards.Find(id));
}
}
// Gets Leaderboard
public IEnumerable <Leaderboard> Get()
{
using (UserAPIEntities entities = new UserAPIEntities())
{
return(entities.Leaderboards.ToList());
}
}
// Gets user by id
public int GetTotalUserCount()
{
using (UserAPIEntities entities = new UserAPIEntities())
{
return(entities.Users.Count());
}
}
// Gets user by id
public User Get(int id)
{
using (UserAPIEntities entities = new UserAPIEntities())
{
return(entities.Users.FirstOrDefault(u => u.UserId == id));
}
}
// Gets all users
public IEnumerable <User> Get()
{
using (UserAPIEntities entities = new UserAPIEntities())
{
return(entities.Users.ToList());
}
}
public void EditEntry(Leaderboard leaderboard)
{
using (UserAPIEntities entities = new UserAPIEntities())
{
entities.Entry(leaderboard).State = EntityState.Modified;
entities.SaveChanges();
}
}
public void Create(Leaderboard leaderboard)
{
using (UserAPIEntities entities = new UserAPIEntities())
{
entities.Leaderboards.Add(leaderboard);
entities.SaveChanges();
}
}
public void EditUser(User editUser)
{
using (UserAPIEntities entities = new UserAPIEntities())
{
entities.Entry(editUser).State = EntityState.Modified;
entities.SaveChanges();
}
}
public void Create(User user)
{
using (UserAPIEntities entities = new UserAPIEntities())
{
entities.Users.Add(user);
entities.SaveChanges();
}
}