public static void AddSamplePlayersToDb(MafiaContext _context)
{
//_context.Rooms.Add(new Models.Room { RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960") });
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4955"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "Romas", Role = "Mafia"
});
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4956"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "Kapitomas", Role = "Mafia"
});
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4957"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "Adomas", Role = "Civil"
});
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4958"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "Omas", Role = "Civil"
});
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4954"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "Tomas", Role = "Mafia"
});
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4959"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "Rudas", Role = "Civil"
});
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4950"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "szudas", Role = "Civil"
});
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4953"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "yolo", Role = "Civil"
});
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4952"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "trysdu", Role = "Civil"
});
_context.Players.Add(new Models.Player {
PlayerId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4951"), RoomId = new Guid("49a20b2e-f469-4614-1649-08d7f90d4960"), IsAlive = true, Name = "keturi", Role = "Civil"
});
_context.SaveChanges();
}
public int WhichSideWon(MafiaContext _context, string votingPlayer)
{
int flag;
string mafia = "Mafia";
string civil = "Civilian";
var currentRoom = _context.Players
.Where(x => x.Name == votingPlayer)
.FirstOrDefault().RoomId;
var playersInSameRoom = _context.Players
.Where(x => x.RoomId == currentRoom)
.ToList();
var isMafiaAlive = playersInSameRoom
.Where(x => x.IsAlive == true && x.Role == mafia)
.FirstOrDefault();
if (isMafiaAlive == null)
{
flag = 2;
return(flag);
}
var isCivilAlive = playersInSameRoom
.Where(x => x.IsAlive == true && x.Role.Equals(civil))
.FirstOrDefault();
if (isCivilAlive == null)
{
flag = 1;
return(flag);
}
flag = 0;
return(flag);
}
public static void AddGameSessionToDb(MafiaContext _context)
{
_context.GameSessions.Add(new Models.GameSession()
{
GameSessionId = new Guid("49a20b2e - f469 - 4614 - 1649 - 08d7f90d4954"),
RoomId = new Guid("49a20b2e - f469 - 4614 - 1649 - 08d7f90d4960"),
GameTime = TimeSpan.FromMinutes(1),
VoteTime = TimeSpan.FromMinutes(1)
});
_context.SaveChanges();
}
public void UpdateRoomParameters(MafiaContext _context, Class classResponder)
{
Guid roomId = new Guid("b7afd4f1-9221-482e-966b-5456ae190100");
var room = _context.Rooms
.Where(x => x.RoomId == roomId)
.FirstOrDefault();
room.Name = classResponder.name;
room.MafiaAmount = classResponder.mafiaAmount;
room.CivilAmount = classResponder.civilAmount;
_context.SaveChanges();
}
public void KillPlayer(MafiaContext _context)
{
var votedPlayerId = _context.Votes
.GroupBy(x => x.VotedPlayerId)
.OrderByDescending(z => z.Count())
.Take(1)
.Select(t => t.Key)
.FirstOrDefault();
_context.Players
.Where(x => x.PlayerId == votedPlayerId)
.FirstOrDefault()
.IsAlive = false;
var votes = _context.Votes.ToList();
_context.Votes.RemoveRange(votes);
_context.SaveChanges();
}
public string WinningSide(MafiaContext _context, string votingPlayer)
{
var currentRoom = _context.Players
.Where(x => x.Name == votingPlayer)
.FirstOrDefault().RoomId;
var playersInSameRoom = _context.Players
.Where(x => x.RoomId == currentRoom)
.ToList();
var winningSide = playersInSameRoom
.GroupBy(x => x.Role)
.OrderByDescending(z => z.Count())
.Take(playersInSameRoom.Count)
.Select(t => t.Key)
.FirstOrDefault();
return(winningSide);
}