// GET: Grades public ActionResult Index() { ScoalaDB db = new ScoalaDB(); var viewModel = (from g in db.Grades join s in db.Students on g.id_student equals s.id_student join c in db.Courses on g.id_cours equals c.id_cours select new { id_grade = g.id_grade, studentName = s.name + " " + s.surname, coursName = c.name, grade = g.grade, date_of_registration = g.date_of_registration }).ToList() .Select(x => new GradeCourseStudent { id_grade = x.id_grade, studentName = x.studentName, coursName = x.coursName, grade = x.grade, date_of_registration = x.date_of_registration }); return(View(viewModel)); }
// GET: Grades/Create public ActionResult Create() { ScoalaDB db = new ScoalaDB(); ViewBag.students = db.Students.ToList(); ViewBag.courses = db.Courses.ToList(); return(View()); }
public ActionResult DeleteConfirmed(int id) { ScoalaDB db = new ScoalaDB(); Grade gradeDelete = db.Grades.Find(id); db.Grades.Remove(gradeDelete); db.SaveChanges(); return(RedirectToAction("Index")); }
protected override void Dispose(bool disposing) { if (disposing) { ScoalaDB db = new ScoalaDB(); db.Dispose(); } base.Dispose(disposing); }
public ActionResult DeleteConfirmed(int id) { ScoalaDB db = new ScoalaDB(); Student student = db.Students.Find(id); db.Students.Remove(student); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { ScoalaDB db = new ScoalaDB(); Course cours = db.Courses.Find(id); db.Courses.Remove(cours); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id_grade,id_student,id_cours,grade,date_of_registration")] Grade gradeEdit) { if (ModelState.IsValid) { ScoalaDB db = new ScoalaDB(); db.Entry(gradeEdit).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(gradeEdit)); }
public ActionResult Edit([Bind(Include = "id_student,name,surname,sex,date_of_registration")] Student student) { if (ModelState.IsValid) { ScoalaDB db = new ScoalaDB(); db.Entry(student).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public ActionResult Edit([Bind(Include = "id_cours,name,date_of_registration")] Course cours) { if (ModelState.IsValid) { ScoalaDB db = new ScoalaDB(); db.Entry(cours).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cours)); }
public ActionResult Create([Bind(Include = "id_cours,name,date_of_registration")] Course cours) { if (ModelState.IsValid) { ScoalaDB db = new ScoalaDB(); cours.date_of_registration = DateTime.Now; db.Courses.Add(cours); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cours)); }
public ActionResult Create([Bind(Include = "id_student,name,surname,sex,date_of_registration")] Student student) { if (ModelState.IsValid) { ScoalaDB db = new ScoalaDB(); student.date_of_registration = DateTime.Now; db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public ActionResult Create([Bind(Include = "id_grade,id_student,id_cours,grade,date_of_registration")] Grade gradeCreate) { if (ModelState.IsValid) { ScoalaDB db = new ScoalaDB(); gradeCreate.date_of_registration = DateTime.Now; db.Grades.Add(gradeCreate); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(gradeCreate)); }
// GET: Courses/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ScoalaDB db = new ScoalaDB(); Course cours = db.Courses.Find(id); if (cours == null) { return(HttpNotFound()); } return(View(cours)); }
// GET: Students/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ScoalaDB db = new ScoalaDB(); Student student = db.Students.Find(id); if (student == null) { return(HttpNotFound()); } return(View(student)); }
// GET: Grades/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ScoalaDB db = new ScoalaDB(); Grade gradeDelete = db.Grades.Find(id); if (gradeDelete == null) { return(HttpNotFound()); } return(View(gradeDelete)); }
// GET: Grades/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ScoalaDB db = new ScoalaDB(); Grade gradeEdit = db.Grades.Find(id); if (gradeEdit == null) { return(HttpNotFound()); } ViewBag.students = db.Students.ToList(); ViewBag.courses = db.Courses.ToList(); return(View(gradeEdit)); }
// GET: Grades/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ScoalaDB db = new ScoalaDB(); var viewModel = (from g in db.Grades join s in db.Students on g.id_student equals s.id_student join c in db.Courses on g.id_cours equals c.id_cours where g.id_grade == id select new { id_grade = g.id_grade, studentName = s.name + " " + s.surname, coursName = c.name, grade = g.grade, date_of_registration = g.date_of_registration }).ToList() .Select(x => new GradeCourseStudent { id_grade = x.id_grade, studentName = x.studentName, coursName = x.coursName, grade = x.grade, date_of_registration = x.date_of_registration }).FirstOrDefault(); if (viewModel == null) { return(HttpNotFound()); } return(View(viewModel)); }
// GET: Students public ActionResult Index() { ScoalaDB db = new ScoalaDB(); return(View(db.Students.ToList())); }