package com.shop.Manager.Impl;

import com.shop.Manager.ShopManager;
import com.shop.Model.Shop;
import com.shop.Util.Pager.PagerManager;
import com.shop.Util.Pager.PagerModel;

public class ShopManagerImpl extends PagerManager implements ShopManager {

	public void addShop(Shop shop) {
		this.getHibernateTemplate().save(shop);

	}

	public void delShop(int id) {
		this.getHibernateTemplate().delete(this.getShopById(id));

	}

	public Shop getShopById(int id) {
		
		return (Shop)this.getHibernateTemplate().get(Shop.class, id);
	}

	public PagerModel searchShops(Shop shop) {
		String where = "";
		if(shop.getShopName()!=null && shop.getShopName()!=""){
			where = where+" and s.shopName = '"+shop.getShopName()+"'";
		}
		if(shop.getType()!=0){
			where = where+" and s.type = "+shop.getType();
		}
		String hql = "select s from Shop s where 1=1 "+where;
		return this.searchPaginated(hql);
	}

	public void updateShop(Shop shop) {
		this.getHibernateTemplate().update(shop);
	}

}