private void btnUpdateClick(object sender, RoutedEventArgs e)
{
taJeux.Update(dsJeux);
taJeux = new teamxboxliveDataSetTableAdapters.jeuxTableAdapter();
taJeux.Fill(dsJeux);
var jeuxQuery = from je in dsJeux where je.jeux_id == jeuxId select je;
dtGridGame.ItemsSource = jeuxQuery.ToArray();
Console.WriteLine("Update !");
}
public UserControlModifJeux(int id){
InitializeComponent();
taJeux = new teamxboxliveDataSetTableAdapters.jeuxTableAdapter();
dsJeux = new teamxboxliveDataSet.jeuxDataTable();
taJeux.Fill(dsJeux);
jeuxId = id;
var jeuxQuery = from je in dsJeux where (je.jeux_id == id) select je;
dtGridGame.ItemsSource = jeuxQuery.ToArray();
}
private void btnAjouter_click(object sender, RoutedEventArgs e)
{
string libelle = tbxLibelle.Text;
int consoleId = int.Parse(tbxConsoleId.Text);
teamxboxliveDataSetTableAdapters.jeuxTableAdapter taJeux = new teamxboxliveDataSetTableAdapters.jeuxTableAdapter();
taJeux.InsertQueryJeux(libelle,consoleId);
tbxLibelle.Text = "";
tbxConsoleId.Text = "";
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
taJeux = new teamxboxliveDataSetTableAdapters.jeuxTableAdapter();
dsJeux = new teamxboxliveDataSet.jeuxDataTable();
taJeux.Fill(dsJeux);
if (!System.ComponentModel.DesignerProperties.GetIsInDesignMode(this))
{
//Chargez vos données ici et assignez le résultat à CollectionViewSource.
System.Windows.Data.CollectionViewSource myCollectionViewSource = (System.Windows.Data.CollectionViewSource)this.Resources["Resource Key for CollectionViewSource"];
cboJeux.ItemsSource = dsJeux;
}
}
private void btnGameClick(object sender, RoutedEventArgs e)
{
Button btn = (Button)sender;
frameUserControl.IsEnabled = true;
if(btn == btnAddGame){
ControlAddJeux = new UserControlAddJeux();
ControlAddJeux.btnAnnuler_clicked += controlGameClosed;
frameUserControl.Content = ControlAddJeux;
}else if(btn == btnModifierJeux){
int column = 0;
if(dtGridJeux.SelectedIndex != -1){
string idJeux = "" + ((DataRowView)dtGridJeux.SelectedItem).Row.ItemArray[column];
ControlModifJeux = new UserControlModifJeux(int.Parse(idJeux));
ControlModifJeux.btnAnnuler_clicked += controlGameClosed;
frameUserControl.Content = ControlModifJeux;
}
}else if(btn == btnSupprimerJeux){
if(dtGridMembres.SelectedIndex != -1){
int column = 0;
string idJeux = "" + ((DataRowView)dtGridJeux.SelectedItem).Row.ItemArray[column];
teamxboxliveDataSetTableAdapters.jeuxTableAdapter taMembres = new teamxboxliveDataSetTableAdapters.jeuxTableAdapter();
taMembres.DeleteQueryById(int.Parse(idJeux));
actualiserTbGridJeux();
}
}
}
