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