private void BtnLogin_Click(object sender, EventArgs e)
{
AuthBAL Auth = new AuthBAL();
if (TxtUsername.Text.Trim() != "" && TxtPassword.Text.Trim() != "")
{
Auth.Username = TxtUsername.Text.Trim();
Auth.Password = TxtPassword.Text.Trim();
bool result = Ad.Auth(Auth);
if (result == true)
{
Home main = new Home();
main.Show();
Hide();
}
else
{
MessageBox.Show("Invalid Username and Password");
}
}
else if (TxtUsername.Text.Trim() == "")
{
MessageBox.Show("Username Cannot be Empty");
TxtUsername.Focus();
}
else if (TxtPassword.Text.Trim() == "")
{
MessageBox.Show("Password Cannot be Empty");
TxtPassword.Focus();
}
else
{
MessageBox.Show("Username and Password Invalid");
}
}
private void BtnLogin_Click(object sender, EventArgs e)
{
AuthBAL Auth = new AuthBAL();
AuthDAL Ad = new AuthDAL();
if (TxtUseName.Text.Trim() != "" && TxtPasWord.Text.Trim() != "")
{
Auth.Username = TxtUseName.Text.Trim();
Auth.Password = TxtPasWord.Text.Trim();
bool result = Ad.Auth(Auth);
if (result == true)
{
TUnlock.Enabled = true;
}
else
{
MessageBox.Show("Invalid Username and Password");
}
}
else if (TxtUseName.Text.Trim() == "")
{
MessageBox.Show("Username Cannot be Empty");
TxtUsername.Focus();
}
else if (TxtPasWord.Text.Trim() == "")
{
MessageBox.Show("Password Cannot be Empty");
TxtPassword.Focus();
}
else
{
MessageBox.Show("Username and Password cannot be empty");
}
}
protected void login_Click(object sender, EventArgs e)
{
AuthPROPS ap = new AuthPROPS();
ap.Email = email.Text;
ap.Passowrd = new HashSami().GetHash(password.Text.Trim());
DataTable dt = new AuthBAL().login(ap);
if (dt.Rows.Count > 0)
{
int AccessLevel = (int)dt.Rows[0]["AccessLevel"];
Session["Email"] = email;
Session["PD_ID"] = dt.Rows[0]["U_ID"];
Session["Name"] = dt.Rows[0]["Name"];
Session["AccessLevel"] = AccessLevel;
Session["deptid"] = dt.Rows[0]["Department_ID"];
Session["dean"] = dt.Rows[0]["Dean"];
Session["Campus"] = dt.Rows[0]["Campus"];
if (AccessLevel == 1)
{
Response.Redirect("Coordinator/dashboard.aspx");
}
else if (AccessLevel == 2)
{
Response.Redirect("HOD/dashboard.aspx");
}
else if (AccessLevel == 3)
{
Response.Redirect("DEAN/dashboard.aspx");
}
else if (AccessLevel == 4)
{
Response.Redirect("Dir_Acad/dashboard.aspx");
}
else if (AccessLevel == 5)
{
Response.Redirect("DG/dashboard.aspx");
}
else if (AccessLevel == 6)
{
Response.Redirect("Rector/dashboard.aspx");
}
}
else
{
alert.Text = "Incorrect Email or Password";
alert.Visible = true;
}
}
public bool Auth(AuthBAL A)
{
bool result;
try
{
MySqlParameter[] Pms = new MySqlParameter[2];
Pms[0] = new MySqlParameter("UName", MySqlDbType.VarChar)
{
Value = A.Username
};
Pms[1] = new MySqlParameter("Pword", MySqlDbType.VarChar)
{
Value = A.Password
};
MySqlCommand cmd = new MySqlCommand
{
Connection = Con.Con,
CommandType = CommandType.StoredProcedure,
CommandText = "Check_Auth"
};
cmd.Parameters.AddRange(Pms);
Con.Con.Open();
var dr = cmd.ExecuteReader();
if (dr.Read())
{
result = true;
}
else
{
result = false;
}
Con.Con.Close();
return(result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
public bool CheckAuth(AuthBAL A)
{
try
{
string Query = "Select * From users Where Name = '" + A.Username + "' AND Pass = '******'";
MySqlDataAdapter Sda = new MySqlDataAdapter(Query, Con.Con);
DataTable dt = new DataTable();
Sda.Fill(dt);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
