public void eliminarrLector(Libros u)
{
conetar();
comando = conexion.CreateCommand();
comando.CommandText = " delete from Libros where idLibro=@user";
comando.Parameters.AddWithValue("@user", u.idlibro);
comando.ExecuteNonQuery();
desconectar();
}
public void actualizarLector(Libros u)
{
conetar();
comando = conexion.CreateCommand();
comando.CommandText = " update Libros set nombre=@n2,editorial=@a1,autor=@a2,foto=@dir where idlibro=@n1";
comando.Parameters.AddWithValue("@n1", u.idlibro);
comando.Parameters.AddWithValue("@n2", u.titulo);
comando.Parameters.AddWithValue("@a1", u.editorial);
comando.Parameters.AddWithValue("@a2", u.autor);
System.IO.MemoryStream ms = new System.IO.MemoryStream();
u.portada.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
comando.Parameters.AddWithValue("@dir", ms.GetBuffer());
comando.ExecuteNonQuery();
desconectar();
}
public void registrarLector(Libros u)
{
conetar();
comando = conexion.CreateCommand();
comando.CommandText = " INSERT INTO Libros values(@user,@n1,@n2,@a1,@dir)";
comando.Parameters.AddWithValue("@user", u.idlibro);
comando.Parameters.AddWithValue("@n1", u.titulo);
comando.Parameters.AddWithValue("@n2", u.editorial);
comando.Parameters.AddWithValue("@a1", u.autor);
System.IO.MemoryStream ms = new System.IO.MemoryStream();
u.portada.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
comando.Parameters.AddWithValue("@dir", ms.GetBuffer());
comando.ExecuteNonQuery();
desconectar();
}