public static IEnumerable <SelectListItem> UserOrders(string UserId) { using (var db = new GestionaleDB()) { var user = db.Users.FirstOrDefault(x => x.UserId == UserId); if (user == null) { return(new SelectListItem[0]); } var ordUsr = user.UserOrders.Where(x => !x.Order.Closed) .Select(x => new SelectListItem { Value = x.OrderId, Text = x.Order.Description }).ToArray(); var ordTL = db.Orders.Where(x => !x.Closed && x.TeamLeaderId == UserId) .Select(x => new SelectListItem { Value = x.OrderId, Text = x.Description }).ToArray(); return(ordUsr.Union(ordTL, new ComparerSLI())); } }
public static IEnumerable <SelectListItem> UserRoles() { using (var db = new GestionaleDB()) { return(db.UserRoles.OrderBy(x => x.Id).ToArray() .Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Value })); } }
public static IEnumerable <SelectListItem> HoursProfiles() { using (var db = new GestionaleDB()) { return(db.HoursProfiles.OrderBy(x => x.Id).ToArray() .Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Description })); } }
public static IEnumerable <SelectListItem> Users() { using (var db = new GestionaleDB()) { return(db.Users.Where(x => x.UserId != "Admin") .ToArray() .OrderBy(x => x.RoleId) .ThenBy(x => x.LastName) .ThenBy(x => x.FirstName) .Select(x => new SelectListItem { Value = x.UserId, Text = x.LastName + " " + x.FirstName, })); //.ToArray() //.OrderBy(x => x.Text); } }