private void REFART_Validated(object sender, EventArgs e) { try { MySqlCommand mySqlCommand = new MySqlCommand(); if (Globals.conn.State == ConnectionState.Closed) { Globals.conn.Open(); } mySqlCommand.Connection = Globals.conn; mySqlCommand.CommandText = "select distinct REFART from ARTICLE_D where REFART ='" + REFART.Text + "'"; mySqlCommand.CommandType = CommandType.Text; MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); REFART.Items.Clear(); if (mySqlDataReader.HasRows) { mySqlDataReader.Close(); mySqlDataReader.Dispose(); REFART_SelectedIndexChanged(RuntimeHelpers.GetObjectValue(sender), e); } else { if (Operators.CompareString(REFART.Text, "", false) == 0) { mySqlDataReader.Close(); mySqlDataReader.Dispose(); goto end_IL_0001; } mySqlDataReader.Close(); mySqlDataReader.Dispose(); MessageBox.Show("Article no trouvé!", "Article"); REFART.Text = ""; LIBART.Text = ""; REFART.Focus(); } mySqlDataReader.Close(); mySqlDataReader.Dispose(); if (Globals.conn != null) { Globals.conn.Close(); } end_IL_0001 :; } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } }
private void REFART_Validated(object sender, EventArgs e) { try { MySqlCommand mySqlCommand = new MySqlCommand(); if (Globals.conn.State == ConnectionState.Closed) { Globals.conn.Open(); } mySqlCommand.Connection = Globals.conn; mySqlCommand.CommandText = "select distinct REFART from ARTICLE_D where REFART LIKE '" + REFART.Text + "%'"; mySqlCommand.CommandType = CommandType.Text; MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); REFART.Items.Clear(); if (mySqlDataReader.HasRows) { mySqlDataReader.Close(); mySqlDataReader.Dispose(); REFART_SelectedIndexChanged(RuntimeHelpers.GetObjectValue(sender), e); LIBART.Focus(); } else { DialogResult dialogResult = MessageBox.Show("Etes vous sure de vouloir ajouter un article?", "Ajout Article?", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (dialogResult == DialogResult.No) { base.Close(); REFART.Text = ""; LIBART.Text = ""; ClearTextBox(this); fournisseur.Text = ""; REFART.Focus(); } else { MyProject.Forms.Gestion_Article_Com.Show(); MyProject.Forms.Gestion_Article_Com.REFART.Text = REFART.Text; MyProject.Forms.Gestion_Article_Com.REFART_Validated(RuntimeHelpers.GetObjectValue(sender), e); } } mySqlDataReader.Close(); mySqlDataReader.Dispose(); if (Globals.conn != null) { Globals.conn.Close(); } } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception ex2 = ex; MessageBox.Show(ex2.Message); ProjectData.ClearProjectError(); } finally { if (Globals.conn != null) { Globals.conn.Close(); } } }