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