public bool connect(string pseudo, string password)
{
bool connected = false;
using (var db = new bowlingEntities())
{
try
{
string pwd = utils.CalculateMD5Hash(password);
staff user = (from s in db.staffs
where s.Pseudo == pseudo
&& s.Password == pwd
select s).Single();
if (user != null)
connected = true;
else
connected = false;
}
catch (Exception e)
{
throw new Exception("Error", e);
}
return connected;
}
}
public game getCurrentGame()
{
using (var db = new bowlingEntities())
{
if (!this.isAvalaible())
return db.games.Where(x => x.State == "in progress" && x.Lane_id == this.Id).SingleOrDefault();
else
return null;
}
}
public void deletePlayer()
{
using (var db = new bowlingEntities())
{
this.game.players.Remove(this);
try
{
db.SaveChanges();
}
catch (Exception e)
{
throw new Exception("Error", e);
}
}
}
public void addPlayer(player p)
{
using (var db = new bowlingEntities())
{
this.game.players.Add(p);
try
{
db.SaveChanges();
}
catch (Exception e)
{
throw new Exception("Error", e);
}
}
}
public void cancelGame(game g)
{
using (var db = new bowlingEntities())
{
try
{
game game = db.games.Find(g.Id);
game.State = "canceled";
db.SaveChanges();
}
catch (Exception e)
{
throw new Exception("Error", e);
}
}
}
public void addPlayer(game g, player p)
{
using (var db = new bowlingEntities())
{
try
{
game game = db.games.Find(g.Id);
game.players.Add(p);
db.SaveChanges();
}
catch (Exception e)
{
throw new Exception("Error", e);
}
}
}
public void assignReservation()
{
using (bowlingEntities db = new bowlingEntities())
{
lane lane = (from l in db.lanes
join g in db.games on l.Id equals g.Lane_id
where g.State != "finished"
select l).SingleOrDefault();
db.games.Attach(this);
db.Entry(this).State = EntityState.Modified;
if (lane != null)
this.Lane_id = lane.Id;
else
this.Lane_id = (from l in db.lanes select l).SingleOrDefault().Id;
}
}
public game createGame()
{
bowlingEntities db = new bowlingEntities();
game g = new game();
g.State = "pending";
try
{
db.games.Add(g);
db.SaveChanges();
}
catch (Exception e)
{
throw new Exception("Error", e);
}
return g;
}
public void assignToLane()
{
using (var db = new bowlingEntities())
{
lane lane = (from l in db.lanes
where l.State == "available"
select l).SingleOrDefault();
db.games.Attach(this);
db.Entry(this).State = EntityState.Modified;
if (lane != null)
{
this.Lane_id = lane.Id;
}
else
{
this.assignReservation();
}
db.SaveChanges();
}
}
public game createGame()
{
using (var db = new bowlingEntities())
{
db.players.Attach(this);
db.Entry(this).State = EntityState.Modified;
game game = new game();
game.players.Add(this);
try
{
db.games.Add(game);
db.SaveChanges();
}
catch (Exception e)
{
throw new Exception("Error", e);
}
return game;
}
}
