Beispiel #1
0
        public static bool VerifyRecord(int userId, string pws)
        {
            SqlConnection conn      = UtilityDB.ConnectDB();
            SqlCommand    cmdSelect = new SqlCommand();


            cmdSelect.CommandText = "SELECT * FROM Users WHERE UserId = @UserId AND Password = @Password";
            cmdSelect.Parameters.AddWithValue("@UserId", userId);
            cmdSelect.Parameters.AddWithValue("@Password", pws);

            cmdSelect.Connection = conn;

            SqlDataReader dataReader = cmdSelect.ExecuteReader();

            bool result;

            result = dataReader.Read();

            conn.Close();

            return(result);
        }
Beispiel #2
0
        public static User ReadRecord(int userID)
        {
            SqlConnection conn      = UtilityDB.ConnectDB();
            SqlCommand    cmdSelect = new SqlCommand();


            cmdSelect.CommandText = "SELECT * FROM Users WHERE UserId = @UserId";
            cmdSelect.Parameters.AddWithValue("@UserId", userID);

            cmdSelect.Connection = conn;

            SqlDataReader dataReader = cmdSelect.ExecuteReader();

            dataReader.Read();
            User tempUser = new User();

            tempUser.UserID     = Convert.ToInt32(dataReader["UserId"]);
            tempUser.Password   = dataReader["Password"].ToString();
            tempUser.JobTitle   = dataReader["JobTitle"].ToString();
            tempUser.UserStatus = dataReader["UserStatus"].ToString();

            conn.Close();
            return(tempUser);
        }