is there a better way to implement role based acton and view in mvc than if/else?
===

So I have three roles, administrators, companies and employees in my mvc .net application that uses asp.net membership in a separate database. I moved the .net membership in a different database for now because everytime I modify the model, the .net membership tables are getting deleted.

Anyway, I am handling different roles using if/else in the action method. For example, in Index() action, I check if the user is in administrators role, then create model and linq query based on that. If user in companies role, different query and if user in employees role, different query. check code below. The model created after the if condition is passed to the View.

I feel like this is not the best way to handle roles. Is this the best way to handle roles? I am considering different areas as well, but I use same views for the different roles, i think it may not be productive.

Any suggestion/idea greatly appreciated.


    [Authorize]
        public class CompanyController : Controller
        {
            private MyDBContext db = new MyDBContext();
    
            //
            // GET: /Company/
    
            public ViewResult Index()
            {
                var viewModel = new CompanyIndexViewModel();
                if (Roles.IsUserInRole("administrators")) {
                    viewModel = new CompanyIndexViewModel { Companies = db.Companies.ToList() };
                }
                else if (Roles.IsUserInRole("companies")) {
                    viewModel = new CompanyIndexViewModel { Companies = db.Companies.Where(c => c.Username.ToLower().Equals(this.User.Identity.Name.ToLower())).ToList() };
                }
                else if (Roles.IsUserInRole("employees")) {
                    string userName = this.User.Identity.Name.ToLower();
                    var companies = db.Companies.Where(c => c.Appointments.Any(a =>
                                       a.Employee.Username.ToLower() == userName)).ToList();
                    viewModel = new CompanyIndexViewModel { Companies = companies.ToList() };
                }
    
                return View(viewModel);
            }
    ....