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