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