public void BookConnecting()
{
var actual = new List <ENBook>();
var book = new ENBook();
Assert.AreEqual(0, book.Id);
}
public void BookReadingAll()
{
var actual = new List <ENBook>();
var book = new ENBook();
actual = book.ReadAll();
}
private void buttonGuardarNuevoLibro_Click(object sender, EventArgs e)
{
if (textBoxNuevoLibroIdBook.Text != "")
{
// try
//{
ENCourse course = new ENCourse();
course = course.Read(comboBoxNuevoLibroCurso.Text);
ENPublisher publisher = new ENPublisher();
publisher = publisher.read(comboBoxNuevoLibroEditorial.Text);
ENSubject subject = new ENSubject();
//subject = subject.Course
ENBook book = new ENBook(textBoxNuevoLibroIdBook.Text, subject, course, publisher.Cif, null, textBoxNuevoLibroNombre.Text, 1, textBoxNuevoLibroDescripcion.Text);
book.insert();
/* }
* catch
* {
* MessageBox.Show("Inserte un libro correcto.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }*/
}
else
{
MessageBox.Show("Inserte un ISBN/EAN13.", "Atención!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void buttonBuscarLibro_Click(object sender, EventArgs e)
{
if (textBoxIdLibroBuscar.Text != "")
{
//try
//{
ENBook book = new ENBook();
book = book.read(textBoxIdLibroBuscar.Text);
textBoxAsignaturasLibroBuscar.Text = book.Subject.Name;
textBoxCursosLibroBuscar.Text = book.Course.Courses;
textBoxNombreLibroBuscar.Text = book.Name;
textBoxEditorialBuscaLibro.Text = book.CIF;
textBoxDescripcionBuscaLibro.Text = book.Description;
pictureBoxImagenLibro.Image = Image.FromFile(book.Image);
buttonEliminarLibro.Visible = true;
/* }
* catch
* {
* MessageBox.Show("Inserte un libro correcto.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }*/
}
else
{
MessageBox.Show("Inserte un curso.", "Atención!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void buttonEliminarLibro_Click(object sender, EventArgs e)
{
ENBook book = new ENBook();
book = book.read(textBoxIdLibroBuscar.Text);
book.delete();
buttonEliminarLibro.Visible = false;
}
private void buttonMostrarLibros_Click(object sender, EventArgs e)
{
ENBook libro = new ENBook();
List <ENBook> lista = libro.readAll();
dataGridViewMostrarLibros.Rows.Clear();
foreach (ENBook b in lista)
{
dataGridViewMostrarLibros.Rows.Add(b.IDBook, b.Subject.Name, b.Course.Courses, b.CIF, b.Years, b.Name, b.Description);
}
}
public JsonResult BookUpdate(ENBook updatedBook)
{
try
{
updatedBook.Save();
return(Json(new { Result = "OK" }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public JsonResult BookCreate(ENBook newBook)
{
try
{
newBook.Save();
return(Json(new { Result = "OK", Record = newBook }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public void BookUpdate()
{
var book = new ENBook();
book = book.Read(1);
var oldName = book.Name;
book.Name = "testUpdateName";
book.Save();
var actual = book.Read(1);
var actualName = actual.Name;
actual.Name = oldName;
actual.Save();
Assert.AreEqual("testUpdateName", actualName);
}
public void BookInsert()
{
var book = new ENBook();
book.IdBook = "testInsertID";
book.Name = "testInsertName";
var testSubject = new ENSubject();
testSubject = testSubject.Read(1);
book.Subject = testSubject;
book.Bussiness = (new ENBusiness()).Read(1);
book.Save();
var bookList = book.ReadAll();
var actual = bookList[bookList.Count - 1];
actual.Delete();
Assert.AreEqual("testInsertID", actual.IdBook);
}
public JsonResult BookList()
{
try
{
var reader = new ENBook();
var list = reader.ReadAll();
/*
* var list = new List<Models.Book>();
* list.Add(new Models.Book("1", "The First", 3.05f, "url/to/first.img"));
* list.Add(new Models.Book("2", "The Second", 21.95f, "url/to/second.img"));
* list.Add(new Models.Book("3", "The Third", 70.25f, "url/to/third.img"));
*/
return(Json(new { Result = "OK", Records = list, TotalRecordCount = list.Count }));
}
catch (Exception ex)
{
return(Json(new { Result = "ERROR", Message = ex.Message }));
}
}
public ENNew read(String id)
{
try
{
connect();
SqlCommand cmd = new SqlCommand("SELECT * FROM News WHERE idnews=@id)", connection);
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
ENBook book = base.read(id);
ENNew nuevo = new ENNew();
nuevo.IDBook = dr["idnews"].ToString(); //devuelve un objeto EN que tendra todos sus datos
nuevo.Quantity = int.Parse(dr["quantity"].ToString());
nuevo.CIF = book.CIF;
nuevo.Course = book.Course;
nuevo.Description = book.Description;
nuevo.Name = book.Name;
nuevo.Subject = book.Subject;
nuevo.Years = book.Years;
dr.Close();
return(nuevo);
}
catch (Exception ex)
{
throw ex;
}
finally
{
disconnect();
}
}
