username@email.com
2025-05-21 a980cd04341d71216e0f59bd4b7327fe9fc50032
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
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);
        }
    }
}