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();
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 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 cbCourses_SelectedIndexChanged(object sender, EventArgs e)
{
lbStudents.Items.Clear();
string id = cbCourses.SelectedItem.ToString();
foreach (Course c in courses)
{
if (c.CourseID.Trim() == id.Trim())
{
this.txtName.Text = c.CourseName;
this.txtCost.Text = c.Cost.ToString("C");
}
}
Tafe_DataTier dt = new Tafe_DataTier();
List <Student> students = dt.getStudentEnrolledInCourse(id);
if (students.Count == 0)
{
lbStudents.Items.Add("--------- NO ENROLLMENTS ----------");
}
else
{
foreach (Student s in students)
{
this.lbStudents.Items.Add(s.StudentName + " --> " + s.StudentID);
}
}
}
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)
{
Tafe_DataTier dt = new Tafe_DataTier();
lbCourses.Items.Clear();
string id = cbStudents.SelectedItem.ToString();
foreach (Student s in students)
{
if (s.StudentID == id)
{
txtName.Text = s.StudentName;
txtDateEnrolled.Text = s.DateEnrolled.ToString("d");
}
}
List <Course> enrolmentsForStudent = dt.getEnrolmentsForStudent(id);
if (enrolmentsForStudent.Count == 0)
{
lbCourses.Items.Add("--------- NO ENROLLMENTS ----------");
}
else
{
foreach (Course c in enrolmentsForStudent)
{
lbCourses.Items.Add(c.CourseName);
}
}
}
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 frmStudents_Load(object sender, EventArgs e)
{
Tafe_DataTier dt = new Tafe_DataTier();
studList = dt.viewStudents();
foreach (Student s in studList)
{
lbStudents.Items.Add(s.StudentID.ToString() + "-->" + s.StduentName.ToString());;
}
}
private void frmStudents_Load(object sender, EventArgs e)
{
Tafe_DataTier dt = new Tafe_DataTier();
students = dt.viewStudents();
foreach (Student s in students)
{
lbStudents.Items.Add(s.StudentID + " --> " + s.StudentName);
}
}
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 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 frmStudents_Load(object sender, EventArgs e)
{
Tafe_DataTier dt = new Tafe_DataTier();
table = dt.viewStudents();
foreach (DataRow row in table)
{
lbStudents.Items.Add(row["StudentID"].ToString() + "-->" + row["StduentName"].ToString());;
}
}
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 frmStudentTT_Load(object sender, EventArgs e)
{
cbStudents.Text = "-Select Student-";
Tafe_DataTier dt = new Tafe_DataTier();
students = dt.viewStudents();
foreach (Student s in students)
{
cbStudents.Items.Add(s.StudentID);
}
}
private void frmStudentTT_Load(object sender, EventArgs e)
{
cbStudents.Text = "-Select Student-";
Tafe_DataTier dt = new Tafe_DataTier();
table = dt.viewStudents();
foreach (DataRow row in table)
{
cbStudents.Items.Add(row["StudentID"].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 btnEnroll_Click(object sender, EventArgs e)
{
dt = new Tafe_DataTier();
int rowsInserted = dt.enroll(cbCourses.SelectedItem.ToString(), cbStudents.SelectedItem.ToString());
if (rowsInserted > 0)
{
MessageBox.Show("New Enrollment Information Saved", "Enrollment", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("New Enrollment Information NOT Saved", "Enrollment", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
Tafe_DataTier dt = new Tafe_DataTier();
int rowsInserted = dt.insertStudent(txtID.Text, txtName.Text, dtpEnrollment.Value);
if (rowsInserted > 0)
{
MessageBox.Show("New Student Information Saved", "Add Student", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("New Student Information NOT Saved", "Add Student", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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 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 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);
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
Tafe_DataTier dt = new Tafe_DataTier();
if (this.validateData())
{
try
{
int rowsInserted = dt.insertCourse(txtID.Text, txtName.Text, Decimal.Parse(txtCost.Text));
if (rowsInserted > 0)
{
MessageBox.Show("New Course Information Saved", "Add Course", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("New Course Information NOT Saved", "Add Course", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR");
}
}
}
private void cbStudents_SelectedIndexChanged(object sender, EventArgs e)
{
dt = new Tafe_DataTier();
List <Course> courses;
lbCourses.Items.Clear();
string id = cbStudents.SelectedItem.ToString();
List <Student> students = dt.viewStudents();
foreach (Student s in students)
{
if (s.StudentID.Trim() == id.Trim())
{
this.txtName.Text = s.StudentName;
}
}
courses = dt.getEnrolmentsForStudent(id);
Decimal total = 0.0M;
if (courses.Count == 0)
{
lbCourses.Items.Add("--------- NO ENROLLMENTS ----------");
}
else
{
foreach (Course c in courses)
{
lbCourses.Items.Add(c.CourseName);
total += c.Cost;
}
}
txtCost.Text = total.ToString("C");
}
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));
}
}
}
public frmEnroll()
{
InitializeComponent();
dt = new Tafe_DataTier();
}
public frmBilling()
{
dt = new Tafe_DataTier();
InitializeComponent();
}
