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