public static int GetForumPostVotes(programComponents.forumNeeds.ForumPost post)
{
var row = staticSource.SelectOneRow("votes FROM " + MysqlHandler.tblForum +
$" WHERE ID = '{post.id}'");
int votes = Convert.ToInt32(row[0]);
return(votes);
}
static internal bool PushNewForumProblem(programComponents.forumNeeds.ForumPost forumPost)
{
string name = forumPost.name;
string description = forumPost.description;
var subjectId = forumPost.subjectId;
//name = string.Format("'{0}'", name);
//description = string.Format("'{0}'", description);
string nameHolder = "■name"; //alt 254
string descHolder = "■desc";
var qParams = MysqlHandler.ConstructQueryParams(new string[] { nameHolder, descHolder },
new string[] { name, description });
return(staticSource.InsertInto(MysqlHandler.tblForum
+ "(ownerID, name, subjectID, description) VALUES"
+ $"('{CurrentUser.id}', '{nameHolder}', '{subjectId}', '{descHolder}')",
qParams));
}
public static programComponents.forumNeeds.ForumContent GetForum()
{
var rows = staticSource.Select("ID, name, subjectID, description, ownerID, votes FROM " +
MysqlHandler.tblForum);
var post = new programComponents.forumNeeds.ForumPost[rows.Count];
int i = 0;
foreach (var row in rows)
{
long id = Convert.ToInt64(row[0]);
string name = row[1];
int subjectId = Convert.ToInt32(row[2]);
string description = row[3];
int ownerId = Convert.ToInt32(row[4]);
int votes = Convert.ToInt32(row[5]);
var temp = new programComponents.forumNeeds.ForumPost(id, subjectId, name,
description, ownerId, votes);
//System.Windows.Forms.MessageBox.Show(temp.ToString() );
post[i++] = temp;
}
var content = new programComponents.forumNeeds.ForumContent(post);
return(content);
}
static internal bool UpvoteForumProblem(programComponents.forumNeeds.ForumPost post)
{
return(staticSource.InsertInto(MysqlHandler.tblForumVotes +
" (userID, forumID) VALUES "
+ $"('{CurrentUser.id}', '{post.id}')"));
}
public static bool TakeBackUpvoteForForum(programComponents.forumNeeds.ForumPost post)
{
return(staticSource.DeleteFrom(MysqlHandler.tblForumVotes +
$" WHERE userID = {CurrentUser.id} AND forumID = {post.id}"));
}
public static bool SetForumPostVotes(programComponents.forumNeeds.ForumPost post, int intoVotes)
{
post.votes = intoVotes;
return(staticSource.Update(MysqlHandler.tblForum + " SET votes =" +
$" '{post.votes}' WHERE ID = '{post.id}'"));
}
