// GET: Student/AddToKolegij/1 public ActionResult AddToKolegij(int id) { IEnumerable <Student> studentiNaTrazenomKolegiju = db.Student .Join( db.KolegijStudents, s => s.Id, ks => ks.StudentId, (s, ks) => new { student = s, kolegijId = ks.KolegijId } ) .Where(studentKolegijId => studentKolegijId.kolegijId == id) .Select(studentKolegijId => studentKolegijId.student); IEnumerable <SelectListItem> studentiNisuNaKolegiju = db.Student .Where(s => !studentiNaTrazenomKolegiju.Select(ss => ss.Id).Contains(s.Id)) .ToList() .Select(s => new SelectListItem { Text = s.Ime + " " + s.Prezime + " (" + s.JMBAG + ")", Value = s.Id.ToString() }); KolegijStudent kolegijStudent = new KolegijStudent { KolegijId = id }; StudentViewModel studentViewModel = new StudentViewModel { students = studentiNisuNaKolegiju, kolegijStudent = kolegijStudent, studentiNaKolegiju = studentiNaTrazenomKolegiju.ToList() }; return(View(studentViewModel)); }
public ActionResult RemoveFromKolegij(int kolegijId, int studentId) { KolegijStudent kolegijStudent = db.KolegijStudents.Where(ks => ks.KolegijId == kolegijId && ks.StudentId == studentId).First(); db.KolegijStudents.Remove(kolegijStudent); db.SaveChanges(); return(RedirectToAction("AddToKolegij", new { id = kolegijId })); }
public ActionResult AddToKolegij([Bind(Include = "Id,StudentId,KolegijId")] KolegijStudent kolegijStudent) { if (ModelState.IsValid) { KolegijStudent newkolegijStudent = db.KolegijStudents.Add(kolegijStudent); db.SaveChanges(); } return(RedirectToAction("AddToKolegij", new { id = kolegijStudent.KolegijId })); }
public ActionResult Create([Bind(Include = "Id,StudentId,KolegijId")] KolegijStudent kolegijStudent) { if (ModelState.IsValid) { KolegijStudent newkolegijStudent = db.KolegijStudents.Add(kolegijStudent); db.SaveChanges(); return(RedirectToAction("Index")); } { return(View()); } }