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