public void OnGet()
{
var connection = Connection.Open();
try
{
Id = int.Parse(HttpContext.Request.Query["open"]);
}
catch
{
ReturnWithError();
return;
}
var reader = connection.GetDataFromDb($@"SELECT * FROM FORUM WHERE discussion_id = '{Id}'");
if (reader.Read())
{
Discussion = ForumDAO.MadeNewDiscussionObject(reader, connection);
}
reader.Close();
if (Discussion == null || Discussion.Name == null || Discussion.Name.Length < 1)
{
ReturnWithError();
return;
}
reader = CommentsDAO.GetAllComments(Id, connection);
Comments = new List <Comments>();
while (reader.Read())
{
Comments.Add(CommentsDAO.MadeNewCommentObject(reader, connection));
}
connection.Close();
}
//gets all forum topics in database
public List<ForumTopic> getAllTopics()
{
ForumDAO datalayer = new ForumDAO();
List<ForumTopic> topics = datalayer.getAllTopics();
return topics;
}
//gets a forum post from the datalayer
public ForumPost getTopic(int postID)
{
ForumDAO dataLayer = new ForumDAO();
ForumPost post = dataLayer.getForumPost(postID);
return post;
}
//gets all forum topics in database
public List <ForumTopic> getAllTopics()
{
ForumDAO datalayer = new ForumDAO();
List <ForumTopic> topics = datalayer.getAllTopics();
return(topics);
}
//gets a forum post from the datalayer
public ForumPost getTopic(int postID)
{
ForumDAO dataLayer = new ForumDAO();
ForumPost post = dataLayer.getForumPost(postID);
return(post);
}
public void OnGet()
{
var connection = Connection.Open();
var reader = ForumDAO.GetAllDiscussions(connection);
_list = new List <Discussion>();
while (reader.Read())
{
_list.Add(ForumDAO.MadeNewDiscussionObject(reader, connection));
}
connection.Close();
}
//adds a comment to a post
public bool addComment(int postID, string username, string userComment)
{
Comment comment = new Comment();
comment.forumTopic = postID;
comment.username = username;
comment.comment = userComment;
comment.createdOnDate = DateTime.Now;
ForumDAO dataLayer = new ForumDAO();
bool success = dataLayer.addComment(comment);
return success;
}
//adds a comment to a post
public bool addComment(int postID, string username, string userComment)
{
Comment comment = new Comment();
comment.forumTopic = postID;
comment.username = username;
comment.comment = userComment;
comment.createdOnDate = DateTime.Now;
ForumDAO dataLayer = new ForumDAO();
bool success = dataLayer.addComment(comment);
return(success);
}
//adds a new post to db
public bool addPost(string postTitle, string firstComment, string username)
{
ForumDAO dataLayer = new ForumDAO();
ForumTopic topic = new ForumTopic();
topic.createdBy = username;
topic.createdOnDate = DateTime.Now;
topic.title = postTitle;
int topicID = dataLayer.createNewTopic(topic);
Comment comment = new Comment();
comment.comment = firstComment;
comment.username = username;
comment.createdOnDate = DateTime.Now;
comment.forumTopic = topicID;
bool success = dataLayer.addComment(comment);
return success;
}
//adds a new post to db
public bool addPost(string postTitle, string firstComment, string username)
{
ForumDAO dataLayer = new ForumDAO();
ForumTopic topic = new ForumTopic();
topic.createdBy = username;
topic.createdOnDate = DateTime.Now;
topic.title = postTitle;
int topicID = dataLayer.createNewTopic(topic);
Comment comment = new Comment();
comment.comment = firstComment;
comment.username = username;
comment.createdOnDate = DateTime.Now;
comment.forumTopic = topicID;
bool success = dataLayer.addComment(comment);
return(success);
}
public void OnGet()
{
var connection = Connection.Open();
var list = UsersDAO.GetMyDiscussions(login.LoginSession, connection);
discussions = new List <Discussion>();
if (list != null)
{
var str = list.Aggregate("", (current, e) => current + ($@"'{e}'" + ","));
str = str.Remove(str.Length - 1);
var reader =
Connection.GetDataFromDb(connection, $@"SELECT * FROM FORUM WHERE discussion_id in ({str})");
if (reader.HasRows)
{
while (reader.Read())
{
discussions.Add(ForumDAO.MadeNewDiscussionObject(reader, connection));
}
}
}
connection.Close();
}
/// <summary> Retrieves Entity rows in a datatable which match the specified filter. It will always create a new connection to the database.</summary>
/// <param name="selectFilter">A predicate or predicate expression which should be used as filter for the entities to retrieve.</param>
/// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query.</param>
/// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param>
/// <param name="relations">The set of relations to walk to construct to total query.</param>
/// <param name="pageNumber">The page number to retrieve.</param>
/// <param name="pageSize">The page size of the page to retrieve.</param>
/// <returns>DataTable with the rows requested.</returns>
public static DataTable GetMultiAsDataTable(IPredicate selectFilter, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relations, int pageNumber, int pageSize)
{
ForumDAO dao = DAOFactory.CreateForumDAO();
return(dao.GetMultiAsDataTable(maxNumberOfItemsToReturn, sortClauses, selectFilter, relations, pageNumber, pageSize));
}
