public UserSettingsView GetViewModel(int id) { var user = _db.FirstOrDefault <User>(new Sql().Select("*").From("dbo.umbracoUser").Where("id=@tag", new { tag = id })); var languages = _db.Fetch <UserLanguage>(new Sql().Select("*").From("dbo.simpleTranslationUserLanguages").Where("id=@tag", new { tag = id })); var model = new UserSettingsView { User = user, UserLanguages = languages.Select(x => x.LanguageId), Languages = _db.Fetch <Language>(new Sql().Select("*").From("dbo.umbracoLanguage")), UserRole = _urh.GetUserRole(id), Roles = TranslationRole.TranslationRoles }; return(model); }