public cartao(int CodigoCartao) { MysqlDB.dbMysql oDB; System.Data.IDataReader myReader; string Query = CMD_CARTAO_SELECT.Replace("_CARTAO_", CodigoCartao.ToString()); bool AchouCartao = false; try { oDB = new dbMysql(); myReader = oDB.ExecuteCommand(Query); // Importa os dados pra estrutura! while (myReader.Read()) { AchouCartao = true; mCodigoCartao = System.Convert.ToInt32(myReader["numCartao"].ToString()); mNome = myReader["strNome"].ToString(); mSexo = (TipoSexo) System.Convert.ToInt32(myReader["optSexo"].ToString()); mRG = myReader["strRG"].ToString(); mNascimento = System.Convert.ToDateTime(myReader["dthNascimento"].ToString()); mCartaoAberto = (System.Convert.ToInt32(myReader["flgAberto"].ToString()) == 0 ? true : false); } if (!AchouCartao) throw(new System.Exception("Cartão não encontrado no banco de dados!")); mFromDatabase = true; myReader.Close(); myReader = null; oDB.Dispose(); } catch (System.Exception oException) { throw(oException); } }
// 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); } }