public ActionResult viewdiscussion(tbl_CourseAssigntoTeacherValidation testing)
{
try
{
int teacherid = Convert.ToInt32(Session["Teacher"]);
int tempclassid;
int originalclassid;
var getteacherid = dbContext.Teachers.Find(teacherid);
tempclassid = getteacherid.Class_Id;
var classid = dbContext.Tbl_Class.Where(x => x.Class_Id == tempclassid).SingleOrDefault();
originalclassid = classid.Class_Id;
CourseDBHandle gc = new CourseDBHandle();
List <tbl_CourseAssigntoTeacherValidation> list = gc.GetTeacherAssignedCourse(teacherid, originalclassid);
ViewBag.course = new SelectList(list, "courseId", "courseName");
return(RedirectToAction("Index", new { courseid = testing.courseId }));
}
catch (Exception ex)
{
ViewBag.Message = "Please try later";
return(View());
}
}
public List <tbl_CourseAssigntoTeacherValidation> GetTeacherStudentSimilarCourse(int Id, string RegNo)
{
List <tbl_CourseAssigntoTeacherValidation> CourseInformation = new List <tbl_CourseAssigntoTeacherValidation>();
SqlCommand sc = new SqlCommand("[Digital_School].get_TeacherStudentSimilarCourse", Connections.GetConnection());
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.AddWithValue("@Id", Id);
sc.Parameters.AddWithValue("@RegNo", RegNo);
SqlDataReader sdr = sc.ExecuteReader();
while (sdr.Read())
{
tbl_CourseAssigntoTeacherValidation gc = new tbl_CourseAssigntoTeacherValidation();
gc.courseId = Convert.ToInt32(sdr["courseId"]);
gc.courseName = sdr["courseName"].ToString();
CourseInformation.Add(gc);
}
sdr.Close();
return(CourseInformation);
}
