Example #1
0
        // Database stuff
        public void updateDatabase()
        {
            MysqlDB.dbMysql oDB;
             string Query;

             // Salva no banco de dados
             if (!mFromDatabase)
             {
            Query = CMD_CARTAO_INSERT;
            mFromDatabase = true;
             }
             else
            Query = CMD_CARTAO_UPDATE;

             Query = Query.Replace("_CARTAO_", mCodigoCartao.ToString());
             Query = Query.Replace("_NOME_", mNome);
             Query = Query.Replace("_SEXO_", ((int) mSexo).ToString());
             Query = Query.Replace("_RG_", mRG);
             Query = Query.Replace("_NASCIMENTO_", mNascimento.ToString("yyyy/MM/dd"));
             Query = Query.Replace("_ABERTO_", (mCartaoAberto ? "1" : "0"));

             try
             {
            oDB = new dbMysql();
            oDB.ExecuteNonQuery(Query);
            oDB.Dispose();
             }
             catch (System.Exception oException)
             {
            throw(oException);
             }
        }