public List <string> getCourse(string teacherId) { List <string> a = new List <string>(); using (var db = new EbysVol9Entities()) { var result = from k in db.GIVENCOURSES where k.GTeacherId == teacherId select new { k.GCourseId }; foreach (var item in result) { a.Add(item.GCourseId); } } return(a); //SqlConnection con = new SqlConnection("DESKTOP-RUVJ75R;initial catalog=EbysVol9;integrated security=True"); //SqlCommand cmd = new SqlCommand("select GCourseId from GIVENCOURSES where GteacherId=@teacherId",con); //cmd.Parameters.AddWithValue("@teacherId", teacherId); //con.Open(); //cmd.ExecuteNonQuery(); }
public List <string> getSemesterCourse() { List <string> a = new List <string>(); using (var db = new EbysVol9Entities()) { var result = from k in db.SEMESTERCOURSE select new { k.CourseId }; foreach (var item in result) { a.Add(item.CourseId); } } return(a); }
public List <string> getStudents(string courseId) { List <string> a = new List <string>(); using (var db = new EbysVol9Entities()) { var result = from k in db.TAKENCOURSES where k.TCourseId == courseId select new { k.TStudenId }; foreach (var item in result) { a.Add(item.TStudenId); } } return(a); }