/// <summary>
        /// Loads all comments into the list.
        /// </summary>
        private void LoadComments()
        {
            Database db = new Database();
            try
            {
                comments = new List<RemoteFileComment>();
                db.CreateCommand("SELECT * FROM files_comments WHERE files_id = :id");
                db.AddParameter("id", Id);
                db.OpenConnection();
                db.ExecuteCommand();
                OracleDataReader dr = db.DataReader;

                while (dr.Read())
                {
                    User user = ftp_db_poc.User.GetById(dr.GetValueByColumn<int>("users_id"));
                    DateTime dateTime = dr.GetValueByColumn<DateTime>("created");
                    string text = dr.GetValueByColumn<string>("text");
                    RemoteFileComment comment = new RemoteFileComment(dr.GetValueByColumn<int>("id"), text, user, dateTime);
                    comments.Add(comment);
                }
            }
            finally
            {
                db.CloseConnection();
            }
        }
        /// <summary>
        /// Removes the comment from the database and from the list.
        /// </summary>
        /// <param name="comment"></param>
        public void RemoveComment(RemoteFileComment comment)
        {
            Database db = new Database();
            try
            {
                db.CreateCommand("DELETE files_comments WHERE id = :id");
                db.AddParameter("id", comment.Id);
                db.OpenConnection();
                db.ExecuteCommand();

                comments.Remove(comment);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                db.CloseConnection();
            }
        }