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