public static bool excUnmed(CL_Unmed objUnmed, string con) { DB_Funcoes.DesmontaConexao(con); CONEXAO = montaDAO(CONEXAO); Conn = new NpgsqlConnection(CONEXAO); string sql = "DELETE FROM unmedida WHERE u_unid='" + objUnmed.u_unid + "'"; NpgsqlCommand comand = new NpgsqlCommand(sql, Conn); Conn.Open(); try { comand.ExecuteScalar(); return(true); } catch (Exception ex) { ex.ToString(); return(false); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }
public static bool cadUnmed(CL_Unmed objUnmed, string con) { DB_Funcoes.DesmontaConexao(con); CONEXAO = montaDAO(CONEXAO); Conn = new NpgsqlConnection(CONEXAO); try { string sql = "INSERT INTO unmedida (u_unid, u_nome, u_multip)" + "VALUES (@u_unid, @u_nome, @u_multip)"; NpgsqlCommand comand = new NpgsqlCommand(sql, Conn); comand.Parameters.AddWithValue("u_unid", objUnmed.u_unid); comand.Parameters.AddWithValue("u_nome", objUnmed.u_nome); comand.Parameters.AddWithValue("u_multip", objUnmed.u_multip); Conn.Open(); comand.ExecuteScalar(); return(true); } catch (Exception ex) { ex.ToString(); return(false); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }
public static bool alteraUnmed(CL_Unmed objUnmed, string con) { DB_Funcoes.DesmontaConexao(con); CONEXAO = montaDAO(CONEXAO); Conn = new NpgsqlConnection(CONEXAO); try { string sql = "UPDATE unmedida SET u_nome='" + objUnmed.u_nome + "', u_multip=" + objUnmed.u_multip + " WHERE u_unid='" + objUnmed.u_unid + "'"; NpgsqlCommand comand = new NpgsqlCommand(sql, Conn); Conn.Open(); comand.ExecuteScalar(); return(true); } catch (Exception ex) { ex.ToString(); return(false); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }
public static List <CL_Unmed> listar(List <CL_Unmed> objListUnmed, string con) { DB_Funcoes.DesmontaConexao(con); CONEXAO = montaDAO(CONEXAO); Conn = new NpgsqlConnection(CONEXAO); string sql = "SELECT * FROM unmedida"; CL_Unmed obj = null; NpgsqlCommand comand = new NpgsqlCommand(sql, Conn); NpgsqlDataReader dr; try { Conn.Open(); dr = comand.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { //instancio objeto cliente a cada item da lista de registos obj = new CL_Unmed(); //leio as informações dos campos e jogo para o objeto obj.u_unid = dr["u_unid"].ToString().Trim(); obj.u_nome = dr["u_nome"].ToString().Trim(); obj.u_multip = Convert.ToDouble(dr["u_multip"]); objListUnmed.Add(obj); } dr.Close(); return(objListUnmed); } else { objListUnmed = null; return(objListUnmed); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }
public static CL_Unmed buscaUnmed(CL_Unmed objUnmed, string con) { DB_Funcoes.DesmontaConexao(con); CONEXAO = montaDAO(CONEXAO); Conn = new NpgsqlConnection(CONEXAO); string sql = "SELECT * FROM unmedida WHERE u_unid='" + objUnmed.u_unid + "'"; NpgsqlCommand comand = new NpgsqlCommand(sql, Conn); NpgsqlDataReader dr; try { Conn.Open(); dr = comand.ExecuteReader(); if (dr.HasRows) { if (dr.Read()) { objUnmed.u_nome = dr["u_nome"].ToString().Trim(); objUnmed.u_multip = Convert.ToDouble(dr["u_multip"]); return(objUnmed); } else { objUnmed = null; return(objUnmed); } } else { objUnmed = null; return(objUnmed); } } catch (Exception ex) { ex.ToString(); objUnmed = null; return(objUnmed); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }
public static bool cadUnmed(CL_Unmed objUnmed, string con) { return(DB_Unmed.cadUnmed(objUnmed, con)); }
public static CL_Unmed buscaUnmed(CL_Unmed objUnmed, string con) { return(DB_Unmed.buscaUnmed(objUnmed, con)); }
public static bool alteraUnmed(CL_Unmed objUnmed, string con) { return(DB_Unmed.alteraUnmed(objUnmed, con)); }