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 }