private static void Ingresar(Biblioteca biblio)
{
SqlCommand cmd;
SqlDataReader rd;
string insert;
string select;
insert = "insert into Biblioteca (cNombre, cDescripcion) values ('" + biblio.Nombre + "', '" + biblio.Descripcion + "')";
select = "select IDENT_CURRENT ('Biblioteca')";
cmd = new SqlCommand(insert, BD.Con);
cmd.ExecuteNonQuery();
cmd = new SqlCommand(select, BD.Con);
rd = cmd.ExecuteReader();
rd.Read();
biblio.BibliotecaId = Convert.ToInt32(rd [0]);
rd.Close();
}
public static Biblioteca BuscarPorId(int id)
{
SqlCommand cmd;
SqlDataReader rd;
string select;
Biblioteca biblio = null;
select = "select * from Biblioteca where iBibliotecaId =" + id;
cmd = new SqlCommand(select, BD.Con);
rd = cmd.ExecuteReader();
if (rd.Read())
{
biblio = new Biblioteca();
biblio.BibliotecaId = id;
biblio.Nombre = rd [1].ToString();
biblio.Descripcion = rd [2].ToString();
rd.Close();
}
return(biblio);
}
