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 DataTable login(AuthPROPS ap) { DataTable dt = new DataTable(); conn.Open(); SqlCommand cmd = new SqlCommand("LOGIN", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Email", ap.Email)); cmd.Parameters.Add(new SqlParameter("@Password", ap.Passowrd)); sdr = cmd.ExecuteReader(); if (sdr.HasRows) { dt.Load(sdr); } return(dt); }
public DataTable login(AuthPROPS ap) { return(new AuthDAL().login(ap)); }