//public static List<Monstre> MonstreTriCagnotte(bool ascendant) //Tri des monstres par cagnotte //{ // List<Monstre> listeMonstres = ListeMonstres(); // if (!ascendant) // { // List<Monstre> orderedListDescending = listeMonstres.OrderByDescending(monstre => monstre.cagnotte).ToList(); // listeMonstres = new List<Monstre>(orderedListDescending); // return listeMonstres; // } // else // { // List<Monstre> orderedList = listeMonstres.OrderBy(monstre => monstre.cagnotte).ToList(); // listeMonstres = new SortableBindingList<Monstre>(orderedList); // return listeMonstres; // } //} public static void AttractionTriIdentifiant(bool ascendant) //Tri par ID { if (!ascendant) { List <Attraction> orderedListDescending = listeAttractions.OrderByDescending(attraction => attraction.identifiant).ToList(); listeAttractions = new SortableBindingList <Attraction>(orderedListDescending); } else { List <Attraction> orderedList = listeAttractions.OrderBy(attraction => attraction.identifiant).ToList(); listeAttractions = new SortableBindingList <Attraction>(orderedList); } }
public static void PersonnelTriMatricule(bool ascendant) //Tri par matricule { if (!ascendant) { List <Personnel> orderedListDescending = listePersonnel.OrderByDescending(personnel => personnel.matricule).ToList(); listePersonnel = new SortableBindingList <Personnel>(orderedListDescending); } else { List <Personnel> orderedList = listePersonnel.OrderBy(personnel => personnel.matricule).ToList(); listePersonnel = new SortableBindingList <Personnel>(orderedList); } }
private void SetupDataBinding() { try { // Use Load to query for entities before binding to the local collection. // (For further information see: http://msdn.microsoft.com/en-us/data/jj592911.aspx) this.DbContext.Categories.Include("Books").Load(); SortableBindingList <Book> bindingList = this.DbContext.Books.Local.ToSortableBindingList(); this.bindingSource1.DataSource = bindingList.OrderBy(b => b.Title); this.bindingNavigator1.BindingSource = this.bindingSource1; // // DataGridView Books // DataGridViewColumn[] arBooks = new DataGridViewColumn[this.dataGridViewBooks.Columns.Count]; this.dataGridViewBooks.Columns.CopyTo(arBooks, 0); this.dataGridViewBooks.Columns.Clear(); this.dataGridViewBooks.DataSource = this.bindingSource1; for (int i = 0; i < arBooks.Length; i++) { DataGridViewColumn col = arBooks[i]; this.dataGridViewBooks.Columns[i].Visible = col.Visible; this.dataGridViewBooks.Columns[i].Width = col.Width; this.dataGridViewBooks.Columns[i].HeaderText = col.HeaderText; this.dataGridViewBooks.Columns[i].DefaultCellStyle = col.DefaultCellStyle; } // // Text Boxes // this.textBoxBookId.DataBindings.Add("Text", this.bindingSource1, "ID"); this.textBoxTitle.DataBindings.Add("Text", this.bindingSource1, "Title"); this.textBoxCopyrightYear.DataBindings.Add("Text", this.bindingSource1, "CopyrightYear"); this.textBoxISBNNumber.DataBindings.Add("Text", this.bindingSource1, "ISBNNumber"); this.textBoxPublishingCompany.DataBindings.Add("Text", this.bindingSource1, "PublishingCompany"); this.textBoxPublisherName.DataBindings.Add("Text", this.bindingSource1, "PublisherName"); this.textBoxPublishingYear.DataBindings.Add("Text", this.bindingSource1, "PublishingYear"); this.textBoxPlaceOfPublication.DataBindings.Add("Text", this.bindingSource1, "PlaceOfPublication"); this.textBoxVolumeNumber.DataBindings.Add("Text", this.bindingSource1, "VolumeNumber"); this.textBoxEditionNumber.DataBindings.Add("Text", this.bindingSource1, "EditionNumber"); this.textBoxCoverType.DataBindings.Add("Text", this.bindingSource1, "CoverType"); this.textBoxPages.DataBindings.Add("Text", this.bindingSource1, "Pages"); this.textBoxLocation.DataBindings.Add("Text", this.bindingSource1, "Location"); this.textBoxNotes.DataBindings.Add("Text", this.bindingSource1, "Notes"); Binding b1 = this.textBoxPurchasePrice.DataBindings.Add("Text", this.bindingSource1, "PurchasePrice"); Binding b2 = this.textBoxDatePurchased.DataBindings.Add("Text", this.bindingSource1, "DatePurchased"); b2.Format += new ConvertEventHandler(DateFormat); Binding b3 = this.textBoxListPrice.DataBindings.Add("Text", this.bindingSource1, "ListPrice"); // // Picturebox // this.dataPictureBox1.DataBindings.Add("ImagePath", this.bindingSource1, "ImageUrl"); this.dataPictureBox2.DataBindings.Add("ImagePath", this.bindingSource1, "ImageUrl2"); this.dataPictureBox3.DataBindings.Add("ImagePath", this.bindingSource1, "ImageUrl3"); this.dataPictureBox4.DataBindings.Add("ImagePath", this.bindingSource1, "ImageUrl4"); // // DataGridView Authors // DataGridViewColumn[] arAuthors = new DataGridViewColumn[this.dataGridViewAuthors.Columns.Count]; this.dataGridViewAuthors.Columns.CopyTo(arAuthors, 0); this.dataGridViewAuthors.Columns.Clear(); this.dataGridViewAuthors.DataBindings.Add("DataSource", this.bindingSource1, "Authors"); for (int i = 0; i < arAuthors.Length; i++) { DataGridViewColumn col = arAuthors[i]; this.dataGridViewAuthors.Columns[i].Visible = col.Visible; this.dataGridViewAuthors.Columns[i].Width = col.Width; this.dataGridViewAuthors.Columns[i].HeaderText = col.HeaderText; this.dataGridViewAuthors.Columns[i].DefaultCellStyle = col.DefaultCellStyle; } // // DataGridView Categories // DataGridViewColumn[] arCategories = new DataGridViewColumn[this.dataGridViewCategories.Columns.Count]; this.dataGridViewCategories.Columns.CopyTo(arCategories, 0); this.dataGridViewCategories.Columns.Clear(); this.dataGridViewCategories.DataBindings.Add("DataSource", this.bindingSource1, "Categories"); for (int i = 0; i < arCategories.Length; i++) { DataGridViewColumn col = arCategories[i]; this.dataGridViewCategories.Columns[i].Visible = col.Visible; this.dataGridViewCategories.Columns[i].Width = col.Width; this.dataGridViewCategories.Columns[i].HeaderText = col.HeaderText; this.dataGridViewCategories.Columns[i].DefaultCellStyle = col.DefaultCellStyle; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }