SqlitePerson.Update C# (CSharp) Method

Update() public static method

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();
    }

Usage Example

Exemplo n.º 1
0
    //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);
    }