public bool ExitDefaultLevel(int projectId)
{
using (var db = new ContextDB.IncidencPlusDBContext())
{
return(db.Levels.Any(_ => _.ProjectID == projectId && _.IsDefault == true));
}
}
public List <Level> GetLevelsByProjectID(int id)
{
using (var db = new ContextDB.IncidencPlusDBContext())
{
var levels = db.Levels.Where(c => c.ProjectID == id).ToList();
return(levels);
}
}
public List <Category> GetCategoriesByProjectID(int id)
{
using (var db = new ContextDB.IncidencPlusDBContext())
{
var categories = db.Categories.Where(c => c.ProjectID == id).ToList();
return(categories);
}
}
public User ValidateCredential(User user)
{
using (var db = new ContextDB.IncidencPlusDBContext())
{
var userTemp = db.Users.Include(_ => _.Rol).Where(_ => _.UserName.ToUpper() == user.UserName.ToUpper() && _.Password.ToUpper() == user.Password.ToUpper()).FirstOrDefault();
if (userTemp != null)
{
return(userTemp);
}
return(null);
}
}
public override List <User> GetAll()
{
using (var db = new ContextDB.IncidencPlusDBContext())
{
var result = db.Users.Include(_ => _.Rol).ToList();
return(result.Select(_ => new User()
{
Id = _.Id,
Name = _.Name,
Email = _.Email,
UserName = _.UserName,
Rol = new Rol()
{
Id = _.Rol.Id,
Name = _.Rol.Name,
Description = _.Rol.Description
}
}).ToList());;
}
}
