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