public bool createTopic(Topic topic)
{
string Author = verifyToken(topic.token);
if (Author == "")
{
ForumException forumException = new ForumException();
forumException.ErrorCode = 1;
forumException.Message = "Invalid token.";
throw new FaultException <ForumException>(forumException, new FaultReason("Invalid token."));
}
bool result = false;
string query = "INSERT INTO [Topic] (Name, Author, Discussion) VALUES (@Name, @Author, @Discussion)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@Name", topic.Name);
cmd.Parameters.AddWithValue("@Author", Author);
Console.WriteLine(Author);
cmd.Parameters.AddWithValue("@Discussion", topic.Discussion);
try
{
con.Open();
int i = cmd.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new FaultException <Exception>(ex, new FaultReason(ex.Message));
}
finally
{
con.Close();
}
return(result);
}
public bool addComment(Comment comment)
{
string Author = verifyToken(comment.token);
if (Author == "")
{
ForumException forumException = new ForumException();
forumException.ErrorCode = 1;
forumException.Message = "Invalid token.";
throw new FaultException <ForumException>(forumException, new FaultReason("Invalid token."));
}
bool result = false;
string query = "INSERT INTO [Comment] (TopicId, Author, Comment, Timestamp) VALUES (@TopicId, @Author, @Comment, @Timestamp)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@TopicId", comment.TopicId);
cmd.Parameters.AddWithValue("@Author", Author);
cmd.Parameters.AddWithValue("@Comment", comment.Comments);
cmd.Parameters.AddWithValue("@Timestamp", DateTime.Now);
try
{
con.Open();
int i = cmd.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw new FaultException <Exception>(ex, new FaultReason(ex.Message));
}
finally
{
con.Close();
}
return(result);
}
