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; }