private void LoginUser()
{
using (SqlConnection conn = new SqlConnection(Connectionstring))
{
string query = "SELECT * FROM [User] WHERE USERNAME = '******' AND PASSWORD = '******'";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
conn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
_loginCount++;
_user.UserName = reader["username"].ToString();
_user.Password = reader["password"].ToString();
_user.Name = reader["name"].ToString();
_user.Email = reader["email"].ToString();
_user.Address = reader["address"].ToString();
_user.ContactNo = reader["contact_no"].ToString();
_user.JoinDate = reader["join_date"].ToString();
_user.AccountType = reader["account_type"].ToString();
}
}
}
}
if (_loginCount == 1 && _user.AccountType == "Admin")
{
Hide();
FormAdminPanel adminPanel = new FormAdminPanel(txtUserName.Text);
adminPanel.Show();
Hide();
}
else if (_loginCount == 1 && _user.AccountType == "Employee")
{
Hide();
FormEmployeePanel employeePanel = new FormEmployeePanel(txtUserName.Text);
employeePanel.Show();
}
else
{
MessageBox.Show(@"Access Denied", @"Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void Verification(string username, string password, FormHome home)
{
string trueFalseValue = firstStepOfVerification(username, password);
if (trueFalseValue == "1")
{
//--------------successfull Log In
MessageBox.Show("Successfull Log In", "Message");
//-----------------close Home Form and Open Admin Form
home.Hide();
FormAdminPanel fap = new FormAdminPanel(ref username);
fap.ShowDialog();
}
else
{
//--------------Failed Log In
MessageBox.Show("Log In Failed", "Message");
}
}
