public Boolean insert(ENPublishingOrder publishingOrder)
{
try
{
connect();
SqlCommand cmd = new SqlCommand("INSERT INTO Publishing_House_Orders(idPHouse_Orders, CIF, DataOrder) VALUES (@idPHouse_Orders, @CIF, @DataOrder)", connection);
cmd.Parameters.Add(new SqlParameter("@idPHouse_Orders", publishingOrder.IdHouse_Orders));
cmd.Parameters.Add(new SqlParameter("@CIF", publishingOrder.CIF));
cmd.Parameters.Add(new SqlParameter("@DataOrder", publishingOrder.DataOrder));
if (cmd.ExecuteNonQuery() == 1)
return true;
else
return false;
}
catch (Exception ex)
{
throw ex;
}
finally
{
disconnect();
}
}
public Boolean delete(ENPublishingOrder publishingOrder)
{
try
{
connect();
SqlCommand cmd = new SqlCommand("DELETE FROM Publishing_House_Orders WHERE idPHouse_Orders=@idPHouse_Orders", connection);
cmd.Parameters.Add(new SqlParameter("@idPHouse_Orders", publishingOrder.IdHouse_Orders));
if (cmd.ExecuteNonQuery() == 1)
{
SqlCommand cmdlines = new SqlCommand("DELETE FROM Order_Lines_Customers WHERE idPHouse_Orders=@idPHouse_Orders ", connection);
cmdlines.Parameters.Add(new SqlParameter("@idPHouse_Orders", publishingOrder.IdHouse_Orders));
if (cmdlines.ExecuteNonQuery() >= 0)
return true;
else
return false;
}
else
return false;
}
catch (Exception ex)
{
throw ex;
}
finally
{
disconnect();
}
}
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();
}
