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