- 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 = "";