public IEnumerable <avatar> GetAvatars()
{
using (var db = new fightClubEntities())
{
return(db.avatar.ToList());
}
}
public IEnumerable <user> GetUsers()
{
using (var db = new fightClubEntities())
{
return(db.user.ToList());
}
}
public user GetUserById(int id)
{
using (var db = new fightClubEntities())
{
return(db.user.Single(a => a.id == id));
}
}
public user GetOpponent(string userName)
{
using (var db = new fightClubEntities())
{
return(db.user.SingleOrDefault(a => a.username == userName));
}
}
public List <match> GetMatches()
{
using (var db = new fightClubEntities())
{
return(db.match.ToList());
}
}
public List <match> GetWaitingMatches(int id)
{
using (var db = new fightClubEntities())
{
return(db.match.Where(a => a.user1 == id).ToList());
}
}
public List <match> GetPlayedMatches(int id)
{
using (var db = new fightClubEntities())
{
return(db.match.Where(a => (a.user2 == id || a.user1 == id) && a.resolved).ToList());
}
}
public List <match> GetPendingMatches(int id)
{
using (var db = new fightClubEntities())
{
return(db.match.Where(a => a.user2 == id && a.resolved == false).ToList());
}
}
public user GetUser(string userName)
{
if (string.IsNullOrEmpty(userName))
{
throw new ArgumentException("invalid input", "userName");
}
using (var db = new fightClubEntities())
{
var userProfile = db.user.SingleOrDefault(a => a.username == userName);
if (userProfile == null)
{
var ava = db.avatar.OrderBy(r => Guid.NewGuid()).First();
var newUser = new user
{
username = userName,
avatar = ava,
created = DateTime.Now,
lastModified = DateTime.Now,
matchesLeft = 10
};
var hest = db.user.Add(newUser);
db.SaveChanges();
return(hest);
}
return(userProfile);
}
}
public user GetRandomOpponent(string username)
{
using (var db = new fightClubEntities())
{
var opponent = db.user.OrderBy(r => Guid.NewGuid()).First(a => a.username != username);
return(opponent);
}
}
public void AddAvatar(avatar avatar)
{
using (var db = new fightClubEntities())
{
db.avatar.Add(avatar);
db.SaveChanges();
}
}
public void CreateMatch(match match)
{
using (var db = new fightClubEntities())
{
db.match.Add(match);
db.SaveChanges();
}
}
public match GetMatchByMatchId(int id)
{
using (var db = new fightClubEntities())
{
var result = db.match.SingleOrDefault(a => a.id == id);
return(result);
}
}
public void UpdateMatch(match match)
{
using (var db = new fightClubEntities())
{
var oldMatch = db.match.Single(a => a.id == match.id);
if (oldMatch == null)
{
throw new Exception("not found");
}
db.Entry(oldMatch).CurrentValues.SetValues(match);
db.SaveChanges();
}
}
public user UpdateUser(user user)
{
using (var db = new fightClubEntities())
{
var dbuser = db.user.Single(a => a.id == user.id);
if (dbuser == null)
{
throw new Exception("not found");
}
db.Entry(dbuser).CurrentValues.SetValues(user);
db.SaveChanges();
return(dbuser);
}
}