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);
|
}
|
}
|
}
|