package com.laundry.model;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToOne;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

@Entity
@NamedQueries({
	 @NamedQuery(name="BookingList.findAll", query="SELECT a FROM BookingList a"),
	 @NamedQuery(name="BookingList.findByNr", query="SELECT a FROM BookingList a WHERE a.apartmentNr LIKE :apartmentNr"),
	 @NamedQuery(name="BookingList.findByBookedDate", query="SELECT b FROM BookingList b WHERE b.bookedDate LIKE :bookedDate"),
	 @NamedQuery(name="BookingList.findByDateAndTime", query="SELECT b FROM BookingList b WHERE b.bookedDate LIKE :bookedDate AND b.laundryTime.bookedLaundryTime LIKE :laundryTime"),
	 })
@Table(name="BookingList")

public class BookingList implements Serializable{

	private String apartmentNr;
	private String bookedDate;
	private LaundryTime laundryTime;

	@Id
    @Column(name = "apartmentNr")
	public String getApartmentNr() {
		return apartmentNr;
	}
	public void setApartmentNr(String apartmentNr) {
		this.apartmentNr = apartmentNr;
	}

	@Column(name = "bookedDate")
	public String getBookedDate() {
		return bookedDate;
	}
	public void setBookedDate(String bookedDate) {
		this.bookedDate = bookedDate;
	}

	@ManyToOne
	@JoinColumn(name ="bookedLaundryTime", referencedColumnName ="bookedLaundryTime")
	public LaundryTime getLaundryTime() {
		return laundryTime;
	}
	public void setLaundryTime(LaundryTime laundryTime) {
		this.laundryTime = laundryTime;
	}


}