public bool changePassword(int idUser, string newpass)
{
using(DatabaseContext db = new DatabaseContext())
{
try
{
var user = (from u in db.Users
where u.Id == idUser
select u).First();
user.Password = newpass;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return true;
}
catch(Exception e)
{
return false;
}
}
}
public bool addUsersToRoom(ICollection<User> usersId, int idRoom)
{
using (DatabaseContext db = new DatabaseContext())
{
try
{
var room = (from r in db.GameRooms
where r.Id == idRoom
select r).First();
ICollection<User> users = new List<User>();
foreach(var us in usersId)
{
var nesto = (from u in db.Users
where u.Id == us.Id
select u).First();
users.Add(nesto);
}
room.Users = users;
db.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
public bool addRoom(GameRoom room)
{
using (DatabaseContext db = new DatabaseContext())
{
try
{
if (getRoom(room.Id) != null)
return false;
else
{
db.GameRooms.Add(room);
db.SaveChanges();
return true;
}
}
catch (Exception e)
{
return false;
}
}
}
public bool deleteUser(int idUser)
{
using (DatabaseContext db = new DatabaseContext())
{
try
{
var user = db.Users.Find(idUser);
if (user == null)
return false;
db.Users.Remove(user);
db.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
public bool deleteRoom(int idRoom)
{
using (DatabaseContext db = new DatabaseContext())
{
try
{
var room = db.GameRooms.Find(idRoom);
if (room == null)
return false;
db.GameRooms.Remove(room);
db.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
public bool addUser(User user)
{
using (DatabaseContext db = new DatabaseContext())
{
try
{
if (getUser(user) != null)
return false;
else
{
User u = new User() { Username = user.Username, Password = user.Password, Role = "User" };
db.Users.Add(u);
db.SaveChanges();
return true;
}
}
catch (Exception e)
{
return false;
}
}
}
public bool makeWinner(int idUser, int idGameRoom)
{
using (DatabaseContext db = new DatabaseContext())
{
try
{
var gr = (from g in db.GameRooms
where g.Id == idGameRoom
select g).First();
gr.WinnerId = idUser;
db.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
public bool updateUserRole(int idUser, string Role)
{
using (DatabaseContext db = new DatabaseContext())
{
try
{
User user = (from us in db.Users
where us.Id == idUser
select us).First();
user.Role = Role;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
}
