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