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