private User insUpdUserDB(User newUser, int userIdModify)
        {
            User user = new User();
            try
            {
                String _query = "SP_AdminContenido_INSUPDUSER '" + newUser.email + "','"+newUser.pass
                    +"', '"+newUser.name+"', '"+newUser.type+"', '"+newUser.status+"',"+ userIdModify;
                conexion.Conectar();
                conexion.CrearComando(_query);
                DbDataReader DRConexion = conexion.EjecutarConsulta();
                while (DRConexion.Read())
                {

                    user = new User
                    {
                        id = DRConexion.GetInt32(0).ToString(),
                        email = DRConexion.GetString(1),
                        name = DRConexion.GetString(2),
                        type = DRConexion.GetString(3),
                        status = DRConexion.GetString(4)
                    };

                }
                conexion.Desconectar();
            }
            catch
            {
                user = new User
                {
                    id = null
                };
            }

            return user;
        }
        DataBase conexion = new DataBase("SQL"); //Creando objetos de la base de datos

        #endregion Fields

        #region Methods

        public User createUser(string _email, string _pass, string _name, string _type, int userIdModify  )
        {
            User newUser = new User();
            newUser.email   = _email;
            newUser.pass    = _pass;
            newUser.name    = _name;
            newUser.status  = Constants.STATUS_USER_ACTIVE;
            newUser.type    = _type;

            newUser = insUpdUserDB(newUser, userIdModify);

            return newUser;
        }
        public User updateUser(string _id, string _email, string _pass, string _name, string _type, string _status, int _idUserUpdate)
        {
            User updateUser = new User();

            updateUser.email    = _email;
            updateUser.pass     = _pass;
            updateUser.name     = _name;
            updateUser.status   = _status;
            updateUser.type     = _type;
            updateUser.id       = _id;

            updateUser = insUpdUserDB(updateUser, _idUserUpdate);

            return updateUser;
        }
        private User loginDB(string email, string pass)
        {
            User user = new User();
            try
            {
                String _query = "SP_AdminContenido_LOGIN '" + email + "','" + pass + "'";
                conexion.Conectar();
                conexion.CrearComando(_query);
                DbDataReader DRConexion = conexion.EjecutarConsulta();
                while (DRConexion.Read())
                {

                    user = new User
                    {
                        id = DRConexion.GetInt32(0).ToString(),
                        email = DRConexion.GetString(1),
                        name = DRConexion.GetString(2),
                        type = DRConexion.GetString(3),
                        status = DRConexion.GetString(4)
                    };

                }
                conexion.Desconectar();
            }
            catch
            {
                user = new User
                {
                    id = null
                };
            }

            return user;
        }
 public User login(string _email, string _pass)
 {
     User user = new User();
     user = loginDB(_email, _pass);
     return user;
 }