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