public static void Incluir(Ferias oFerias)
{
using (PROJETOACADEMIAEntities db = new PROJETOACADEMIAEntities())
{
db.Ferias.Add(oFerias);
db.SaveChanges();
}
}
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 <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);
}
}