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 void SaveSecureSiteData(SecureSiteData secureSiteData) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { dbContext.SecureSiteData.AddOrUpdate(secureSiteData); dbContext.SaveChanges(); } }
public void Log(AccessLog logEntity) { using (UsersLibDbContext dbContext = new UsersLibDbContext()) { dbContext.AccessLog.Add(logEntity); dbContext.SaveChanges(); } }
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 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 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 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(); } } }