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); }
}
