public CustomResponse Delete(int id)
{
try
{
using (var context = new UserManagementContext())
{
Users user = context.Users.Where(x => x.Id == id).FirstOrDefault();
if (user != null)
{
context.Users.Remove(user);
context.SaveChanges();
return(new CustomResponse {
State = 200, Message = "Eliminación exitoso"
});
}
else
{
return(new CustomResponse {
State = 405, Message = "Usuario no encontrado"
});
}
}
}
catch (Exception ex)
{
return(new CustomResponse {
State = 500, Message = ex.Message.ToString()
});
}
}
public CustomResponse GetAllUsers()
{
try
{
UserManagementContext context = new UserManagementContext();
var objectList = context.Users.Select(user => new UsersDto
{
Id = user.Id,
Username = user.Username,
Password = user.Password,
Fullname = user.Fullname,
Address = user.Address,
Phone = user.Phone,
Email = user.Email,
Age = user.Age,
RolesId = user.RolesId,
Roles = new RolesDto {
Id = user.Roles.Id, Role = user.Roles.Role
},
Permissions = user.Roles.PermissionsRoles.Select(permissions => permissions.Permission).ToList()
}).ToList();
return(new CustomResponse {
State = 200, Message = "Listado exitoso", Custom = objectList
});
}
catch (Exception ex)
{
return(new CustomResponse {
State = 500, Message = ex.Message.ToString()
});
}
}
//Takes usergroup object and replaces/adds connection between user and group in database
public dynamic changeGroup(UserGroup ugc)
{
var dc = new UserManagementContext();
if (ugc.gid != -1)
{
if (dc.UserGroup.Any(o => o.uid == ugc.uid))
{
UserGroup ug = dc.UserGroup.Where(o => o.uid == ugc.uid).Single();
dc.UserGroup.Attach(ug);
dc.UserGroup.Remove(ug);
dc.SaveChanges();
dc.Add(ugc);
}
else
{
dc.Add(ugc);
}
}
else
{
if (dc.UserGroup.Any(o => o.uid == ugc.uid))
{
UserGroup ug = dc.UserGroup.Where(o => o.uid == ugc.uid).Single();
dc.UserGroup.Attach(ug);
dc.UserGroup.Remove(ug);
dc.Add(ugc);
}
}
dc.SaveChanges();
return(getUserGroups());
}
public bool Exist(string name)
{
using (var context = new UserManagementContext())
{
return(context.Projects.Any(e => e.Name.ToLower() == name.ToLower()));
}
}
public ICollection <Project> GetAll()
{
using (var context = new UserManagementContext())
{
return(context.Projects.ToList());
}
}
public CustomResponse Put(int id, [FromBody] Users user)
{
try
{
if (id != user.Id)
{
return(new CustomResponse {
State = 400, Message = "Error en la solicitud, deben coincidir los ids"
});
}
using (var context = new UserManagementContext())
{
context.Entry(user).State = EntityState.Modified;
context.Entry(user).Property(x => x.Password).IsModified = false;
context.SaveChanges();
}
return(new CustomResponse {
State = 200, Message = "Modificación exitosa"
});
}
catch (Exception ex)
{
return(new CustomResponse {
State = 500, Message = ex.Message.ToString()
});
}
}
public RequestToConfirmUserAccountLoanEventHandler(
UserManagementContext userContext,
IUserManagementIntegrationEventService userIntegrationEventService,
ILogger <RequestToConfirmUserAccountLoanEventHandler> logger)
{
_userContext = userContext;
_userIntegrationEventService = userIntegrationEventService;
_logger = logger ?? throw new System.ArgumentNullException(nameof(logger));
}
public int Add(Project project)
{
using (var context = new UserManagementContext())
{
context.Projects.Add(project);
context.SaveChanges();
return(project.Id);
}
}
public UserManagementService(
UserManagementContext userContext,
IMapper autoMapper)
{
this._userContext = userContext ?? throw new ArgumentNullException(nameof(userContext));
this._autoMapper = autoMapper;
// Do not track entity changes
this._userContext.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
}
public UserManagementIntegrationEventService(
ILogger <UserManagementIntegrationEventService> logger,
IEventBus eventBus,
UserManagementContext userContext,
Func <DbConnection, IIntegrationEventLogService> integrationEventLogServiceFactory)
{
_logger = logger ?? throw new ArgumentNullException(nameof(logger));
_usersContext = userContext ?? throw new ArgumentNullException(nameof(userContext));
_integrationEventLogServiceFactory = integrationEventLogServiceFactory ?? throw new ArgumentNullException(nameof(integrationEventLogServiceFactory));
_eventBus = eventBus ?? throw new ArgumentNullException(nameof(eventBus));
_eventLogService = _integrationEventLogServiceFactory(_usersContext.Database.GetDbConnection());
}
public UserManagementServiceTest()
{
var dbContextOptionBuilder = new DbContextOptionsBuilder <UserManagementContext>().UseInMemoryDatabase(databaseName: "temp");
var userContext = new UserManagementContext(dbContextOptionBuilder.Options);
var mappingConfiguration = new MapperConfiguration(mc => {
mc.CreateMap <List <User>, List <UserViewModel> >();
mc.CreateMap <CreateUserViewModel, User>();
});
this.mapper = new AutoMapper.Mapper(mappingConfiguration);
this.userManagementService = new UserManagementService(userContext, this.mapper);
}
public UsersController(ILogger <UsersController> logger,
UserManagementContext dbcontext,
UserManager <ApplicationUser> userManager,
RoleManager <IdentityRole> roleManager,
IConfiguration configuration)
{
_logger = logger;
_dbcontext = dbcontext;
_userManager = userManager;
_roleManager = roleManager;
_configuration = configuration;
// Create an instance of AutoMapper to make it easier to clean models for data transfer.
var config = new MapperConfiguration(cfg => cfg.CreateMap <ApplicationUser, User>());
_mapper = new Mapper(config);
}
public UserAPIControllerTest()
{
// Use database to test here, we could mock UserManagementContext if we only need to test controller.
var optionsBuilder = new DbContextOptionsBuilder <UserManagementContext>();
optionsBuilder.UseSqlServer(@"Server=localhost\SQLExpress;Database=UserManagement;UID=sa;PWD=Abcd1234;");
UserManagementContext domainContext = new UserManagementContext(optionsBuilder.Options);
// Auto Mapper Configurations
var mappingConfig = new MapperConfiguration(mc =>
{
mc.AddProfile(new MappingProfile());
});
IMapper mapper = mappingConfig.CreateMapper();
usersController = new UserAPIController(new UserRepository(domainContext, mapper));
}
public CustomResponse Get(int id)
{
try
{
var context = new UserManagementContext();
var objectUser = context.Users.Where(u => u.Id == id).Select(user => new UsersDto
{
Id = user.Id,
Username = user.Username,
Password = user.Password,
Fullname = user.Fullname,
Address = user.Address,
Phone = user.Phone,
Email = user.Email,
Age = user.Age,
RolesId = user.RolesId,
Roles = new RolesDto {
Id = user.Roles.Id, Role = user.Roles.Role
},
Permissions = user.Roles.PermissionsRoles.Select(permissions => permissions.Permission).ToList()
}).FirstOrDefault();
if (objectUser is null)
{
return new CustomResponse {
State = 405, Message = "Usuario no encontrado"
}
}
;
else
{
return new CustomResponse {
State = 200, Message = "Usuario encontrado", Custom = objectUser
}
};
}
catch (Exception ex)
{
return(new CustomResponse {
State = 500, Message = ex.Message.ToString()
});
}
}
public CustomResponse GetAllRoles()
{
try
{
UserManagementContext context = new UserManagementContext();
var objectList = context.Roles.Select(role => new RolesDto
{
Id = role.Id,
Role = role.Role
}).ToList();
return(new CustomResponse {
State = 200, Message = "Listado exitoso", Custom = objectList
});
}
catch (Exception ex)
{
return(new CustomResponse {
State = 500, Message = ex.Message.ToString()
});
}
}
public CustomResponse Post([FromBody] Users user)
{
try
{
using (var context = new UserManagementContext())
{
context.Users.Add(user);
context.SaveChanges();
}
return(new CustomResponse {
State = 200, Message = "Creación exitosa"
});
}
catch (Exception ex)
{
return(new CustomResponse {
State = 500, Message = ex.Message.ToString()
});
}
}
public UserService()
{
_dc = new UserManagementContext();
}
public TokenFactory(UserManagementContext db)
{
this.db = db;
}
public HospitalService(UserManagementContext db, IMapper mapper)
{
_db = db;
_mapper = mapper;
}
public UserRepository(UserManagementContext userManagementcontext)
{
this.userManagementContext = userManagementcontext ?? throw new ArgumentNullException(nameof(userManagementcontext));
}
public HospitalController(UserManagementContext db, IMapper mapper)
{
_service = new HospitalService(db, mapper);
}
public UserRepository(UserManagementContext _db, IMapper _mapper)
{
db = _db;
mapper = _mapper;
}
public UserRepository(UserManagementContext context) : base(context)
{
this._dbContext = context;
}
} //db context
public MainWindow()
{
InitializeComponent();
dbContext = new UserManagementContext(dbName); //connect to db
}
public AuthorizationPipelineItem(UserManagementContext context, CallContext callContext)
{
this.context = context;
this.callContext = callContext;
}
public UserManagementRepository(UserManagementContext context)
{
_context = context;
_dbSet = _context.Set <T>();
}
public UserManagementUnitOfWork(UserManagementContext context)
{
_context = context;
}
public UserViewRepository(UserManagementContext dbContext) : base(dbContext)
{
}
public UserViewSearcher(UserManagementContext db)
{
this.db = db;
}
public UserSearcher(UserManagementContext context)
{
this.context = context;
}
