private void btn_Login_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(CSTool.sqlConnString()); SqlCommand cmd = new SqlCommand("SP_Login", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@uname", txt_loginID.Text); cmd.Parameters.AddWithValue("@pass", txt_loginPW.Text); conn.Open(); //cmd.ExecuteNonQuery(); var reader = cmd.ExecuteReader(); while (reader.Read()) { //ASSIGN USER LEVEL TO LOCAL VAR CSVar.userLevel = (int)reader[0]; //CHECK IF LOGGED SUCCESSFULY if (CSVar.userLevel > 0) { CSTool.infoMessage("Successfully logged in."); //SHOW CPANEL if a valid user if (CSULevel.User() || CSULevel.Support() || CSULevel.Admin()) { //SHOW CPANEL CPanel CPWindow = new CPanel(); CPWindow.Show(); //HIDE LOGIN PANEL this.Hide(); } } else { CSTool.errorMessage("Incorrect Username or password."); } } conn.Close(); }
private void btn_Login_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(CSTool.sqlConnString()); SqlCommand cmd = new SqlCommand("SP_Login", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@uname", txt_loginID.Text); cmd.Parameters.AddWithValue("@pass", txt_loginPW.Text); conn.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { CSVar.userLevel = (int)reader[0]; if (CSVar.userLevel > 0) { CSTool.infoMessage("Successfully logged in."); if (CSULevel.User() || CSULevel.Support() || CSULevel.Admin()) { CPanel CPWindow = new CPanel(); CPWindow.Show(); this.Hide(); } } else { CSTool.errorMessage("Incorrect Username or password."); } } conn.Close(); }