public static Update ( Person, myPerson ) : void | ||
myPerson | Person, | |
return | void |
public static void Update(Person myPerson)
{
Sqlite.Open();
dbcmd.CommandText = "UPDATE " + Constants.PersonTable +
" SET name = \"" + myPerson.Name +
"\", sex = \"" + myPerson.Sex +
"\", dateborn = \"" + UtilDate.ToSql(myPerson.DateBorn) +
"\", race = " + myPerson.Race +
", countryID = " + myPerson.CountryID +
", description = \"" + myPerson.Description +
"\", serverUniqueID = " + myPerson.ServerUniqueID +
" WHERE uniqueID == " + myPerson.UniqueID;
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
Sqlite.Close();
}
//upload a person private static Person serverUploadPerson(ChronojumpServer myServer, Person person, int serverSessionID) { int idAtServer = myServer.UploadPerson(person, serverSessionID); //update person (serverUniqueID) on client database person.ServerUniqueID = idAtServer; SqlitePerson.Update(person); return(person); }