private void button4_Click(object sender, EventArgs e) { WebBrowserfrm bt = new WebBrowserfrm(user); bt.Show(); this.Hide(); }
private void submitbtn_Click(object sender, EventArgs e) { int role; if (usernametxt.Text == "" || passtxt.Text == "") { if (usernametxt.Text == "") { usernameerror.SetError(usernametxt, "User name is required"); } else { usernameerror.Dispose(); } if (passtxt.Text == "") { passworderror.SetError(passtxt, "Password is required"); } else { passworderror.Dispose(); } } if (usernametxt.Text != "" && passtxt.Text != "") { SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=RAHUL;Initial Catalog=Webbrowser;Integrated Security=true"; DataTable dt = new DataTable(); string date1 = DateTime.Now.Date.ToString(); try { con.Open(); SqlCommand cmd = new SqlCommand(); SqlCommand cmd2 = new SqlCommand(); cmd.Connection = con; cmd2.Connection = con; cmd2.CommandType = CommandType.Text; cmd.CommandType = CommandType.Text; cmd2.CommandText = "insert into log values('" + usernametxt.Text + "','" + ipadd + "','" + date1 + "')"; cmd.CommandText = "select * from login where loginusername='******' and loginpassword='******' "; int result = cmd2.ExecuteNonQuery(); SqlDataReader dr = cmd.ExecuteReader(); //int count = 0; if (dr.HasRows) { while (dr.Read()) { role = (int)dr[2]; if (role == 0) { WebBrowserfrm wbf = new WebBrowserfrm(usernametxt.Text); wbf.Show(); this.Hide(); } if (role == 1) { Admin a = new Admin(usernametxt.Text); a.Show(); this.Hide(); } } /*if (count == 1) * { * * MessageBox.Show("username and password is correct"); * usernameerror.Dispose(); * passworderror.Dispose(); * * dr.Close(); * int result = cmd2.ExecuteNonQuery(); * * * * * * } * * else if (count > 1) * { * * MessageBox.Show("Duplicate username and password"); * * }*/ /* else * { * * MessageBox.Show(" username and password incorrect"); * * usernametxt.Clear(); * passtxt.Clear(); * * }*/ } else { MessageBox.Show("Invalid user.Login again"); usernameerror.Dispose(); passworderror.Dispose(); usernametxt.Clear(); passtxt.Clear(); } } catch (Exception e3) { MessageBox.Show("" + e3); } finally { con.Close(); } } }