public ActionResult DeleteConfirmed(int id) { TeacherCoursesRecord teacherCoursesRecord = db.TeacherCoursesRecord.Find(id); db.TeacherCoursesRecord.Remove(teacherCoursesRecord); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(TeacherclassAssigning teacherclassAssigning) { TeacherCoursesRecord instance = new TeacherCoursesRecord(); if (ModelState.IsValid) { var classname = (from alias in db.classes where alias.Id == teacherclassAssigning.ClassId select alias.ClassName).FirstOrDefault(); var programname = (from alias in db.programs where alias.Id == teacherclassAssigning.ProgramId select alias.ProgramName).FirstOrDefault(); var subjectname = (from alias in db.subject where alias.Id == teacherclassAssigning.SubjectId select alias.SubjectName).FirstOrDefault(); teacherclassAssigning.Name = (from alias in db.Teachers where alias.Id == teacherclassAssigning.Teacherid select alias.TeacherName).FirstOrDefault(); teacherclassAssigning.AssignedDate = DateTime.Now; teacherclassAssigning.ClassName = classname; teacherclassAssigning.SubjectName = subjectname; teacherclassAssigning.ProgramName = programname; db.TeacherclassAssigning.Add(teacherclassAssigning); db.SaveChanges(); //here assigned histroy record is creating db.Entry(teacherclassAssigning).GetDatabaseValues(); int asignid = teacherclassAssigning.id; instance.Teacherid = teacherclassAssigning.Teacherid; instance.Name = teacherclassAssigning.Name; instance.AssignedDate = teacherclassAssigning.AssignedDate; instance.Assignedprocessid = asignid; instance.ClassId = teacherclassAssigning.ClassId; instance.ProgramId = teacherclassAssigning.ProgramId; instance.SubjectId = teacherclassAssigning.SubjectId; instance.ProgramName = programname; instance.ClassName = classname; instance.SubjectName = subjectname; db.TeacherCoursesRecord.Add(instance); db.SaveChanges(); TempData["message"] = "Sucessfully Class Subject is Assigned to" + instance.Name; //end record saved return(RedirectToAction("Index")); } ViewBag.ProgramId = new SelectList(db.programs, "Id", "ProgramName", teacherclassAssigning.ProgramId); ViewBag.TeacherId = db.Teachers.Select(c => new SelectListItem { Value = c.Id.ToString(), Text = c.Id.ToString() }) .ToList(); return(View(teacherclassAssigning)); }
// GET: TeacherCoursesRecords/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TeacherCoursesRecord teacherCoursesRecord = db.TeacherCoursesRecord.Find(id); if (teacherCoursesRecord == null) { return(HttpNotFound()); } return(View(teacherCoursesRecord)); }
public ActionResult Details(int?id) { TeacherCoursesRecord detail = db.TeacherCoursesRecord.Find(id); return(View(detail)); }