public bool validausuario(PessoaPojo usuario) { Conexao objCon = new Conexao(); MySqlConnection Conn = new MySqlConnection(); Conn = objCon.OpenConnection(); MySqlCommand cmd = Conn.CreateCommand(); string query = "SELECT Count(*) FROM pessoa where email='" + usuario.Email + "' and senha='" + usuario.Senha + "'"; cmd.CommandText = query; MySqlDataReader Reader = cmd.ExecuteReader(); while (Reader.Read()) { System.Diagnostics.Debug.WriteLine(Reader.GetUInt16(0)); if (Reader.GetUInt16(0) > 0) { cmd.Dispose(); objCon.CloseConnection(); return(true); } } objCon.CloseConnection(); cmd.Dispose(); return(false); }
public PessoaPojo buscarusuario(PessoaPojo usuario) { Conexao objCon = new Conexao(); MySqlConnection Conn = new MySqlConnection(); Conn = objCon.OpenConnection(); MySqlCommand cmd = Conn.CreateCommand(); string query = "SELECT nivel,id FROM pessoa where email='" + usuario.Email + "' and senha='" + usuario.Senha + "'"; cmd.CommandText = query; MySqlDataReader Reader = cmd.ExecuteReader(); while (Reader.Read()) { usuario.Nivel = Reader.GetInt16(0); usuario.Id = Reader.GetInt16(1); } cmd.Dispose(); objCon.CloseConnection(); return(usuario); }
public bool inserirdesejos(filmespojo filme, PessoaPojo pessoa) { int opcao = 0; Conexao objCon = new Conexao(); MySqlConnection Conn = new MySqlConnection(); Conn = objCon.OpenConnection(); MySqlCommand cmdverificar = Conn.CreateCommand(); string queryverificar = "SELECT status FROM meufilme WHERE pessoaid='" + pessoa.Id + "'and filmeid='" + filme.cod + "'"; cmdverificar.CommandText = queryverificar; MySqlDataReader Reader = cmdverificar.ExecuteReader(); while (Reader.Read()) { if (Reader.HasRows == true) { opcao = 1; } } cmdverificar.Dispose(); objCon.CloseConnection(); if (opcao == 1) { return(false); } Conn = objCon.OpenConnection(); MySqlCommand cmd = Conn.CreateCommand(); string query = "INSERT INTO meufilme (pessoaid, filmeid, status) VALUES('" + pessoa.Id + "', '" + filme.cod + "','0')"; //create command and assign the query and connection from the constructor cmd.CommandText = query; //Execute command cmd.ExecuteNonQuery(); //close connection cmd.Dispose(); objCon.CloseConnection(); return(true); }
public void removerdesejos(filmespojo f, PessoaPojo usuario) { Conexao objCon = new Conexao(); MySqlConnection Conn = new MySqlConnection(); Conn = objCon.OpenConnection(); MySqlCommand cmd = Conn.CreateCommand(); string query = "DELETE FROM meufilme WHERE filmeid='" + f.cod + "' and status='0' and pessoaid='" + usuario.Id + "'"; //create command and assign the query and connection from the constructor cmd.CommandText = query; //Execute command cmd.ExecuteNonQuery(); //close connection cmd.Dispose(); objCon.CloseConnection(); cmd.Dispose(); }
public void inserirpessoa(PessoaPojo pessoa) { Conexao objCon = new Conexao(); MySqlConnection Conn = new MySqlConnection(); Conn = objCon.OpenConnection(); MySqlCommand cmd = Conn.CreateCommand(); string query = "INSERT INTO pessoa (email,senha,nivel) VALUES('" + pessoa.Email + "', '" + pessoa.Senha + "','0')"; cmd.CommandText = query; //create command and assign the query and connection from the constructor //Execute command cmd.ExecuteNonQuery(); //close connection cmd.Dispose(); objCon.CloseConnection(); }