Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.dtr;

import java.io.Serializable;

import java.time.LocalDateTime;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

/**

 * This class basically contains api details

 * 

 * @author ashikali

 *

 */

@Entity

@Table(name="dtr.brands", schema = "dtr")

@NamedQueries({

	@NamedQuery(name = "Brand.selectCount", query = "select count(b) from Brand b"),

	@NamedQuery(name="Brand.selectAll",query="select b from Brand b where b.displayedInPreferencePage = :displayedInPreferencePage"),

	@NamedQuery(name="Brand.selectById",query="select b from Brand b where b.id= :id"),

	@NamedQuery(name="Brand.selectByName",query="select b from Brand b where b.name= :name"),

	@NamedQuery(name="Brand.selectByIdAndName",query="select b from Brand b where b.id = :id and b.name= :name"),

	@NamedQuery(name = "Brand.selectCountByName", query = "select count(b) from Brand b where b.name= :name"),

	@NamedQuery(name="Brand.deleteById",query="delete from Brand b where b.id= :id")

})

public class Brand implements Serializable{

	private static final long serialVersionUID = 1L;

	public Brand() {

	}

	@Id

	@Column(name="id", columnDefinition = "int(10) unsigned")

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	@Column(name="name")

	private String name;

	@Column(name = "category_id")

	private int categoryId;

	@Column(name = "displayed_in_preference_page", columnDefinition="tinyint(1) default 0")

	private boolean displayedInPreferencePage;

	@Column(name = "created")

	private LocalDateTime createTimestamp;

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public void setName(String name) {

        this.name = name;

    }

    public String getName() {

        return name;

    }

    public int getCategoryId() {

		return categoryId;

	}

    public void setCategoryId(int categoryId) {

		this.categoryId = categoryId;

	}

    public boolean isDisplayedInPreferencePage() {

		return displayedInPreferencePage;

	}

    public void setDisplayedInPreferencePage(boolean displayedInPreferencePage) {

		this.displayedInPreferencePage = displayedInPreferencePage;

	}

    public LocalDateTime getCreateTimestamp() {

		return createTimestamp;

	}

    public void setCreateTimestamp(LocalDateTime createTimestamp) {

		this.createTimestamp = createTimestamp;

	}

	@Override

	public String toString() {

		return "Brand [id=" + id + ", name=" + name + ", categoryId=" + categoryId + ", displayedInPreferencePage="

				+ displayedInPreferencePage + ", createTimestamp=" + createTimestamp + "]";

	}

}