private void cek_login(object sender, EventArgs e)
{
try
{
string connectionSQL = "server=localhost;database=bmkg;uid=root;password=;";
MySqlConnection myConn = new MySqlConnection(connectionSQL);
MySqlCommand SelectCommand = new MySqlCommand("select * from bmkg.user_ms where username='******' and pass='******' ", myConn);
MySqlDataReader myReader;
myConn.Open();
myReader = SelectCommand.ExecuteReader();
int count = 0;
while (myReader.Read())
{
count = count + 1;
}
if (count == 1)
{
MessageBox.Show("Username and Password Correct");
this.Hide();
Form frm2 = new adminpage(username_txt.Text);
frm2.Show();
}
else if (count > 1)
{
MessageBox.Show("Duplicate Username and User, access denied");
}
else
{
MessageBox.Show("Username and Password is incorrect, try again");
}
myConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
/*{
* if ((username_txt.Text.Equals("putri")) && (password_txt.Text.Equals("password")))
* {
* MessageBox.Show("You are now Logged in");
* this.Hide();
* Form frm2 = new BMKG();
* frm2.Show();
*
* }
* else if ((username_txt.Text.Equals("putri")) && (password_txt.Text != "password"))
* {
* MessageBox.Show("You have entered the wrong password! Try again");
* password_txt.Clear();
* password_txt.Focus();
* }
* else if ((username_txt.Text != "putri") && (password_txt.Text.Equals("password")))
* {
* MessageBox.Show("You have entered the wrong username! Try again");
* username_txt.Clear();
* username_txt.Focus();
* }
* else
* {
* MessageBox.Show("You have entered the wrong username and password! Try again");
* username_txt.Clear();
* password_txt.Clear();
* }
* }*/
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection("Data Source=.;Initial Catalog=CarInsuranceSystem;Integrated Security=True");
connection.Open();
if (usernamelog.Text == "" || (usernamelog.Text.Trim() == "Username" && usernamelog.ForeColor == Color.DarkGray))
{
usernamelog.Focus();
}
else if (passwordlog.Text == "" || (passwordlog.ForeColor == Color.DarkGray && passwordlog.Text.Trim() == "Password"))
{
passwordlog.Focus();
}
else
{
SqlCommand command = new SqlCommand("Login", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@UserName", usernamelog.Text));
command.Parameters.Add(new SqlParameter("@Password", passwordlog.Text));
if (admin.Checked)
{
command.Parameters.Add(new SqlParameter("@Admin", '1'));
}
else
{
command.Parameters.Add(new SqlParameter("@Admin", '0'));
}
var returnParam1 = new SqlParameter {
ParameterName = "@@exist",
Direction = ParameterDirection.Output,
Size = 5
};
command.Parameters.Add(returnParam1);
command.ExecuteNonQuery();
if (command.Parameters["@@exist"].Value.ToString() == "Exist")
{
connection.Close();
if (!admin.Checked)
{
this.Hide();
userPage f = new userPage(usernamelog.Text);
f.ShowDialog();
this.Close();
}
else
{
this.Hide();
adminpage f = new adminpage(usernamelog.Text);
f.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show("Invalid Username or password.");
}
connection.Close();
}
}