//**********************************************************************************************************************
//**********************************************************************************************************************
private void Search_Click(object sender, RoutedEventArgs e)
{
SqlConnection conn = new SqlConnection(conn_string);
SqlDataReader rdr = null;
try
{
conn.Open();
String Query = "SELECT * FROM Bien_etre WHERE Marque ='" + this.Marque.Text + "' and Type ='" + this.type.Text + "'";
SqlCommand cmd = new SqlCommand(Query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
bien_etre pharm_inf = new bien_etre();
pharm_inf.Marque = rdr["Marque"].ToString();
pharm_inf.Type = rdr["Type"].ToString();
pharm_inf.DateDePeremption = Convert.ToDateTime(rdr["DateDePeremption"]).ToString("dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture);
pharm_inf.DateDeProduction = Convert.ToDateTime(rdr["DateDeProduction"]).ToString("dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture);
pharm_inf.Prix = Convert.ToDouble(rdr["Prix"]);
pharm_inf.Gout = rdr["Gout"].ToString();
pharm_inf.Quantite = Convert.ToInt32(rdr["Quantite"]);
list_inf.Add(pharm_inf);
}
if (list_inf.Count == 0)
{
MessageBox.Show("Produit n'existe pas !");
}
view_bien_etre.ItemsSource = list_inf;
}
finally
{
conn.Close();
rdr.Close();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DateTime?selected_date_prod = date_prod.SelectedDate;
DateTime?selected_date_perom = date_peromp.SelectedDate;
string formated, formated2;
object d1 = null, d2 = null;
if (selected_date_prod.HasValue)
{
formated = selected_date_prod.Value.ToString("dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture);
d1 = Convert.ToDateTime(formated);
}
else
{
formated = null;
}
if (selected_date_perom.HasValue)
{
formated2 = selected_date_perom.Value.ToString("dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture);
d2 = Convert.ToDateTime(formated2);
}
else
{
formated2 = null;
}
bien_etre b1_etre = new bien_etre(d1, d2, Quantite.Text, prix.Text, Marque.Text, Type.Text, main_ingred.Text, 0);
Database datab = new Database();
if (b1_etre.inserer())
{
MessageBox.Show("Produit inséré avec succès");
}
else
{
MessageBox.Show(b1_etre.ExceptionMessage);
}
}//"Un ERREUR a été produit!! Réessayez s'il vous plaît"
