private void btnLogin_Click(object sender, EventArgs e) { string userName = textBoxName.Text; string password = Cryptology.MD5Sifrele(textBoxPassword.Text); connection.Open(); SqlCommand command = new SqlCommand("SELECT * FROM TblLoginCustomer", connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (userName == reader["UserName"].ToString() && password == reader["Password"].ToString()) { isThere = true; break; } else { isThere = false; } } connection.Close(); if (isThere) { MessageBox.Show("Başarılı giriş yaptınız!", "Program"); } else { MessageBox.Show("Hatalı kullanıcı adı veya şifre!"); } }
private void btnLogin_Click(object sender, EventArgs e) { string userName = textBoxName.Text; string password = Cryptology.MD5Sifrele(textBoxPassword.Text); connection.Open(); SqlCommand command = new SqlCommand("SELECT * FROM TblLoginCustomer WHERE UserName='******'", connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (userName == reader["UserName"].ToString() && password == reader["Password"].ToString() && reader["Counter"].ToString() != "3") { isThere = true; label1.Text = reader["id"].ToString(); break; } else { isThere = false; } } connection.Close(); CustomerForm cf = new CustomerForm(); if (isThere) { cf.etc = label1.Text; this.Hide(); cf.ShowDialog(); this.Close(); } else { connection.Open(); SqlCommand komut = new SqlCommand("SELECT * FROM TblLoginCustomer WHERE UserName='******'", connection); SqlDataReader read = komut.ExecuteReader(); if (read.Read()) { if (read["Counter"].ToString() == "3") { MessageBox.Show("Hesabınız bloke olmuştur. Lütfen sistem yöneticimizle [email protected] adresi üzerinden iletişime geçiniz.."); } else { connection.Close(); connection.Open(); SqlCommand commandd = new SqlCommand("UPDATE TblLoginCustomer SET Counter = Counter +1 WHERE UserName='******'", connection); commandd.ExecuteNonQuery(); MessageBox.Show("Hatalı kullanıcı adı veya şifre!"); } } connection.Close(); } }
private void btnLoginSignUp_Click(object sender, EventArgs e) { connection.Open(); SqlCommand command = new SqlCommand("INSERT INTO TblLoginCustomer (UserName,Password,Answer) values ('" + textBoxNameSignUp.Text + "','" + Cryptology.MD5Sifrele(textBoxPasswordSignUp.Text) + "','" + txtBxAnswer.Text + "')", connection); command.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Başarılı", "Program"); }
private void btnLoginSignUp_Click(object sender, EventArgs e) { int Counter = 0; connection.Open(); if (cbForgetQuestion.SelectedItem == null && txtBxAnswer.Text == null) { MessageBox.Show("Parola Kurtarma Sorusu Boş Bırakılamaz...", "Program"); } SqlCommand command = new SqlCommand("INSERT INTO TblLoginCustomer (UserName,Password,Question,Answer,Counter) values ('" + textBoxNameSignUp.Text + "','" + Cryptology.MD5Sifrele(textBoxPasswordSignUp.Text) + "','" + cbForgetQuestion.SelectedItem.ToString() + "','" + txtBxAnswer.Text + "','" + 0 + "')", connection); command.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Başarılı", "Program"); }