Example #1
0
        //Update a forum

        public void update(ForumModel forum)
        {
            connection.Connect();
            SqlCommand sqlCommand = new SqlCommand("update forum set name = @name, description = @description where id = @id", connection.getConnection());

            sqlCommand.Parameters.AddWithValue("@name", forum.name);
            sqlCommand.Parameters.AddWithValue("@description", forum.description);
            sqlCommand.Parameters.AddWithValue("@id", forum.id);
            sqlCommand.ExecuteNonQuery();

            connection.disConnect();
        }
Example #2
0
        //Store a forum

        public int store(ForumModel forum)
        {
            SqlCommand sqlCommand = new SqlCommand("insert into forum (name, description) VALUES (@name, @description) select scope_identity()", connection.getConnection());

            connection.Connect();
            sqlCommand.Parameters.AddWithValue("@name", forum.name);
            sqlCommand.Parameters.AddWithValue("@description", forum.description);
            sqlCommand.Connection = connection.getConnection();
            int id = (int)(decimal)sqlCommand.ExecuteScalar();

            connection.disConnect();

            return(id);
        }
Example #3
0
        //Find a forum

        public ForumModel find(int id)
        {
            ForumModel forum = new ForumModel();

            connection.Connect();
            SqlCommand sqlCommand = new SqlCommand("select * from forum where id=@id", connection.getConnection());

            sqlCommand.Parameters.AddWithValue("@id", id);
            SqlDataReader reader = sqlCommand.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    forum.id          = Convert.ToInt32(reader["id"]);
                    forum.name        = reader["name"].ToString();
                    forum.description = reader["description"].ToString();
                }
            }

            connection.disConnect();
            return(forum);
        }
Example #4
0
        //Return all forums

        public List <ForumModel> index()
        {
            ForumModel        forum;
            List <ForumModel> forums = new List <ForumModel>();

            connection.Connect();
            SqlCommand    sqlCommand = new SqlCommand("select * from forum", connection.getConnection());
            SqlDataReader reader     = sqlCommand.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    forum             = new ForumModel();
                    forum.id          = Convert.ToInt32(reader["id"]);
                    forum.name        = reader["name"].ToString();
                    forum.description = reader["description"].ToString();
                    forums.Add(forum);
                }
            }

            connection.disConnect();
            return(forums);
        }