private void button2_Click(object sender, EventArgs e)
{
FormMenuAdmin formMenuAdmin = new FormMenuAdmin();
formMenuAdmin.Show();
this.Close();
}
private void btLogAdmin_Click(object sender, EventArgs e)
{
MySqlConnection conectaradmin = new MySqlConnection("server=localhost; database=datos_proyecto; UID=root; password=;");
conectaradmin.Open();
MySqlCommand codigo = new MySqlCommand();
MySqlConnection conectanos = new MySqlConnection();
codigo.Connection = conectaradmin;
codigo.CommandText = ("Select * from clientes where Nombre ='" + tbNickAdmin.Text + "'and Contraseña = '" + tbPassAdmin.Text + "'and TipoPersona= '" + 0 + "'");
MySqlDataReader leer = codigo.ExecuteReader();
if (leer.Read())
{
MessageBox.Show("Bienvenido " + tbNickAdmin.Text);
FormMenuAdmin formMenuAdmin = new FormMenuAdmin();
formMenuAdmin.Show();
this.Hide();
}
else
{
MessageBox.Show("Usuario o contraseña incorrectos");
}
conectaradmin.Close();
}
private void btnAdmin_Click_1(object sender, EventArgs e)
{
pnlNoiDung.Controls.Clear();
setClickEventButton(btnAdmin);
FormMenuAdmin frm = new FormMenuAdmin();
pnlNoiDung.Height = frm.Height;
pnlNoiDung.AutoScroll = true;
foreach (Form frmItem in pnlNoiDung.Controls)
{
if (frmItem is FormMenuAdmin)
{
frmItem.BringToFront();
return;
}
}
frm.Dock = DockStyle.Fill;
frm.TopLevel = false;
frm.FormBorderStyle = 0;
pnlNoiDung.Controls.Add(frm);
frm.Show();
frm.BringToFront();
}
private void button1_Click(object sender, EventArgs e)
{
DateTime end_of_exams_semester_a = new DateTime(DateTime.Today.Year, 3, 5);
DateTime end_of_semester_b = new DateTime(DateTime.Today.Year, 6, 15);
DateTime end_of_exams_semester_b = new DateTime(DateTime.Today.Year, 7, 15);
SqlDataReader read = db.Select("*", "NewUsers");
try
{
if (textBox1.Text == "")
{
MessageBox.Show("Logon Failure: unknown ID or invalid password");
return;
}
if (SQLFunctions.checkExistsEmail(textBox1.Text))
{
if (SQLFunctions.checkLogIn(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text)), textBox2.Text))
{
this.Hide();
if (SQLFunctions.checkRole(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString()))) == "Student")
{
FormMenuStudent mainForm = new FormMenuStudent(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString())), textBox2.Text);
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString()))) == "SecretaryA")
{
FormMenuSecretary mainForm = new FormMenuSecretary(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString())), textBox2.Text);
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString()))) == "Exam Department")
{
FormMenuExamDepartment mainForm = new FormMenuExamDepartment();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString()))) == "Admin")
{
FormMenuAdmin mainForm = new FormMenuAdmin();
mainForm.Show();
}
else
{
while (read.Read())
{
if (textBox1.Text == read["Email"].ToString().Trim() && textBox2.Text == read["Password"].ToString().Trim())
{
ID = read["ID"].ToString();
// GlobalVariables h;.ID = read["ID"].ToString().Trim();
GlobalVariables.User_ID = read["ID"].ToString().Trim();
GlobalVariables.Full_Name = read["FirstName"].ToString().Trim() + " " + read["LastName"].ToString().Trim();
GlobalVariables.User_Permission = read["Role"].ToString().Trim();
GlobalVariables.User_Department = read["Department"].ToString().Trim();
GlobalVariables.User_Email = read["Email"].ToString().Trim();
if (monthCalendar1.MaxDate >= DateTime.Today && monthCalendar1.MinDate <= DateTime.Today)
{
GlobalVariables.Semester = "A";
}
else if (monthCalendar1.MaxDate < DateTime.Today && DateTime.Today <= end_of_exams_semester_a)
{
GlobalVariables.Semester = "Exam Period semester A";
}
else if (end_of_exams_semester_a < DateTime.Today && DateTime.Today <= end_of_semester_b)
{
GlobalVariables.Semester = "B";
}
else if (end_of_exams_semester_b >= DateTime.Today && DateTime.Today > end_of_semester_b)
{
GlobalVariables.Semester = "Exam Period semester B";
}
else
{
GlobalVariables.Semester = "Summer Semester";
}
IsFound = true;
GlobalVariables.maxDate = monthCalendar1.MaxDate;
GlobalVariables.minDate = monthCalendar1.MinDate;
break;
}
GlobalVariables.maxDate = monthCalendar1.MaxDate;
GlobalVariables.minDate = monthCalendar1.MinDate;
}
read.Close();
if (!IsFound)
{
MessageBox.Show("You have to sign up before");
textBox1.Text = "";
textBox2.Text = "";
return;
}
this.Hide();
main m = new main();
m.Show();
}
}
else
{
MessageBox.Show("Logon Failure: unknown ID or invalid password");
}
}
else
{
MessageBox.Show("Logon Failure: unknown ID or invalid password");
}
}
catch (SqlException exception)
{
MessageBox.Show(exception.ToString());
}
finally
{
if (db.isconnected == true)
{
db.CloseConnection();
}
}
}
/*
* @JuanJo devuelve al usuario al menú de administrador
*/
private void btReturn_Click(object sender, EventArgs e)
{
FormMenuAdmin formMenuAdmin = new FormMenuAdmin();
formMenuAdmin.Show();
}
