- 001
 - 002
 - 003
 - 004
 - 005
 - 006
 - 007
 - 008
 - 009
 - 010
 - 011
 - 012
 - 013
 - 014
 - 015
 - 016
 - 017
 - 018
 - 019
 - 020
 - 021
 - 022
 - 023
 - 024
 - 025
 - 026
 - 027
 - 028
 - 029
 - 030
 - 031
 - 032
 - 033
 - 034
 - 035
 - 036
 - 037
 - 038
 - 039
 - 040
 - 041
 - 042
 - 043
 - 044
 - 045
 - 046
 - 047
 - 048
 - 049
 - 050
 - 051
 - 052
 - 053
 - 054
 - 055
 - 056
 - 057
 - 058
 - 059
 - 060
 - 061
 - 062
 - 063
 - 064
 - 065
 - 066
 - 067
 - 068
 - 069
 - 070
 - 071
 - 072
 - 073
 - 074
 - 075
 - 076
 - 077
 - 078
 - 079
 - 080
 - 081
 - 082
 - 083
 - 084
 - 085
 - 086
 - 087
 - 088
 - 089
 - 090
 - 091
 - 092
 - 093
 - 094
 - 095
 - 096
 - 097
 - 098
 - 099
 - 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 = "";