private void show_info() //shows the relevant infromation about user { name_label.Text = "Welcome, " + user.FIRSTNAME + " " + user.LASTNAME; dept_label.Text = "Department of " + user.SDEPT() + " Engeneering"; year_label.Text = "Year " + user.YEAR + ", Semester " + user.SEMESTER; avg_label.Text = "Average: " + user.calc_avg(); pts_label.Text = "Points: " + user.get_pts(false); }
private void F_Head_Department_Degree_Load(object sender, EventArgs e) { dt = db.FetchTable(db.TPERSON + ", " + db.TSTUDENT, "firstname, lastname, person.id, average", "dept = " + (int)user.DEPT + " and type = 0 and person.id = student.id").Tables[db.TPERSON + ", " + db.TSTUDENT]; dataGridView1.DataSource = dt; dataGridView1.Columns.Add("Points", "Points"); for (int i = 0; i < dataGridView1.Rows.Count; i++) { Student stud = db.getStudent("id = " + dataGridView1.Rows[i].Cells[3].Value); dataGridView1.Rows[i].Cells[5].Value = stud.get_pts(false); } }
private void textBox1_TextChanged(object sender, EventArgs e) { for (int i = 0; i < dataGridView1.Rows.Count; i++) { Student stud = db.getStudent("id = " + dataGridView1.Rows[i].Cells[3].Value); CurrencyManager currencyManager1 = (CurrencyManager)BindingContext[dataGridView1.DataSource]; currencyManager1.SuspendBinding(); if (!string.IsNullOrEmpty(this.textBox1.Text.ToString())) { if (stud.get_pts(false) < Convert.ToInt32(textBox1.Text)) { dataGridView1.Rows[i].Visible = false; } else { dataGridView1.Rows[i].Visible = true; } } currencyManager1.ResumeBinding(); } }
private void F_Student_Grades_Load(object sender, EventArgs e) { listView1.Items.Clear(); for (int i = 0; i < user.GRADES.Count; i++) { ListViewItem Lvi = new ListViewItem(user.GRADES[i].CNAME); Lvi.SubItems.Add(user.GRADES[i].YEAR.ToString()); Lvi.SubItems.Add(user.GRADES[i].SEMESTER.ToString()); Lvi.SubItems.Add(user.GRADES[i].GRADE.ToString()); Lvi.SubItems.Add(user.GRADES[i].POINTS.ToString()); listView1.Items.Add(Lvi); } label2.Text = user.FIRSTNAME + " " + user.LASTNAME + "\nAverage: " + user.AVERAGE + "\nPoints: " + user.get_pts(false).ToString(); }