public InsertAtDB ( bool dbconOpened, string tableName ) : int | ||
dbconOpened | bool | |
tableName | string | |
Результат | int |
public int UploadPersonSessionIfNeeded(PersonSession ps) { if (!SqlitePersonSession.PersonSelectExistsInSession(ps.PersonID, ps.SessionID)) { Console.WriteLine("personSession needed"); Console.WriteLine(ps.ToString()); ps.InsertAtDB(false, Constants.PersonSessionTable); Console.WriteLine("done"); return(1); //unused } else { Console.WriteLine("personSession NOT needed"); } return(0); //unused }
public int UploadPersonSessionIfNeeded(PersonSession ps) { if(!SqlitePersonSession.PersonSelectExistsInSession(ps.PersonID, ps.SessionID)) { Console.WriteLine("personSession needed"); Console.WriteLine(ps.ToString()); ps.InsertAtDB(false, Constants.PersonSessionTable); Console.WriteLine("done"); return 1; //unused } else Console.WriteLine("personSession NOT needed"); return 0; //unused }
protected static void convertPersonAndPersonSessionTo77() { //create person77 SqlitePerson sqlitePersonObject = new SqlitePerson(); sqlitePersonObject.createTable(Constants.PersonTable); //create personSession77 SqlitePersonSession sqlitePersonSessionObject = new SqlitePersonSession(); sqlitePersonSessionObject.createTable(Constants.PersonSessionTable); //select all personOld data SqlitePersonOld sqlitePersonOldObject = new SqlitePersonOld(); ArrayList personsOld = sqlitePersonOldObject.SelectAllPersons(); conversionRateTotal = personsOld.Count; conversionRate = 1; foreach (PersonOld pOld in personsOld) { Person p = new Person( pOld.UniqueID, pOld.Name, pOld.Sex, pOld.DateBorn, pOld.Race, pOld.CountryID, pOld.Description, pOld.ServerUniqueID ); p.InsertAtDB(true, Constants.PersonTable); //select all personSessionOld data of this person SqlitePersonSessionOld sqlitePersonSessionOldObject = new SqlitePersonSessionOld(); ArrayList personSessionsOld = sqlitePersonSessionOldObject.SelectAllPersonSessionsOfAPerson(p.UniqueID); conversionSubRateTotal = personSessionsOld.Count; conversionSubRate = 1; foreach (PersonSessionOld psOld in personSessionsOld) { PersonSession ps = new PersonSession( psOld.UniqueID, psOld.PersonID, psOld.SessionID, pOld.Height, psOld.Weight, pOld.SportID, pOld.SpeciallityID, pOld.Practice, "" //comments ); ps.InsertAtDB(true, Constants.PersonSessionTable); conversionSubRate ++; } conversionRate ++; } //drop old tables Sqlite.dropTable(Constants.PersonOldTable); Sqlite.dropTable(Constants.PersonSessionOldWeightTable); }