1public IQueryable<Equipment> GetEquipmentsByEquipmentClassID
2 (string equipmentClassID)
3{
4 MdfEntities mdfEntities = new MdfEntities();
5 return GetEquipmentsByEquipmentClassID(mdfEntities, equipmentClassID);
6}
7
8public IQueryable<Equipment> GetEquipmentsByEquipmentClassID
9 (MdfEntities mdfEntities, string equipmentClassID)
10{
11 var result = from entity in mdfEntities.Equipments
12 where entity.EquipmentClassID == equipmentClassID
13 select entity;
14
15 return result;
16}
17
18public IQueryable<Equipment> GetEquipmentsByEquipmentClassID
19 (string sortExpression, string equipmentClassID)
20{
21 MdfEntities mdfEntities = new MdfEntities();
22 var result = from entity in mdfEntities.Equipments
23 where entity.EquipmentClassID == equipmentClassID
24 select entity;
25
26 if (sortExpression == "")
27 {
28 sortExpression = "EquipmentID";
29 }
30
31 var parameter = Expression.Parameter(typeof(Equipment), "equipment");
32
33 if (sortExpression.IndexOf(" DESC") < 0)
34 {
35 return result.OrderBy(
36 Expression.Lambda<Func<Equipment, object>>(
37 Expression.Property(parameter, sortExpression),
38 parameter));
39 }
40 else
41 {
42 sortExpression = sortExpression.Replace(" DESC", "");
43 return result.OrderByDescending(
44 Expression.Lambda<Func<Equipment, object>>(
45 Expression.Property(parameter, sortExpression),
46 parameter));
47 }
48}
49
50public IQueryable<Equipment> GetEquipmentsByEquipmentClassID
51 (string sortExpression, int maximumRows,
52 int startRowIndex, string equipmentClassID)
53{
54 if ((maximumRows > 0) && (startRowIndex > 0))
55 {
56 return GetEquipmentsByEquipmentClassID(sortExpression,
57 equipmentClassID).Skip(startRowIndex).Take(maximumRows);
58 }
59 else if (startRowIndex > 0)
60 {
61 return GetEquipmentsByEquipmentClassID(sortExpression,
62 equipmentClassID).Skip(startRowIndex);
63 }
64 else if (maximumRows > 0)
65 {
66 return GetEquipmentsByEquipmentClassID(sortExpression,
67 equipmentClassID).Take(maximumRows);
68 }
69 else
70 {
71 return GetEquipmentsByEquipmentClassID(sortExpression,
72 equipmentClassID);
73 }
74}
75
76public int CountEquipmentsByEquipmentClassID(string equipmentClassID)
77{
78 MdfEntities mdfEntities = new MdfEntities();
79 var result = from entity in mdfEntities.Equipments
80 where entity.EquipmentClassID == equipmentClassID
81 select entity;
82
83 return result.Count();
84}