private void Rempliravec(DataTable tmp)
{
for (int i = DatagGrid.Items.Count - 1; i >= 0; i--)
{
DatagGrid.Items.RemoveAt(i);
}
for (int i = tmp.Rows.Count - 1; i >= 0; i--)
{
DataRow dr = tmp.Rows[i];
DataofFiche datfich = new DataofFiche();
datfich.numero = int.Parse(dr[0].ToString());
datfich.date = DateTime.Parse(dr[1].ToString());
datfich.diagnostique = dr[2].ToString();
datfich.taillepoids = dr[3].ToString() + " - " + dr[4].ToString();
datfich.tempe = dr[5].ToString();
datfich.tention = dr[6].ToString();
datfich.nomprenom = dr[7].ToString() + " " + dr[8].ToString();
if ((datfich.taillepoids == " - ") || (datfich.taillepoids == "0 - 0"))
{
datfich.taillepoids = "";
}
if (datfich.tempe == "0")
{
datfich.tempe = "";
}
if (datfich.tention == "0")
{
datfich.tention = "";
}
DatagGrid.Items.Add(datfich);
}
}
private void butouisup_Click(object sender, RoutedEventArgs e)
{
DataofFiche dataa = (DataofFiche)(DatagGrid.SelectedItem);
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = "DELETE FROM Prescrire WHERE Id_Ordonnance in ( SELECT Id_Ordonnance FROM Ordonnance WHERE Id_FC=" + dataa.numero + ")";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
Command = "DELETE FROM Ordonnance WHERE Id_FC=" + dataa.numero;
Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
Command = "DELETE FROM Certeficat_medical WHERE Id_FC=" + dataa.numero;
Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
Command = "DELETE FROM Fiche_Consultation where Id_Fiche_Consultation=" + dataa.numero;
Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
Datab.deconnecter();
DatagGrid.Items.Remove(dataa);
AffichageStack.IsEnabled = true;
confirmstacksup.Visibility = System.Windows.Visibility.Hidden;
StackModif.IsEnabled = true;
}
private void loadFiche()
{
table = new DataTable();
DataGridTextColumn g0 = new DataGridTextColumn(); g0.Binding = new Binding("numero"); g0.Header = ""; g0.MaxWidth = 0;
DataGridTextColumn g1 = new DataGridTextColumn(); g1.Binding = new Binding("date"); g1.Header = "Date";
DataGridTextColumn g2 = new DataGridTextColumn(); g2.Binding = new Binding("diagnostique"); g2.Header = "Diagnostique"; g2.MaxWidth = 150;
DataGridTextColumn g3 = new DataGridTextColumn(); g3.Binding = new Binding("taillepoids"); g3.Header = "Taille et Poids";
DataGridTextColumn g4 = new DataGridTextColumn(); g4.Binding = new Binding("tempe"); g4.Header = "Temperature";
DataGridTextColumn g5 = new DataGridTextColumn(); g5.Binding = new Binding("tention"); g5.Header = "Tention";
DataGridTextColumn g6 = new DataGridTextColumn(); g6.Binding = new Binding("nomprenom"); g6.Header = "Fait par:";
DatagGrid.Columns.Add(g0); DatagGrid.Columns.Add(g1); DatagGrid.Columns.Add(g2);
DatagGrid.Columns.Add(g3); DatagGrid.Columns.Add(g4); DatagGrid.Columns.Add(g5); DatagGrid.Columns.Add(g6);
g1.ClipboardContentBinding.StringFormat = "d";
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = "select Id_Fiche_Consultation,Date_F,Diagnostique,[Taille ],Poids,Temperature,Tension,Nom,Prenom from";
Command += " Fiche_Consultation LEFT OUTER JOIN Doctor on Fiche_Consultation.Id_Med=Doctor.Id_Doctor LEFT OUTER JOIN";
Command += " Person on Doctor.Id_Person=Person.Id_Person";
if (!ADMIN)
{
Command += " where Id_Doctor=" + IDMED;
}
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
while (dr.Read())
{
DataofFiche datfich = new DataofFiche();
datfich.numero = int.Parse(dr[0].ToString());
datfich.date = DateTime.Parse(dr[1].ToString());
datfich.diagnostique = dr[2].ToString();
datfich.taillepoids = dr[3].ToString() + " - " + dr[4].ToString();
datfich.tempe = dr[5].ToString();
datfich.tention = dr[6].ToString();
datfich.nomprenom = dr[7].ToString() + " " + dr[8].ToString();
if ((datfich.taillepoids == " - ") || (datfich.taillepoids == "0 - 0"))
{
datfich.taillepoids = "";
}
if (datfich.tempe == "0")
{
datfich.tempe = "";
}
if (datfich.tention == "0")
{
datfich.tention = "";
}
DatagGrid.Items.Add(datfich);
}
dr.Close();
SqlDataAdapter Daptr = new SqlDataAdapter(Macmd);
Daptr.Fill(table);
Datab.deconnecter();
}
private void ic_valider_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = "Update Fiche_Consultation SET Tension='" + Tent.Text + "'";
Command = Command + ", Poids=";
if (Pds.Text != "")
{
Command = Command + "TRY_CONVERT(float,'" + Pds.Text + "')";
}
else
{
Command = Command + "null";
}
Command = Command + ", Taille=";
if (Tay.Text != "")
{
Command = Command + int.Parse(Tay.Text);
}
else
{
Command = Command + "null";
}
Command = Command + ", Temperature=";
if (Temp.Text != "")
{
Command = Command + "TRY_CONVERT(float,'" + Temp.Text + "')";
}
else
{
Command = Command + "null";
}
Command = Command + ", Diagnostique='" + diagno.Text + "'";
Command = Command + " where Id_Fiche_Consultation=" + this.id_fich;
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
StackModif.Visibility = System.Windows.Visibility.Hidden;
RecStackModif.Visibility = System.Windows.Visibility.Hidden;
DataofFiche dofich = new DataofFiche();
dofich.tention = Tent.Text; dofich.taillepoids = Tay.Text + " - " + Pds.Text; dofich.tempe = Temp.Text;
dofich.diagnostique = diagno.Text;
DataofFiche dof = (DataofFiche)(this.DatagGrid.SelectedItem);
dofich.date = dof.date; dofich.nomprenom = dof.nomprenom; dofich.numero = dof.numero;
DatagGrid.Items.Insert(DatagGrid.SelectedIndex, dofich);
DatagGrid.Items.Remove(dof);
AffichageStack.IsEnabled = true;
}
private void Supprimer_Click(object sender, RoutedEventArgs e)
{
if (DatagGrid.SelectedIndex >= 0)
{
//A finaliser
DataofFiche dataa = (DataofFiche)(DatagGrid.SelectedItem);
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command1 = "SELECT Id_Ordonnance FROM Ordonnance where Id_FC=" + dataa.numero;
SqlCommand Macmd1 = new SqlCommand(Command1, Datab.cnx);
SqlDataReader dr = Macmd1.ExecuteReader();
this.nb_ord = 0;
while (dr.Read())
{
this.nb_ord++;
}
dr.Close();
Command1 = "SELECT Id_Cert_Med FROM Certeficat_medical where Id_FC=" + dataa.numero;
Macmd1 = new SqlCommand(Command1, Datab.cnx);
dr = Macmd1.ExecuteReader();
this.nb_cert = 0;
while (dr.Read())
{
this.nb_cert++;
}
dr.Close();
if (this.nb_cert != 0 || this.nb_ord != 0)
{
attentionstack.Visibility = System.Windows.Visibility.Visible;
}
else
{
attentionstack.Visibility = System.Windows.Visibility.Collapsed;
}
confirmstacksup.Visibility = System.Windows.Visibility.Visible;
AffichageStack.IsEnabled = false;
//*********************************************************
}
}
private void DatagGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (DatagGrid.SelectedIndex >= 0)
{
Supprimer.IsEnabled = true;
Modifier.IsEnabled = true;
DataofFiche dfg = (DataofFiche)(DatagGrid.SelectedItem);
if (this.IDFC == dfg.numero)
{
Supprimer.IsEnabled = false;
}
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
if (row[0].ToString() == dfg.numero.ToString())
{
id_fich = dfg.numero;
Tent.Text = dfg.tention;
Temp.Text = dfg.tempe;
diagno.Text = dfg.diagnostique;
if ((dfg.taillepoids == " - ") || (dfg.taillepoids == "0 - 0") || (dfg.taillepoids == ""))
{
Tay.Text = "";
Pds.Text = "";
}
else
{
Tay.Text = dfg.taillepoids.Remove(dfg.taillepoids.IndexOf("-"));
Pds.Text = dfg.taillepoids.Remove(0, dfg.taillepoids.IndexOf("-") + 1);
}
}
}
}
else
{
Supprimer.IsEnabled = false;
Modifier.IsEnabled = false;
}
}
