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