private void cbCourses_SelectedIndexChanged(object sender, EventArgs e)
{
lbStudents.Items.Clear();
string id = cbCourses.SelectedItem.ToString();
Tafe_DataTier dt = new Tafe_DataTier();
var course = dt.viewCourses().Find(c => c.CourseID == id);
this.txtName.Text = course.CourseName;
decimal costValue = course.Cost.Value;
this.txtCost.Text = costValue.ToString("C");
//dt.getStudentsEnrolledInCourse(id);
if (dt.getStudentsEnrolledInCourse(id).Count == 0)
{
lbStudents.Items.Add("--------- NO ENROLLMENTS ----------");
}
else
{
var students = dt.getStudentsEnrolledInCourse(id);
foreach (var s in students)
{
this.lbStudents.Items.Add(s.StudentID + "-->" + s.StduentName);
}
}
}
private void cbCourses_SelectedIndexChanged(object sender, EventArgs e)
{
lbStudents.Items.Clear();
string id = cbCourses.SelectedItem.ToString();
this.txtName.Text = (table.FindByCourseID(id)).CourseName;
this.txtCost.Text = (table.FindByCourseID(id)).Cost.ToString("C");
Tafe_DataTier dt = new Tafe_DataTier();
System.Data.SqlClient.SqlDataReader dr = dt.getStudentsEnrolledInCourse(id);
if (!dr.HasRows)
{
lbStudents.Items.Add("--------- NO ENROLLMENTS ----------");
}
else
{
while (dr.Read())
{
this.lbStudents.Items.Add(dr.GetString(0) + "-->" + dr.GetString(1));
}
}
}
private void cbCourses_SelectedIndexChanged(object sender, EventArgs e)
{
lbStudents.Items.Clear();
string id = cbCourses.SelectedItem.ToString();
this.txtName.Text = (courseList.Where(c => c.CourseID == id).FirstOrDefault()).CourseName;
this.txtCost.Text = (courseList.Where(c => c.CourseID == id).FirstOrDefault()).Cost.ToString("C");
Tafe_DataTier dt = new Tafe_DataTier();
var studList = dt.getStudentsEnrolledInCourse(id);
if (studList.Count() <= 0)
{
lbStudents.Items.Add("--------- NO ENROLLMENTS ----------");
}
else
{
foreach (var s in studList)
{
this.lbStudents.Items.Add(s.StudentID + "-->" + s.StduentName);
}
}
}