public String consultaSaldo(string email)
{
try
{
string saldo = "";
DB db = new DB();
db.OpenConnection();
String sql = "SELECT c.saldo, c.email, s.`desc` FROM contas c inner join situacao_conta s on c.idsituacao = s.idsituacao where email=@email;";
MySqlCommand cmd = new MySqlCommand(sql, db.con);
cmd.Prepare();
cmd.Parameters.AddWithValue("@email", email);
db.result = cmd.ExecuteReader();
if (db.result.Read())
{
saldo = db.result.GetString(0);
}
db.CloseConnection();
return saldo;
}
catch
{
return "erro";
}
}
public Boolean registraConta(Conta c)
{
try
{
DB db = new DB();
db.OpenConnection();
String sql = "insert into contas values (null, @email, @senha, @saldo, 1);";
MySqlCommand cmd = new MySqlCommand(sql,db.con);
cmd.Prepare();
cmd.Parameters.AddWithValue("@email",c.email);
cmd.Parameters.AddWithValue("@senha",c.senha);
cmd.Parameters.AddWithValue("@saldo",c.saldo);
cmd.ExecuteNonQuery();
db.CloseConnection();
return true;
}
catch
{
return false;
}
// OdbcCommand cmd = new OdbcCommand(SQL, con);
// con.Open();
// try
// {
// cmd.ExecuteNonQuery();
// return true;
// }
// catch
// {
// return false;
// }
}
