public ActionResult StudentsByCourses(int?id) { Course_tbl course = db.Course_tbl.Find(id); var students = db.Student_tbl.Where(c => c.Level == course.Level); return(View(students.ToList())); }
public ActionResult DeleteConfirmed(string id) { Course_tbl course_tbl = db.Course_tbl.Find(id); db.Course_tbl.Remove(course_tbl); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID,Name,Lecturer,PDFs_Links,Level")] Course_tbl course_tbl) { if (ModelState.IsValid) { db.Entry(course_tbl).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Lecturer = new SelectList(db.Lecturer_tbl, "Code_ID", "Name", course_tbl.Lecturer); return(View(course_tbl)); }
public ActionResult Edit(Course_tbl course_tbl) { if (ModelState.IsValid) { db.Entry(course_tbl).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Prof = new SelectList(db.Lecturer_tbl.Where(m => m.Role == "Prof"), "ID", "Name"); ViewBag.Assistant = new SelectList(db.Lecturer_tbl.Where(m => m.Role == "Assistant"), "ID", "Name"); return(View(course_tbl)); }
public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Course_tbl course_tbl = db.Course_tbl.Find(id); if (course_tbl == null) { return(HttpNotFound()); } return(View(course_tbl)); }
public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Course_tbl course_tbl = db.Course_tbl.Find(id); course_tbl.PDFs = db.File_tbl.Where(m => m.CourseID == course_tbl.ID).Count().ToString(); if (course_tbl == null) { return(HttpNotFound()); } return(PartialView(course_tbl)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Course_tbl course_tbl = db.Course_tbl.Find(id); if (course_tbl == null) { return(HttpNotFound()); } ViewBag.Lecturer = new SelectList(db.Lecturer_tbl, "Code_ID", "Name", course_tbl.Lecturer); return(View(course_tbl)); }
public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Course_tbl course_tbl = db.Course_tbl.Find(id); if (course_tbl == null) { return(HttpNotFound()); } //Allow lecturers of this course and admins to access if (User.Identity.Name != db.Lecturer_tbl.Find(course_tbl.Prof).Email&& User.Identity.Name != db.Lecturer_tbl.Find(course_tbl.Assistant).Email&& !User.IsInRole("Admin")) { return(new HttpStatusCodeResult(HttpStatusCode.Unauthorized)); } ViewBag.Prof = new SelectList(db.Lecturer_tbl.Where(m => m.Role == "Prof"), "ID", "Name"); ViewBag.Assistant = new SelectList(db.Lecturer_tbl.Where(m => m.Role == "Assistant"), "ID", "Name"); //course_ID = id; return(View(course_tbl)); }
protected void btn_submit_Click(object sender, EventArgs e) { string IP = GetVisitorIpAddress(); Course_tbl tblCourse = new Course_tbl(); Tuple<Course_tbl, UniversityEntities> tuple = new Tuple<Course_tbl, UniversityEntities>(null, null); if (btn_submit.Text == "Submit") { try { tblCourse.CenterID = 1; tblCourse.CourseType = ddltype.SelectedValue; tblCourse.Degree = txtbx_coursename.Text; //tblCourse.CourseSubjects = txtbx_subjects.Text; tblCourse.CourseDuration = txtbx_duration.Text; tblCourse.CourseDesc = txtbx_desc.Text; tblCourse.IsBitDeleted = false; tblCourse.CreatedBy = "Admin"; tblCourse.CreatedDate = Convert.ToDateTime(System.DateTime.Now); tblCourse.CreatedIP = IP; int courseid = ManageCourseBAL.SaveCourse(tblCourse); lblmsg.Text = "Course added sucessfully!!!"; lblmsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#ff6230"); } catch { //Exception } finally { BindGrid(grid_course.PageSize, grid_course.PageIndex); Clear(); } } else if (btn_submit.Text == "Update") { try { tblCourse.CourseID = Convert.ToInt32(lblid.Text); tblCourse.CourseType = ddltype.SelectedValue; tblCourse.Degree = txtbx_coursename.Text; //tblCourse.CourseSubjects = txtbx_subjects.Text; tblCourse.CourseDuration = txtbx_duration.Text; tblCourse.CourseDesc = txtbx_desc.Text; tblCourse.ModifiedBy = "Admin"; tblCourse.ModifiedDate = Convert.ToDateTime(System.DateTime.Now); tblCourse.ModifiedIP = IP; int subid = ManageCourseBAL.UpdateCourse(tblCourse); lblmsg.Text = "Record Updated Sucessfully"; lblmsg.ForeColor = System.Drawing.ColorTranslator.FromHtml("#ff6230"); Clear(); } catch { //Exception } finally { BindGrid(grid_course.PageSize, grid_course.PageIndex); Clear(); } } }