public Boolean insert(ENLinePublishingOrder linePublishingOrder)
{
try
{
connect();
SqlCommand cmd = new SqlCommand("INSERT INTO Order_Lines_Publishing_Orders (idLines_POrders, idHouse_order, idNews, Quantity) VALUES (@idLines_POrders, @idHouse_order, @ideNews, @Quantity)", connection);
cmd.Parameters.Add(new SqlParameter("@IdHouse_Orders", linePublishingOrder.IdLines_POrders));
cmd.Parameters.Add(new SqlParameter("@idHouse_order", linePublishingOrder.PublishingOrder.IdHouse_Orders));
// cmd.Parameters.Add(new SqlParameter("@idNews", linePublishingOrder.NewBook.IdNews)); falta implementar en ENNewBook
cmd.Parameters.Add(new SqlParameter("@Quantity", linePublishingOrder.Quantity));
if (cmd.ExecuteNonQuery() == 1)
return true;
else
return false;
}
catch (Exception ex)
{
throw ex;
}
finally
{
disconnect();
}
}
public Boolean delete(ENLinePublishingOrder linePublishingOrder)
{
try
{
connect();
SqlCommand cmd = new SqlCommand("DELETE FROM Order_Lines_Publishing_Orders WHERE idLines_POrders = @idLines_POrders AND IdHouse_Orders=@IdHouse_Orders", connection);
cmd.Parameters.Add(new SqlParameter("@IdHouse_Orders", linePublishingOrder.PublishingOrder.IdHouse_Orders));
cmd.Parameters.Add(new SqlParameter("@idLines_POrders", linePublishingOrder.IdLines_POrders));
if (cmd.ExecuteNonQuery() == 1)
{
return true;
}
else
return false;
}
catch (Exception ex)
{
throw ex;
}
finally
{
disconnect();
}
}
public Boolean update(ENLinePublishingOrder a)
{
return true;
}
