public static void DeleteTypeConges(TypeConges typeConges)
{
using (var db = new MineBricksContext())
{
db.Remove(typeConges);
db.SaveChanges();
}
}
public static void AddTypeConges(TypeConges typeConges)
{
using (var db = new MineBricksContext())
{
db.Add(typeConges);
db.SaveChanges();
}
}
public Conges(DateTime dateAbsenceDebut, DateTime dateAbsenvceFin, int iD_Personne, Personne personne, int iD_TypeConges, TypeConges typeConges)
{
DateAbsenceDebut = dateAbsenceDebut;
DateAbsenceFin = dateAbsenvceFin;
ID_Personne = iD_Personne;
Personne = personne;
ID_TypeConges = iD_TypeConges;
TypeConges = typeConges;
}
public static int GetNombreCongeRestant(TypeConges typeConges)
{
int nb;
using (var db = new MineBricksContext())
{
nb = Convert.ToInt32(db.Conges
.Where(c => c.TypeConges == typeConges)
.Select(c => (c.DateAbsenceFin - c.DateAbsenceDebut).Days));
}
return(nb);
}
