SEE DETAILS - Code First Entity Framework ASP.Net MVC Project: Custom Authorization and @Dropdownlist return values

I have an ASP.Net application project I'm working on. Being fairly new to programming, I need help with a couple of things I'm implementing but having trouble with: #1 Fetch Database Values Based on Dropdownlist Selection: I need 9 @[login to view URL] box values to be filled when an @[login to view URL] value is selected. The dropdownlist part is already binded to the SQL Express database. #2 Custom Authorization: I need to be able to authorize user access to specific pages based on custom role stored in database. I have an employee table which keeps employee information where the role will be stored. I believe it's something like the link below but I keep getting an error regarding the database. I think my error was because I'm not linking the database tables correctly. I removed my authorization related code for a fresh start. Note: I already have the custom log in and register views setup and working with employee database . I can deliver the project code once the project is accepted by freelancer. [login to view URL]