public Student getStudent(String Conditions) { List <String> itemList = new List <String>(); Student _stud = new Student(); itemList = FetchList(TPerson, "*", Conditions); _stud.USERNAME = itemList[0]; _stud.PASSWORD = itemList[1]; _stud.ID = itemList[2]; _stud.FIRSTNAME = itemList[3]; _stud.LASTNAME = itemList[4]; _stud.MAIL = itemList[5]; _stud.PHONE = itemList[6]; _stud.GENDER = (Gender)(Convert.ToInt32(itemList[7])); _stud.DEPT = (Department)(Convert.ToInt32(itemList[8])); //-------------------------------------------------------------------------------------------// itemList = FetchList(TStudent, "*", "id = " + _stud.ID); //-------------------------------------------------------------------------------------------// _stud.AVERAGE = Convert.ToSingle(itemList[1]); _stud.STATE = Convert.ToBoolean(itemList[2]); _stud.decrypt_books(itemList[3]); _stud.decrypt_courses(itemList[4]); _stud.decrypt_grades(itemList[5]); _stud.YEAR = (Year)(Convert.ToInt32(itemList[6])); _stud.SEMESTER = (Semester)(Convert.ToInt32(itemList[7])); return(_stud); }
private void button1_Click(object sender, EventArgs e) { String courses = ""; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value) == true) { courses += dataGridView1.Rows[i].Cells[1].Value.ToString() + "#"; } } if (lect != null) { if (lect.COURSES.Count == 0) { db.SimpleUpdate(db.TEMPLOYEE, "Courses = '" + courses + "'", "id = " + lect.ID); } else { db.SimpleUpdate(db.TEMPLOYEE, "Courses = Courses + '" + courses + "'", "id = " + lect.ID); } lect.decrypt_courses(courses); MessageBox.Show("The courses that selected are added"); F_Add_Courses_Load(new object(), new EventArgs()); } if (stud != null) { if (stud.COURSES.Count == 0) { db.SimpleUpdate(db.TSTUDENT, "Courses = '" + courses + "'", "id = " + stud.ID); } else { db.SimpleUpdate(db.TSTUDENT, "Courses = Courses + '" + courses + "'", "id = " + stud.ID); } stud.decrypt_courses(courses); for (int i = 0; i < stud.COURSES.Count; i++) { foreach (Course value in stud.GRADES) { if (value.CNUM == stud.COURSES[i].CNUM) { stud.GRADES.Remove(value); break; } } } String gradecode = ""; for (int i = 0; i < stud.GRADES.Count; i++) { gradecode += stud.GRADES[i].CNUM + '$' + stud.GRADES[i].GRADE + '#'; } db.SimpleUpdate(db.TSTUDENT, "grades = '" + gradecode + "'", "id = " + stud.ID); MessageBox.Show("The courses that were selected are added"); F_Add_Courses_Load(new object(), new EventArgs()); } }
private void cbLecturers_SelectedIndexChanged(object sender, EventArgs e) { label3.Hide(); CourseBox.Items.Clear(); Student stud = new Student(); List <String> courses = db.FetchList(db.TEMPLOYEE, "courses", "id = " + dt.Rows[LectBox.SelectedIndex].ItemArray[2].ToString()); stud.decrypt_courses(courses[0]); for (int i = 0; i < stud.COURSES.Count; i++) { CourseBox.Items.AddRange(new object[] { stud.COURSES[i].CNAME }); } }
private void F_Add_Courses_Load(object sender, EventArgs e) { dataGridView1.Width = this.Width; dataGridView1.Height = this.Height - 100; if (lect != null) { String fields = "Course_Number, Course_Name, Accademic_Year, Semester, Points"; dt = db.FetchTable(db.TCOURSE, fields, "Department = 0 OR Department = " + (int)lect.DEPT).Tables[db.TCOURSE]; dataGridView1.DataSource = dt; dataGridView1.Columns[0].ReadOnly = false; dataGridView1.Columns[1].ReadOnly = true; dataGridView1.Columns[2].ReadOnly = true; dataGridView1.Columns[3].ReadOnly = true; dataGridView1.Columns[4].ReadOnly = true; dataGridView1.Columns[5].ReadOnly = true; dataGridView1.Columns[1].Visible = false; DataTable ctable = db.FetchTable(db.TEMPLOYEE, "courses", "type = 3").Tables[db.TEMPLOYEE]; String long_code = ""; for (int i = 0; i < ctable.Rows.Count; i++) { long_code += ctable.Rows[i].ItemArray[0].ToString(); } String[] carray = long_code.Split('#'); for (int i = 0; i < dataGridView1.Rows.Count; i++) { CurrencyManager currencyManager1 = (CurrencyManager)BindingContext[dataGridView1.DataSource]; currencyManager1.SuspendBinding(); foreach (String value in carray) { if (dataGridView1.Rows[i].Cells[1].Value.ToString() == value) { dataGridView1.Rows.Remove(dataGridView1.Rows[i]); i--; break; } } currencyManager1.ResumeBinding(); } } if (stud != null) { String fields = "Course_Number, Course_Name, Accademic_Year, Semester, Points, Pre"; dt = db.FetchTable(db.TCOURSE, fields, "Department = 0 OR Department = " + (int)stud.DEPT).Tables[db.TCOURSE]; dataGridView1.DataSource = dt; dataGridView1.Columns[0].ReadOnly = false; dataGridView1.Columns[1].ReadOnly = true; dataGridView1.Columns[2].ReadOnly = true; dataGridView1.Columns[3].ReadOnly = true; dataGridView1.Columns[4].ReadOnly = true; dataGridView1.Columns[5].ReadOnly = true; dataGridView1.Columns[1].Visible = false; dataGridView1.Columns[6].Visible = false; for (int i = 0; i < dataGridView1.Rows.Count; i++) { Student pre = new Student(); Boolean flag2 = false; CurrencyManager currencyManager1 = (CurrencyManager)BindingContext[dataGridView1.DataSource]; currencyManager1.SuspendBinding(); pre.decrypt_courses(dataGridView1.Rows[i].Cells[6].Value.ToString()); if (((int)stud.YEAR < Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value)) || ((int)stud.SEMESTER < Convert.ToInt32(dataGridView1.Rows[i].Cells[4].Value))) { dataGridView1.Rows.Remove(dataGridView1.Rows[i]); i--; } else { foreach (Course value in stud.COURSES) { if (dataGridView1.Rows[i].Cells[1].Value.ToString() == value.CNUM) { dataGridView1.Rows.Remove(dataGridView1.Rows[i]); i--; flag2 = true; break; } } if (flag2 != true) { foreach (Course value in stud.GRADES) { if ((dataGridView1.Rows[i].Cells[1].Value.ToString() == value.CNUM) && (value.GRADE > 55)) { dataGridView1.Rows.Remove(dataGridView1.Rows[i]); i--; flag2 = true; break; } } } if (flag2 != true) { foreach (Course pvalue in pre.COURSES) { Boolean flag = false; foreach (Course value in stud.GRADES) { if ((value.CNUM == pvalue.CNUM) && (value.GRADE >= 56)) { flag = true; break; } } if (flag == false) { dataGridView1.Rows.Remove(dataGridView1.Rows[i]); i--; break; } } } } currencyManager1.ResumeBinding(); } } }