public ActionResult CompleteSpecializari() { //var prog = from pr in db.Programe_de_studiu select pr; //var prog = db.Programe_de_studiu.Select(m=>m.Program_de_studiuId); var prog = getPrograme(); // iteram prin categorii foreach (var p in prog) { //var spec = db.Domenii.Where(m => m.Program_de_studiuId == p); // var spec = from sp in db.Domenii where sp.Program_de_studiuId == p.Program_de_studiuId select sp; var spec = getDomenii(p); foreach (var s in spec) { var List = from rams in db.Specializari where s.SpecializareId == rams.SpecializareId select rams.AnStudiu; for (int i = 1; i <= s.NrAniStudiu; i++) { if (!List.Contains(i)) { Specializare_pe_Domeniu ssp = new Specializare_pe_Domeniu(); ssp.AnStudiu = i; ssp.SpecializareId = s.SpecializareId; ssp.Subramura = s.Denumire; db.Specializari.Add(ssp); db.SaveChanges(); } } } } return(RedirectToAction("FormatiuniFinalizate")); }
public ActionResult Delete(int id, int id_rev) { Specializare_pe_Domeniu sp = db.Specializari.Find(id); db.Specializari.Remove(sp); db.SaveChanges(); return(RedirectToAction("New", "Specializare", new { id = id_rev })); }
public string GetSpec(Specializare_pe_Domeniu sp) { var category = db.Specializari.Find(sp.SubramuraSpecializareId); return(String.Concat(category.Domeniu.Program_de_studiu.Denumire, "- An ", category.AnStudiu, "-", category.Subramura)); }