//Metodo para Consultar Niveles de Usuario
        public DataTable ObtenerNiveles(string sid_Level, string sLevel_Description)
        {
            DataTable    dt            = oConn.ejecutarDataTable("UP_WEB_SEARCHNIVELES", sid_Level, sLevel_Description);
            EPersonLevel oePersonLevel = new EPersonLevel();

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i <= dt.Rows.Count - 1; i++)
                    {
                        oePersonLevel.id_Level             = dt.Rows[i]["id_Level"].ToString().Trim();
                        oePersonLevel.Level_Description    = dt.Rows[i]["Level_Description"].ToString().Trim();
                        oePersonLevel.Modulo_id            = dt.Rows[i]["Modulo_id"].ToString().Trim();
                        oePersonLevel.Modulo_Name          = dt.Rows[i]["Modulo_Name"].ToString().Trim();
                        oePersonLevel.Person_Modulo_Status = Convert.ToBoolean(dt.Rows[i]["Level_status"].ToString().Trim());
                        oePersonLevel.Level_status         = Convert.ToBoolean(dt.Rows[i]["Level_status"].ToString().Trim());
                        oePersonLevel.Level_CreateBy       = dt.Rows[i]["Level_CreateBy"].ToString().Trim();
                        oePersonLevel.Level_DateBy         = Convert.ToDateTime(dt.Rows[i]["Level_DateBy"].ToString().Trim());
                        oePersonLevel.Level_ModiBy         = dt.Rows[i]["Level_ModiBy"].ToString().Trim();
                        oePersonLevel.Level_DateModiBy     = Convert.ToDateTime(dt.Rows[i]["Level_DateModiBy"].ToString().Trim());
                    }
                }
                return(dt);
            }
            else
            {
                return(null);
            }
        }
Beispiel #2
0
        //---Metodo de Consulta de Niveles
        public DataTable BuscarNiveles(
            string sid_Level, string sLevel_Description)
        {
            DPersonLevel odsNiveles = new DPersonLevel();
            EPersonLevel oeNiveles  = new EPersonLevel();
            DataTable    dtNiveles  =
                odsNiveles.ObtenerNiveles(sid_Level, sLevel_Description);

            odsNiveles = null;
            return(dtNiveles);
        }
        /// <summary>
        /// Permite Actualizar la tabla de AD_Person_Modulos.
        /// 04/12/2010  Magaly Jiménez
        /// </summary>
        /// <param name="sid_Level"></param>
        /// <param name="bPerson_Modulo_Status"></param>
        /// <param name="sPerson_Modulo_ModiBy"></param>
        /// <param name="tPerson_Modulo_DateModiBy"></param>
        /// <returns></returns>
        public EPersonLevel Actualizar_NivelesModulos(string sid_Level, string sModulo_id, bool bPerson_Modulo_Status, string sPerson_Modulo_ModiBy, DateTime tPerson_Modulo_DateModiBy)
        {
            DataTable    dt = oConn.ejecutarDataTable("UP_WEB_ACTUALIZA_NIVELESMODULOS", sid_Level, sModulo_id, bPerson_Modulo_Status, sPerson_Modulo_ModiBy, tPerson_Modulo_DateModiBy);
            EPersonLevel oeaNivelesModulo = new EPersonLevel();

            oeaNivelesModulo.id_Level                 = sid_Level;
            oeaNivelesModulo.Person_Modulo_Status     = bPerson_Modulo_Status;
            oeaNivelesModulo.Person_Modulo_ModiBy     = sPerson_Modulo_ModiBy;
            oeaNivelesModulo.Person_Modulo_DateModiBy = tPerson_Modulo_DateModiBy;
            return(oeaNivelesModulo);
        }
        //Metodo para Actualizar Niveles de Usuario
        public EPersonLevel Actualizar_Niveles(string sid_Level, string sLevel_Description, bool bLevel_status, string sLevel_ModiBy, DateTime tLevel_DateModiBy)
        {
            DataTable    dt         = oConn.ejecutarDataTable("UP_WEB_ACTUALIZA_NIVELES", sid_Level, sLevel_Description, bLevel_status, sLevel_ModiBy, tLevel_DateModiBy);
            EPersonLevel oeaNiveles = new EPersonLevel();

            oeaNiveles.id_Level          = sid_Level;
            oeaNiveles.Level_Description = sLevel_Description;
            oeaNiveles.Level_status      = bLevel_status;
            oeaNiveles.Level_ModiBy      = sLevel_ModiBy;
            oeaNiveles.Level_DateModiBy  = tLevel_DateModiBy;
            return(oeaNiveles);
        }
