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); } }