private void cbStudents_SelectedIndexChanged(object sender, EventArgs e) { lbCourses.Items.Clear(); string id = cbStudents.SelectedItem.ToString(); Tafe_DataTier dt = new Tafe_DataTier(); var student = dt.viewStudents().Find(s => s.StudentID == id); txtName.Text = student.StduentName; DateTime date = student.DateEnrolled.Value; txtDateEnrolled.Text = date.ToString("d"); if (dt.getEnrollmentsForStudent(id).Count == 0) { lbCourses.Items.Add("--------- NO ENROLLMENTS ----------"); } else { var enrolls = dt.getEnrollmentsForStudent(id); foreach (var enroll in enrolls) { lbCourses.Items.Add(enroll.CourseID); } } }
private void cbStudents_SelectedIndexChanged(object sender, EventArgs e) { lbCourses.Items.Clear(); string id = cbStudents.SelectedItem.ToString(); dt = new Tafe_DataTier(); var student = dt.viewStudents().Find(s => s.StudentID == id); this.txtName.Text = student.StduentName; Decimal total = 0.0M; if (dt.getEnrollmentsForStudent(id).Count == 0) { lbCourses.Items.Add("--------- NO ENROLLMENTS ----------"); } else { var enrolls = dt.getEnrollmentsForStudent(id); foreach (var enroll in enrolls) { lbCourses.Items.Add(enroll.CourseID); var cost = dt.viewCourses().Find(c => c.CourseID == enroll.CourseID).Cost; total = total + Convert.ToDecimal(cost); } } txtCost.Text = total.ToString("C"); }
private void cbStudents_SelectedIndexChanged(object sender, EventArgs e) { lbCourses.Items.Clear(); string id = cbStudents.SelectedItem.ToString(); this.txtName.Text = (studList.Where(s => s.StudentID == id)).FirstOrDefault().StduentName; dt = new Tafe_DataTier(); List <Course> courseList = dt.getEnrollmentsForStudent(id); Decimal total = 0.0M; if (courseList.Count() <= 0) { lbCourses.Items.Add("--------- NO ENROLLMENTS ----------"); } else { foreach (var c in courseList) { lbCourses.Items.Add(c.CourseName); total = total + c.Cost; } } txtCost.Text = total.ToString("C"); }
private void cbStudents_SelectedIndexChanged(object sender, EventArgs e) { lbCourses.Items.Clear(); string id = cbStudents.SelectedItem.ToString(); this.txtName.Text = (studTable.FindByStudentID(id)).StduentName; dt = new Tafe_DataTier(); System.Data.SqlClient.SqlDataReader dr = dt.getEnrollmentsForStudent(id); Decimal total = 0.0M; if (!dr.HasRows) { lbCourses.Items.Add("--------- NO ENROLLMENTS ----------"); } else { while (dr.Read()) { lbCourses.Items.Add(dr.GetString(0)); total = total + dr.GetDecimal(1); } } txtCost.Text = total.ToString("C"); }
private void cbStudents_SelectedIndexChanged(object sender, EventArgs e) { lbCourses.Items.Clear(); string id = cbStudents.SelectedItem.ToString(); txtName.Text = (studList.Where(s => s.StudentID == id).FirstOrDefault()).StduentName; txtDateEnrolled.Text = (studList.Where(s => s.StudentID == id).FirstOrDefault()).DateEnrolled.ToString("d"); Tafe_DataTier dt = new Tafe_DataTier(); var enrollmentList = dt.getEnrollmentsForStudent(id); if (enrollmentList.Count() <= 0) { lbCourses.Items.Add("--------- NO ENROLLMENTS ----------"); } else { foreach (var enroll in enrollmentList) { lbCourses.Items.Add(enroll.CourseID); } } }
private void cbStudents_SelectedIndexChanged(object sender, EventArgs e) { lbCourses.Items.Clear(); string id = cbStudents.SelectedItem.ToString(); txtName.Text = (table.FindByStudentID(id)).StduentName; txtDateEnrolled.Text = (table.FindByStudentID(id)).DateEnrolled.ToString("d"); Tafe_DataTier dt = new Tafe_DataTier(); System.Data.SqlClient.SqlDataReader dr = dt.getEnrollmentsForStudent(id); if (!dr.HasRows) { lbCourses.Items.Add("--------- NO ENROLLMENTS ----------"); } else { while (dr.Read()) { lbCourses.Items.Add(dr.GetString(0)); } } }