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