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