public async Task <CommentRes> SaveComment(SaveComment request) { var result = new CommentRes() { CommentId = 0, Message = "Something went wrong, please contact administrator." }; try { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@CommentId", request.CommentId); parameters.Add("@Text", request.Text); parameters.Add("@GameId", request.GameId); parameters.Add("@UserId", request.UserId); result = await SqlMapper.QueryFirstOrDefaultAsync <CommentRes>(cnn : connection, sql : "sp_SaveComment", param : parameters, commandType : CommandType.StoredProcedure); return(result); } catch (Exception ex) { return(result); } }
public HttpResponseMessage ToCommentPage(UserByOrderIdReq req) { var userId = Convert.ToInt32(req.userId); var tokenStr = req.Token; Token token = CacheHelper.GetUserToken(tokenStr); if (token == null) { return(ControllerHelper.Instance.JsonResult(400, "token失效")); } if (token.Payload.UserID != userId) { return(ControllerHelper.Instance.JsonResult(400, "token错误")); } var orderId = Convert.ToInt32(req.orderId); var list = OrderInfoOper.Instance.GetViewByOrderId(orderId); list = list.Where(p => p.isMain == true).ToList(); CommentRes res = new CommentRes(list, apiHost); return(ControllerHelper.Instance.JsonResult(200, JsonConvert.SerializeObject(res), "")); }
public static void GetComment() { string guid = DiscussionProvider.Instance.RevitElement.guid; if (guid == null) { MessageBox.Show("You have to refresh first"); return; } DiscussionProvider.Instance.Comments.Clear(); CommentRoute route = new CommentRoute(ProjectProvider.Instance.CurrentProject._id); RestRequest req = new RestRequest(route.url(guid), Method.GET); req.AddHeader("Content-Type", "application/json"); req.AddHeader("Authorization", "Bearer " + AuthProvider.Instance.token.token); IRestResponse res = Route.Client.Execute(req); if (res.StatusCode == System.Net.HttpStatusCode.NotFound) { MessageBox.Show("No comment on this element."); return; } if (res.StatusCode == System.Net.HttpStatusCode.OK) { string format = "0000-12-31T23:50:39.000Z"; var dateTimeConverter = new IsoDateTimeConverter { DateTimeFormat = format, Culture = CultureInfo.InvariantCulture }; CommentRes commentRes = JsonConvert.DeserializeObject <CommentRes>(res.Content, dateTimeConverter); if (commentRes.data != null) { ObservableCollection <Comment> tmp = new ObservableCollection <Comment>(); foreach (Comment comment in commentRes.data.comments) { tmp.Add(comment); } for (int i = 1; i <= tmp.Count(); i++) { DiscussionProvider.Instance.Comments.Add(tmp[tmp.Count() - i]); } } } else { MessageBox.Show("Some errors on getting comments of element"); } }