public async Task NewMessage(string username, RetroModel message)
{
if (message != null)
{
_retroService.CommentsAddOrUpdateOrDelete(message);
}
await Clients.All.SendAsync("messageReceived", username, message);
}
public int CommentsAddOrUpdateOrDelete(RetroModel retro)
{
try
{
var result = _connectContext.uspRetroAddorUPpdate.FromSqlRaw("exec uspRetroAddorUPpdate {0} , {1} , {2} , {3} , {4}, {5}, {6} , {7} , {8} , {9}",
retro.CommentId,
retro.SprintId,
retro.token,
retro.Message,
retro.CreatedBy,
retro.ColorCode,
retro.Type,
retro.VoteDown,
retro.VoteUp,
retro.action
).ToList();
return(result.FirstOrDefault().Result);
}
catch (Exception ex)
{
return(0);
}
}
