public ENLinePublishingOrder(int idLines_POrders, ENPublishingOrder publishingOrder, ENNew newBook, int quantity)
{
this.idLines_POrders = idLines_POrders;
this.publishingOrder = publishingOrder;
this.newBook = newBook;
this.quantity = quantity;
cad = new CADLinePublishingOrder();
}
public ENLinePublishingOrder(int idLines_POrders, ENPublishingOrder publishingOrder, ENNew newBook, int quantity)
{
this.idLines_POrders = idLines_POrders;
this.publishingOrder = publishingOrder;
this.newBook = newBook;
this.quantity = quantity;
cad = new CADLinePublishingOrder();
}
public Boolean insert(ENNew book)
{
try
{
connect();
SqlCommand cmd = new SqlCommand("INSERT INTO News (idnews) VALUES(@idnews)", connection);
cmd.Parameters.Add(new SqlParameter("@id", book.IDBook));
if (cmd.ExecuteNonQuery() == 1)//este comando sirve para ejecutar la sentencia
return true;
else
return false;
}
catch (Exception ex)
{
throw ex;
}
finally
{
disconnect();
}
}
public Boolean delete(ENNew book)
{
try
{
connect();
SqlCommand cmd = new SqlCommand("DELETE FROM News WHERE idnews=@idnews", connection);
cmd.Parameters.Add(new SqlParameter("@idnews", book.IDBook));
if (cmd.ExecuteNonQuery() == 1)
return true;
else
return false;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
disconnect();
}
}
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();
}
}
public Boolean modify(ENNew book)
{
//Método innecesario
return true;
}
public List<ENNew> readAllNewBooks()
{
List<ENNew> news = new List<ENNew>();
List<ENBook> books = new List<ENBook>();
List<ENNew> resultado = new List<ENNew>();
SqlConnection connection = null;
try
{
connect();
DataTable dt = new DataTable();
SqlDataAdapter adaptador;
DataSet ds = new DataSet();
adaptador = new SqlDataAdapter("SELECT * FROM News ", connection);
adaptador.Fill(ds, "News");
dt = ds.Tables["News"];
for (int i = 0; i < dt.Rows.Count; i++)
{
ENNew book = new ENNew();
book.IDBook = dt.Rows[i][0].ToString();
book.Quantity = int.Parse(dt.Rows[i][1].ToString());
news.Add(book);
}
books = base.readAll();
int k = 0;
for (int i = 0; i < books.Capacity; i++)
{
for(int j = 0; j < news.Capacity; j++)
{
if (books[i].IDBook == news[j].IDBook)
{
resultado.Add(news[j]);
resultado[k].CIF = books[j].CIF;
resultado[k].Course = books[j].Course;
resultado[k].Description = books[j].Description;
resultado[k].Name = books[j].Name;
resultado[k].Subject = books[j].Subject;
resultado[k].Years = books[j].Years;
k++;
}
}
}
return resultado;
}
catch (Exception ex)
{
throw ex;
}
finally
{
disconnect();
}
}
