public ActionResult viewtest(tblEnrollStudentInCourseValidation testing) { try { int studentid = Convert.ToInt32(Session["Student"]); int tempclassid; int originalclassid; string Regno; var getstudentid = db.Students.Find(studentid); tempclassid = getstudentid.Class_Id; Regno = getstudentid.RegNo; var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault(); originalclassid = classid.Class_Id; CourseDBHandle gc = new CourseDBHandle(); List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid); ViewBag.course = new SelectList(list, "courseId", "courseName"); return(RedirectToAction("viewuploadedtest", new { courseid = testing.courseId })); } catch (Exception ex) { ViewBag.Message = "Please try later"; return(View()); } }
public ActionResult viewdiscussion(tblEnrollStudentInCourseValidation testing) { try { int studentid = Convert.ToInt32(Session["Student"]); int tempclassid; int originalclassid; string Regno; var getstudentid = dbContext.Students.Find(studentid); tempclassid = getstudentid.Class_Id; Regno = getstudentid.RegNo; var classid = dbContext.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault(); originalclassid = classid.Class_Id; //AB enroll course wala dropdown ajayega CourseDBHandle gc = new CourseDBHandle(); List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid); ViewBag.course = new SelectList(list, "courseId", "courseName"); //TempData["course"] = testing.courseId; //var data = db.SchoolAssignments.ToList(); return(RedirectToAction("Index", new { courseid = testing.courseId })); } catch (Exception ex) { ViewBag.Message = "Please try later"; return(View()); } }
public List <tblEnrollStudentInCourseValidation> GetSudentEnrollCourse(string RegNo, int Class_Id) { List <tblEnrollStudentInCourseValidation> CourseInformation = new List <tblEnrollStudentInCourseValidation>(); SqlCommand sc = new SqlCommand("[Digital_School].get_StudentEnrollCourse", Connections.GetConnection()); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.AddWithValue("@RegNo", RegNo); sc.Parameters.AddWithValue("@Class_Id", Class_Id); SqlDataReader sdr = sc.ExecuteReader(); while (sdr.Read()) { tblEnrollStudentInCourseValidation gc = new tblEnrollStudentInCourseValidation(); //gc.CourseId = Convert.ToInt32(sdr["courseId"]); gc.courseId = Convert.ToInt32(sdr["courseId"]); gc.courseName = sdr["courseName"].ToString(); CourseInformation.Add(gc); } sdr.Close(); return(CourseInformation); }
public ActionResult notesviewer(tblEnrollStudentInCourseValidation testing) { int studentid = Convert.ToInt32(Session["Student"]); int tempclassid; int originalclassid; string Regno; var getstudentid = db.Students.Find(studentid); tempclassid = getstudentid.Class_Id; Regno = getstudentid.RegNo; var classid = db.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault(); originalclassid = classid.Class_Id; CourseDBHandle gc = new CourseDBHandle(); List <tblEnrollStudentInCourseValidation> list = gc.GetSudentEnrollCourse(Regno, originalclassid); ViewBag.course = new SelectList(list, "courseId", "courseName"); return(RedirectToAction("notesview", new { courseid = testing.courseId })); }