private void dataGrid1_MouseDoubleClick(object sender, MouseButtonEventArgs e) { if (grdListeRegions.SelectedIndex >= 0) { objet_region = regions.ElementAt(grdListeRegions.SelectedIndex); txtNom.Text = objet_region.nomregion; txtCodeRegion.Text = objet_region.coderegion; doubleclick = true; //txtCodeRegion.IsEnabled = false; grdListeRegions.UnselectAll(); } }
private void cmdValider_Click(object sender, RoutedEventArgs e) { String code, nom; RegionBE r; if (validerFormulaire() == false) { MessageBox.Show("Veuillez remplir tous les champs", "School brain : Message d'alerte"); } else { code = txtCodeRegion.Text; nom = txtNom.Text; r = new RegionBE(code, nom); if (doubleclick) //c'est une modification { //suppression de l'ancienne valeur if (regionBL.modiferRegion(objet_region, r)) { regions.Remove(objet_region); regions.Add(r); grdListeRegions.Items.Refresh(); doubleclick = false; txtCodeRegion.Clear(); txtNom.Clear(); } else { MessageBox.Show("Modification impossible, verifier si le code ne se repete pas", "School brain:Alerte"); } //txtCodeRegion.IsEnabled = true; } //ajout de la nouvelle region else if (regionBL.enregistrerRegioin(r)) { MessageBox.Show("Region enregistrer avec succès"); regions = regionBL.listerTousRegion(); grdListeRegions.ItemsSource = regions; txtCodeRegion.Clear(); txtNom.Clear(); } else { MessageBox.Show("Enregistrement non effectué"); } } }
public List <RegionBE> ListarRegionPorId(int regionId) { using (OracleCommand oOracleCommand = new OracleCommand("PKG_REGIONES.SP_LISTAR_REGION_POR_ID", conn)) { try { oOracleCommand.CommandType = CommandType.StoredProcedure; oOracleCommand.CommandTimeout = 10; oOracleCommand.Parameters.Add(new OracleParameter("PN_ID_REGION", regionId)); OracleParameter oParam = new OracleParameter("CUR_REGIONES", OracleDbType.RefCursor); oParam.Direction = ParameterDirection.Output; oParam.Size = 128; oOracleCommand.Parameters.Add(oParam); DataTable oDataTable = new DataTable(); conn.Open(); oDataTable.Load(oOracleCommand.ExecuteReader()); conn.Close(); listRegion = new List <RegionBE>(); foreach (DataRow item in oDataTable.Rows) { oRegion = new RegionBE(); oRegion.IdRegion = int.Parse(item[0].ToString()); oRegion.NombreRegion = item[1].ToString(); oRegion.RegionOrdinal = item[2].ToString(); listRegion.Add(oRegion); } return(listRegion); } catch (Exception ex) { return(null); // throw new Exception(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } }
public RegionUI() { CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name); ci.DateTimeFormat.ShortDatePattern = "dd-MM-yyyy"; Thread.CurrentThread.CurrentCulture = ci; regionBL = new GestionRegionBL(); regions = new List <RegionBE>(); objet_region = new RegionBE(); doubleclick = false; InitializeComponent(); regions = regionBL.listerTousRegion(); grdListeRegions.DataContext = this; grdListeRegions.ItemsSource = regions; }
private void dataGrid1_KeyUp(object sender, KeyEventArgs e) { if (e.Key == Key.Delete) { if (MessageBox.Show("Voulez vous supprimer?", "School : Confirmation", System.Windows.MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (grdListeRegions.SelectedIndex != -1) { RegionBE r = new RegionBE(); r = regions.ElementAt(grdListeRegions.SelectedIndex); regionBL.supprimerRegion(r); regions.Remove(r); grdListeRegions.ItemsSource = regions; grdListeRegions.Items.Refresh(); } else { MessageBox.Show("Aucune ligne sélectionnée", "School brain:Alerte"); } } } }