Beispiel #5
0
        /// <summary>
        /// Registra relación de nivel de usuario a modulos para permisos
        /// 03/12/2010  Magaly Jiménez
        /// </summary>
        /// <param name="sid_Level"></param>
        /// <param name="sModulo_id"></param>
        /// <param name="sModulo_Name"></param>
        /// <param name="bPerson_Modulo_Status"></param>
        /// <param name="sPerson_Modulo_CreateBy"></param>
        /// <param name="tPerson_Modulo_Dateby"></param>
        /// <param name="sPerson_Modulo_ModiBy"></param>
        /// <param name="tPerson_Modulo_DateModiBy"></param>
        /// <returns></returns>
        public EPersonLevel RegistrarNivelesModulo(
            string sid_Level, string sModulo_id, string sModulo_Name,
            bool bPerson_Modulo_Status, string sPerson_Modulo_CreateBy,
            DateTime tPerson_Modulo_Dateby, string sPerson_Modulo_ModiBy,
            DateTime tPerson_Modulo_DateModiBy)
        {
            DPersonLevel odrNivelesModulo = new DPersonLevel();
            EPersonLevel oeNivelesModulo  = odrNivelesModulo.registrarPersonLevelModuloPK(sid_Level, sModulo_id, sModulo_Name, bPerson_Modulo_Status, sPerson_Modulo_CreateBy,
                                                                                          tPerson_Modulo_Dateby, sPerson_Modulo_ModiBy, tPerson_Modulo_DateModiBy);

            odrNivelesModulo = null;
            return(oeNivelesModulo);
        }
Beispiel #6
0
        //----Metodo para registrar Niveles
        public EPersonLevel RegistrarNiveles(
            string sid_Level, string sLevel_Description,
            bool bLevel_status, string sLevel_CreateBy,
            DateTime tLevel_DateBy, string sLevel_ModiBy,
            DateTime tLevel_DateModiBy)
        {
            DPersonLevel odrNiveles = new DPersonLevel();
            EPersonLevel oeNiveles  = odrNiveles.registrarPersonLevelPK(sid_Level, sLevel_Description, bLevel_status, sLevel_CreateBy,
                                                                        tLevel_DateBy, sLevel_ModiBy, tLevel_DateModiBy);

            odrNiveles = null;
            return(oeNiveles);
        }
Beispiel #7
0
        /// <summary>
        /// Actualiza estado de modulos de la tabla de AD_Person_Modulos
        /// 04/12/2010  Magaly Jiménez
        /// </summary>
        /// <param name="sid_Level"></param>
        /// <param name="bPerson_Modulo_Status"></param>
        /// <param name="sPerson_Modulo_ModiBy"></param>
        /// <param name="tPerson_Modulo_DateModiBy"></param>
        /// <returns></returns>
        public EPersonLevel Actualizar_NivelesModulos(
            string sid_Level, string sModulo_id,
            bool bPerson_Modulo_Status, string sPerson_Modulo_ModiBy,
            DateTime tPerson_Modulo_DateModiBy)
        {
            DPersonLevel odaNivelesModulos = new DPersonLevel();
            EPersonLevel oeaNivelesModulos =
                odaNivelesModulos.Actualizar_NivelesModulos(
                    sid_Level, sModulo_id, bPerson_Modulo_Status,
                    sPerson_Modulo_ModiBy, tPerson_Modulo_DateModiBy);

            odaNivelesModulos = null;
            return(oeaNivelesModulos);
        }
