public List <Tarjetas> getTodasTarjetas(String cedula) { EnviarCorreo e = new EnviarCorreo(); Conexion c = new Conexion(); SqlConnection con = new SqlConnection(); con = c.ObtenerConexion(); try { using (con) { SqlCommand cmd = new SqlCommand("targetasCliente", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cedula", cedula); SqlDataReader reader = cmd.ExecuteReader(); List <Tarjetas> tar = new List <Tarjetas>(); String num; while (reader.Read()) { Tarjetas pr = new Tarjetas(); pr.setNumtargeta(reader["NumTarjeta"].ToString()); tar.Add(pr); num = pr.getNumtargeta(); } con.Close(); return(tar); } } catch (Exception ex) { throw ex; } }
public Tarjetas getDatosTarjetas(String targeta) { EnviarCorreo e = new EnviarCorreo(); Conexion c = new Conexion(); SqlConnection con = new SqlConnection(); con = c.ObtenerConexion(); try { using (con) { SqlCommand cmd = new SqlCommand("OpcionesTar", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@NumTar", targeta); SqlDataReader reader = cmd.ExecuteReader(); List <Tarjetas> tar = new List <Tarjetas>(); Tarjetas pr = new Tarjetas(); while (reader.Read()) { pr.setDeuda(reader["Deuda"].ToString()); pr.setFechapago(reader["FechaPago"].ToString()); pr.setOpcionpago(reader["OpcionPago"].ToString()); tar.Add(pr); } con.Close(); return(pr); } } catch (Exception ex) { throw ex; } }