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