private void btn_modifier_Click(object sender, RoutedEventArgs e) { try { if (comb_client.Text == string.Empty || comb_nom_voiture_marque.Text == string.Empty || comb_nom_voiture_model.Text == string.Empty || comb_client.Text == string.Empty) { MessageBox.Show("Saisir tout les information ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); } else { var db = dbContext.Resevations; foreach (var rese in db) { if (comb_client.SelectedIndex == -1) { MessageBox.Show("Ce Client n'existe pas ! ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); comb_client.Focus(); return; } else if (comb_nom_voiture_marque.SelectedIndex == -1) { MessageBox.Show("cette marque n'existe pas ! ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); comb_nom_voiture_marque.Focus(); return; } else if (comb_nom_voiture_model.SelectedIndex == -1) { MessageBox.Show("cette model n'existe pas ! ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); comb_nom_voiture_model.Focus(); return; } } int IDReserv = int.Parse(txt_id.Text); Resevation rs = (from r in dbContext.Resevations where r.ID_Reservation == IDReserv select r).First(); rs.ID_Reservation = int.Parse(txt_id.Text); rs.ID_Client = int.Parse(comb_client.SelectedValue.ToString()); rs.ID_Marque = int.Parse(comb_nom_voiture_marque.SelectedValue.ToString()); rs.ID_Model = int.Parse(comb_nom_voiture_model.SelectedValue.ToString()); if (txt_avance.Text == string.Empty) { txt_avance.Text = Convert.ToString(0); } rs.Avance = Convert.ToInt32(txt_avance.Text); rs.Date_D = Convert.ToDateTime(DTP_debut.SelectedDate.Value.ToString()); rs.Date_F = Convert.ToDateTime(DTP_fin.SelectedDate.Value.ToString()); rs.Nomber_Jours = int.Parse(txt_nbr_Jours.Text); dbContext.SaveChanges(); grid_SelectedCellsChanged(sender, null); MessageBox.Show("Modifier avec succes ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); SetDataToGrid(); ClearControls(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Erreur", MessageBoxButton.OK, MessageBoxImage.Error); } }
private void btn_ajouter_Click_1(object sender, RoutedEventArgs e) { //try //{ if (comb_client.Text == string.Empty || comb_nom_voiture_marque.Text == string.Empty || txt_nbr_Jours.Text == string.Empty) { MessageBox.Show("Saisir tout les information ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); } else { var db = dbContext.Resevations; foreach (var rese in db) { if (comb_client.SelectedIndex == -1) { MessageBox.Show("Ce Client n'existe pas ! ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); comb_client.Focus(); return; } else if (comb_nom_voiture_marque.SelectedIndex == -1) { MessageBox.Show("Ce marque n'existe pas ! ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); comb_nom_voiture_marque.Focus(); return; } else if (comb_nom_voiture_model.SelectedIndex == -1) { MessageBox.Show("Ce medel n'existe pas ! ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); comb_nom_voiture_marque.Focus(); return; } } Resevation r = new Resevation(); r.ID_Client = int.Parse(comb_client.SelectedValue.ToString()); r.ID_Marque = int.Parse(comb_nom_voiture_marque.SelectedValue.ToString()); r.ID_Model = int.Parse(comb_nom_voiture_model.SelectedValue.ToString()); if (txt_avance.Text == string.Empty) { txt_avance.Text = Convert.ToString(0); } r.Avance = Convert.ToDecimal(txt_avance.Text); r.Date_D = Convert.ToDateTime(DTP_debut.SelectedDate.Value.ToString()); r.Date_F = Convert.ToDateTime(DTP_fin.SelectedDate.Value.ToString()); r.Nomber_Jours = int.Parse(txt_nbr_Jours.Text); dbContext.Resevations.Add(r); dbContext.SaveChanges(); MessageBox.Show("Ajouter avec succes", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); grid_SelectedCellsChanged(sender, null); SetDataToGrid(); txt_id.Text = Convert.ToString(Convert.ToInt32(grid.Items.Count.ToString()) + 1); ClearControls(); } //} //catch (Exception ex) //{ // MessageBox.Show(ex.Message, "Erreur", MessageBoxButton.OK, MessageBoxImage.Error); //} }
private void btn_supprimer_Click(object sender, RoutedEventArgs e) { if (comb_client.Text == string.Empty || comb_nom_voiture_marque.Text == string.Empty) { MessageBox.Show("Saisir tout les information que vous Supprimer", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); } else { MessageBoxResult res = MessageBox.Show("Voulez vous vraiment supprimer La résérvation", "Confiramtion", MessageBoxButton.YesNo, MessageBoxImage.Question); if (res == MessageBoxResult.Yes) { int IDReserv = int.Parse(txt_id.Text); Resevation rs = (from r in dbContext.Resevations where r.ID_Reservation == IDReserv select r).First(); dbContext.Resevations.Remove(rs); dbContext.SaveChanges(); MessageBox.Show("La supprission avec succes ", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Information); grid_SelectedCellsChanged(sender, null); SetDataToGrid(); ClearControls(); } } }