public static void DBExcluir(Usuarios u) { NpgsqlConnection conn = DBConexao.Conectar(); string query = "DELETE FROM USUARIOS WHERE ID = @I"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; cmd.Parameters.Add("i", u.getId()); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Excluído com sucesso!", "Sucesso", MessageBoxButtons.OK); } else { MessageBox.Show("Erro ao excluir!", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void DBEditar(Categoria c) { NpgsqlConnection conn = DBConexao.Conectar(); string query = "UPDATE Categorias SET descricao = @n WHERE ID = @i"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; cmd.Parameters.Add("i", c.getId()); cmd.Parameters.Add("n", c.getDescricao()); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Categoria alterado com sucesso", "Sucesso", MessageBoxButtons.OK); } else { MessageBox.Show("Erro ao alterar!", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void DBEditar(Fabricantes f) { NpgsqlConnection conn = DBConexao.Conectar(); string query = "UPDATE Fabricante SET NOME = @n WHERE ID = @i"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; cmd.Parameters.Add("i", f.getId()); cmd.Parameters.Add("n", f.getNome()); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Fabricante alterado com sucesso", "Sucesso", MessageBoxButtons.OK); } else { MessageBox.Show("Erro ao alterar!", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void Inserir(Categoria c) { NpgsqlConnection conn = DBConexao.Conectar(); string query = "INSERT INTO CATEGORIA (DESCRICAO) VALUES (@c)"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; cmd.Parameters.Add("c", c.getDescricao()); if (cmd.ExecuteNonQuery() == 1) { frmMain f1 = new frmMain(); MessageBox.Show("Categoria cadastrada com sucesso"); } else { MessageBox.Show("Erro ao cadastrar categoria"); } }
public static void Inserir(Fabricantes f) { NpgsqlConnection conn = DBConexao.Conectar(); string query = "INSERT INTO FABRICANTE(NOME) VALUES (@n)"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; cmd.Parameters.Add("n", f.getNome()); if (cmd.ExecuteNonQuery() == 1) { frmMain f1 = new frmMain(); MessageBox.Show("fabricante cadastrado com sucesso"); } else { MessageBox.Show("Erro ao cadastrar fabricante"); } }
public static void DBEditar(Usuarios u) { NpgsqlConnection conn = DBConexao.Conectar(); string query = "UPDATE USUARIOS SET NOME = @n, LOGIN = @l, SENHA = @s WHERE ID = @i"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; cmd.Parameters.Add("i", u.getId()); cmd.Parameters.Add("n", u.getNome()); cmd.Parameters.Add("l", u.getLogin()); cmd.Parameters.Add("s", u.getSenha()); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Usuário alterado com sucesso", "Sucesso", MessageBoxButtons.OK); } else { MessageBox.Show("Erro ao alterar!", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List <Fabricantes> DBBuscar() { NpgsqlConnection conn = DBConexao.Conectar(); string query = "SELECT ID, NOME FROM FABRICANTE"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; NpgsqlDataReader reader = cmd.ExecuteReader(); List <Fabricantes> lista = new List <Fabricantes>(); while (reader.Read()) { Fabricantes f = new Fabricantes(); f.id = (Convert.ToInt32(reader["id"])); f.nome = (reader["nome"].ToString()); lista.Add(f); } return(lista); }
public static bool Entrar(Usuarios u) { NpgsqlConnection conn = DBConexao.Conectar(); string query = "SELECT LOGIN, SENHA FROM USUARIOS WHERE LOGIN = @u AND SENHA = @s"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; cmd.Parameters.Add("u", u.getLogin()); cmd.Parameters.Add("s", u.getSenha()); NpgsqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { MessageBox.Show("Usuário localizado com sucesso!", "Bem Vindo", MessageBoxButtons.OK); return(true); } else { MessageBox.Show("Erro ao localizar o usuário", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } }
public static void Inserir(Usuarios u) { NpgsqlConnection conn = DBConexao.Conectar(); string query = "INSERT INTO USUARIOS(NOME, LOGIN, SENHA) VALUES (@n, @l, @s)"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; cmd.Parameters.Add("n", u.getNome()); cmd.Parameters.Add("l", u.getLogin()); cmd.Parameters.Add("s", u.getSenha()); if (cmd.ExecuteNonQuery() == 1) { frmMain f1 = new frmMain(); MessageBox.Show("Usuário cadastrado com sucesso"); } else { MessageBox.Show("Erro ao cadastrar usuario"); } }
public static List <Categoria> Buscar() { NpgsqlConnection conn = DBConexao.Conectar(); string query = "SELECT ID, DESCRICAO FROM CATEGORIA"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; NpgsqlDataReader reader = cmd.ExecuteReader(); List <Categoria> lista = new List <Categoria>(); while (reader.Read()) { Categoria c = new Categoria(); c.id = (Convert.ToInt32(reader["id"])); c.descricao = (reader["descricao"].ToString()); lista.Add(c); } return(lista); }
public List <Usuarios> DBBuscar() { NpgsqlConnection conn = DBConexao.Conectar(); string query = "SELECT ID, NOME, LOGIN FROM USUARIOS ORDER BY ID ASC"; NpgsqlCommand cmd = new NpgsqlCommand(query); cmd.Connection = conn; NpgsqlDataReader reader = cmd.ExecuteReader(); List <Usuarios> lista = new List <Usuarios>(); while (reader.Read()) { Usuarios u = new Usuarios(); u.id = (Convert.ToInt32(reader["id"])); u.nome = (reader["nome"].ToString()); u.login = (reader["login"].ToString()); lista.Add(u); } return(lista); }