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 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 frmCourses_Load(object sender, EventArgs e)
{
Tafe_DataTier dt = new Tafe_DataTier();
var courses = dt.viewCourses();
foreach (var c in courses)
{
lbCourses.Items.Add(c.CourseID.ToString() + "-->" + c.CourseName.ToString());;
}
}
private void frmCourses_Load(object sender, EventArgs e)
{
Tafe_DataTier dt = new Tafe_DataTier();
courses = dt.viewCourses();
foreach (Course s in courses)
{
lbCourses.Items.Add(s.CourseID + " --> " + s.CourseName);
}
}
private void frmViewEnrollments_Load(object sender, EventArgs e)
{
cbCourses.Text = "-Select Courset-";
Tafe_DataTier dt = new Tafe_DataTier();
var courses = dt.viewCourses();
foreach (var c in courses)
{
cbCourses.Items.Add(c.CourseID.ToString());;
}
}
private void frmCourses_Load(object sender, EventArgs e)
{
Tafe_DataTier dt = new Tafe_DataTier();
table = dt.viewCourses();
foreach (DataRow row in table)
{
lbCourses.Items.Add(row["CourseID"].ToString() + "-->" + row["CourseName"].ToString());;
}
}
private void frmViewEnrollments_Load(object sender, EventArgs e)
{
cbCourses.Text = "-Select Courset-";
Tafe_DataTier dt = new Tafe_DataTier();
table = dt.viewCourses();
foreach (DataRow row in table)
{
cbCourses.Items.Add(row["CourseID"].ToString());;
}
}
private void frmEnroll_Load(object sender, EventArgs e)
{
cbStudents.Text = "-Select Student-";
studList = dt.viewStudents();
foreach (Student s in studList)
{
cbStudents.Items.Add(s.StudentID.ToString());;
}
cbCourses.Text = "-Select Course-";
courseList = dt.viewCourses();
foreach (Course c in courseList)
{
cbCourses.Items.Add(c.CourseID.ToString());;
}
}
private void frmEnroll_Load(object sender, EventArgs e)
{
cbStudents.Text = "-Select Student-";
studTable = dt.viewStudents();
foreach (DataRow row in studTable)
{
cbStudents.Items.Add(row["StudentID"].ToString());;
}
cbCourses.Text = "-Select Course-";
courseTable = dt.viewCourses();
foreach (DataRow row in courseTable)
{
cbCourses.Items.Add(row["CourseID"].ToString());;
}
}