public List <ModelViewUsers> GetAllList() { var NegocioEmpleado = new BusinessEmployee(); var NegocioModulos = new BusinessModuleService(); var usuarios = GetAll(); var empleados = NegocioEmpleado.GetAll(); var modulos = NegocioModulos.GetAll(); var lt = (from a in usuarios join b in empleados on a.UserID equals b.FK_UserID join c in modulos on b.FK_ModuleID equals c.ModuleID select new ModelViewUsers() { UserID = a.UserID, ProfileID = a.ProfileID, UserName = a.UserName, Name = a.Name, Email = a.Email, Status = a.Status, DateCreate = a.DateCreate, DateLastAccess = a.DateLastAccess, DateModification = a.DateModification, EmployyeID = b.EmployeeID, Module = c.ID + " - " + c.Base }).ToList(); return(lt); }
public List <ModelViewUserNotification> GetAllNotificationUsers(string ModuleID, string Name) { var NegocioUsuario = new BusinessUsers(); var NegocioEmpleado = new BusinessEmployee(); var NegocioModulosMabe = new BusinessModuleService(); // var usuarios = NegocioUsuario.GetActives().Where(p=> p.ProfileID == 4); var empleados = NegocioEmpleado.GetAll(); var modulos = new List <EntityModuleService>(); var usuarios = new List <ModelViewUserList>(); if (ModuleID != null) { int[] nums = ModuleID.Split(',').Select(int.Parse).ToArray(); modulos = NegocioModulosMabe.GetAll().Where(p => nums.Contains(p.ModuleID)).ToList(); } else { modulos = NegocioModulosMabe.GetAll(); } if (Name != "") { usuarios = NegocioUsuario.GetActives().Where(p => p.ProfileID == 4 && (p.Name.ToLower().Contains(Name.ToLower()) || p.UserName.Contains(Name))).ToList(); } else { usuarios = NegocioUsuario.GetActives(); } return((from a in usuarios join b in empleados on a.UserID equals b.FK_UserID join c in modulos on b.FK_ModuleID equals c.ModuleID select new ModelViewUserNotification() { UserID = a.UserID, Name = "(" + a.UserName + ")" + " " + b.FirstName + " " + b.LastName + " " + c.ID + " - " + c.Base }).ToList()); }
public List <ModelViewUserNotification> GetAllNotificationUsers(string Employee) { var NegocioUsuario = new BusinessUsers(); var NegocioEmpleado = new BusinessEmployee(); var NegocioModulosMabe = new BusinessModuleService(); var empleados = NegocioEmpleado.GetAll(); var modulos = new List <EntityModuleService>(); var usuarios = new List <ModelViewUserList>(); modulos = NegocioModulosMabe.GetAll(); int[] nums = Employee.Split(',').Select(int.Parse).ToArray(); usuarios = NegocioUsuario.GetActives().Where(p => nums.Contains(p.UserID)).ToList(); return((from a in usuarios join b in empleados on a.UserID equals b.FK_UserID join c in modulos on b.FK_ModuleID equals c.ModuleID select new ModelViewUserNotification() { UserID = a.UserID, Name = "(" + a.UserName + ")" + " " + b.FirstName + " " + b.LastName + " " + c.ID + " - " + c.Base }).ToList()); }