Select() public static method

public static Select ( bool dbconOpened, int uniqueID ) : string
dbconOpened bool
uniqueID int
return string
Esempio n. 1
0
    protected void printPersons()
    {
        //PERSON STUFF
        ArrayList myData = new ArrayList(1);

        myData.Add("\n" + Catalog.GetString("ID") + ":" + Catalog.GetString("Name") + ":" +
                   Catalog.GetString("Sex") + ":" + Catalog.GetString("Date of Birth") + ":" +
                   Catalog.GetString("Description") + ":" +
                   Catalog.GetString("Height") + ":" + Catalog.GetString("Weight") + ":" +
                   Catalog.GetString("Sport") + ":" + Catalog.GetString("Specialty") + ":" +
                   Catalog.GetString("Level") + ":" + Catalog.GetString("Comments")
                   );

        Sqlite.Open();
        foreach (PersonAndPS paps in myPersonsAndPS)
        {
            string sportName       = (SqliteSport.Select(true, paps.ps.SportID)).Name;
            string speciallityName = SqliteSpeciallity.Select(true, paps.ps.SpeciallityID);

            myData.Add(
                paps.p.UniqueID.ToString() + ":" + paps.p.Name + ":" +
                paps.p.Sex + ":" + paps.p.DateBorn.ToShortDateString() + ":" +
                Util.RemoveNewLine(paps.p.Description, true) + ":" +
                paps.ps.Height + ":" + paps.ps.Weight + ":" +
                sportName + ":" + speciallityName + ":" +
                Util.FindLevelName(paps.ps.Practice) + ":" +
                Util.RemoveNewLine(paps.ps.Comments, true)
                );
        }
        Sqlite.Close();

        writeData(myData);
        writeData("VERTICAL-SPACE");
    }