public void LogInButton_Click(object sender, EventArgs e)
{
LogInPageClass login = new LogInPageClass();
if (usernameTextBox.Text == null || usernameTextBox.Text.Length < 4 || passwordTextBox.Text == null || passwordTextBox.Text.Length < 6)
{
MessageBox.Show("Ivalied Username or Password \n Please Try again");
return;
}
else
{
login.Username = usernameTextBox.Text;
login.Password = passwordTextBox.Text;
}
LogInPageManager loginmanager = new LogInPageManager();
bool isAdded = loginmanager.Check(login);
if (isAdded)
{
this.Hide();
HomePage homePage = new HomePage();
homePage.Show();
usernameTextBox.Clear();
passwordTextBox.Clear();
}
else
{
MessageBox.Show("Wrong username or password");
return;
}
}
public bool Check(LogInPageClass login)
{
SqlConnection con = new SqlConnection(@"server=DESKTOP-OMV5TK2\SQLEXPRESS;database=Stock Management System;integrated security=true");
string query = @"SELECT Count(*) FROM UserInformation Where [UserName]='" + login.Username + "' and [Password]='" + login.Password + "'";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
sda.Fill(dt);
bool isAdded = dt.Rows[0][0].ToString() == "1";
con.Close();
return(isAdded);
}
public bool Check(LogInPageClass login)
{
bool isAdded = loginrepo.Check(login);
return(isAdded);
}
