public static List <TipoPerfil> SelecionarTodos()
{
using (PROJETOACADEMIAEntities db = new PROJETOACADEMIAEntities())
{
var res = (from p in db.TipoPerfil select p).ToList();
db.Dispose();
return(res);
}
}
public static List <Ferias> SelecionarPeriodoIgual(int idAluno, DateTime data)
{
using (PROJETOACADEMIAEntities db = new PROJETOACADEMIAEntities())
{
var res = (from p in db.Ferias where p.idAluno == idAluno && p.dataInicio <= data && p.dataFim >= data select p).ToList();
db.Dispose();
return(res);
}
}
public static List <Pagamento> SelecionarTodos(int idAluno)
{
using (PROJETOACADEMIAEntities db = new PROJETOACADEMIAEntities())
{
var res = (from p in db.Pagamento where p.idAluno == idAluno select p).ToList();
db.Dispose();
return(res);
}
}
public static List <Ferias> SelecionarTodos(int idAluno, DateTime databaseFim)
{
using (PROJETOACADEMIAEntities db = new PROJETOACADEMIAEntities())
{
var res = (from p in db.Ferias where p.idAluno == idAluno && p.dataBaseFimPagamento == databaseFim select p).ToList();
db.Dispose();
return(res);
}
}
