public static bool EliminarTarjeta(Tarjeta_credito t)
{
string cadenaConexion = System.Configuration.ConfigurationManager.AppSettings["cadenaTP1"];
SqlConnection cn = new SqlConnection(cadenaConexion);
bool res = false;
try
{
SqlCommand cmd = new SqlCommand();
string consulta = "EliminarTarjetaCredito";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@id", t.IdTarjeta);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = consulta;
cn.Open();
cmd.Connection = cn;
cmd.ExecuteNonQuery();
res = true;
}
catch (Exception)
{
throw;
}
finally
{
cn.Close();
}
return(res);
}
public static Tarjeta_credito ObtenerTarjetaXID(int id)
{
string cadenaConexion = System.Configuration.ConfigurationManager.AppSettings["cadenaTP1"];
SqlConnection cn = new SqlConnection(cadenaConexion);
Tarjeta_credito t = new Tarjeta_credito();
try
{
SqlCommand cmd = new SqlCommand();
string consulta = "BuscarTarjetaPorID";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@id", id);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = consulta;
cn.Open();
cmd.Connection = cn;
SqlDataReader dr = cmd.ExecuteReader();
if (dr != null && dr.Read())
{
t.IdTarjeta = Convert.ToInt32(dr["id_tarjeta"]);
t.NombreTarjeta = dr["nombre_tarjeta"].ToString();
t.IdTipoTarjeta = Convert.ToInt32(dr["id_tipo_tarjeta"]);
}
}
catch (Exception)
{
throw;
}
finally
{
cn.Close();
}
return(t);
}
