private void login()
{
Task.Delay(30000);
//MODELO SELECT
string conexaostr = "Server=den1.mysql2.gear.host; User Id=bdmyschool; password=123456.;database=bdmyschool";
MySqlConnection conexao = null;
try
{
conexao = new MySqlConnection(conexaostr);
conexao.Open();
MySqlCommand comando = new MySqlCommand();
comando.Connection = conexao;
//COMANDO SQL
comando.CommandText = "SELECT email_professor, senha_professor, nome_professor FROM tb_professor WHERE email_professor=@email and senha_professor=@senha";
//VARIAVEIS
comando.Parameters.AddWithValue("@email", textBox1.Text);
comando.Parameters.AddWithValue("@senha", textBox2.Text);
comando.ExecuteNonQuery();
MySqlDataReader leitor = comando.ExecuteReader();
//se há linhas
if (leitor.HasRows)
{
leitor.Read();
nomeprof = leitor.GetString(2);
Form home = new Home();
home.Closed += (s, args) => this.Close();
carregamento.Close();
home.Show();
}
else
{
carregamento.Hide();
this.Show();
textBox1.Text = "";
textBox2.Text = "";
MessageBox.Show("Usuario e/ou senha incorretos");
}
}
finally
{
if (conexao != null)
{
conexao.Close();
}
}
//MODELO SELECT
}
private void InfoTactical_KeyDown(object sender, KeyEventArgs e)
{
switch (e.KeyCode)
{
case Keys.Escape:
{
var frm = new Home();
this.Hide();
frm.Show();
break;
}
}
}
private void loginBtn_Click(object sender, EventArgs e)
{
// 아이디 비번 찾는 쿼리문 비밀번호는 MD5암호화 후 전송
string findCommand = "SELECT count(ID) FROM user WHERE ID='" + idTextBox.Text + "' AND PW='" + MD5HashFunc(pwTextBox.Text) + "';";
int cnt = 0;
// db접속
db.connection.Open();
if (idTextBox.Text.Length > 0)
{
if (pwTextBox.Text.Length > 0)
{
// db query 명령어
MySqlCommand command = new MySqlCommand(findCommand, db.connection);
// 명령어 실행
cnt = Convert.ToInt32(command.ExecuteScalar());
// 아이디, 비밀번호가 일치하는 컬럼 개수가 0이상이면 성공
if (cnt > 0)
{
// 로그인후 ID를 계속 갖기 위해, user 객체생성(생성자를 통해 ID 넘겨줌)
member.set(idTextBox.Text);
db.connection.Close();
home.Show();
this.Hide();
}
else
{
MessageBox.Show("아이디,비밀번호가 일치하지 않습니다.");
}
}
else
{
MessageBox.Show("비밀번호를 입력하시오");
}
}
else
{
MessageBox.Show("아이디를 입력하시오.");
}
db.connection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\Akoch\Documents\Table.mdf; Integrated Security = True; Connect Timeout = 30");
string query = "Select * from Login Where UserName ='******' and PassWord ='******' ";
SqlDataAdapter sda = new SqlDataAdapter(query, cn);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count == 1)
{
this.Hide();
Home h = new Home();
h.Show();
}
else
{
MessageBox.Show("please check your username and password!");
}
}
private void Button1_Click(object sender, EventArgs e)
{
string psw;
unm = textBox1.Text;
psw = textBox2.Text;
manager mn = new manager();
int a = mn.log(unm, psw);
if (a == 0)
{
MessageBox.Show("username password dosent match");
}
else
{
Home hm = new Home();
this.Hide();
hm.Show();
}
}
private void login_button_Click(object sender, EventArgs e)
{
AntiBruteForce++;
if (AntiBruteForce > 5)
{
timer1.Interval = 1000;
timer1.Start();
login_button.Enabled = false;
login_result.Text = "You've attemped to Login more than 5 times.";
login_result.ForeColor = Color.Red;
}
else if (Usernames.Contains(login_username.Text))
{
StreamReader sr = new StreamReader(Path_Accounts + login_username.Text + ".txt");
string[] Identifiers = sr.ReadLine().Split(' ');
if (login_password.Text == Identifiers[1])
{
UsernameLogged = login_username.Text;
login_username.Text = "";
login_password.Text = "";
login_checkbox.Checked = false;
login_password.UseSystemPasswordChar = true;
login_checkbox.Text = "Show";
Home Home = new Home();
Hide();
Home.Show();
}
else
{
login_result.Text = "Password incorrect.";
login_result.ForeColor = Color.Red;
}
}
else
{
login_result.Text = "Username or password incorrect.";
login_result.ForeColor = Color.Red;
}
}
private void bttnSubmit_Click(object sender, EventArgs e)
{
Functionality.ValidateLogin valid = new Functionality.ValidateLogin();
string User = txtbxUser.Text;
string Password = txtbxPWD.Text;
int permissions = valid.Validation(User, Password);
if (permissions > 0)
{
// Validate Valid = new Validate();//testing Database
//Home next = new Home();
Home next = new Home();
next.Show();
next.name(User);
next.logName("logout");
// Valid.ConnectDB(User, Password);//testing Database
this.Hide();
}
else
{
txtError.Visible = true;
}
}
private void btnIngreso_Click(object sender, EventArgs e)
{
try
{
//creando la conexion
SqlConnection miConecion = new SqlConnection("Data Source=.;Initial Catalog=HorasExtrasLacteosOsorno;Integrated Security=True;MultipleActiveResultSets=True;");
//abriendo conexion
miConecion.Open();
SqlCommand comando = new SqlCommand("select Usuario, Clave, Seccion, TipoUsuario from Usuarios where Usuario = '" + txtUsuario.Text + "'And Clave = '" + txtContraseña.Text + "'And Seccion = '" + cbxArea.Text + "'And TipoUsuario = '" + cbxTipoUsuario + "' ", miConecion);
//ejecuta una instruccion de sql devolviendo el numero de las filas afectadas
comando.ExecuteNonQuery();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(comando);
//Llenando el dataAdapter
da.Fill(ds, "HorasExtrasLacteosOsorno");
//utilizado para representar una fila de la tabla q necesitas en este caso usuario
DataRow DR;
DR = ds.Tables["Usuarios"].Rows[0];
//evaluando que la contraseña,usuario y area sean correctos
if ((txtUsuario.Text == DR["Usuario"].ToString()) || (txtContraseña.Text == DR["Clave"].ToString()) || (cbxArea.Text == DR["Seccion"].ToString()) || (cbxTipoUsuario.Text == DR["TipoUsuario"].ToString()))
{
//instanciando el formulario principal
Home frmPrincipal = new Home();
frmPrincipal.Show(); //abriendo el formulario principal
this.Hide(); //esto sirve para ocultar el formulario de login
}
}
catch
{
MessageBox.Show("Error! Su usuario o contraseña es incorrecta", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//private void Welcome_Load(object sender, EventArgs e)
//{
// try
// {
// cn.Open();
// string qry = "SELECT Role FROM Auth";
// SqlDataReader dr = new SqlCommand(qry, cn).ExecuteReader();
// while (dr.Read())
// {
// cbox.Items.Add(dr.GetValue(0).ToString());
// }
// dr.Close();
// }
// catch (SqlException x)
// {
// MessageBox.Show(x.Message);
// }
// cn.Close();
//}
private void Submit_Click(object sender, EventArgs e)
{
try
{
if (attempt == 0)
{
lbl_Msg.Text = ("ALL 3 ATTEMPTS HAVE FAILED - CONTACT ADMIN");
tb1.Enabled = false;
tb2.Enabled = false;
tb1.Clear();
tb2.Clear();
return;
}
cmd = new SqlCommand("select count(*) from Auth where login=@login and pass=@pass", cn);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@login", tb1.Text);
cmd.Parameters.AddWithValue("@pass", tb2.Text);
cn.Open();
if (cmd.ExecuteScalar().ToString() == "1")
{
errorlogin.Icon = Properties.Resources.ok;
errorlogin.SetError(tb1, "تم");
errorpass.Icon = Properties.Resources.ok;
errorpass.SetError(tb2, "تم");
MessageBox.Show(" تم الدخول بنجاح ");
this.Hide();
var sh = new Home(tb1.Text + " :مرحبا ");
sh.Closed += (s, args) => this.Close();
sh.Show();
}
// cmd SelectCommand = new MySqlCommand("Select role form Auth", cn);
// DataTable dt = new DataTable();
// sda.Fill(dt);
// if (dt.Rows.Count == 1)
// {
// this.Hide();
// var sh = new Home(tb1.Text + " :مرحبا ");
// sh.Closed += (s, args) => this.Close();
// sh.Show();
// }else
// {
// this.Hide();
// var sh1 = new Home1(tb1.Text + " :مرحبا ");
// sh1.Closed += (s, args) => this.Close();
// sh1.Show();
// }
//}
else
{
errorlogin.Icon = Properties.Resources.err;
errorlogin.SetError(tb1, "خطأ في اسم المستخدم");
errorpass.Icon = Properties.Resources.err;
errorpass.SetError(tb2, "خطأ في كلمة المرور");
MessageBox.Show(" لا يمكن الدخول \n الرجاء اعادة اسم المستخدم و كلمة السر ");
lbl_Msg.Text = (" لديك فقط " + Convert.ToString(attempt) + " محاولات للاعادة ");
--attempt;
tb1.Clear();
tb2.Clear();
}
cn.Close();
}
catch
{
//nothing here
}
}
