using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using AbstractFactory;
using CY.Model;
using CY.Infrastructure.Query;
namespace CY.BLL
{
    public class CategoriesBLL
    {
        ICategoriesDAL cDal = Factory.GetDALByInterfaceName(DALInterface.ICategoriesDAL) as ICategoriesDAL;//Factory.GetCategoriesDAL();

        public bool InsertModel(Categories model)
        {
            return cDal.InserModel(model);
        }

        public IEnumerable<Categories> GetCategoriesList()
        {
            Query query = new Query();
            query.SPName = "Categories_GetModel";
            return cDal.SelectAllModel(query);
        }


        public IEnumerable<Categories> GetCategoriesList(Pagination pa)
        {
            Query query = new Query();
            IList<Criterion> criterias = new List<Criterion>()
            {
                new Criterion("","CategoryID,CategoryName,Description"),
                new Criterion("","[Categories]"),
                new Criterion("",""),
                new Criterion("","CategoryID"),
            };
            query.Criteria = criterias;
            return cDal.SelectModelPage(query, pa);
        }

        public IList<Products> GetProductsByCategorieId(int CategorieId)
        {
            return cDal.GetProductsByCategorieId(CategorieId);
        }
    }
}