public List <UserAuthorizationParam> getUserAuthorizedList(long userId) { List <UserAuthorizationParam> ret = new List <UserAuthorizationParam>(); try { using (var db = new UKareEntities()) { var aUser = db.Users.Find(userId); if (aUser != null) { //foreach (Role r in aUser.Roles) //{ //ret = ret.Concat( // (from rap in r.AssetPermissions // select new UserAuthorizationParam // { // UserId = userId, // AssetItem = rap.Asset.Code, // PermittedAction = rap.Permission.Name, // }).ToList() // ).ToList(); //} } } } catch (Exception) { throw; } return(ret); }
public static bool SaveVisitorInfo() { UKareEntities db = new UKareEntities(); string CurrentUserIp = GetUser_IP(); //HttpContext.Current.Request.UserHostAddress; SiteVisit vister = db.SiteVisits.Where(p => p.IPaddress == CurrentUserIp && EntityFunctions.TruncateTime(p.LastVisitedDate) == EntityFunctions.TruncateTime(DateTime.Now)).FirstOrDefault(); if (vister != null) { vister.VisitCount = vister.VisitCount + 1; vister.LastVisitedDate = DateTime.Now; db.SaveChanges(); } else { vister = new SiteVisit(); vister.IPaddress = CurrentUserIp; vister.LastVisitedDate = DateTime.Now; vister.VisitCount = 1; db.SiteVisits.Add(vister); db.SaveChanges(); } CurrentUserIp = string.Empty; vister = null; db.Dispose(); return(true); }
public List <SelectListItem> GetCountries() { List <SelectListItem> countries = new List <SelectListItem>(); db = new UKareEntities(); var countryList = db.Countries.Select(c => c).ToList(); foreach (var item in countryList) { SelectListItem model = new SelectListItem(); model.Text = item.Name; model.Value = item.Id.ToString(); countries.Add(model); } return(countries); }
public bool IsAuthorized(UserAuthorizationParam UserAuthor) { bool IsPermitted = false; using (var db = new UKareEntities()) { var aUser = db.Users.Where(p => p.Id == UserAuthor.UserId).FirstOrDefault(); if (aUser != null) { var userRoleId = aUser.RoleId; var userPermissions = db.Permissions.Where(p => p.RoleId == userRoleId).ToList(); IsPermitted = userPermissions.Any(up => up.ActionName.Equals(UserAuthor.PermittedAction, StringComparison.InvariantCultureIgnoreCase) && up.ActionName.Equals(UserAuthor.PermittedAction, StringComparison.InvariantCultureIgnoreCase)); return(IsPermitted); } } return(IsPermitted); }