public bool AddFileContribution(FileContribution fileContribution, int postID) { var query = "p_post.AddFile"; var parameters = new List <OracleParameter> { new OracleParameter("Return_Value", OracleDbType.Int32, ParameterDirection.ReturnValue), new OracleParameter("p_accountId", fileContribution.UserID), new OracleParameter("p_bijdrageId", postID), new OracleParameter("p_path", fileContribution.Filepath), new OracleParameter("p_size", fileContribution.Filesize) }; return(Database.ExecuteNonQuery(query, parameters)); }
private void OnPreRender(object sender, EventArgs eventArgs) { Username.InnerText = LogicCollection.UserLogic.GetById(Post.UserID).Username; delete.Attributes.Add("value", Post.ID.ToString()); like.Attributes.Add("value", Post.ID.ToString()); report.Attributes.Add("value", Post.ID.ToString()); // Only the owners of the main posts an admins are allowed to remove posts var user = SiteMaster.CurrentUser(); delete.Visible = (Post.UserID == user.ID || user.Admin); var likes = LogicCollection.PostLogic.GetLikesByPost(Post); if (IsPostBack) { like.Visible = false; report.Visible = false; } // Adds the amount of likes to the posts, if any if (likes.Any()) { like.InnerHtml += "<span> " + likes.Count + "</span>"; } else { like.InnerHtml += "<span></span>"; } if (likes.Any(x => x == user.ID)) { like.Attributes.Add("class", like.Attributes["class"] + " liked"); } // Changes the button depending on whether or not the current user has reported it var reports = LogicCollection.PostLogic.GetReportsByPost(Post); if (reports.Any(x => x == user.ID)) { report.Attributes.Add("class", like.Attributes["class"] + " reported"); report.InnerHtml += "<span>Gerapporteerd</span>"; } else { report.InnerHtml += "<span>Rapporteren</span>"; } // Regular expression that extracts every hashtag var regex = new Regex(@"#(?<content>[^/\s]+)", RegexOptions.IgnoreCase); var list = regex.Matches(Post.Content).Cast <Match>().Select(m => m.Value).ToList(); // Wrapping every hashtag with a hyperlink tag to search for it foreach (var match in list) { Post.Content = Post.Content.Replace(match, $@"<a href='/Timeline?q={match.Replace("#", "")}'>{match}</a>"); } if (Post.File == null) { return; } File = Post.File; postThumbnail.ImageUrl = File.Filepath; }
public bool AddFileContribution(FileContribution fileContribution, int postID) { return(_context.AddFileContribution(fileContribution, postID)); }