private void Button_Click(object sender, RoutedEventArgs e)
{
ListBoxItem di = the_list.ContainerFromElement(sender as DependencyObject) as ListBoxItem;
medID_qunt c = di.Content as medID_qunt;
//MessageBox.Show(c.DCI.ToString() + c.Marque.ToString() + c.Tab_MedID.ToString() + c.Dosage.ToString());
SqlDataReader reader = null;
SqlConnection cn = Connect(".\\SQLEXPRESS", "mydb");
SqlCommand cmd = null;
if (c.Rest == 0)
{
cmd = new SqlCommand {
Connection = cn, CommandText = "select * from Tab_NEW where Tab_medID = " + c.Tab_MedID.ToString()
};
}
else
{
cmd = new SqlCommand {
Connection = cn, CommandText = "select * from TabRestitue where Tab_medID = " + c.Tab_MedID.ToString()
};
}
cn.Open();
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
string aff = "- DCI : " + c.DCI.ToString();
aff += "\n- Date de production : " + reader[1].ToString().Remove(reader[1].ToString().Length - 9);
aff += "\n- Date de peremption : " + reader[2].ToString().Remove(reader[2].ToString().Length - 9);
aff += "\n- Stock : " + reader[3].ToString();
aff += "\n- Prix : " + reader[4].ToString();
Label l1 = new Label();
BrushConverter k = new BrushConverter();
l1.BorderThickness = new Thickness(1);
l1.BorderBrush = (Brush)k.ConvertFrom("#FF000000");
l1.Background = (Brush)k.ConvertFrom("AliceBlue");
l1.Foreground = (Brush)k.ConvertFrom("#FF151922");
l1.FontWeight = FontWeights.DemiBold;
l1.FontSize = 15;
l1.FontStyle = FontStyles.Italic;
l1.Margin = new Thickness(2, 2, 2, 5);
l1.Content = aff;
plus_infos.Children.Add(l1);
bool zz = plus.IsOpen;
plus.IsOpen = true;
MainWindow.GetWindow(this).IsEnabled = false;
//plus.Visibility = System.Windows.Visibility.Visible;
}
}
}
private void recherche_button_Click(object sender, RoutedEventArgs e)
{
the_list.Visibility = System.Windows.Visibility.Visible;
aucune.Visibility = System.Windows.Visibility.Collapsed;
the_list.ItemsSource = null;
String DCI = dci.Text;
string Dosage = dosage.Text;
String Marque = marque.Text;
object Forme = forme.SelectedValue;
object Effet = effet.SelectedValue;
object Categorie = categorie.SelectedIndex;
object Remboursement = remboursement.IsChecked;
object Oriente = oriente.IsChecked;
string pServerName = ".\\SQLEXPRESS";
string pDataBase = "mydb";
string pTableName = "Tab_med";
if (DCI == "")
{
DCI = null;
}
if (Marque == "")
{
Marque = null;
}
if (Dosage == "")
{
Dosage = null;
}
if ((int)Categorie == -1)
{
Categorie = null;
}
if (grid.Visibility == Visibility.Collapsed)
{
Marque = null;
Forme = null;
Effet = null;
Categorie = null;
Remboursement = null;
Oriente = null;
Dosage = null;
}
grid.Visibility = System.Windows.Visibility.Collapsed;
//recherche.Visibility = System.Windows.Visibility.Visible;
SqlDataReader rdr = Recherche_Med(Connect(pServerName, pDataBase), pTableName, DCI, Marque, Forme, Dosage, Categorie, Effet, Remboursement, Oriente, null, null);
/*
* recuperation des fomres de la base de donnée
*/
SqlDataReader rdr1 = recherche_forme(Connect(pServerName, pDataBase));
const int a = 40;
String[] tab_forme = new string[a];;
int m = 0;
while (rdr1.Read())
{
tab_forme[m] = rdr1[1].ToString();
m++;
}
/*
* recuperation des effets de la base de donnée
*/
SqlDataReader rdr2 = recherche_effet(Connect(pServerName, pDataBase));
const int b = 40;
String[] tab_effet = new string[b];;
m = 0;
while (rdr2.Read())
{
tab_effet[m] = rdr2[1].ToString();
m++;
}
List <medID_qunt> l = new System.Collections.Generic.List <medID_qunt>();
if (rdr == null || rdr != null && !rdr.HasRows) // medicament equivalent
{
SqlDataReader rdr3 = Recherche_Med(Connect(pServerName, pDataBase), pTableName, DCI, null, Forme, null, null, Effet, null, null, null, null);
if (rdr3 == null)
{
the_list.ItemsSource = l;
the_list.Visibility = Visibility.Collapsed;
MessageBox.Show("aucune resultat");
aucune.Visibility = Visibility.Visible;
}
else if (rdr3.HasRows)
{
while (rdr3.Read())
{
var i = new medID_qunt();
i.Tab_MedID = rdr3[0].ToString();
i.DCI = rdr3[1].ToString();
i.Dosage = rdr3[4].ToString();
i.Marque = rdr3[2].ToString();
i.Rest = Convert.ToInt32(rdr3[9]);
if (!(rdr3[3].GetType().ToString() == "System.DBNull"))
{
i.Forme = tab_forme[(int)(rdr3[3]) - 1];
}
if (!(rdr3[6].GetType().ToString() == "System.DBNull"))
{
i.Effet = tab_effet[(int)(rdr3[6]) - 1];
}
l.Add(i);
}
the_list.ItemsSource = l;
}
else
{
the_list.ItemsSource = l;
the_list.Visibility = Visibility.Collapsed;
MessageBox.Show("aucune resultat");
aucune.Visibility = Visibility.Visible;
}
}
else
{
while (rdr.Read())
{
var i = new medID_qunt();
i.Tab_MedID = rdr[0].ToString();
i.DCI = rdr[1].ToString();
i.Dosage = rdr[4].ToString();
i.Marque = rdr[2].ToString();
i.Rest = Convert.ToInt32(rdr[9]);
if (!(rdr[3].GetType().ToString() == "System.DBNull"))
{
i.Forme = tab_forme[(int)(rdr[3]) - 1];
}
if (!(rdr[6].GetType().ToString() == "System.DBNull"))
{
i.Effet = tab_effet[(int)(rdr[6]) - 1];
}
l.Add(i);
}
the_list.ItemsSource = l;
}
dci.Text = "";
marque.Text = "";
dosage.Text = "";
remboursement.IsChecked = false;
oriente.IsChecked = false;
forme.SelectedItem = null;
effet.SelectedItem = null;
categorie.SelectedItem = null;
}
