Package edu.ubb.warp.model

Examples of edu.ubb.warp.model.Booking

198
199
200
201
202
203
204
205
206
207
208
  }

  public Booking getMaxBookingByResource(Resource resource)
      throws ResourceNotBookedException, DAOException {
    Booking booking = new Booking();
    try {
      String command = "SELECT * FROM Booking WHERE ResourceID = ? AND Week = (SELECT MAX(Week) FROM Booking WHERE ResourceID = ?)";
      PreparedStatement statement = JdbcConnection.getConnection()
          .prepareStatement(command);
      statement.setInt(1, resource.getResourceID());
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
  }

  public Booking getMinBookingByProject(Project project)
      throws ProjectNotBookedException, DAOException {
    Booking booking = new Booking();
    try {
      String command = "SELECT * FROM Booking WHERE ProjectID = ? AND Week = (SELECT MIN(Week) FROM Booking WHERE ProjectID = ?)";
      PreparedStatement statement = JdbcConnection.getConnection()
          .prepareStatement(command);
      statement.setInt(1, project.getProjectID());
View Full Code Here
242
243
244
245
246
247
248
249
250
251
252
  }

  public Booking getMaxBookingByProject(Project project)
      throws ProjectNotBookedException, DAOException {
    Booking booking = new Booking();
    try {
      String command = "SELECT * FROM Booking WHERE ProjectID = ? AND Week = (SELECT MAX(Week) FROM Booking WHERE ProjectID = ?)";
      PreparedStatement statement = JdbcConnection.getConnection()
          .prepareStatement(command);
      statement.setInt(1, project.getProjectID());
View Full Code Here
TOP

Related Classes of edu.ubb.warp.model.Booking

  • edu.ubb.warp.dao.jdbc.BookingJdbcDAO
  • edu.ubb.warp.ui.CloseProjectPageUI
  • edu.ubb.warp.ui.HomePageUI
  • edu.ubb.warp.ui.HubPageUI
  • edu.ubb.warp.ui.ProjectInformationPageUI
  • edu.ubb.warp.ui.ProjectOptionsPageUI
  • edu.ubb.warp.ui.ProjectPageUI
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.