public int GetUserId(string login) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.UserAccount.FirstOrDefault(item => item.Login == login)?.UserId ?? 0); } }
public Site GetSite(string siteKey) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.Sites.FirstOrDefault(item => item.Name == siteKey)); } }
public Site GetSite(int siteId) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.Sites.FirstOrDefault(item => item.SiteId == siteId)); } }
public void SaveSiteGroups(int siteId, List <int> siteGroupIds) { if (siteId == 0) { return; } using (UsersLibDbContext dbContext = new UsersLibDbContext()) { Site site = dbContext.Sites .Where(item => item.SiteId == siteId) .Include(item => item.Groups).FirstOrDefault(); List <Group> groups = dbContext.Groups .Where(item => siteGroupIds.Contains(item.Id)) .ToList(); if (site != null) { site.Groups.Clear(); foreach (Group group in groups) { site.Groups.Add(group); } dbContext.SaveChanges(); } } }
public List <Site> GetSites() { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.Sites.ToList()); } }
public List <Group> GetGroups() { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.Groups.ToList()); } }
public User GetUser(int userId) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.Users.FirstOrDefault(item => item.UserId == userId)); } }
public SecureSiteData GetSecureSiteData(int siteId) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.SecureSiteData.FirstOrDefault(item => item.SiteId == siteId)); } }
public UserAccount GetUserAccount(string login, string password) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.UserAccount .FirstOrDefault(item => item.Login == login && item.Password == password)); } }
public List <UserRoleKind> GetUserRoles(int userId) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.UserRole.Where(item => item.UserId == userId) .Select(item => item.Role).ToList()); } }
public Dictionary <User, List <Group> > GetUsersByGroups() { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.Users.Include(user => user.Groups) .ToDictionary(item => item, item => item.Groups.ToList())); } }
public List <User> GetUsers() { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { List <User> dbUsers = dbContext.Users.ToList(); return(dbUsers.ToList()); } }
public void Log(AccessLog logEntity) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { dbContext.AccessLog.Add(logEntity); dbContext.SaveChanges(); } }
public void SaveSecureSiteData(SecureSiteData secureSiteData) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { dbContext.SecureSiteData.AddOrUpdate(secureSiteData); dbContext.SaveChanges(); } }
public Dictionary <Site, List <Group> > GetSitesByGroups() { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.Sites.Include(site => site.Groups) .ToDictionary(item => item, item => item.Groups.ToList())); } }
public void DeleteGroup(int groupId) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { IEnumerable <Group> groups = dbContext.Groups.Where(item => item.Id == groupId); dbContext.Groups.RemoveRange(groups); dbContext.SaveChanges(); } }
public Group SaveGroup(Group group) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { dbContext.Groups.AddOrUpdate(group); dbContext.SaveChanges(); return(group); } }
public void DeleteUser(int userId) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { IEnumerable <User> users = dbContext.Users.Where(item => item.UserId == userId); dbContext.Users.RemoveRange(users); dbContext.SaveChanges(); } }
public void DeleteSite(int siteId) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { IEnumerable <Site> sites = dbContext.Sites.Where(item => item.SiteId == siteId); dbContext.Sites.RemoveRange(sites); dbContext.SaveChanges(); } }
public UserAccount SaveUserAccount(UserAccount userAccount) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { dbContext.UserAccount.AddOrUpdate(userAccount); dbContext.SaveChanges(); return(userAccount); } }
public List <Group> GetSiteGroups(int siteId) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.Sites .Where(item => item.SiteId == siteId) .SelectMany(item => item.Groups) .ToList()); } }
//public int UpdateUsers(List<User> users) //{ // using (UsersLibDbContext dbContext = new UsersLibDbContext()) // { // List<string> existingUsers = dbContext.Users.Select(item => item.Login).ToList(); // users.RemoveAll(user => existingUsers.Contains(user.Login)); // List<User> addedUsers = dbContext.Users.AddRange(users).ToList(); // dbContext.SaveChanges(); // return addedUsers.Count; // } //} public List <Group> GetUserGroups(int userId) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { return(dbContext.Users .Where(item => item.UserId == userId) .SelectMany(item => item.Groups) .ToList()); } }
public void SaveSite(Site site) { if (site == null) { return; } using (UsersLibDbContext dbContext = new UsersLibDbContext()) { dbContext.Sites.AddOrUpdate(site); dbContext.SaveChanges(); } }
public void SaveUser(User user) { if (user == null) { return; } using (UsersLibDbContext dbContext = new UsersLibDbContext()) { dbContext.Users.AddOrUpdate(user); dbContext.SaveChanges(); } }
public void SaveUserGroups(int userId, List <int> userGroupIds) { if (userId == 0) { return; } using (UsersLibDbContext dbContext = new UsersLibDbContext()) { User user = dbContext.Users.Find(userId); List <Group> groups = dbContext.Groups .Where(item => userGroupIds.Contains(item.Id)) .ToList(); if (user != null) { user.Groups.Clear(); foreach (Group userGroup in groups) { user.Groups.Add(userGroup); } dbContext.SaveChanges(); } } }