private void toilet_CheckedChanged(object sender, EventArgs e) { if (toilet.Checked == true) { if (!Main_Screen.log_table.Rows[0][12].ToString().Equals("00:00:00")) { int startHour = Main_Screen.GetHoures(Main_Screen.log_table.Rows[0][12].ToString(), Main_Screen.getTime()); int startMinutes = Main_Screen.GetMinutes(Main_Screen.log_table.Rows[0][12].ToString(), Main_Screen.getTime()); int endtHour = Main_Screen.GetHoures(Main_Screen.getTime(), Main_Screen.ChangeEndTime()); int endMinutes = Main_Screen.GetMinutes(Main_Screen.getTime(), Main_Screen.ChangeEndTime()); if (startHour != 0 && startMinutes != 0 || endtHour != 0 && endMinutes != 0) { if (startHour >= 1 || startMinutes >= 30) { if (endtHour >= 1 || endMinutes >= 30) { string query2 = "SELECT * FROM report WHERE exam_id = @exam_id AND type = 'toilet' AND end = ''"; MySqlConnection conn2 = new MySqlConnection("server=localhost;user id=root;database=easytest"); conn2.Open(); MySqlCommand cmd2 = new MySqlCommand(query2, conn2); cmd2.Parameters.AddWithValue("@exam_id", Login.exam_table.Rows[0].ItemArray[0].ToString()); cmd2.Parameters.AddWithValue("@student_id", IDAnsLABEL.Text); //cmd.Parameters.AddWithValue("@start_time", ExitTimeLBL.Text); MySqlDataAdapter da2 = new MySqlDataAdapter(cmd2); DataTable dt2 = new DataTable(); da2.Fill(dt2); if (dt2.Rows.Count > 0) { if (dt2.Rows[0][2].ToString().Equals(IDAnsLABEL.Text)) { ContentNote.Visible = false; comboBox.Visible = false; TimerBTN.Enabled = true; ReturnBTN2.Visible = true; ExitTimeLBL2.Visible = true; button1.Visible = false; ExitTimeLBL.Text = dt2.Rows[0].ItemArray[4].ToString().Substring(0, 5); ExitTimeLBL.Visible = true; TimerBTN.Text = "סיים טיימר"; TimerClick = true; ClickCount++; //Main_Screen.StudentInToilet = true; /*string query = "SELECT report_id, start FROM report WHERE exam_id = @exam_id AND student_id = @student_id AND type = 'toilet' AND end = ''"; * * MySqlConnection conn = new MySqlConnection("server=localhost;user id=root;database=easytest"); * conn.Open(); * * MySqlCommand cmd = new MySqlCommand(query, conn); * * cmd.Parameters.AddWithValue("@exam_id", Login.exam_table.Rows[0].ItemArray[0].ToString()); * cmd.Parameters.AddWithValue("@student_id", IDAnsLABEL.Text); * //cmd.Parameters.AddWithValue("@start_time", ExitTimeLBL.Text); * * MySqlDataAdapter da = new MySqlDataAdapter(cmd); * * da.Fill(report_dt); * * if (report_dt.Rows.Count > 0) * {*/ //} //conn.Close(); } else { MessageBox.Show("קיים סטודנט בשירותים", "הודעה"); } conn2.Close(); } else { ContentNote.Visible = false; comboBox.Visible = false; TimerBTN.Enabled = true; ReturnBTN2.Visible = true; ExitTimeLBL2.Visible = true; button1.Visible = false; } } else { MessageBox.Show("!היציאה לשירותים אסורה", "הודעה", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("!היציאה לשירותים אסורה", "הודעה", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("!היציאה לשירותים אסורה", "הודעה", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("!היציאה לשירותים אסורה", "הודעה", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void button10_Click(object sender, EventArgs e) { if (!lastBTN.Equals("")) { string query = ""; if (Main_Screen.EmptyClass && !Main_Screen.TestBegin) { Main_Screen.EmptyClass = false; Main_Screen.BeginBTN = true; Main_Screen.first = false; ///////////////////////////////////////////////////// } if (Main_Screen.TestBegin) { query = "INSERT INTO `examination_log` (`exam_id`, `student_id`," + " `lecturer_id`, `proctor_id`, `report_id`, `course_id`, `class_num`," + " `notebook_num`, `table_num`, `start_time`, `end_time`," + " `extra_time`, `class_start_time`) VALUES (@exam_id, @student_id, @lecturer_id, @proctor_id, ''," + " @course_id, @class_num, @notebook_num, @table_num, @startTime, '', '',@class_start_time)"; } else { query = "INSERT INTO `examination_log` (`exam_id`, `student_id`," + " `lecturer_id`, `proctor_id`, `report_id`, `course_id`, `class_num`," + " `notebook_num`, `table_num`, `start_time`, `end_time`," + " `extra_time`, `class_start_time`) VALUES (@exam_id, @student_id, @lecturer_id, @proctor_id, ''," + " @course_id, @class_num, @notebook_num, @table_num, '', '', '','')"; } MySqlConnection conn = new MySqlConnection("server=localhost;user id=root;database=easytest"); conn.Open(); MySqlCommand cmd = new MySqlCommand(query, conn); cmd.Parameters.AddWithValue("@exam_id", Login.exam_table.Rows[0].ItemArray[0].ToString()); cmd.Parameters.AddWithValue("@student_id", Add_Student.StudentID); cmd.Parameters.AddWithValue("@lecturer_id", Login.exam_table.Rows[0].ItemArray[2].ToString()); cmd.Parameters.AddWithValue("@proctor_id", Login.exam_table.Rows[0].ItemArray[1].ToString()); cmd.Parameters.AddWithValue("@course_id", Login.exam_table.Rows[0].ItemArray[3].ToString()); cmd.Parameters.AddWithValue("@class_num", Login.exam_table.Rows[0].ItemArray[4].ToString()); cmd.Parameters.AddWithValue("@notebook_num", NoteBook_Num.notebookNum); cmd.Parameters.AddWithValue("@table_num", lastBTN); cmd.Parameters.AddWithValue("@startTime", Main_Screen.getTime()); cmd.Parameters.AddWithValue("@class_start_time", Main_Screen.class_start_time); cmd.ExecuteNonQuery(); conn.Close(); ////////////////////////////////////////////////////////////// ///בודק כל הזמן המעדכן אם הכיתה התחילה בחינה - עבור הציאה לשירותים string Query1 = "SELECT * FROM examination_log WHERE exam_id = @exam_id"; MySqlConnection conn1 = new MySqlConnection("server=localhost;user id=root;database=easytest"); conn1.Open(); MySqlCommand cmd1 = new MySqlCommand(Query1, conn1); cmd1.Parameters.AddWithValue("@exam_id", Login.exam_table.Rows[0].ItemArray[0].ToString()); MySqlDataAdapter da1 = new MySqlDataAdapter(cmd1); da1.Fill(Main_Screen.log_table); conn1.Close(); // sending the result to main screen // for (int i = 0; i < Int32.Parse(Main_Screen.map_row); i++) { for (int j = 0; j < Int32.Parse(Main_Screen.map_collumn); j++) { if (cards[j, i].BackColor == Color.Green) { Main_Screen.mainMap[j, i].BackColor = Color.Green; Main_Screen.mainMap[j, i].Enabled = true; } } } Add_Student.student_table.Clear(); Login.main_screen.Show(); Hide(); } else { MessageBox.Show("נא לבחור מס' שולחן", "הודעה", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void button1_Click(object sender, EventArgs e) { if (!Main_Screen.log_table.Rows[0][12].ToString().Equals("00:00:00")) { int startHour = Main_Screen.GetHoures(Main_Screen.log_table.Rows[0][12].ToString(), Main_Screen.getTime()); int startMinutes = Main_Screen.GetMinutes(Main_Screen.log_table.Rows[0][12].ToString(), Main_Screen.getTime()); if (startHour >= 1 || startMinutes >= 30) { string query = "UPDATE `examination_log` SET `end_time` = @endTime WHERE exam_id = @exam_id AND student_id = @student_id"; MySqlConnection conn = new MySqlConnection("server=localhost;user id=root;database=easytest"); conn.Open(); MySqlCommand cmd = new MySqlCommand(query, conn); cmd.Parameters.AddWithValue("@endTime", Main_Screen.getTime()); cmd.Parameters.AddWithValue("@exam_id", Login.exam_table.Rows[0].ItemArray[0].ToString()); cmd.Parameters.AddWithValue("@student_id", idLBL.Text); int flg = cmd.ExecuteNonQuery(); //MySqlDataReader dr = cmd.ExecuteReader(); conn.Close(); if (flg > 0) { Main_Screen.tableForIcone = tableBTN.Text; Main_Screen.typeForIcone = "finish"; Main_Screen.newFinished = true; MessageBox.Show("סטודנט הגיש בחינה"); string query4 = "SELECT course_name FROM course WHERE course_id = @courseId"; MySqlConnection conn4 = new MySqlConnection("server=localhost;user id=root;database=easytest"); conn4.Open(); MySqlCommand cmd4 = new MySqlCommand(query4, conn4); cmd4.Parameters.AddWithValue("@courseId", Login.exam_table.Rows[0][3].ToString()); MySqlDataAdapter da4 = new MySqlDataAdapter(cmd4); DataTable dt4 = new DataTable(); da4.Fill(dt4); try { SmtpClient clientDetails = new SmtpClient(); clientDetails.Port = 587; clientDetails.Host = "smtp.gmail.com"; clientDetails.EnableSsl = true; clientDetails.DeliveryMethod = SmtpDeliveryMethod.Network; clientDetails.UseDefaultCredentials = false; clientDetails.Credentials = new NetworkCredential("*****@*****.**", "Project1234"); MailMessage mailDetails = new MailMessage(); mailDetails.From = new MailAddress("*****@*****.**"); mailDetails.To.Add(student_table.Rows[0][3].ToString()); mailDetails.Subject = nameLBL.Text + " להלן פרטי הבחינה בקורס " + dt4.Rows[0][0].ToString(); mailDetails.IsBodyHtml = false; mailDetails.Body = " הודעה אטומטית ממערכת EasyTest:" + " מספר מחברת - " + examination_log_table.Rows[0][7].ToString(); clientDetails.Send(mailDetails); MessageBox.Show("מייל נשלח בהצלחה", "הודעה", MessageBoxButtons.OK, MessageBoxIcon.Information); conn4.Close(); } catch { MessageBox.Show("שגיאה בשליחת מייל", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show("ניתן להגיש בחינה רק לאחר חצי שעה"); } } else { MessageBox.Show("ניתן להגיש בחינה רק לאחר חצי שעה"); } }