public List <FiltroTurnosViewModels> GetAll() { try { using (PwaEntities context = new PwaEntities()) { var query = context.FiltroTurnos .ToList(); if (query == null) { return(null); } List <FiltroTurnosViewModels> lst = new List <FiltroTurnosViewModels>(); var resp_lst = query.AsEnumerable() .Select(o => new FiltroTurnosViewModels { Id = o.IdFiltroHorario, Descripcion = o.Descripcion }).ToList().OrderBy(x => x.Id.ToString()); lst.AddRange(resp_lst); return(lst); } } catch (Exception ex) { throw ex; } }
public List <MedicoViewModels> GetAllByEspecialidad(int idespecialidad) { try { using (PwaEntities context = new PwaEntities()) { var query = context.Profesionales.Where(x => x.IdEspecialidad == idespecialidad) .ToList(); if (query == null) { return(null); } List <MedicoViewModels> lst = new List <MedicoViewModels>(); var resp_lst = query.AsEnumerable() .Select(o => new MedicoViewModels { Id = o.IdProfesional, Nombre = o.Nombre, Apellido = o.Apellido, IdEspecialidad = o.IdEspecialidad }).ToList().OrderBy(x => x.Id.ToString()); lst.AddRange(resp_lst); return(lst); } } catch (Exception ex) { throw ex; } }