public static List <CL_Pedidos> buscaPedidos(int p_cod, string con) { DB_Funcoes.DesmontaConexao(con); CONEXAO = montaDAO(CONEXAO); Conn = new NpgsqlConnection(CONEXAO); CL_Pedidos obj = null; List <CL_Pedidos> objListPedido = new List <CL_Pedidos>(); string sql = "SELECT ped_cod, est_cod, est_nome, ped_qtdade, ped_preco, ped_vldesc, ped_desc, ped_idumov FROM pedidos WHERE ped_cod=@p_cod"; NpgsqlCommand comand = new NpgsqlCommand(sql, Conn); NpgsqlDataReader dr; comand.Parameters.AddWithValue("p_cod", p_cod); try { Conn.Open(); dr = comand.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { obj = new CL_Pedidos(); obj.ped_cod = p_cod; obj.est_cod = dr["est_cod"].ToString().Trim(); obj.est_nome = dr["est_nome"].ToString().Trim(); obj.ped_qtdade = Convert.ToDouble(dr["ped_qtdade"]); obj.ped_preco = Convert.ToDouble(dr["ped_preco"]); obj.ped_vldesc = Convert.ToDouble(dr["ped_vldesc"]); obj.ped_desc = Convert.ToDouble(dr["ped_desc"]); obj.ped_idumov = Convert.ToInt32(dr["ped_idumov"]); objListPedido.Add(obj); } return(objListPedido); } else { objListPedido = null; return(objListPedido); } } catch (Exception ex) { ex.ToString(); objListPedido = null; return(objListPedido); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }
public static bool attCondicPed(CL_Pedidos objPedidosCondic, string con) { return(DB_Pedidos.attCondicPed(objPedidosCondic, con)); }
public static bool attCondicPed(CL_Pedidos obj, string con) { DB_Funcoes.DesmontaConexao(con); CONEXAO = montaDAO(CONEXAO); Conn = new NpgsqlConnection(CONEXAO); try { string sql = "UPDATE pedido SET p_condic=@p_condic, p_ccondi=@p_ccondi WHERE p_cod=@p_cod; UPDATE pedidos SET " + "ped_condic=@p_condic, ped_ccondi=@p_ccondi, " + "ped_pz1=@ped_pz1, ped_pz2=@ped_pz2, ped_pz3=@ped_pz3, ped_pz4=@ped_pz4, ped_pz5=@ped_pz5, ped_pz6=@ped_pz6, ped_pz7=@ped_pz7, " + "ped_pz8=@ped_pz8, ped_pz9=@ped_pz9, ped_pz10=@ped_pz10, ped_pz11=@ped_pz11, ped_pz12=@ped_pz12, " + "ped_dt1=@ped_dt1, ped_dt2=@ped_dt2, ped_dt3=@ped_dt3, ped_dt4=@ped_dt4, ped_dt5=@ped_dt5, ped_dt6=@ped_dt6, ped_dt7=@ped_dt7, " + "ped_dt8=@ped_dt8, ped_dt9=@ped_dt9, ped_dt10=@ped_dt10, ped_dt11=@ped_dt11, ped_dt12=@ped_dt12, " + "ped_vlr1=@ped_vlr1, ped_vlr2=@ped_vlr2, ped_vlr3=@ped_vlr3, ped_vlr4=@ped_vlr4, ped_vlr5=@ped_vlr5, ped_vlr6=@ped_vlr6, ped_vlr7=@ped_vlr7, " + "ped_vlr8=@ped_vlr8, ped_vlr9=@ped_vlr9, ped_vlr10=@ped_vlr10, ped_vlr11=@ped_vlr11, ped_vlr12=@ped_vlr12 WHERE ped_cod=@p_cod"; NpgsqlCommand cmd = new NpgsqlCommand(sql, Conn); cmd.Parameters.AddWithValue("p_condic", obj.ped_condic); cmd.Parameters.AddWithValue("p_ccondi", obj.ped_ccondic); cmd.Parameters.AddWithValue("p_cod", obj.ped_cod); cmd.Parameters.AddWithValue("ped_pz1", obj.ped_pz1); cmd.Parameters.AddWithValue("ped_pz2", obj.ped_pz2); cmd.Parameters.AddWithValue("ped_pz3", obj.ped_pz3); cmd.Parameters.AddWithValue("ped_pz4", obj.ped_pz4); cmd.Parameters.AddWithValue("ped_pz5", obj.ped_pz5); cmd.Parameters.AddWithValue("ped_pz6", obj.ped_pz6); cmd.Parameters.AddWithValue("ped_pz7", obj.ped_pz7); cmd.Parameters.AddWithValue("ped_pz8", obj.ped_pz8); cmd.Parameters.AddWithValue("ped_pz9", obj.ped_pz9); cmd.Parameters.AddWithValue("ped_pz10", obj.ped_pz10); cmd.Parameters.AddWithValue("ped_pz11", obj.ped_pz11); cmd.Parameters.AddWithValue("ped_pz12", obj.ped_pz12); cmd.Parameters.AddWithValue("ped_dt1", obj.ped_dt1); cmd.Parameters.AddWithValue("ped_dt2", obj.ped_dt2); cmd.Parameters.AddWithValue("ped_dt3", obj.ped_dt3); cmd.Parameters.AddWithValue("ped_dt4", obj.ped_dt4); cmd.Parameters.AddWithValue("ped_dt5", obj.ped_dt5); cmd.Parameters.AddWithValue("ped_dt6", obj.ped_dt6); cmd.Parameters.AddWithValue("ped_dt7", obj.ped_dt7); cmd.Parameters.AddWithValue("ped_dt8", obj.ped_dt8); cmd.Parameters.AddWithValue("ped_dt9", obj.ped_dt9); cmd.Parameters.AddWithValue("ped_dt10", obj.ped_dt10); cmd.Parameters.AddWithValue("ped_dt11", obj.ped_dt11); cmd.Parameters.AddWithValue("ped_dt12", obj.ped_dt12); cmd.Parameters.AddWithValue("ped_vlr1", obj.ped_vlr1); cmd.Parameters.AddWithValue("ped_vlr2", obj.ped_vlr2); cmd.Parameters.AddWithValue("ped_vlr3", obj.ped_vlr3); cmd.Parameters.AddWithValue("ped_vlr4", obj.ped_vlr4); cmd.Parameters.AddWithValue("ped_vlr5", obj.ped_vlr5); cmd.Parameters.AddWithValue("ped_vlr6", obj.ped_vlr6); cmd.Parameters.AddWithValue("ped_vlr7", obj.ped_vlr7); cmd.Parameters.AddWithValue("ped_vlr8", obj.ped_vlr8); cmd.Parameters.AddWithValue("ped_vlr9", obj.ped_vlr9); cmd.Parameters.AddWithValue("ped_vlr10", obj.ped_vlr10); cmd.Parameters.AddWithValue("ped_vlr11", obj.ped_vlr11); cmd.Parameters.AddWithValue("ped_vlr12", obj.ped_vlr12); Conn.Open(); cmd.ExecuteScalar(); return(true); } catch (Exception ex) { ex.ToString(); return(false); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }