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(); }