private void AddGradeCourseToListView(ListView view, GradeClassCourse GradeCourse) { view.Clear(); view.FullRowSelect = true; view.GridLines = true; view.Columns.Add("MSSV", 100); view.Columns.Add("Ho ten", 100); view.Columns.Add("Diem GK", 70); view.Columns.Add("Diem CK", 70); view.Columns.Add("Diem khac", 70); view.Columns.Add("Diem tong", 70); view.Columns.Add("Tinh trang", 70); foreach (var grade in GradeCourse.listGrade) { ListViewItem item = new ListViewItem(); item.Text = grade.StudentID; item.SubItems.Add(findName(grade.StudentID)); item.SubItems.Add(grade.GradeGK.ToString()); item.SubItems.Add(grade.GradeCK.ToString()); item.SubItems.Add(grade.GradeE.ToString()); item.SubItems.Add(grade.TotalGrade.ToString()); if (grade.TotalGrade >= 5.0) { item.SubItems.Add("Dau"); } else { item.SubItems.Add("Rot"); } view.Items.Add(item); } }
private void comboBoxGrade_SelectedIndexChanged(object sender, EventArgs e) { choose = GetGrades(comboBoxGrade.SelectedItem.ToString()); foreach (var student in choose.listGrade) { comboBoxStudent.Items.Add(student.StudentID + "-" + FindName(student.StudentID)); } }
public bool updateGradeStudentInClassCourse(GradeClassCourse seleted, Grade newGrade) { if (List_Of_GradeClassCourses != null) { foreach (var classCourse in List_Of_GradeClassCourses) { if (classCourse.classCourse.course.CourseID == seleted.classCourse.course.CourseID && classCourse.classCourse.course.classID.ClassID == seleted.classCourse.course.classID.ClassID) { foreach (var student in classCourse.listGrade) { if (student.StudentID == newGrade.StudentID) { student.GradeCK = newGrade.GradeCK; student.GradeGK = newGrade.GradeGK; student.GradeE = newGrade.GradeE; student.TotalGrade = newGrade.TotalGrade; try { OleDbConnection connect = new OleDbConnection(); connect.ConnectionString = conn; connect.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = connect; cmd.CommandText = "Update GradeCourses SET GradeGK = ?, GradeCK = ?, GradeE = ?, Total = ? WHERE CourseID = ? AND StudentID = ?"; OleDbParameter para = cmd.Parameters.Add("", OleDbType.Double); para.Value = student.GradeGK; para = cmd.Parameters.Add("", OleDbType.Double); para.Value = student.GradeCK; para = cmd.Parameters.Add("", OleDbType.Double); para.Value = student.GradeE; para = cmd.Parameters.Add("", OleDbType.Double); para.Value = student.TotalGrade; para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = classCourse.classCourse.course.CourseID; para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = student.StudentID; cmd.ExecuteNonQuery(); return(true); } catch { } } } } } return(false); } return(false); }
public void LoadGradeClassCourse(string pathFile) { if (List_Of_GradeClassCourses == null) { List_Of_GradeClassCourses = new List <GradeClassCourse>(); } try { StreamReader reader = new StreamReader(pathFile); string ClassID_Course = reader.ReadLine(); string classID_course = ClassID_Course.Replace('-', ','); string[] splitCI = classID_course.Split(','); GradeClassCourse newGradeClassCourse = new GradeClassCourse(); newGradeClassCourse.classCourse = null; foreach (var classCourse in List_Of_ClassCourses) { if (classCourse.course.CourseID == splitCI[1] && classCourse.course.classID.ClassID == splitCI[0]) { newGradeClassCourse.classCourse = classCourse; } } newGradeClassCourse.listGrade = new List <Grade>(); reader.ReadLine(); string line = ""; while ((line = reader.ReadLine()) != null) { string[] split = line.Split(','); Grade newGrade = new Grade(); newGrade.StudentID = split[1]; newGrade.GradeGK = double.Parse(split[3]); newGrade.GradeCK = double.Parse(split[4]); newGrade.GradeE = double.Parse(split[5]); newGrade.TotalGrade = double.Parse(split[6]); newGradeClassCourse.listGrade.Add(newGrade); } reader.Close(); List_Of_GradeClassCourses.Add(newGradeClassCourse); InitialGradeCourses(newGradeClassCourse.classCourse.course.CourseID); return; } catch { return; } }
private void comboBoxGrade_SelectedIndexChanged(object sender, EventArgs e) { Service service = new Service(); GradeClassCourse grade = service.GetGradeClassCourse(comboBoxGrade.SelectedItem.ToString()); AddGradeCourseToListView(listView1, grade); textBoxGrade.Visible = true; textBoxGrade.Clear(); textBoxGrade.AppendText("So luong: " + grade.listGrade.Count().ToString() + "\r\n"); textBoxGrade.AppendText("Dau: " + PassOrFail(grade).ToString() + "/" + (PassOrFail(grade) * 1.0 / grade.listGrade.Count() * 100).ToString() + "%" + "\r\n"); textBoxGrade.AppendText("Rot: " + (grade.listGrade.Count() - PassOrFail(grade)).ToString() + "/" + (100 - (PassOrFail(grade) * 1.0 / grade.listGrade.Count() * 100)).ToString() + "%" + "\r\n"); }
public bool updateGradeStudentInClassCourse(GradeClassCourse selected, Grade newGrade) { DataSetRepo dataSet = new DataSetRepo(); if (dataSet.updateGradeStudentInClassCourse(selected, newGrade)) { return(true); } else { return(false); } }
private int PassOrFail(GradeClassCourse grade) { int Pass = 0; foreach (var Grade in grade.listGrade) { if (Grade.TotalGrade >= 5) { Pass++; } } return(Pass); }
public GradeClassCourse GetGradeClassCourse(string ClassCourse) { GradeClassCourse result = new GradeClassCourse(); DataSetRepo dataSet = new DataSetRepo(); string[] split = ClassCourse.Split('-'); if (dataSet.GetList_Of_GradeClassCourses() != null) { foreach (var grade in dataSet.GetList_Of_GradeClassCourses()) { if (grade.classCourse.course.classID.ClassID == split[0] && grade.classCourse.course.CourseID == split[1]) { return(grade); } } } return(null); }
private void buttonSave_Click(object sender, EventArgs e) { newGrade = new Grade(); double temp = 0; if (!double.TryParse(textBoxCK.Text.ToString(), out temp) || !double.TryParse(textBoxGK.Text.ToString(), out temp) || !double.TryParse(textBoxKhac.Text.ToString(), out temp) || !double.TryParse(textBoxTong.Text.ToString(), out temp)) { newGrade = null; choose = null; Close(); } string[] studentID = comboBoxStudent.SelectedItem.ToString().Split('-'); newGrade.GradeCK = double.Parse(textBoxCK.Text.ToString()); newGrade.GradeGK = double.Parse(textBoxGK.Text.ToString()); newGrade.GradeE = double.Parse(textBoxKhac.Text.ToString()); newGrade.TotalGrade = double.Parse(textBoxTong.Text.ToString()); newGrade.StudentID = studentID[0]; Close(); }
private void buttonCancel_Click(object sender, EventArgs e) { choose = null; newGrade = null; Close(); }
public bool LoadData() { try { List_Of_Classes = new List <Classes>(); List_Of_Students = new List <Students>(); List_Of_Courses = new List <Courses>(); List_Of_ClassCourses = new List <ClassCourse>(); List_Of_GradeClassCourses = new List <GradeClassCourse>(); List_Of_Account = new List <AccountLogIn>(); OleDbConnection connect = new OleDbConnection(); connect.ConnectionString = conn; connect.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = connect; cmd.CommandText = "SELECT * FROM Classes"; OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var Class = new Classes(); Class.ClassID = reader.GetString(0); List_Of_Classes.Add(Class); } reader.Close(); cmd.CommandText = "SELECT * FROM Students"; reader = cmd.ExecuteReader(); while (reader.Read()) { var student = new Students(); student.StudentID = reader.GetString(0); student.FullName = reader.GetString(1); student.Gender = reader.GetString(2); student.ID = reader.GetString(3); student.classID = new Classes(); student.classID.ClassID = reader.GetString(4); List_Of_Students.Add(student); } reader.Close(); cmd.CommandText = "SELECT * FROM Courses"; reader = cmd.ExecuteReader(); while (reader.Read()) { var course = new Courses(); course.CourseID = reader.GetString(0); course.CourseName = reader.GetString(1); course.Room = reader.GetString(2); course.classID = new Classes(); course.classID.ClassID = reader.GetString(3); List_Of_Courses.Add(course); } reader.Close(); cmd.CommandText = "SELECT distinct CourseID FROM ClassCourses"; reader = cmd.ExecuteReader(); while (reader.Read()) { var classCourse = new ClassCourse(); string temp = reader.GetString(0); foreach (var course in List_Of_Courses) { if (course.CourseID == temp) { classCourse.course = course; classCourse.students = new List <Students>(); OleDbCommand cmd2 = new OleDbCommand(); cmd2.Connection = connect; cmd2.CommandText = $"SELECT StudentID FROM ClassCourses WHERE CourseID = '{course.CourseID}' "; OleDbDataReader rd = cmd2.ExecuteReader(); while (rd.Read()) { string StudentID = rd.GetString(0); foreach (var stu in List_Of_Students) { if (stu.StudentID == StudentID) { classCourse.students.Add(stu); } } } rd.Close(); List_Of_ClassCourses.Add(classCourse); } } } reader.Close(); cmd.CommandText = "SELECT distinct CourseID FROM GradeCourses"; reader = cmd.ExecuteReader(); while (reader.Read()) { var gradeClassCourse = new GradeClassCourse(); gradeClassCourse.classCourse = new ClassCourse(); string temp = reader.GetString(0); foreach (var course in List_Of_Courses) { if (course.CourseID == temp) { gradeClassCourse.classCourse.course = course; gradeClassCourse.listGrade = new List <Grade>(); OleDbCommand cmd2 = new OleDbCommand(); cmd2.Connection = connect; cmd2.CommandText = $"SELECT * FROM GradeCourses WHERE CourseID = '{course.CourseID}' "; OleDbDataReader rd = cmd2.ExecuteReader(); while (rd.Read()) { Grade newGrade = new Grade(); newGrade.StudentID = rd.GetString(1); newGrade.GradeGK = rd.GetDouble(2); newGrade.GradeCK = rd.GetDouble(3); newGrade.GradeE = rd.GetDouble(4); newGrade.TotalGrade = rd.GetDouble(5); gradeClassCourse.listGrade.Add(newGrade); } rd.Close(); List_Of_GradeClassCourses.Add(gradeClassCourse); } } } reader.Close(); cmd.CommandText = "SELECT * FROM Account"; reader = cmd.ExecuteReader(); while (reader.Read()) { var account = new AccountLogIn(); account.ID = reader.GetString(0); account.Password = reader.GetString(1); List_Of_Account.Add(account); } reader.Close(); connect.Close(); return(true); } catch { return(false); } }