//import java.util.Vector;
import java.rmi.RemoteException;
import java.util.Date;
-import java.util.LinkedList;
import java.util.List;
import java.util.ListIterator;
import java.util.Vector;
import domain.Account;
import domain.Administrator;
import domain.Booking;
+import domain.Client;
import domain.HouseFeatures;
import domain.Offer;
//import dataModel.Offer;
}
}
- public Administrator getAdminData() {
+ public Vector<Offer> getRHsOffer(String name){
+ if (c.isDatabaseLocal() == false)
+ openSDB();
+ else
+ openDB();
+
+ try {
+ RuralHouse rh = (RuralHouse)db.queryByExample(new RuralHouse(name, null, null, null, null)).get(0);
+ Offer proto = new Offer(0, rh, null, null, 0);
+ ObjectSet<Offer> result = db.queryByExample(proto);
+ return new Vector<Offer>(result);
+ } finally {
+ db.close();
+ }
+ }
+
+ public Administrator getAdminData(){
+
if (c.isDatabaseLocal() == false)
openSDB();
else
try {
List<Administrator> admL = db.query(new Predicate<Administrator>() {
- /**
- *
- */
private static final long serialVersionUID = 1L;
public boolean match(Administrator admin) {
}
- @SuppressWarnings("static-access")
public void storeAdmin() {
+
if (c.isDatabaseLocal() == false)
openSDB();
else
Administrator.getInstance().getRemoveRequest());
admL.get(0).setNewOwnerRequest(
Administrator.getInstance().getNewOwnerRequest());
+
db.commit();
} catch (Exception e) {
* day, last day, house number and telephone
* @return a book
*/
- public Booking createBooking(RuralHouse ruralHouse, Date firstDate,
- Date lastDate, String bookTelephoneNumber)
- throws OfferCanNotBeBooked {
+ public Vector<Booking> createBooking(RuralHouse ruralHouse, Date firstDate,
+ Date lastDate, Client cl) throws OfferCanNotBeBooked {
if (c.isDatabaseLocal() == false)
openSDB();
else
openDB();
- Booking bok = null;
+ Vector<Booking> book = new Vector<Booking>();
try {
openSDB();
RuralHouse proto = new RuralHouse(ruralHouse.getHouseName(), null,
- ruralHouse.getDescription(), ruralHouse.getDistrict(), null);
+ null, null, null);
ObjectSet<RuralHouse> result = db.queryByExample(proto);
RuralHouse rh = (RuralHouse) result.next();
Offer offer;
- offer = rh.findOffer(firstDate, lastDate);
+ offer = (Offer)db.queryByExample(new Offer(0, rh, firstDate, lastDate, 0)).get(0);
if (offer != null) {
- offer.createBooking(theDB4oManagerAux.bookingNumber++,
- bookTelephoneNumber);
+ offer.createBooking(theDB4oManagerAux.bookingNumber++, cl);
db.store(theDB4oManagerAux); // To store the new value for
// bookingNumber
+
db.store(offer);
db.commit();
- bok = offer.getBooking();
+ book = offer.getBookings();
+
}
} catch (com.db4o.ext.ObjectNotStorableException e) {
} finally {
db.close();
}
- return bok;
+ return book;
}
/**
}
}
- public Vector<RuralHouse> getAllRuralHouses() throws RemoteException,
- Exception {
-
- if (c.isDatabaseLocal() == false)
- openSDB();
- else
- openDB();
-
- try {
- RuralHouse proto = new RuralHouse(null, null, null, null, null);
- ObjectSet<RuralHouse> result = db.queryByExample(proto);
- Vector<RuralHouse> ruralHouses = new Vector<RuralHouse>();
- while (result.hasNext())
- ruralHouses.add((RuralHouse) result.next());
- return ruralHouses;
- } finally {
- db.close();
- }
- }
-
public boolean existsOverlappingOffer(RuralHouse rh, Date firstDay,
Date lastDay) throws RemoteException, OverlappingOfferExists {
}
}
- public static ObjectContainer getContainer() {
- return db;
- }
-
public void close() {
db.close();
System.out.println("DataBase closed");
}
- public Vector<RuralHouse> getRuralHouses(String name, String town,
+ public Vector<RuralHouse> getRuralHouses(Owner ow, String name, String town,
int nBed, int nKit, int nBath, int nPark, int nLiv) {
HouseFeatures fea = new HouseFeatures(nBed, nKit, nBath, nLiv, nPark);
- RuralHouse rh = new RuralHouse(name, null, null, town, fea);
+ RuralHouse rh = new RuralHouse(name, ow, null, town, fea);
if (c.isDatabaseLocal() == false)
openSDB();
else
openDB();
try {
- //TODO realize if there is another account with same username. Quite difficult with the f***ing salt
+ ObjectSet<Account> result = db.queryByExample(new Account(acc
+ .getUsername()));
+ if (result.isEmpty()) {
db.store(acc);
db.commit();
+ return true;
+ }
} catch (Exception exc) {
exc.printStackTrace();
} finally {
db.close();
}
- return true;
+ return false;
}
-
- //TODO remove account
+
+ // TODO remove account
public boolean removeAccount(Account acc) {
+ if (c.isDatabaseLocal() == false)
+ openSDB();
+ else
+ openDB();
+
+ try {
+ ObjectSet<Account> result = db.queryByExample(new Account(acc
+ .getUsername()));
+ if (!result.isEmpty()) {
+ db.delete(result.get(0));
+ ;
+ db.commit();
+ return true;
+ }
+ } catch (Exception exc) {
+ exc.printStackTrace();
+ } finally {
+ db.close();
+ }
return false;
}
+ // TODO this method should be improved.
+ public void acceptBooking(Offer of) {
+ Offer off = new Offer(of.getOfferNumber(), of.getRuralHouse(),
+ of.getFirstDay(), of.getLastDay(), of.getPrice());
+ if (c.isDatabaseLocal() == false)
+ openSDB();
+ else
+ openDB();
+
+ try {
+ ObjectSet<Offer> result = db.queryByExample(off);
+ this.deleteOffer(result.get(0));
+ db.store(of);
+ db.close();
+
+ } catch (Exception e) {
+ e.printStackTrace();
+ ;
+ }
+ }
+
+ public void removeBooking(Booking b) {
+ if (c.isDatabaseLocal() == false)
+ openSDB();
+ else
+ openDB();
+ try {
+ ObjectSet<Booking> result = db.queryByExample(b);
+ ObjectSet<Client> result2 = db.queryByExample(b.getClient());
+ db.delete(result.get(0));
+ db.delete(result2.get(0));
+ db.commit();
+ } catch (Exception e) {
+ e.printStackTrace();
+ ;
+ } finally {
+ db.close();
+ }
+
+ }
}
projects / RRRRHHHH_Code / blobdiff