Beispiel #8
0
        //----Metodo para Atualizar Niveles
        public EPersonLevel Actualizar_Niveles(
            string sid_Level, string sLevel_Description,
            bool bLevel_status, string sLevel_ModiBy,
            DateTime tLevel_DateModiBy)
        {
            DPersonLevel odaNiveles = new DPersonLevel();
            EPersonLevel oeaNiveles =
                odaNiveles.Actualizar_Niveles(
                    sid_Level, sLevel_Description, bLevel_status,
                    sLevel_ModiBy, tLevel_DateModiBy);

            odaNiveles = null;
            return(oeaNiveles);
        }
        //Metodo para Registrar Niveles de usuarios
        public EPersonLevel registrarPersonLevelPK(string sid_Level, string sLevel_Description, bool bLevel_status, string sLevel_CreateBy,
                                                   DateTime tLevel_DateBy, string sLevel_ModiBy, DateTime tLevel_DateModiBy)
        {
            DataTable dt = oConn.ejecutarDataTable("UP_WEB_REGISTERLEVEL", sid_Level, sLevel_Description, bLevel_status, sLevel_CreateBy,
                                                   tLevel_DateBy, sLevel_ModiBy, tLevel_DateModiBy);
            EPersonLevel oerPersonLevel = new EPersonLevel();

            oerPersonLevel.id_Level          = sid_Level;
            oerPersonLevel.Level_Description = sLevel_Description;
            oerPersonLevel.Level_status      = bLevel_status;
            oerPersonLevel.Level_CreateBy    = sLevel_CreateBy;
            oerPersonLevel.Level_DateBy      = tLevel_DateBy;
            oerPersonLevel.Level_ModiBy      = sLevel_ModiBy;
            oerPersonLevel.Level_DateModiBy  = tLevel_DateModiBy;
            return(oerPersonLevel);
        }
        /// <summary>
        /// inserción de relación de mosulos a Nivel a la tabla de [AD_Person_Modulos]
        /// 03/12/2010  Magaly Jiménez.
        /// </summary>
        /// <param name="sid_Level"></param>
        /// <param name="sModulo_id"></param>
        /// <param name="sModulo_Name"></param>
        /// <param name="bPerson_Modulo_Status"></param>
        /// <param name="sPerson_Modulo_CreateBy"></param>
        /// <param name="tPerson_Modulo_Dateby"></param>
        /// <param name="sPerson_Modulo_ModiBy"></param>
        /// <param name="tPerson_Modulo_DateModiBy"></param>
        /// <returns></returns>
        public EPersonLevel registrarPersonLevelModuloPK(string sid_Level, string sModulo_id, string sModulo_Name, bool bPerson_Modulo_Status, string sPerson_Modulo_CreateBy,
                                                         DateTime tPerson_Modulo_Dateby, string sPerson_Modulo_ModiBy, DateTime tPerson_Modulo_DateModiBy)
        {
            DataTable dt = oConn.ejecutarDataTable("UP_WEBXPLORA_AD_REGISTERLEVELMODULO", sid_Level, sModulo_id, sModulo_Name, bPerson_Modulo_Status, sPerson_Modulo_CreateBy,
                                                   tPerson_Modulo_Dateby, sPerson_Modulo_ModiBy, tPerson_Modulo_DateModiBy);
            EPersonLevel oerPersonLevelModulo = new EPersonLevel();

            oerPersonLevelModulo.id_Level                 = sid_Level;
            oerPersonLevelModulo.Modulo_id                = sModulo_id;
            oerPersonLevelModulo.Modulo_Name              = sModulo_Name;
            oerPersonLevelModulo.Person_Modulo_CreateBy   = sPerson_Modulo_CreateBy;
            oerPersonLevelModulo.Person_Modulo_Dateby     = tPerson_Modulo_Dateby;
            oerPersonLevelModulo.Person_Modulo_ModiBy     = sPerson_Modulo_ModiBy;
            oerPersonLevelModulo.Person_Modulo_DateModiBy = tPerson_Modulo_DateModiBy;

            return(oerPersonLevelModulo);
        }