private static async Task <IActionResult> PostOrPutExecution(HttpRequest req, string postId, CloudTable collector, ILogger log, FacebookProfileDto fbUser, HttpOperation httpMethod) { log.LogInformation($"Trigger for {httpMethod} http method"); log.LogInformation($"Reading body"); var body = await new StreamReader(req.Body).ReadToEndAsync(); if (string.IsNullOrWhiteSpace(body)) { log.LogWarning($"Empty Body"); return(new BadRequestResult()); } log.LogInformation($"Received body : {body}, trying to deserialize"); var comment = JsonConvert.DeserializeObject <CommentDto>(body); var partitionKey = postId; var rowKey = $"{fbUser.Id}"; log.LogInformation( $"Deserialized, trying insert or replace comment, partitionKey: {partitionKey}, rowKey: {rowKey}"); var tableEntity = new CommentTable { PartitionKey = partitionKey, RowKey = rowKey, Comment = comment.Comment, Title = comment.Title, ETag = "*" }; TableOperation operation = null; switch (httpMethod) { case HttpOperation.Put: log.LogInformation("Have chosen table operation Replace"); operation = TableOperation.Replace(tableEntity); break; case HttpOperation.Post: log.LogInformation("Have chosen table operation Insert"); operation = TableOperation.Insert(tableEntity); break; default: // Unsupported HTTP verbs = HTTP 405 (method not allowed) return(new StatusCodeResult(405)); } await collector.ExecuteAsync(operation); log.LogInformation("Done"); if (httpMethod == HttpOperation.Post) { return(new OkObjectResult(comment)); } return(new OkResult()); }
public BaseResponse PostComment(CommentTable commentTable, string userId) { var response = new BaseResponse(); try { var comment = _context.CommentTable.Add(commentTable); _context.SaveChanges(); var internalUserId = _context.UserTable.Where(x => x.AspNetUserId == userId).Single().Id; var userComment = new UserCommentTable(); userComment.UserId = internalUserId; userComment.CommentId = comment.Id; _context.UserCommentTable.Add(userComment); _context.SaveChanges(); response.Message = "OK"; response.Success = true; } catch (Exception ex) { response.Success = false; response.Message = ex.Message; } return(response); }
private void RebuidTokens() { CommentTable.Clear(); ClassfificationList.Clear(); QuickInfoList.Clear(); StructNameList.Clear(); BracePairList.Clear(); OutlineList.Clear(); ErrorList.Clear(); var snapshot = this.Buffer.CurrentSnapshot; var lexer = new FlatbufferLexer(new AntlrInputStream(snapshot.GetText())); foreach (var token in lexer.GetAllTokens()) { if (token.Type == FlatbufferLexer.COMMENT) { ClassfificationList.Add(new ClassificationSpan(new SnapshotSpan(snapshot, new Span(token.StartIndex, token.StopIndex - token.StartIndex + 1)), FBSComment)); var txt = token.Text; if (txt.StartsWith("//")) { txt = txt.Substring(2).Trim(); } else if (txt.StartsWith("/*")) { txt = txt.Substring(2, txt.Length - 4).Trim().Trim('*').Trim(); } var lines = txt.Split('\n'); for (int i = 0; i < lines.Length; i++) { CommentTable.Add(token.Line + i, txt); } } } lexer.Reset(); var parser = new FlatbufferParser(new CommonTokenStream(lexer)); parser.ErrorHandler = classificationErrorHandler; parser.RemoveErrorListeners(); parser.AddErrorListener(classificationErrorListener); parser.schema().Accept <int>(classificationVisitor); var dom = this.Buffer.Properties.GetProperty(typeof(ITextDocument)); if (dom != null) { filePath = (dom as ITextDocument).FilePath; FBSProject builder = new FBSProject("", new string[] { filePath }, ErrorReport); builder.Build(filePath, snapshot.GetText()); } ClassificationChanged?.Invoke(this, new ClassificationChangedEventArgs(new SnapshotSpan(snapshot, 0, snapshot.Length))); }
public Comment(CommentTable s, UserTable User) { CB = s; UserName = User.Name; UserAvatar = JsonConvert.DeserializeObject <List <string> >(User.Avatar); CommentText = s.Comment; CommentNR = s.CommentNR; }
public static void SyncAsync() { MobileService.SyncContext.PushAsync().ConfigureAwait(false); ModuleTable.PullAsync("allModules", ModuleTable.CreateQuery()); QATable.PullAsync("allQA", QATable.CreateQuery()); CommentTable.PullAsync("allComments", CommentTable.CreateQuery()); SkillsTable.PullAsync("allSkills", SkillsTable.CreateQuery()); }
public void MakeComment(CommentTable s) { var User = App.database.GetUser(s.User); if (User != null) { var C = new Comment(s, User.First()); CommentList.Add(C); } }
public CommentModel ToCommentModelFrom(CommentTable from) { var comment = new CommentModel(); comment.Id = from.Id; comment.Content = from.Content; comment.DateCreated = from.DateCreated; //comment.Post = ToPostModelFrom( from.Post); //comment.Author = ToUserModelFrom ( from.Author ); return(comment); }
protected override void Seed(CommentTableContext context) { var comment = new CommentTable { HostID = "1", UserID = "1", PostID = "1", Description = "Charles:This party sucks; Ichika:I know;" }; context.Set <CommentTable>().Add(comment); base.Seed(context); }
public void SaveDomain(CommentTable domainTable, string currentUserName = "") { string localUserName = getCurrentUserName(currentUserName); ApplicationUser user = _AccountService.FirstOrDefault(x => x.UserName == localUserName); domainTable.CreatedDate = DateTime.UtcNow; domainTable.ModifiedDate = domainTable.CreatedDate; domainTable.ApplicationUserCreatedId = user.Id; domainTable.ApplicationUserModifiedId = user.Id; domainTable.CompanyTableId = user.CompanyTableId; repo.Add(domainTable); _uow.Save(); }
public CommentPage(int argc, CommentTable s) { root = s; ArticleNR = argc; InitializeComponent(); BackButton.Clicked += (o, e) => { Chain.Remove(Chain.Last()); CLVL--; LoadComments(CLVL, Chain.Last().ID); }; Chain.Add(root); LoadComments(CLVL, Chain.Last().ID); }
public CommentTable ToCommentFrom(CommentModel from) { var comment = new CommentTable(); comment.Id = from.Id; comment.Content = from.Content; comment.DateCreated = from.DateCreated; comment.AuthorId = from.Author.Id; comment.Author = ToUserFrom(from.Author); comment.PostId = from.Post.Id; comment.Post = ToPostFrom(from.Post); return(comment); }
public static int InsertOrUpdateComments(Comment comment) { var lookup = CommentTable.LookupAsync(comment.id); if (lookup == null || comment.id == null) { CommentTable.InsertAsync(comment); } else { CommentTable.UpdateAsync(comment); } MobileService.SyncContext.PushAsync(); return(1); }
//Nullable<int> parentId public bool AddComment(string content, int houseId, int userId) { CommentTable comment = new CommentTable() { CommentContent = content, IsDelete = false, HouseId = houseId, UserId = userId, CommentTime = DateTime.Now, IsUpdata = false, }; forHouseContext.CommentTable.Add(comment); forHouseContext.SaveChanges(); return(true); }
/// <summary> /// 管理员删除用户评论 /// </summary> /// <param name="commentid">评论id</param> /// <returns></returns> public static int CommentDelAdmin(int commentid) { using (LgShopDBEntities db = new LgShopDBEntities()) { try { CommentTable con = db.CommentTable.Find(commentid); int id = con.UserID ?? 0; db.CommentTable.Remove(con); db.Database.ExecuteSqlCommand($"insert into NoticeTable values({id},'违规评论处理通知','尊敬的用户您好,您评论的内容:{con.CommentContent} 因违反了乐购商城相关规定,已被删除,请您遵守相关规定!','{DateTime.Now}',0)"); return(db.SaveChanges()); } catch (Exception) { return(0); } } }
public IActionResult Details(ProductsViewModels model) { if (HttpContext.Session.GetString("ID") == null) { return(RedirectToAction("Login", "Users")); } var data = new CommentTable() { ProductId = model.Id, UserId = Convert.ToInt32(HttpContext.Session.GetString("ID")), Comments = model.Comments }; _context.Comments.Add(data); _context.SaveChanges(); return(RedirectToAction("Index")); }
protected void btnPost_Click(object sender, EventArgs e) { if (txtComment.Text == "") { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('内容不能为空')", true); return; } else { string strConn = WebConfigurationManager.ConnectionStrings["dmtucaoConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO [comment] ([comment],[date],[user],[type],[it]) values(@comment,@date,@user,@type,@it)", con); cmd.Parameters.AddWithValue("@comment", txtComment.Text); cmd.Parameters.AddWithValue("@date", DateTime.Now); if ((bool)Session["pass"]) { cmd.Parameters.AddWithValue("@user", Session["NickName"].ToString()); } else { cmd.Parameters.AddWithValue("@user", "_guest"); } cmd.Parameters.AddWithValue("@type", Convert.ToByte(ddlType.SelectedValue)); cmd.Parameters.AddWithValue("@it", Convert.ToInt32(PageIndex.Value)); int count = cmd.ExecuteNonQuery(); if (1 == count) { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('评论成功')", true); CommentTable.DataBind(); SqlCommand read = new SqlCommand("UPDATE [ImageText] SET [danmaku]=@danmaku WHERE [it]=@it", con); read.Parameters.AddWithValue("@danmaku", CommentTable.Rows.Count.ToString()); read.Parameters.AddWithValue("@it", Context.Request["it"]); read.ExecuteNonQuery(); } else { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('评论失败,请重试')", true); } cmd = null; con.Close(); con = null; return; } }
async void SubmitComment(object sender, EventArgs e) { CommentButton.IsEnabled = false; //CommentListView.IsRefreshing = true; if (App.Online) { var CNR = App.database.CommentCount(ArticleNR); if (App.database.TokenCheck() && CommentEntry.Text != null && CommentEntry.Text != "" && CommentEntry.Text.Length > 0 && CNR != -1) { var SC = new CommentTable { Article = ArticleNR, CommentNR = CNR, UserSubmitted = 0, User = App.LoggedinUser.ID, Replynr = -1, Replylvl = 0, Comment = CommentEntry.Text, Point = 0 }; CommentEntry.Text = ""; Console.WriteLine("Inserting Comment"); App.database.InsertComment(SC); Console.WriteLine("Loading Comments"); LoadComments(); Console.WriteLine("Refreshing Comments"); CommentListView.ItemsSource = null; CommentListView.ItemsSource = CommentList; CommentListView.HeightRequest = LWH; } } else { await DisplayAlert("Offline", "The Server is currently Offline. Please try again later.", "OK"); } //CommentListView.IsRefreshing = false; CommentButton.IsEnabled = true; }
void SubmitComment(int ReplyNR) { Console.WriteLine("PING1"); if (App.database.TokenCheck() && (Comment.Text != null || Comment.Text != "")) { Console.WriteLine("PING2"); var CNR = App.database.CommentCount(ArticleNR); var SC = new CommentTable { Article = ArticleNR, CommentNR = CNR, UserSubmitted = root.UserSubmitted, User = App.LoggedinUser.ID, Replynr = ReplyNR }; if (ReplyNR > -1) { Console.WriteLine("PING3.1.1"); var Reply = new CommentTable(); //App.database.GetComment(ReplyNR).First(); Console.WriteLine("PING3.1.2"); var User = App.database.GetUser(Reply.User).First(); Console.WriteLine("PING3.1.3"); SC.Replylvl = Reply.Replylvl + 1; SC.Comment = "@" + User.Name + Reply.CommentNR + ", " + Comment.Text; // } else { Console.WriteLine("PING3.2"); SC.Replylvl = 0; SC.Comment = Comment.Text; } SC.Point = 0; Comment.Text = ""; App.database.InsertComment(SC); Console.WriteLine("PING4"); LoadComments(CLVL, Chain.Last().ID); } }
private void RebuidTokens() { CommentTable.Clear(); ClassfificationList.Clear(); StructNameList.Clear(); BracePairList.Clear(); OutlineList.Clear(); ErrorList.Clear(); var snapshot = this.Buffer.CurrentSnapshot; var lexer = new TemplateLexer(new AntlrInputStream(snapshot.GetText())); var parser = new TemplateParser(new CommonTokenStream(lexer)); //parser.ErrorHandler = classificationErrorHandler; //parser.RemoveErrorListeners(); //parser.AddErrorListener(classificationErrorListener); parser.document().Accept <int>(classificationVisitor); FlagAllHiddenToken(snapshot, lexer); //ClassificationChanged?.Invoke(this, new ClassificationChangedEventArgs(new SnapshotSpan(snapshot, 0, snapshot.Length))); }
void AddComment(CommentTable s) { var User = App.database.GetUser(s.User).First(); var Box = new Button { CornerRadius = 10, Margin = 5, BackgroundColor = Color.White, HorizontalOptions = LayoutOptions.FillAndExpand, VerticalOptions = LayoutOptions.FillAndExpand, }; var Comment = new Label { Text = s.Comment, HorizontalTextAlignment = TextAlignment.Start, VerticalTextAlignment = TextAlignment.Center, HorizontalOptions = LayoutOptions.Start, TextColor = Color.Black, FontSize = 16, WidthRequest = 290, Margin = 20, }; var Username = new Label { Text = " " + User.Name, HorizontalTextAlignment = TextAlignment.Start, VerticalTextAlignment = TextAlignment.Start, TextColor = Color.Black, FontSize = 16, }; var CurLVL = new Label { Text = s.Replylvl.ToString(), TextColor = Color.Black, BackgroundColor = Color.Transparent, HorizontalOptions = LayoutOptions.End, VerticalOptions = LayoutOptions.Center, Margin = 0, FontSize = 16, }; var Reply = new Button() { BackgroundColor = Color.FromHex("#649FD4"), TextColor = Color.FromHex("#FFFFFF"), WidthRequest = 60, HeightRequest = 30, Text = "Reply", FontSize = 10, HorizontalOptions = LayoutOptions.End, VerticalOptions = LayoutOptions.End, Margin = 20, }; Reply.Clicked += (o, e) => { SubmitComment(s.ID); }; CommentGrid.RowDefinitions.Add(new RowDefinition { Height = GridLength.Auto }); CommentGrid.Children.Add(Box, 0, 6, s.CommentNR, s.CommentNR + 1); CommentGrid.Children.Add(Comment, 1, 5, s.CommentNR, s.CommentNR + 1); CommentGrid.Children.Add(Username, 1, 5, s.CommentNR, s.CommentNR + 1); CommentGrid.Children.Add(Reply, 5, 6, s.CommentNR, s.CommentNR + 1); CommentGrid.Children.Add(CurLVL, 4, 5, s.CommentNR, s.CommentNR + 1); if (s.Replylvl == CLVL) { var Replies = new Button() { Text = "X Replies", BackgroundColor = Color.FromRgb(80, 210, 194), TextColor = Color.Black, WidthRequest = 60, HeightRequest = 20, HorizontalOptions = LayoutOptions.Center, VerticalOptions = LayoutOptions.End, Margin = 0, }; Replies.Clicked += (o, e) => { Chain.Add(s); CLVL++; LoadComments(CLVL, Chain.Last().ID); }; CommentGrid.Children.Add(Replies, 3, 4, s.CommentNR, s.CommentNR + 1); } if (CLVL > 1) { CommentGrid.RowDefinitions.Add(new RowDefinition { Height = GridLength.Auto }); CommentGrid.Children.Add(BackButton, 0, 6, s.CommentNR + 1, s.CommentNR + 2); } }
public static async Task <ObservableCollection <Comment> > GetModuleComments(string moduleId) { var x = new ObservableCollection <Comment>(await CommentTable.Where(y => y.moduleId == moduleId).ToCollectionAsync <Comment>().ConfigureAwait(false)); return(x); }
protected void Timer1_Tick(object sender, EventArgs e) { CommentTable.DataBind(); }