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();
}
}
}