1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61
62. 62
63. 63
64. 64
65. 65
66. 66
67. 67
68. 68
69. 69
70. 70
71. 71
72. 72
73. 73
74. 74
75. 75
76. 76
77. 77
78. 78
79. 79
80. 80
81. 81
82. 82
83. 83
84. 84
85. 85
86. 86
87. 87
88. 88
89. 89
90. 90
91. 91
92. 92
93. 93
94. 94
95. 95
96. 96
97. 97
98. 98
99. 99
100. 100

public List<SpecialtyToCollege> SpecialtyToCollegeForKcp(int collegeID)
{
			List<SpecialtyToCollege> result = new List<SpecialtyToCollege>();
			var allKcp = _dataContext.fkcKcp.Where(el => el.CollegeId == collegeID && el.Deleted == null && el.Year == 18 && el.Count != 0 && el.OrgId != 1382).ToList();
			var lisitems = _dataContext.fkcListItems.ToList();
			foreach (fkcKcp t in allKcp)
			{
				var LevelIds = _dataContext.fkcSpecialties.SingleOrDefault(el => el.id == t.SpecId).LevelID;

				string FormTitle = "";
				if (t.FormId == 7)
				{
					FormTitle = _dataContext.fkcListItems.SingleOrDefault(el => el.id == 8).Title;
				}
				else if (t.FormId == 8)
				{
					FormTitle = _dataContext.fkcListItems.SingleOrDefault(el => el.id == 7).Title;
				}
				else
				{
					FormTitle = _dataContext.fkcListItems.SingleOrDefault(el => el.id == t.FormId).Title;
				}

				fkcSpecialty spec = _dataContext.fkcSpecialties.SingleOrDefault(el => el.id == t.SpecId);
				fkcOrganisation org = _dataContext.fkcOrganisation.SingleOrDefault(el => el.id == t.OrgId);

				if (spec != null && org != null)
				{
					string LevelTitle = lisitems.SingleOrDefault(el => el.id == LevelIds).Title;
					int? Region = _dataContext.fkcOrganisation.SingleOrDefault(el => el.id == t.OrgId).SubRegionID;
					string OrgRegion = lisitems.SingleOrDefault(el => el.id == Region).Title;

					result.Add(new SpecialtyToCollege(
						t,
						LevelIds,
						LevelTitle,
						spec.Code,
						spec.Title,
						org.Title,
						org.lCity,
						OrgRegion,
						FormTitle
						)
					);
				}
			}
			return result;
		}

		public List<SpecialtyAndFormKcp> SpecialtyFormKcp()
		{
			List<SpecialtyAndFormKcp> result = new List<SpecialtyAndFormKcp>();
			var allKcp = _dataContext.fkcKcp.Where(el => el.Deleted == null && el.Year == 18 && el.Count != 0 && el.OrgId != 1382).ToList();
			var lisitems = _dataContext.fkcListItems.ToList();
			foreach (fkcKcp t in allKcp)
			{
				var LevelIds = _dataContext.fkcSpecialties.SingleOrDefault(el => el.id == t.SpecId).LevelID;
				string LevelTitle = "";
				string Code = "";
				string SpecTitle = "";
				string FormTitle = "";
				int FormId;
				int SpecId;
				if (t.FormId == 7)
				{
					FormTitle = _dataContext.fkcListItems.SingleOrDefault(el => el.id == 8).Title;
				}
				else if (t.FormId == 8)
				{
					FormTitle = _dataContext.fkcListItems.SingleOrDefault(el => el.id == 7).Title;
				}
				else
				{
					FormTitle = _dataContext.fkcListItems.SingleOrDefault(el => el.id == t.FormId).Title;
				}
				FormId = t.FormId;
				LevelTitle = lisitems.SingleOrDefault(el => el.id == LevelIds).Title;
				Code = _dataContext.fkcSpecialties.SingleOrDefault(el => el.id == t.SpecId).Code;
				SpecId = _dataContext.fkcSpecialties.SingleOrDefault(el => el.id == t.SpecId).id;
				SpecTitle = _dataContext.fkcSpecialties.SingleOrDefault(el => el.id == t.SpecId).Title;
				if (result.SingleOrDefault(el => el.SpecId == SpecId && el.FormTitle == FormTitle) == null)
				{
					result.Add(new SpecialtyAndFormKcp(SpecId, FormId, LevelTitle, Code, SpecTitle, FormTitle));
				}
			}

			return result;
		}

		public List<KcpSpecOrgCollege> KcpSpecOrgCollege(int specID, int formID)
		{
			List<KcpSpecOrgCollege> result = new List<KcpSpecOrgCollege>();
			var allKcp = _dataContext.fkcKcp
				.Where(el => el.SpecId == specID && el.FormId == formID && el.Deleted == null && el.Year == 18 && el.Count != 0 && el.OrgId != 1382).ToList();
			var lisitems = _dataContext.fkcListItems.ToList();
			foreach (fkcKcp t in allKcp)
			{
				var SpecID = _dataContext.fkcSpecialties.SingleOrDefault(el => el.id == t.SpecId).id;
				var CollegeRegionID = _dataContext.fkcCollege.SingleOrDefault(el => el.id == t.CollegeId).RegionID;
				string CollegeTitle = "";