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 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("ניתן להגיש בחינה רק לאחר חצי שעה");
}
}