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