public ViewModelOffer(MegaCastingEntities entities)
: base(entities)
{
/// <summary>
/// Permet d'affcter a Offer les entités de la liste des Offers
/// </summary>
this.Entities.Offers.ToList();
this.Offers = this.Entities.Offers.Local;
/// <summary>
/// Permet d'affcter a Citys les entités de la liste des cities
/// </summary>
this.Entities.Cities.ToList();
this.Citys = this.Entities.Cities.Local;
/// <summary>
/// Permet d'affcter a Producers les entités de la liste des Producers
/// </summary>
this.Entities.Producers.ToList();
this.Producers = this.Entities.Producers.Local;
/// <summary>
/// Permet d'affcter a Jobs les entités de la liste des jobs
/// </summary>
this.Entities.Jobs.ToList();
this.Jobs = this.Entities.Jobs.Local;
/// <summary>
/// Permet d'affcter a ContractTypes les entités de la liste des ContractTypes
/// </summary>
this.Entities.ContractTypes.ToList();
this.ContractTypes = this.Entities.ContractTypes.Local;
}
public MainWindow()
{
InitializeComponent();
#if DEBUG
this.Entities = new MegaCastingEntities();
#endif
#if RELEASE
this.Entities.ContractTypes.FirstOrDefault();
#endif
}
/// <summary>
/// Permet d'affcter a Job les entités de la liste des Jobs
/// </summary>
public ViewModelJob(MegaCastingEntities entities)
: base(entities)
{
/// <summary>
/// Permet d'affcter a Job les entités de la liste des Jobs
/// </summary>
this.Entities.Jobs.ToList();
this.Jobs = this.Entities.Jobs.Local;
/// <summary>
/// Permet d'affcter a Job les entités de la liste des DomainJobs
/// </summary>
this.Entities.DomainJobs.ToList();
this.DomainJobs = this.Entities.DomainJobs.Local;
}
public ViewModelProducer(MegaCastingEntities entities)
: base(entities)
{
/// <summary>
/// Permet d'affcter a Produers les entités de la liste des producers
/// </summary>
this.Entities.Producers.ToList();
this.Producers = this.Entities.Producers.Local;
/// <summary>
/// Permet d'affcter a Packs les entités de la liste des pack
/// </summary>
this.Entities.Packs.ToList();
this.Packs = this.Entities.Packs.Local;
}
public ViewModelHomeUser(MegaCastingEntities entities)
{
this.entities = entities;
}
static void Main(string[] args)
{
#region Presentation LinQ
#region Génération des données
#region Categories
_Categories = new List <Category>();
_Categories.Add(new Category("Brune"));
_Categories.Add(new Category("Blonde"));
_Categories.Add(new Category("Ambrée"));
#endregion
#region Beers
_Beers = new List <Beer>();
/// <summary>
///
/// </summary>
Category blondCategory = _Categories
.First(category => category.Name == "Blonde");
_Beers.Add(new Beer("Corona", 5, blondCategory));
_Beers.Add(new Beer("Despe", 4.7, blondCategory));
_Beers.Add(new Beer("Corona", 4.2, blondCategory));
_Beers.Add(new Beer("Chouffe", 7.6, blondCategory));
_Beers.Add(new Beer("La levrette", 3.5, blondCategory));
_Beers.Add(new Beer("La mort subite", 6, blondCategory));
_Beers.Add(new Beer("La lancelot", 4.2, blondCategory));
_Beers.Add(new Beer("La morgane", 5.5, blondCategory));
/// <summary>
///
/// </summary>
Category bitterCategory = _Categories
.First(category => category.Name == "Brune");
_Beers.Add(new Beer("Leffe rituelle", 12, bitterCategory));
_Beers.Add(new Beer("Bavaria", 9, bitterCategory));
_Beers.Add(new Beer("DrewDog IPA Dunk", 5, bitterCategory));
_Beers.Add(new Beer("Guinnes", 5, bitterCategory));
_Beers.Add(new Beer("Stephanus", 5, bitterCategory));
/// <summary>
///
/// </summary>
Category AmberCategory = _Categories
.First(category => category.Name == "Ambrée");
_Beers.Add(new Beer("Leffe ambrée", 6, AmberCategory));
_Beers.Add(new Beer("Kwak", 5, AmberCategory));
_Beers.Add(new Beer("Queue de charrue", 7.7, AmberCategory));
#endregion
#endregion
#region Exemple de requêtes linQ
//Nombre de bière total
_Beers.Count();
_Beers.ForEach(beer => Console.WriteLine(beer.Name));
//Attend la saisie d'une touch
Console.ReadKey();
Console.WriteLine("1 - Nombre de bière : " + _Beers.Count().ToString());
//La somme des degrées des bières brunes
_Beers
.Where(beer => beer.Category.Name == "Brune")
.Sum(beer => beer.Degrees).ToString();
Console.ReadKey();
//La liste des catégories en passant par les bières
_Beers
.Select(beer => beer.Category)
.Distinct() //enleve les doublon
.ToList() //on les mets en format list
.ForEach(category => Console.WriteLine(category.Name));
Console.ReadKey();
//La liste des bières blondes
_Beers
.Where(beer => beer.Category.Name == "Blonde")
.ToList()
.ForEach(beer => Console.WriteLine(beer.Name));
//La liste des bières à 6°
_Beers
.Where(beer => beer.Degrees == 6)
.ToList()
.ForEach(beer => Console.WriteLine(beer.Degrees));
//Les bière les plus forte
List <Beer> beers = _Beers
.Where(beer => beer.Degrees >= _Beers
.Select(beerTemp => beerTemp.Degrees)
.Max()
).ToList();
Console.WriteLine("Les bières les plus fortes (" + _Beers
.Max(beer => beer.Degrees) + "°) :");
beers.ForEach(beer => Console.WriteLine(beer.Name));
#endregion
#endregion
#region Présentation EF
MegaCastingEntities entities = new MegaCastingEntities();
entities.Offers
.Where(offer => offer.City == "Laval");
#endregion
}
/// <summary>
/// Permet d'affcter a Packs les entités de la liste des Packs
/// </summary>
public ViewModelPackageCasting(MegaCastingEntities entities)
: base(entities)
{
this.Entities.Packs.ToList();
this.Packs = this.Entities.Packs.Local;
}
public ViewModelHomeJob(MegaCastingEntities entities) : base(entities)
{
this.Entities.Jobs.ToList();
this.Jobs = this.Entities.Jobs.Local;
}
/// <summary>
/// COntructeur par défault d'un ViewModelBase
/// </summary>
public ViewModelBase()
{
this.Entities = new MegaCastingEntities();
}
/// <summary>
/// Permet d'affcter a ContractTypes les entités de la liste des types de contrats
/// </summary>
/// <param name="entities"></param>
public ViewModelContractType(MegaCastingEntities entities)
: base(entities)
{
this.Entities.ContractTypes.ToList();
this.ContractTypes = this.Entities.ContractTypes.Local;
}
public ViewModelMainWindows(MegaCastingEntities entities)
: base(entities)
{
}
/// <summary>
///
/// </summary>
/// <param name="entities"></param>
public ViewModelBase(MegaCastingEntities entities)
{
this.Entities = entities;
}
static void Main(string[] args)
{
#region Présentation LinQ
#region Datas generation
#region Categories
_Categories = new List <Category>();
_Categories.Add(new Category("Brune"));
_Categories.Add(new Category("Blonde"));
_Categories.Add(new Category("Ambrée"));
#endregion
#region Bières
_Beers = new List <Beer>();
Category blondCategory = _Categories
.First(category => category.Name == "Blonde");
_Beers.Add(new Beer("Leffe", 5, blondCategory));
_Beers.Add(new Beer("Despe", 4.7, blondCategory));
_Beers.Add(new Beer("Corona", 4.2, blondCategory));
_Beers.Add(new Beer("Chouffe", 7.2, blondCategory));
_Beers.Add(new Beer("La levrette", 3.5, blondCategory));
_Beers.Add(new Beer("La mort subite", 6, blondCategory));
_Beers.Add(new Beer("La lancelot", 4.2, blondCategory));
_Beers.Add(new Beer("La morgane", 5.5, blondCategory));
Category bitterCategory = _Categories
.First(category => category.Name == "Brune");
_Beers.Add(new Beer("Leffe rituelle", 12, bitterCategory));
_Beers.Add(new Beer("Bavaria", 9, bitterCategory));
_Beers.Add(new Beer("BrewDog IPA Punk", 5, bitterCategory));
_Beers.Add(new Beer("Guinness", 5, bitterCategory));
_Beers.Add(new Beer("Stephanus", 5, bitterCategory));
Category amberCategory = _Categories
.First(category => category.Name == "Ambrée");
_Beers.Add(new Beer("Leffe ambrée", 9, amberCategory));
_Beers.Add(new Beer("Kwak", 8, amberCategory));
_Beers.Add(new Beer("Queue de charrue", 7.7, amberCategory));
#endregion
#endregion
#region Exemple de requêtes linQ
Console.WriteLine("bwahhh");
Console.ReadKey(); // Attend la saisie d'une touche
//Nombre de bière total
Console.WriteLine("1 - Nombre de bières : " + _Beers.Count().ToString());
//Afficher toutes les bières
_Beers.ForEach(beer => Console.WriteLine(beer.Name));
// La somme des degrées des bières brunes
Console.WriteLine("2 - Degrés totaux : "
+ _Beers
.Where(beer => beer.Category.Name == "Brune")
.Sum(beer => beer.Degrees)
.ToString());
// La liste des catégories en passant par les bières (faisable en deux fois si trop complexe pour vous)
Console.WriteLine("3 - Listes des catégories : ");
_Beers
.Select(beer => beer.Category)
.Distinct()
.ToList()
.ForEach(category => Console.WriteLine(category.Name));
Console.ReadKey();
// La liste des bières blondes
_Beers.Where(beer => beer.Category.Name == "Blonde")
.ToList()
.ForEach(beer => Console.WriteLine(beer.Name));
// La liste des bières à 6 degrés
_Beers.Where(beer => beer.Degrees == 6)
.ToList()
.ForEach(beer => Console.WriteLine(beer.Name));
// Les bières les plus fortes
List <Beer> beers = _Beers.Where(beer => beer.Degrees >= _Beers
.Select(beerTemp => beerTemp.Degrees)
.Max()
).ToList();
Console.WriteLine("Les bières les plus fortes (" + _Beers
.Max(beer => beer.Degrees) + "°) :");
beers.ForEach(beer => Console.WriteLine(beer.Name));
Console.ReadKey();
#endregion
#endregion
#region Présentation EF
MegaCastingEntities entities = new MegaCastingEntities();
entities.Countries.Where(country => country.Name == "France");
#endregion
}
