public int Remove()
{
return MariaDBHelper.ExecuteNonQuery(
"RemoveMessage",
CommandType.StoredProcedure,
new MySqlParameter("Id", m_id)
);
}
public int Reply(CommentEntity cmt)
{
return(MariaDBHelper.ExecuteNonQuery(
"ReplyCommentById",
CommandType.StoredProcedure,
new MySqlParameter("SourceId", cmt.m_id),
new MySqlParameter("Content", m_content),
new MySqlParameter("Now", m_postTime),
new MySqlParameter("Composer", m_composer),
new MySqlParameter("PostIP", m_postIP)
));
}
public int Reply(MessageEntity msg)
{
return MariaDBHelper.ExecuteNonQuery(
"ReplyMessageById",
CommandType.StoredProcedure,
new MySqlParameter("Content", m_content),
new MySqlParameter("Now", m_postTime),
new MySqlParameter("Composer", m_composer),
new MySqlParameter("PostIP", m_postIP),
new MySqlParameter("SourceID", msg.m_id)
);
}
public int Add()
{
return(MariaDBHelper.ExecuteNonQuery(
"AddResource",
CommandType.StoredProcedure,
new MySqlParameter("Parent", m_parentFolder),
new MySqlParameter("Name", m_name),
new MySqlParameter("Type", m_type),
new MySqlParameter("Format", m_format),
new MySqlParameter("Composer", m_composer),
new MySqlParameter("Description", m_description)
));
}
public int Remove(string path)
{
if (m_type.ToLower() == "folder" && Directory.Exists(path))
{
Directory.Delete(path, true);
}
else if (File.Exists(path))
{
File.Delete(path);
}
return(MariaDBHelper.ExecuteNonQuery(
"RemoveResource",
CommandType.StoredProcedure,
new MySqlParameter("@ResourceId", m_id)
));
}
public int React(string react)
{
switch (react.ToLower())
{
case "support":
case "oppose":
case "report":
return(MariaDBHelper.ExecuteNonQuery(
string.Format("UPDATE T_Comment SET {0} = {0} + 1, F_ReactLastIP = @Ip WHERE F_Id = @Id", "F_" + react),
CommandType.Text,
new MySqlParameter("Id", m_id),
new MySqlParameter("Ip", m_postIP)
));
default:
return(-1);
}
}
