public Names Adds2(int id, string name )
{
var qwe = new Names();
qwe.ID = id;
qwe.Name = name;
qwe.List =null;
return qwe;
}
public Names Adds(int id,string name,List<Names> list)
{
var qwe = new Names();
qwe.ID = id;
qwe.Name = name;
qwe.List = list;
return qwe;
}
public ActionResult NavigationStudentPoisk()
{
var qw = ugtu_db.TREE_Stud_Search;
var NavList = (from Gr in ugtu_db.Grup
join RSF in ugtu_db.Relation_spec_fac on Gr.ik_spec_fac equals RSF.ik_spec_fac
join S in ugtu_db.Spec_stud on RSF.ik_spec equals S.ik_spec
join F in ugtu_db.Fac on RSF.ik_fac equals F.Ik_fac
join StGr in ugtu_db.StudGrup on Gr.Ik_grup equals StGr.Ik_grup
join Za in ugtu_db.Zach on StGr.Ik_zach equals Za.Ik_zach
join stud in ugtu_db.Student on Za.nCode equals stud.nCode
join Res in ugtu_db.Resume on stud.nCode equals Res.idStud
where StGr.ik_pricOtch == null && Res.idStatus == 1
select new
{
idGrup = Gr.Ik_grup,
NameGrup = Gr.Cname_grup,
idSpec = S.ik_spec,
NameSpec = S.Cname_spec,
idFac = F.Ik_fac,
NameFac = F.Cname_fac
}).Distinct().ToList();
List<Names> listFac = new List<Names>();
foreach (var q in NavList.Select(search => new { idFac = search.idFac, nameFac = search.NameFac }).Distinct())
{
List<Names> listSpec = new List<Names>();
foreach (var a in NavList.Select(search => new { nameSpec = search.NameSpec, idSpec = search.idSpec, idFac = search.idFac }).Where(arg => arg.idFac == q.idFac).Distinct())
{
List<Names> listGrup = new List<Names>();
foreach (var s in NavList.Select(search => new { GrupName = search.NameGrup, idGrup = search.idGrup, idSpec = search.idSpec }).Where(arg => arg.idSpec == a.idSpec).Distinct())
{
Names qwe1 = new Names();//
listGrup.Add(qwe1.Adds2(s.idGrup, s.GrupName));
}
Names qwe2 = new Names();
listSpec.Add(qwe2.Adds(a.idSpec, a.nameSpec, listGrup));
}
Names qwe = new Names();
listFac.Add(qwe.Adds(q.idFac, q.nameFac, listSpec));
}
return PartialView("PartialNavPoiskStudent2", listFac);
}
public ActionResult NavigationVipusknik()
{
var qw = ugtu_db.TREE_Stud_Search;
var NavList = (from Gr in ugtu_db.Grup
join RSF in ugtu_db.Relation_spec_fac on Gr.ik_spec_fac equals RSF.ik_spec_fac
join S in ugtu_db.Spec_stud on RSF.ik_spec equals S.ik_spec
join F in ugtu_db.Fac on RSF.ik_fac equals F.Ik_fac
join StGr in ugtu_db.StudGrup on Gr.Ik_grup equals StGr.Ik_grup
where Gr.DateExit.Value.Year == DateTime.Today.Year && Gr.DateExit>DateTime.Today
select new
{
idGrup = Gr.Ik_grup,
NameGrup = Gr.Cname_grup,
idSpec = S.ik_spec,
NameSpec = S.Cname_spec,
idFac = F.Ik_fac,
NameFac = F.Cname_fac
}).Distinct().ToList();
List<Names> listFac = new List<Names>();
foreach (var q in NavList.Select(search => new { idFac = search.idFac, nameFac = search.NameFac }).Distinct())
{
List<Names> listSpec = new List<Names>();
foreach (var a in NavList.Select(search => new { nameSpec = search.NameSpec, idSpec = search.idSpec, idFac = search.idFac }).Where(arg => arg.idFac == q.idFac).Distinct())
{
List<Names> listGrup = new List<Names>();
foreach (var s in NavList.Select(search => new { GrupName = search.NameGrup, idGrup = search.idGrup, idSpec = search.idSpec }).Where(arg => arg.idSpec == a.idSpec).Distinct())
{
Names qwe1 = new Names();//
listGrup.Add(qwe1.Adds2(s.idGrup, s.GrupName));
}
Names qwe2 = new Names();
listSpec.Add(qwe2.Adds(a.idSpec, a.nameSpec, listGrup));
}
Names qwe = new Names();
listFac.Add(qwe.Adds(q.idFac, q.nameFac, listSpec));
}
return PartialView("PartialNavVipusknik", listFac);
}
public List<Names> Navigation(IEnumerable<NavigationDTO> NavList)
{
List<Names> listFac = new List<Names>();
using (var ugtu_db = new UGTU_DBDataContext())
{
foreach (var q in NavList.Select(search => new { idFac = search.idFac, nameFac = search.NameFac }).OrderBy(search => search.nameFac).Distinct())
{
List<Names> listSpec = new List<Names>();
foreach (var a in NavList.Select(search => new { nameSpec = search.NameSpec, idSpec = search.idSpec, idFac = search.idFac }).Where(arg => arg.idFac == q.idFac).OrderBy(search => search.nameSpec).Distinct())
{
List<Names> listGrup = new List<Names>();
foreach (var s in NavList.Select(search => new { GrupName = search.NameGrup, idGrup = search.idGrup, idSpec = search.idSpec }).Where(arg => arg.idSpec == a.idSpec).OrderBy(search => search.GrupName).Distinct())
{
if (ugtu_db.StudGrup.Where(grup => grup.Ik_grup == s.idGrup).Count() > 0)
{
Names qwe1 = new Names();//
listGrup.Add(qwe1.Adds2(s.idGrup, s.GrupName));
}
}
Names qwe2 = new Names();
listSpec.Add(qwe2.Adds(a.idSpec, a.nameSpec, listGrup));
}
Names qwe = new Names();
listFac.Add(qwe.Adds(q.idFac, q.nameFac, listSpec));
}
listFac.OrderBy(l => l.Name);
}
return listFac;
}
