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(); }