public Boolean insertar(Ent_Tarjeta tar)
{
string sqlquery = "USP_Insertar_Tarjeta";
Boolean _valida = false;
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idtarjeta", tar.idtarjeta);
cmd.Parameters.AddWithValue("@tarnom", tar.tarnom);
cmd.Parameters.AddWithValue("@tarimagen", tar.tarimagen);
cmd.ExecuteNonQuery();
}
}
}
catch
{
_valida = false;
}
return(_valida);
}
public List <Ent_Tarjeta> Leer()
{
List <Ent_Tarjeta> tar_list = null;
string sqlquery = "USP_Leer_Tarjetas";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
tar_list = new List <Ent_Tarjeta>();
while (dr.Read())
{
Ent_Tarjeta add_tar = new Ent_Tarjeta();
add_tar.idtarjeta = dr["idtarjeta"].ToString();
add_tar.tarnom = dr["tarnom"].ToString();
add_tar.tarimagen = (Byte[])dr["tarimagen"];
tar_list.Add(add_tar);
}
}
}
}
}
catch
{
tar_list = null;
}
return(tar_list);
}
