public STypeList SelectAll()
 {
     Stypes          = new STypeList();
     cmd.CommandText = "SELECT  * From Stypes";
     Stypes          = new STypeList(base.Select());
     return(Stypes);
 }
        public STypeList SelectAllTypes()
        {
            STypeDB   db = new STypeDB();
            STypeList l  = new STypeList();

            l = db.SelectAll();
            return(l);
        }
        public RegisterPage(Person p) : this()
        {
            this.p = p;
            PasswordBox.Password = p.Password;
            STypeList l = host.SelectAllTypes();

            p.SType            = l.Find(item => item.ID == p.SType.ID);
            this.DataContext   = p;
            this.XX.Visibility = Visibility.Visible;
        }
        public static STypes SelectByID(int id)
        {
            if (Stypes == null)
            {
                STypeDB db = new STypeDB();
                Stypes = db.SelectAll();
            }
            STypes STypes = Stypes.Find(c => c.ID == id);

            return(STypes);
        }