private void notebookBTN_back_Click(object sender, EventArgs e) { firstTime = true; Student_Information st = new Student_Information(); st.Show(); Hide(); }
private void InsertStudentBTN_Click(object sender, EventArgs e) { Regex IdReg = new Regex("[0-9]{9}"); if (!IdReg.IsMatch(StudentID_textbox.Text)) { MessageBox.Show("!יש להזין ת.ז כולל ספרת ביקורת", "הודעה"); } else { string Query = "SELECT * FROM examination_log WHERE student_id = @UserID_textbox AND " + "exam_id = @exam_id"; MySqlConnection conn = new MySqlConnection("server=localhost;user id=root;database=easytest"); conn.Open(); MySqlCommand cmd = new MySqlCommand(Query, conn); cmd.Parameters.AddWithValue("@UserID_textbox", StudentID_textbox.Text); cmd.Parameters.AddWithValue("@exam_id", Login.exam_table.Rows[0][0].ToString()); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { MessageBox.Show("הסטודנט כבר קיים במבחן", "הודעה"); conn.Close(); } else { string Q = "SELECT * FROM student_courses WHERE student_id = @UserID_textbox AND " + "course_id = @course_id"; MySqlCommand cmd3 = new MySqlCommand(Q, conn); cmd3.Parameters.AddWithValue("@UserID_textbox", StudentID_textbox.Text); cmd3.Parameters.AddWithValue("@course_id", Login.exam_table.Rows[0][3].ToString()); MySqlDataAdapter dap = new MySqlDataAdapter(cmd3); DataTable dta = new DataTable(); dap.Fill(dta); if (dta.Rows.Count > 0) { string Query1 = "SELECT * FROM student WHERE student_id = @UserID_textbox AND " + "allowed = 1"; MySqlCommand cmd1 = new MySqlCommand(Query1, conn); cmd1.Parameters.AddWithValue("@UserID_textbox", StudentID_textbox.Text); MySqlDataAdapter da1 = new MySqlDataAdapter(cmd1); da1.Fill(student_table); // MySqlDataReader rdr = cmd.ExecuteReader(); // rdr.Read(); if (student_table.Rows.Count > 0) { StudentID = StudentID_textbox.Text; conn.Close(); Student_Information si = new Student_Information(); si.Show(); Hide(); } else { MessageBox.Show(" הסטודנט אינו רשאי להבחן", "הודעה"); } } else { MessageBox.Show("הסטודנט אינו רשום לקורס זה", "הודעה"); } } ClickTextBox = false; StudentID_textbox.Text = "הכנס ת.ז"; } }