public ActionResult Create([Bind(Include = "id,id_student,id_subject,examen1,examen2,examen3,examen4")] Studentsubject studentsubject) { if (ModelState.IsValid) { Studentsubject ss2 = db.Studentsubjects.ToList().Find(value => value.id_student == studentsubject.id_student && value.id_subject == studentsubject.id_subject); if (ss2 == null) { if (studentsubject.examen1 >= 0 && studentsubject.examen1 <= 10 && studentsubject.examen2 >= 0 && studentsubject.examen2 <= 10 && studentsubject.examen3 >= 0 && studentsubject.examen3 <= 10 && studentsubject.examen4 >= 0 && studentsubject.examen4 <= 10) { db.Studentsubjects.Add(studentsubject); db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.error = "Error, Score must be between 0 and 10"; } } else { ViewBag.error = "Error, Student already have the score!"; } } ViewBag.id_student = new SelectList(db.Students, "id", "name", studentsubject.id_student); ViewBag.id_subject = new SelectList(db.Subjects, "id", "name_subject", studentsubject.id_subject); return(View(studentsubject)); }
public IHttpActionResult PutStudentsubject(int id, Studentsubject studentsubject) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != studentsubject.id) { return(BadRequest()); } db.Entry(studentsubject).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!StudentsubjectExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(int id) { Studentsubject studentsubject = db.Studentsubjects.Find(id); db.Studentsubjects.Remove(studentsubject); db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult GetStudentsubject(int id) { Studentsubject studentsubject = db.Studentsubjects.Find(id); if (studentsubject == null) { return(NotFound()); } return(Ok(studentsubject)); }
public IHttpActionResult PostStudentsubject(Studentsubject studentsubject) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Studentsubjects.Add(studentsubject); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = studentsubject.id }, studentsubject)); }
public IHttpActionResult DeleteStudentsubject(int id) { Studentsubject studentsubject = db.Studentsubjects.Find(id); if (studentsubject == null) { return(NotFound()); } db.Studentsubjects.Remove(studentsubject); db.SaveChanges(); return(Ok(studentsubject)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Studentsubject studentsubject = db.Studentsubjects.Find(id); if (studentsubject == null) { return(HttpNotFound()); } return(View(studentsubject)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Studentsubject studentsubject = db.Studentsubjects.Find(id); if (studentsubject == null) { return(HttpNotFound()); } ViewBag.id_student = new SelectList(db.Students, "id", "name", studentsubject.id_student); ViewBag.id_subject = new SelectList(db.Subjects, "id", "name_subject", studentsubject.id_subject); return(View(studentsubject)); }
public ActionResult Edit([Bind(Include = "id,id_student,id_subject,examen1,examen2,examen3,examen4")] Studentsubject studentsubject) { if (ModelState.IsValid) { if (studentsubject.examen1 >= 0 && studentsubject.examen1 <= 10 && studentsubject.examen2 >= 0 && studentsubject.examen2 <= 10 && studentsubject.examen3 >= 0 && studentsubject.examen3 <= 10 && studentsubject.examen4 >= 0 && studentsubject.examen4 <= 10) { db.Entry(studentsubject).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewBag.error = "Error, Score must be between 0 and 10"; } } ViewBag.id_student = new SelectList(db.Students, "id", "name", studentsubject.id_student); ViewBag.id_subject = new SelectList(db.Subjects, "id", "name_subject", studentsubject.id_subject); return(View(studentsubject)); }