//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());
}
}
