public static IEnumerable <Territoire> WherePrestation(int id)
{
var territoires = DAO.GetDbSet <Prestation_Territoire>()
.Where(pt => pt.Prestation.ID == id)
.ToList()
.Select(pt => pt.Territoire).ToList();
return(territoires);
}
public static Prestation_Territoire Where(int prestationId, int territoireId, Func <Prestation_Territoire> callBackIfNull)
{
var ret = DAO.GetDbSet <Prestation_Territoire>().SingleOrDefault(pt => pt.Prestation.ID == prestationId && pt.Territoire.ID == territoireId);
if (ret == null)
{
return(callBackIfNull());
}
return(ret);
}
public static Pole First()
{
return(DAO.GetDbSet <Pole>().First());
}
public static Pole WherePrestation(int id)
{
return(DAO.GetDbSet <Pole>()
.Single(x => x.Prestations.Select(get => get.ID).Contains(id)));
}
public static IEnumerable <Activite> FindByName(string name)
{
return(DAO.GetDbSet <Activite>().Where(x => x.Nom == name));
}
public static IEnumerable <Territoire> All()
{
return(DAO.GetDbSet <Territoire>());
}
public static IEnumerable <Territoire> Find(IEnumerable <int> ids)
{
var set = DAO.GetDbSet <Territoire>().AsEnumerable().Where(x => ids.Contains(x.ID));
return(set);
}
public static Prestation First()
{
return(DAO.GetDbSet <Prestation>().First());
}
public static Prestation_Territoire Where(int prestationId, int territoireId)
{
return(DAO.GetDbSet <Prestation_Territoire>().Single(pt => pt.Prestation.ID == prestationId && pt.Territoire.ID == territoireId));
}
public static IEnumerable <Prestation_Territoire> WherePrestation(int id)
{
return(DAO.GetDbSet <Prestation_Territoire>().Where(pt => pt.Prestation.ID == id));
}