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); } }