public void Update(DalRole entity) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); Roles role = context.Set<Roles>().FirstOrDefault(r => r.id == entity.Id); role.Name = entity.Name; }
public void Delete(DalRole e) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); Roles role = context.Set<Roles>().FirstOrDefault(r => r.id == e.Id); context.Set<Roles>().Remove(role); }
public void Create(DalRole e) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); Roles role = new Roles() { id = e.Id, Name = e.Name }; context.Set<Roles>().Add(role); }
public void SetRole(DalUser user, DalRole role) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); Users ormuser = context.Set<Users>().FirstOrDefault(users => users.id == user.Id); Roles ormrole = context.Set<Roles>().FirstOrDefault(roles => roles.id == role.Id); ormuser.Roles.Add(ormrole); }
public IEnumerable<DalUser> GetByRole(DalRole role) { if (context.Database.Connection.State != ConnectionState.Open) context.Database.Connection.Open(); Roles r = context.Set<Roles>().FirstOrDefault(roles => roles.id == role.Id); IEnumerable<Users> users = context.Set<Users>().Where(user => user.Roles.Contains(r)).AsEnumerable(); List<DalUser> result = new List<DalUser>(); foreach (Users u in users) { result.Add(new DalUser() { Id = u.id, Login = u.Login, Email = u.Email, FirstName = u.FirstName, SecondName = u.SecondName, ThirdName = u.ThirdName, PasswordHash = u.PasswordHash }); } return result; }