| public InsertAtDB ( bool dbconOpened, string tableName ) : int | ||
| dbconOpened | bool | |
| tableName | string | |
| return | 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);
}
