// Создание задачи для голосовани.
public IActionResult TopicCreate(int PokerRoomId, int PlayerId, string Title, string Description, int password)
{
if (Title != null)
{
try
{
using (var _context = new PokerPlanningContext())
{
var Topic = new Topic
{
Title = Title,
Description = Description,
Status = 1, // не обсуждается
PokerRoomId = PokerRoomId,
IterationNumb = 0
};
_context.Topics.Add(Topic);
_context.SaveChanges();
}
}
catch (ArgumentNullException)
{
return(new BadRequestResult());//Сделать: Отправка в форму, что не введено;
}
}
return(RedirectToAction("RoomEntrance", new { PokerRoomId, PlayerId, password }));
}
public IActionResult DeleteTopic(Topic topic)
{
int PokerRoomId;
int PlayerId;
int Password;
using (var _context = new PokerPlanningContext())
{
topic = _context.Topics.Where(t => t.Id == topic.Id).SingleOrDefault();
PokerRoomId = topic.PokerRoomId;
Password = _context.PokerRooms.FirstOrDefault(rid => rid.Id == PokerRoomId).Password.Value;
ViewBag.Password = Password;
var player = _context.Players.Where(p => p.PokerRoomId == topic.PokerRoomId && p.Role == 2).SingleOrDefault();
PlayerId = player.Id;
var cards = _context.Cards.Where(c => c.TopicId == topic.Id).ToList();
_context.Cards.RemoveRange(cards);
_context.Topics.Remove(topic);
_context.SaveChanges();
}
return(RedirectToAction("RoomEntrance", new { PokerRoomId, PlayerId, Password }));
}
//Получение результатов голосования участников.
public async Task <IActionResult> GetResultVote(int PokerRoomId, int PlayerId, string ValueCard, int TopicId, string Comment, int password)
{
using (var _context = new PokerPlanningContext())
{
// Вычисление итерации голосования топика.
var count = _context.Topics.Where(t => t.Id == TopicId).SingleOrDefault().IterationNumb;
var cardIteration = _context.Cards.Where(c => c.TopicId == TopicId && c.PlayerId == PlayerId && c.IterationNumb == count)
.SingleOrDefault(); // Проверка, существует ли карточка в БД для этого игрока.
if (cardIteration == null)
{
var Cards = new Card
{
CardValue = ValueCard,
PlayerId = PlayerId,
TopicId = TopicId,
Comment = Comment,
IterationNumb = count
};
_context.Cards.Add(Cards);
_context.SaveChanges();
}
else
{
//предупреждение
}
}
await hubContext.Clients.All.SendAsync("UpdatePage");
return(RedirectToAction("RoomDiscussion", "ScrumRoom", new { PokerRoomId, PlayerId, password }));
}
// Вход в комнату для создателя комнаты.
public IActionResult RoomEntrance(int PokerRoomId, int PlayerId, int Password)
{
//Результат карточек.
Dictionary <string, (string, string)> resultCard = new Dictionary <string, (string, string)>();
ViewBag.PokerRoomId = PokerRoomId;
using (var _context = new PokerPlanningContext())
{
var pw = _context.PokerRooms.FirstOrDefault(rid => rid.Id == PokerRoomId).Password;
if (Equals(Password, pw))
{
ViewBag.Password = pw;
var player = _context.Players.Where(p => p.Id == PlayerId).SingleOrDefault();
try
{
player.IsOnline = true;
_context.Players.Update(player);
_context.SaveChanges();
}
catch (NullReferenceException)
{
return(new BadRequestResult());
}
List <Topic> topics = _context.Topics.Where(t => t.PokerRoomId == PokerRoomId).ToList();
// Выбор карточек для отображения результатов голосования.
var Topic = _context.Topics.Where(t => t.PokerRoomId == PokerRoomId && t.Status == 2).SingleOrDefault();
if (Topic != null)
{
var cards = _context.Cards.Where(c => c.TopicId == Topic.Id && c.IterationNumb == Topic.IterationNumb).ToList();
if (cards != null)
{
foreach (var card in cards)
{
var playerName = _context.Players.Where(p => p.Id == card.PlayerId).SingleOrDefault().Name;
resultCard[playerName] = (card.CardValue, card.Comment);
}
}
}
//Список пользователей-онлайн.
var playersOnline = _context.Players.Where(p => p.PokerRoomId == PokerRoomId && p.IsOnline == true).ToList();
ViewBag.NamePlayer = player.Name;
ViewBag.PlayerId = player.Id;
return(View((topics, resultCard, playersOnline)));
}
else
{
return(RedirectToAction("RoomsList", "Home"));
}
}
}
public void OnlineUser(int UserId)
{
using (var _context = new PokerPlanningContext())
{
var Player = _context.Players.Where(p => p.Id == UserId).SingleOrDefault();
Player.IsOnline = true;
_context.Players.Update(Player);
_context.SaveChanges();
}
}
public async Task OnlineUserList(int RoomId)
{
string[] playersOnline;
string adminName;
using (var _context = new PokerPlanningContext())
{
var players = _context.Players.Where(p => p.PokerRoomId == RoomId && p.IsOnline == true);
playersOnline = players.Select(s => s.Name).ToArray();
adminName = players.Where(p => p.Role == 2).SingleOrDefault().Name;
}
await this.Clients.All.SendAsync("OnlineUsers", playersOnline, adminName);
}
public void OfflineUser(int RoomId)
{
using (var _context = new PokerPlanningContext())
{
var Player = _context.Players.Where(p => p.PokerRoomId == RoomId).ToList();
foreach (var player in Player)
{
player.IsOnline = false;
}
_context.Players.UpdateRange(Player);
_context.SaveChanges();
}
}
public IActionResult RoomsList()//Вывод списка комнат
{
using (var _context = new PokerPlanningContext())
{
var RList = _context.PokerRooms.ToList().OrderBy(m => m.CreateDate);
var Pcount = _context.Players.ToList();
var rooms = RList.GroupJoin(Pcount, R => R.Id, P => P.PokerRoomId,
(rl, pc) => new RoomListModel(rl.Id, rl.Title, pc.Count()))
.ToList();
return(View(rooms));
}
}
//Удаление задачи.
public IActionResult DeleteTopic(int id)
{
Topic topic;
using (var _context = new PokerPlanningContext())
{
topic = _context.Topics.Where(t => t.Id == id).SingleOrDefault();
ViewBag.Password = _context.PokerRooms.FirstOrDefault(rid => rid.Id == topic.PokerRoomId).Password;
ViewBag.PokerRoomId = topic.PokerRoomId;
var player = _context.Players.Where(p => p.PokerRoomId == topic.PokerRoomId && p.Role == 2).SingleOrDefault();
ViewBag.PlayerId = player.Id;
}
return(View(topic));
}
public IActionResult EditTopic(Topic topic)
{
if (ModelState.IsValid)
{
using (var _context = new PokerPlanningContext())
{
_context.Topics.Update(topic);
_context.SaveChanges();
ViewBag.PokerRoomId = topic.PokerRoomId;
ViewBag.Password = _context.PokerRooms.FirstOrDefault(rid => rid.Id == topic.PokerRoomId).Password;
var player = _context.Players.Where(p => p.PokerRoomId == topic.PokerRoomId && p.Role == 2).SingleOrDefault();
ViewBag.PlayerId = player.Id;
}
}
return(View(topic));
}
// Старт или стоп обсуждения задачи.
public async Task <IActionResult> StartVoting(int PokerRoomId, int PlayerId, int IdTopic, int password)
{
try
{
using (var _context = new PokerPlanningContext())
{
var Topic = new Topic();
Topic = _context.Topics.Where(t => t.Id == IdTopic).SingleOrDefault();
var countTopicStart = _context.Topics.Where(t => t.PokerRoomId == PokerRoomId && t.Status == 2)
.ToList().Count;
if (Topic.Status == 1 && countTopicStart == 0) //если голосование необходимо запустить
{
Topic.Status = 2; // старт голосования
Topic.IterationNumb++;
}
else if (Topic.Status == 2 && countTopicStart == 1)
{
Topic.Status = 1; // стоп голосования
var cards = (List <string>)_context.Cards.Where(c => c.TopicId == IdTopic && c.IterationNumb == Topic.IterationNumb)
.Select(s => s.CardValue).ToList(); // получение всех карточек для данного топика
var typeCards = _context.PokerRooms.Where(t => t.Id == PokerRoomId).
SingleOrDefault().TypeCards; // получение типа карточек
Topic.Marks = ResultMarks(cards, typeCards); // подсчет общей оценки для карточки
}
else
{
//предупреждение
}
_context.Topics.Update(Topic);
_context.SaveChanges();
}
}
catch (ArgumentNullException)
{
return(new BadRequestResult());//Сделать: Отправка в форму, что не введено;
}
await hubContext.Clients.All.SendAsync("UpdatePage");
return(RedirectToAction("RoomEntrance", new { PokerRoomId, PlayerId, password }));
}
//Удаление комнаты.
public IActionResult DeletePokerRoom(int PokerRoomId)
{
using (var _context = new PokerPlanningContext())
{
// Начало транзакции.
using (var transaction = _context.Database.BeginTransaction())
{
try
{
//Удаление сообщений для комнаты.
var messages = _context.Messages.Where(m => m.PokerRoomId == PokerRoomId);
_context.Messages.RemoveRange(messages);
_context.SaveChanges();
//Удаление карточек и задач для комнаты.
var topics = _context.Topics.Where(t => t.PokerRoomId == PokerRoomId);
foreach (var topic in topics)
{
var cards = _context.Cards.Where(c => c.TopicId == topic.Id);
_context.Cards.RemoveRange(cards);
_context.Topics.Remove(topic);
_context.SaveChanges();
}
// Удаление всех игроков для комнаты.
var players = _context.Players.Where(p => p.PokerRoomId == PokerRoomId);
_context.Players.RemoveRange(players);
_context.SaveChanges();
// Удаление комнаты.
var pokerRoom = _context.PokerRooms.Where(p => p.Id == PokerRoomId).Single();
_context.PokerRooms.Remove(pokerRoom);
_context.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
return(new BadRequestResult());
}
}
return(RedirectToAction("Index", "Home"));
}
}
public IActionResult RoomCreate(CreateModel Created)
{
// Creation of ScrumPoker room
if (ModelState.IsValid)
{
int _nullablepassword;
using (var _context = new PokerPlanningContext())
{
_nullablepassword = PasswordEncrypt.GetPassword(Created.Password);
var NewRoom = new PokerRoom()
{
Title = Created.RoomTitle,
Description = "",
Password = _nullablepassword,
CreateDate = DateTime.Now,
CloseDate = null,
TypeCards = Created.CardsType
};
_context.PokerRooms.Add(NewRoom);
_context.SaveChanges();
var NewPlayer = new Player()
{
Name = Created.Name,
Role = 2,
PokerRoomId = NewRoom.Id,
IsOnline = false
};
_context.Players.Add(NewPlayer);
_context.SaveChanges();
return(RedirectToAction("RoomEntrance", "ScrumRoom", new { PokerRoomId = NewRoom.Id, PlayerId = NewPlayer.Id, password = _nullablepassword })); //переход в комнату
}
}
else
{
return(View(Created));
}
}
public async Task SendMessage(int RoomId, int UserId, string Context)
{
string playername;
using (var _context = new PokerPlanningContext())
{
var messagetodb = new Message()
{
Context = Context,
CreateDate = DateTime.Now,
PokerRoomId = RoomId,
PlayerId = UserId
};
await _context.AddAsync <Message>(messagetodb);
await _context.SaveChangesAsync();
playername = _context.Players.FirstOrDefault(pl => pl.Id == UserId).Name.ToString();
}
await this.Clients.Groups($"{RoomId}").SendAsync("ForwardToClients", playername, Context);
}
public async Task JoinGroup(int RoomId)
{
using (var _context = new PokerPlanningContext())
{
var messageslist = _context.Messages
.Where(msg => msg.PokerRoomId == RoomId)
.Select(msg => new { msg.Context, msg.PlayerId, msg.CreateDate });
if (!(messageslist is null))
{
var playername = _context.Players
.Join(messageslist, pl => pl.Id, msg => msg.PlayerId,
(players, messages) => new { players.Name, messages.Context, messages.CreateDate })
.OrderBy(time => time.CreateDate);
foreach (var item in playername)
{
await this.Clients.Caller.SendAsync("ForwardToClients", item.Name, item.Context);
}
}
}
await this.Groups.AddToGroupAsync(this.Context.ConnectionId, RoomId.ToString());
}
public IActionResult RoomJoin(JoinModel Joined)
{
// Joining to ScrumPoker room
if (ModelState.IsValid)
{
int _nullablepassword;
try
{
using (var _context = new PokerPlanningContext())
{
_nullablepassword = PasswordEncrypt.GetPassword(Joined.Password);
var Room = _context.PokerRooms.Where(m => m.Id == Joined.RoomId).SingleOrDefault();
if (Equals(Room.Password, _nullablepassword))//Проверка пароля, регистр важен
{
var NewPlayer = new Player()
{
Name = Joined.Name,
Role = 1,
PokerRoomId = Joined.RoomId.Value,
IsOnline = false
};
var Checker = _context.Players
.Where(m => m.PokerRoomId == NewPlayer.PokerRoomId &&
string.Compare(NewPlayer.Name, m.Name, true) == 0).ToList().Count;
if (Checker == 0)//Создать нового пользователя
{
_context.Players.Add(NewPlayer);
_context.SaveChanges();
return(RedirectToAction("RoomDiscussion", "ScrumRoom", new { PokerRoomId = Room.Id, PlayerId = NewPlayer.Id, password = _nullablepassword }));//переход в комнату
}
else //Такой пользователь уже есть, зайти под ним
{
var player = _context.Players.Where(p => p.PokerRoomId == Joined.RoomId && p.Name == NewPlayer.Name).SingleOrDefault();
if (player.Role == 2)
{
return(RedirectToAction("RoomEntrance", "ScrumRoom", new { PokerRoomId = Room.Id, PlayerId = player.Id, password = _nullablepassword }));//переход в комнату
}
else
{
return(RedirectToAction("RoomDiscussion", "ScrumRoom", new { PokerRoomId = Room.Id, PlayerId = player.Id, password = _nullablepassword }));
}
}
}
else
{
ModelState.AddModelError("Password", "Неверный пароль");
return(View(Joined));
}
}
}
catch (NullReferenceException)
{
ModelState.AddModelError("RoomId", "Неверный ID Комнаты");
return(View(Joined));
}
}
else
{
return(View(Joined));
}
}
//Комната обсуждения задачи.
public IActionResult RoomDiscussion(int PokerRoomId, int PlayerId, int password) //SignalR настроить
{
ViewBag.PokerRoomId = PokerRoomId;
List <string> valueCards = new List <string>();
using (var _context = new PokerPlanningContext())
{
var pw = _context.PokerRooms.FirstOrDefault(rid => rid.Id == PokerRoomId).Password;
if (Equals(password, pw))
{
ViewBag.Password = pw;
var player = _context.Players.Where(p => p.Id == PlayerId).SingleOrDefault();
var typeCards = _context.PokerRooms.Where(p => p.Id == PokerRoomId).SingleOrDefault().TypeCards;
string stringValueCards = "";
switch (typeCards)
{
case 1:
stringValueCards = "1,2,3,5,8,13,20,40,100,∞,?,CC";
break;
case 2:
stringValueCards = "1,2,3,5,8,13,20,40,?";
break;
case 3:
stringValueCards = "XS,S,M,L,XL,XXL,?";
break;
case 4:
stringValueCards = "1,2,5,10,20,50,100";
break;
}
valueCards = stringValueCards.Split(new char[] { ' ', ',' }, StringSplitOptions.RemoveEmptyEntries).ToList();
var TopicDiscussion = _context.Topics.Where(t => t.PokerRoomId == PokerRoomId && t.Status == 2);
var countTopicDiscussion = TopicDiscussion.ToList().Count;
ViewBag.CountTopicDiscussion = countTopicDiscussion;
//Если тема обсуждается.
if (countTopicDiscussion != 0)
{
var topic = TopicDiscussion.SingleOrDefault();
var cards = _context.Cards.Where(c => c.TopicId == topic.Id &&
c.IterationNumb == topic.IterationNumb && c.PlayerId == PlayerId).SingleOrDefault();
if (cards == null)
{
ViewBag.StatusMessage = 0; // еще нет карточки
}
else
{
ViewBag.StatusMessage = 1; // уже обсудили
ViewBag.Value = cards.CardValue;
}
ViewBag.Title = topic.Title;
ViewBag.Description = topic.Description;
ViewBag.IdTopic = topic.Id;
}
try
{
player.IsOnline = true;
_context.Players.Update(player);
_context.SaveChanges();
}
catch (NullReferenceException)
{
return(new BadRequestResult());
}
//Список пользователей-онлайн.
var playersOnline = _context.Players.Where(p => p.PokerRoomId == PokerRoomId && p.IsOnline == true).ToList();
ViewBag.NamePlayer = player.Name;
ViewBag.PlayerId = player.Id;
return(View((valueCards, playersOnline)));
}
return(RedirectToAction("RoomsList", "Home"));
}
}
