public async Task <List <DREsDTO> > GetCodeDreAdm(string userName) { try { using (Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { var user = db.PrivilegedAccess.Where(x => x.Login == userName).FirstOrDefault(); if (user != null && !string.IsNullOrEmpty(user.DreCodeEol)) { var dreApi = new DREAPI(endPoint); return(await dreApi.GetDresPorCodigo(user.DreCodeEol, _token)); } else { return(null); } } } catch (Exception) { throw; } }
public List <MathPoolNumber> BuscarAlunosTurmaRelatorioMatematicaNumber(string turmaEol, string proficiencia, string term) { var liststudentPoll = new List <StudentPollMatematica>(); var listStudentsPoll = new List <MathPoolNumber>(); using (Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { switch (term) { case "1° Semestre": listStudentsPoll = db.MathPoolNumbers.Where(x => x.TurmaEolCode == turmaEol && x.Semestre.Equals(1)).ToList(); break; case "2° Semestre": listStudentsPoll = db.MathPoolNumbers.Where(x => x.TurmaEolCode == turmaEol && x.Semestre.Equals(2)).ToList(); break; default: break; } } return(listStudentsPoll); }
public static async Task <bool> RegisterUser(string username, string password) { using (Data.Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { Models.Authentication.User user = await (from current in db.Users.Include(".Roles") where current.Name == username select current).FirstOrDefaultAsync(); if (user == null) { user = new Models.Authentication.User() { Name = username, Password = Functionalities.Cryptography.HashPassword(password) }; await db.Users.AddAsync(user); await db.SaveChangesAsync(); return(true); } return(false); } }
public static async Task <UserRole> GetUserRoleById(string id) { using (var db = new Contexts.SMEManagementContextData()) { return(await db.UserRoles.FirstOrDefaultAsync(x => x.Id.ToUpper().Equals(id.ToUpper()))); } }
public static bool ResetSenhaPadrão(ResetPasswordDTO credentials, out IEnumerable <string> validationErrors) { using (Data.Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { User user = (from current in db.Users where current.Name == credentials.Username select current).FirstOrDefault(); validationErrors = default; if (user != null) { validationErrors = ValidatePassword(credentials, user); if (validationErrors.Count() < 1) { user.Password = Cryptography.HashPassword(credentials.NewPassword); return(db.SaveChanges() > 0); } } return(false); } }
public static async Task <List <Models.Authentication.UserRole> > GetUserRoles(string username) { using (Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { List <Models.Authentication.UserRole> userRoles = await (from current in db.UserRoles.Include(".User").Include(".Role").Include(".AccessLevel") where current.User.Name == username select current).ToListAsync(); return(userRoles); } }
// Corrigir esste método private static async Task <Models.Authentication.User> GetUserById(string id) { using (Data.Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { Models.Authentication.User user = await (from current in db.Users.Include(".Profile.Roles") where current.Id == id select current).FirstOrDefaultAsync(); return(user); } }
public async Task <List <PeriodoDeAbertura> > GetPeriodoDeAberturas(string schoolYear) { try { using (Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { var teste = db.AccessLevels; var listaPeriodoAbertura = db.PeriodoDeAberturas.Where(x => x.Ano == schoolYear).ToList(); return(listaPeriodoAbertura); } } catch (System.Exception ex) { throw ex; } }
public static async Task <bool> ResetSenha(string username, string newPassword) { using (Data.Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { Models.Authentication.User user = await (from current in db.Users where current.Name == username select current).FirstOrDefaultAsync(); if (user != null) { user.Password = Functionalities.Cryptography.HashPassword(newPassword); await db.SaveChangesAsync(); return(true); } } return(false); }
public static PrivilegedAccessModel ValidatePrivilegedUser(string username) { using (Data.Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { var user = db.PrivilegedAccess.Where(x => x.Login == username).FirstOrDefault(); if (user != null) { var userPrivileged = new PrivilegedAccessModel() { Login = user.Login, Name = user.Name, OccupationPlace = user.OccupationPlace, OccupationPlaceCode = user.OccupationPlaceCode, }; return(userPrivileged); } return(null); } }
public static async Task <bool> SetRole(string username, string roleName, string accessLevelValue, Guid perfil) { using (Contexts.SMEManagementContextData db = new Contexts.SMEManagementContextData()) { var user = await (from current in db.Users where current.Name.Equals(username) select current).FirstOrDefaultAsync(); if (user == null) { return(false); } var role = await (from current in db.Roles where current.Name.Equals(roleName) select current).FirstOrDefaultAsync(); if (role == null) { return(false); } var accessLevel = await (from current in db.AccessLevels where current.Value.Equals(accessLevelValue) select current).FirstOrDefaultAsync(); if (accessLevel == null) { return(false); } var userRole = await (from current in db.UserRoles where current.AccessLevelId.Equals(accessLevel.Id) && current.RoleId.Equals(role.Id) && current.UserId.Equals(user.Id) && current.PerfilId.Equals(perfil) select current).FirstOrDefaultAsync(); if (userRole != null) { return(true); } userRole = new Models.Authentication.UserRole() { User = user, Role = role, AccessLevel = accessLevel, PerfilId = perfil }; await db.UserRoles.AddAsync(userRole); await db.SaveChangesAsync(); return(true); } }