Carpetas.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using sage.ew.db;
using sage.ew.interficies;

namespace sage.addons.rgpd.Negocio
{
    internal class GestorCarpetas
    {
        IRgpdGestdocOperationProvider _oModulo = null;

        internal List<CarpetaItem> _Carpetas
        {
            get { return _lisCarpetas; }
            set { _lisCarpetas = value; }
        }
        List<CarpetaItem> _lisCarpetas = new List<CarpetaItem>();

        private GestorCarpetas() { }

        public GestorCarpetas(IRgpdGestdocOperationProvider toModulo)
        {
            _oModulo = toModulo;
            _Load();
        }

        private void _Load()
        {
            _lisCarpetas.Clear();

            string lcSql = "SELECT ID, IDGESTDOC, NOMBRE, PARENT, VISIBLE FROM " + 
                           DB.SQLDatabase("RGPD", "CARPETAS") + 
                           " WHERE VISIBLE = 1 " +
                           " ORDER BY ID ASC ";

            DataTable ldtCarpetas = new DataTable();
            if (DB.SQLExec(lcSql, ref ldtCarpetas) && ldtCarpetas.Rows.Count > 0)
            {
                ldtCarpetas.AsEnumerable().Cast<DataRow>().ToList()
                    .ForEach(loRow => _lisCarpetas.Add(new CarpetaItem(loRow)));
            }
        }

        public bool _GarantizarCarpetasRgpd()
        {
            //Obtengo la carpeta Raiz
            CarpetaItem loRaiz = _lisCarpetas.Where(loCarpeta => loCarpeta._IsRoot() == true).FirstOrDefault();
            if (loRaiz != null)
            {
                loRaiz._CreateOrUpdateIdGestDoc(_oModulo);
                var restoCarpetas = _lisCarpetas.Where(loCarpeta => loCarpeta._IsRoot() == false).ToList();

                //Establezco el Parent que ha de usar en la GESTION DOCUMENTAL
                restoCarpetas.ForEach(loCarpeta => loCarpeta._ParentGestDoc = loRaiz._IdGestdoc);

                //Invierto la ordenación para que no me reaproveche un Max de IdGestdoc
                var carpetasOrdenadas = restoCarpetas.OrderByDescending(loEle => loEle._IdRgpd).ToList();

                //Trato la carpeta
                carpetasOrdenadas.ForEach(loCarpeta => loCarpeta._CreateOrUpdateIdGestDoc(_oModulo));
                return true;
            }
            else
                return false;
        }

        public Dictionary<int, int> _ToDictionary()
        {
            Dictionary<int, int> dicCarpetas = new Dictionary<int, int>();
            _Carpetas.ForEach(loCarpeta => dicCarpetas.Add(loCarpeta._IdRgpd, loCarpeta._IdGestdoc));
            return dicCarpetas;
        }
    }

    internal class CarpetaItem
    {
        #region Propiedades

        public int _IdRgpd
        {
            get { return _nIdRgpd; }
            set { _nIdRgpd = value; }
        }
        private int _nIdRgpd = -1;

        public int _IdGestdoc
        {
            get { return _nIdGestdoc; }
            set { _nIdGestdoc = value; }
        }
        private int _nIdGestdoc = -1;

        public string _Nombre
        {
            get { return _cNombre; }
            set { _cNombre = value; }
        }
        private string _cNombre = "";

        public int _Parent
        {
            get { return _nParent; }
            set { _nParent = value; }
        }
        private int _nParent = -1;

        public int _ParentGestDoc
        {
            get { return _nParentGestDoc; }
            set { _nParentGestDoc = value; }
        }
        private int _nParentGestDoc = -1;

        public bool _Visible
        {
            get { return _lVisible; }
            set { _lVisible = value; }
        }
        private bool _lVisible = false;

        #endregion Propiedades

        #region Constructores

        public CarpetaItem() { }

        public CarpetaItem(DataRow tdRow) 
        {
            _nIdRgpd = Convert.ToInt32(tdRow["ID"]);
            _cNombre = Convert.ToString(tdRow["NOMBRE"]).TrimEnd();
            _nIdGestdoc = Convert.ToInt32(tdRow["IDGESTDOC"]);
            _nParent = Convert.ToInt32(tdRow["PARENT"]);
            _lVisible = Convert.ToBoolean(tdRow["VISIBLE"]);

            if (_IsRoot())
                _nParentGestDoc = 1; //Esblezco la raiz del rgpd
        }

        #endregion Constructores

        public bool _IsRoot()
        {
            return _nParent == 0;
        }

        public void _CreateOrUpdateIdGestDoc(IRgpdGestdocOperationProvider toModulo)
        {
            string lcNombreOriginal = _cNombre;
            int lnIdGestDocOriginal = _nIdGestdoc;
            toModulo.RgpdGarantizarDirectorio(ref _cNombre, ref _nIdGestdoc, _nParentGestDoc);
            if (lnIdGestDocOriginal != _nIdGestdoc || lcNombreOriginal != _cNombre) //Si ha cambiado de nombre o de ID
                _Update();
        }

        private bool _Update()
        {
            return DB.SQLExec("UPDATE " + DB.SQLDatabase("RGPD", "CARPETAS") +
                                    " SET NOMBRE = " + DB.SQLString(_cNombre) + ", IDGESTDOC = " + _nIdGestdoc + " " +
                                    " WHERE ID = " + _nIdRgpd);
        }
    }
}