//VER LISTA DE PAGOS //public List<Pago> obtenerPago() //{ // NpgsqlConnection conn = DAO.getInstanceDAO(); // conn.Open(); // string sql = "SELECT p.\"COD\", p.\"Peso\", p.\"Volumen\", tp.\"Clasificacion\", p.\"FK-EnvioP\", s.\"Nombre\", " + // "FROM \"Paquete\" p, \"TipoPaquete\" tp, \"Cliente\" c1, \"Cliente\" c2, \"Sucursal\" s " + // "WHERE p.\"FK - TipoPaquete\"= tp.\"COD\" and p.\"FK - Sucursal\"=s.\"COD\" and " + // "Order by p.\"COD\" "; // NpgsqlCommand cmd = new NpgsqlCommand(sql, conn); // NpgsqlDataReader dr = cmd.ExecuteReader(); // List<Pago> data = new List<Pago>(); // while (dr.Read()) // { // System.Diagnostics.Debug.WriteLine("connection established"); // data.Add(new Pago() // { // cod = Int32.Parse(dr[0].ToString()), // peso = Int32.Parse(dr[1].ToString()), // volumen = Int32.Parse(dr[2].ToString()), // ClasificacionTipoPaquete = dr[3].ToString(), // fkEnvioP = Int32.Parse(dr[4].ToString()), // NombreSucursal = dr[5].ToString(), // NombreClienteEnvia = dr[6].ToString(), // NombreClienteRecibe = dr[7].ToString(), // }); // } // dr.Close(); // conn.Close(); // return data; //} //BUSCAR A UNO public Pago buscarPago(int cod) { NpgsqlConnection conn = DAO.getInstanceDAO(); conn.Open(); string sql = "SELECT p.\"COD\", p.\"MontoTotal\", to_char(p.\"Fecha\", 'DD-MM-YYYY'), p.\"PagoDest\", pm.\"CODTarjeta\", " + "pm.\"CODCheque\", pm.\"CODTrans\", pm.\"CODEfect\" " + "FROM \"Pago\" p, \"Pago-Metodo\" pm " + "WHERE p.\"COD\" = " + cod + " and p.\"COD\"=pm.\"CODPago\""; NpgsqlCommand cmd = new NpgsqlCommand(sql, conn); NpgsqlDataReader dr = cmd.ExecuteReader(); Pago data = new Pago(); while (dr.Read()) { System.Diagnostics.Debug.WriteLine("connection established"); data.cod = Int32.Parse(dr[0].ToString()); data.montoTotal = Int32.Parse(dr[1].ToString()); data.fecha = dr[2].ToString(); data.pagoEnDestino = dr[3].ToString(); data.codMetodoPago = dr[4].ToString(); data.metodoPago = "Tarjeta"; if (data.codMetodoPago == "") { data.codMetodoPago = dr[5].ToString(); data.metodoPago = "Cheque"; } if (data.codMetodoPago == "") { data.codMetodoPago = dr[6].ToString(); data.metodoPago = "Transferencia"; } if ((data.codMetodoPago == "") || (data.pagoEnDestino == "True")) { data.codMetodoPago = dr[7].ToString(); data.metodoPago = "Efectivo"; } if (data.pagoEnDestino == "True") { data.pagoEnDestino = "Si"; } else { data.pagoEnDestino = "No"; } } dr.Close(); conn.Close(); return(data); }
//BUSCAR A UNO POR CODIGO DE ENVIO public Pago buscarPagoEnvio(int cod) { NpgsqlConnection conn = DAO.getInstanceDAO(); conn.Open(); string sql = "SELECT p.\"COD\" " + "FROM \"Pago\" p " + "WHERE p.\"FK-EnvioP\" = " + cod + " "; NpgsqlCommand cmd = new NpgsqlCommand(sql, conn); NpgsqlDataReader dr = cmd.ExecuteReader(); Pago data = new Pago(); while (dr.Read()) { System.Diagnostics.Debug.WriteLine("connection established"); data.cod = Int32.Parse(dr[0].ToString()); } dr.Close(); conn.Close(); return(data); }
//BUSCANDO ULTIMO PAGO public Pago buscarUltimoPago() { NpgsqlConnection conn = DAO.getInstanceDAO(); conn.Open(); string sql = "SELECT e.\"COD\", \"MontoTotal\" " + "FROM \"Pago\" e " + "Order by \"COD\" DESC " + "LIMIT 1 "; NpgsqlCommand cmd = new NpgsqlCommand(sql, conn); NpgsqlDataReader dr = cmd.ExecuteReader(); Pago data = new Pago(); while (dr.Read()) { System.Diagnostics.Debug.WriteLine("connection established"); data.cod = Int32.Parse(dr[0].ToString()); data.montoTotal = Int32.Parse(dr[1].ToString()); } dr.Close(); conn.Close(); return(data); }