public void get_Patient(int idpat, ref string nomcomplet, ref DateTime datnais)
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = @"select Nom,Prenom,Date_de_naissance from Patient LEFT OUTER JOIN Person";
Command = Command + @" on Patient.Id_Person=Person.Id_Person where Id_Patient=" + idpat;
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
if (dr.Read())
{
nomcomplet = dr[0].ToString() + " " + dr[1].ToString();
try
{
datnais = DateTime.Parse(dr[2].ToString());
}
catch (Exception ex)
{
ex.GetType();
}
}
Datab.deconnecter();
}
public static void Insert_medic(string nom_medi)
{
nom_medi = nom_medi.ToUpper();
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = "select count(*) from Medicaments where Medicament='" + nom_medi + "'";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
int count = 0;
if (dr.Read())
{
count = int.Parse(dr[0].ToString());
}
dr.Close();
if (count == 0)
{
Datab.cmd.CommandType = CommandType.StoredProcedure;
Datab.cmd.CommandText = "SP_Insert_Medicament";
Datab.cmd.Parameters.Add("@param1", SqlDbType.NVarChar, 80).Value = nom_medi;
Datab.cmd.Connection = Datab.cnx;
Datab.cmd.ExecuteNonQuery();
Datab.deconnecter();
}
}
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 btnGrid_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
int i;
if (btn.Content.ToString() == "Activer")
{
i = 1;
btn.Content = "Désactiver";
}
else
{
i = 0;
btn.Content = "Activer";
}
try
{
Dataofgrid dfg = (Dataofgrid)(DatagGrid.SelectedItem);
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = "update Doctor set EtatCompte=" + i + " where Username='******'";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
Datab.deconnecter();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
public void Load_Rdv()
{
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"; g1.MaxWidth = 120; g1.MinWidth = 120;
DataGridTextColumn g2 = new DataGridTextColumn(); g2.Binding = new Binding("important"); g2.Header = "A notifier"; g2.MaxWidth = 0;
DataGridTextColumn g3 = new DataGridTextColumn(); g3.Binding = new Binding("lieu"); g3.Header = "Lieu";
DataGridTextColumn g4 = new DataGridTextColumn(); g4.Binding = new Binding("commentaire"); g4.Header = "Commentaire";
DataGridTextColumn g5 = new DataGridTextColumn(); g5.Binding = new Binding("nom"); g5.Header = "Nom Patient";
Rdv_DataGrid.Columns.Add(g0); Rdv_DataGrid.Columns.Add(g1); Rdv_DataGrid.Columns.Add(g2);
Rdv_DataGrid.Columns.Add(g3); Rdv_DataGrid.Columns.Add(g4); Rdv_DataGrid.Columns.Add(g5);
g1.ClipboardContentBinding.StringFormat = @"dd/MM/yyyy HH:mm";
Rdv_DataGrid.Columns[0].DisplayIndex = 7;
Rdv_DataGrid.Columns[1].DisplayIndex = 6;
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
string Command = @"select Id_RDV,Date_Rdv,Important,Lieu,Commentaire,Nom,Prenom from [Rendez-vous] LEFT OUTER JOIN Patient";
Command += @" on [Rendez-vous].Id_Patient=Patient.Id_Patient LEFT OUTER JOIN Person on Patient.Id_Person=Person.Id_Person";
Command += @" where Id_Rdv in ( SELECT Id_RDV FROM Avoir_RDV WHERE Id_Doctor=" + this.Idmedc + ") order by [Rendez-vous].Date_Rdv";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
while (dr.Read())
{
this.Ajouter_DataGrid(int.Parse(dr[0].ToString()), dr[1].ToString(), int.Parse(dr[2].ToString()), dr[3].ToString(),
dr[4].ToString(), dr[5].ToString() + " " + dr[6].ToString());
}
dr.Close();
Datab.deconnecter();
}
private void Button_Click_Modifier(object sender, RoutedEventArgs e)
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
if (!BienSelect)
{
/*this.Etat_dajoutTxt.Content = "Médicament non valide";
* this.Etat_dajoutTxt.Visibility = System.Windows.Visibility.Visible;
* this.Etat_dajout.Source = Animations.GetImage(@"False.png");
* this.Etat_dajout.Visibility = System.Windows.Visibility.Visible;*/
}
else
{
String nomedic = Nom_Medic.Text; String forme = Forme_Medic.Text; String utilis = Nbre_fois.Text + " chaque " + frequence.Text;
String dose = Dose_Medic.Text; int quan = int.Parse(Quant_Medic.Text); String durer = Dure.Text;
String Command = @"UPDATE Prescrire SET Id_Medicament='" + nomedic + "', Dose='" + dose + "', Forme='" + forme + "', Dure='" + durer + "', Quantité=" + quan + ", Nbre_Utilisation='" + utilis + "' " + medic.Chaine();
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
this.vider();
this.addtoListview();
this.Etat_dajoutTxt.Content = "Medicament modifié avec succés";
this.Etat_dajoutTxt.Visibility = System.Windows.Visibility.Visible;
this.Etat_dajout.Source = Animations.GetImage(@"True.png");
this.Etat_dajout.Visibility = System.Windows.Visibility.Visible;
addButton.IsEnabled = true; updateButton.IsEnabled = false;
Datab.deconnecter();
}
}
private void loadRdvImpo()
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = @"select Date_Rdv,Lieu,Commentaire,Nom,Prenom,Id_RDV from [Rendez-vous] LEFT OUTER JOIN Patient";
Command = Command + @" on [Rendez-vous].Id_Patient=Patient.Id_Patient LEFT OUTER JOIN Person on Patient.Id_Person=Person.Id_Person";
Command = Command + @" where Important=1 and Id_Rdv in ( SELECT Id_RDV FROM Avoir_RDV WHERE Id_Doctor=" + this.Idmed + ") order by [Rendez-vous].Date_Rdv";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
DateTime dt; String l, c, np; int id;
while (dr.Read())
{
dt = DateTime.Parse(dr[0].ToString());
l = dr[1].ToString();
c = dr[2].ToString();
np = dr[3].ToString() + " " + dr[4].ToString();
id = int.Parse(dr[5].ToString());
Notification notif = new Notification(dt, l, c, np, id);
lisdesnotif.Add(notif);
}
Datab.deconnecter();
}
private void doctorMail_LostFocus(object sender, RoutedEventArgs e)
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = @"SELECT COUNT(*) FROM Person WHERE Email='" + this.doctorMail.Text + "'";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
if (dr.Read())
{
int nb = (int)dr[0];
if (nb != 0)
{
this.doctorMail.Width = 100;
this.mailpic.Visibility = vizibl;
this.mailWarning.Content = "Cet Email est déja utilisé";
this.mailWarning.Visibility = vizibl;
emailverif = false;
}
else
{
this.doctorMail.Width = 160;
this.mailpic.Visibility = Nonvizibl;
this.mailWarning.Visibility = Nonvizibl;
emailverif = true;
}
}
Datab.deconnecter();
}
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 Lier()
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String command = "INSERT INTO Contient values (" + this.id_dm + "," + this.id_fc + ")";
SqlCommand Macmd = new SqlCommand(command, Datab.cnx);
Macmd.ExecuteNonQuery();
Datab.deconnecter();
}
//private void Id_box_TextChanged(object sender, TextChangedEventArgs e)
//{
// if (Id_box.Text != "")
// {
// int ii_pp = -1;
// ConnexionBDD Datab = new ConnexionBDD();
// Datab.connecter();
// String command = "SELECT Id_Person From Patient WHERE Id_Patient=" + Id_box.Text;
// SqlCommand Macmd = new SqlCommand(command, Datab.cnx);
// SqlDataReader dr;
// dr = Macmd.ExecuteReader();
// if (dr.Read())
// {
// ii_pp = (int)dr["Id_Person"];
// }
// dr.Close();
// if (ii_pp != -1)
// {
// String command1 = "SELECT * FROM Person WHERE Id_Person=" + ii_pp;
// SqlCommand Macmd1 = new SqlCommand(command1, Datab.cnx);
// dr = Macmd1.ExecuteReader();
// if (dr.Read())
// {
// nom_patt = dr["Nom"].ToString();
// prenom_patt = dr["Prenom"].ToString();
// }
// dr.Close();
// textbox_name_pat.Text = nom_patt + " " + prenom_patt;
// }
// else
// {
// textbox_name_pat.Clear();
// }
// }
// else
// {
// textbox_name_pat.Clear();
// }
//}
private void Insert_av_rdv()
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String command = "INSERT INTO Avoir_RDV Values (" + Rdv.get_Id_RDV() + "," + Idmedc + ")";
SqlCommand Macmd = new SqlCommand(command, Datab.cnx);
Macmd.ExecuteNonQuery();
Datab.deconnecter();
}
private void doctorUsername_LostFocus(object sender, RoutedEventArgs e)
{
saisiFrame.Visibility = Nonvizibl;
if (this.doctorUsername.Text.Trim() == "")
{
this.doctorUsername.Width = 100;
this.usernamepic.Visibility = vizibl;
this.usernameWarning.Content = "Non Rempli!";
this.usernameWarning.Visibility = vizibl;
userverif = false;
}
else
{
if (this.doctorUsername.Text.Length <= 5)
{
this.doctorUsername.Width = 100;
this.usernamepic.Visibility = vizibl;
this.usernameWarning.Content = "Nom d'utilisateur trés court";
this.usernameWarning.Visibility = vizibl;
userverif = false;
}
else
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = @"SELECT COUNT(*) FROM Doctor WHERE Username='******'";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
if (dr.Read())
{
int nb = (int)dr[0];
if (nb != 0)
{
this.doctorUsername.Width = 100;
this.usernamepic.Visibility = vizibl;
this.usernameWarning.Content = "Nom d'utilisateur déja utilisé";
this.usernameWarning.Visibility = vizibl;
userverif = false;
}
else
{
this.doctorUsername.Width = 160;
this.usernamepic.Visibility = Nonvizibl;
this.usernameWarning.Visibility = Nonvizibl;
userverif = true;
}
}
Datab.deconnecter();
}
}
}
private void Supprimer_Click_1(object sender, RoutedEventArgs e)
{
if (DatagGrid.SelectedIndex >= 0)
{
DataofLettre dataa = (DataofLettre)(DatagGrid.SelectedItem);
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = "DELETE FROM Lettre where Id_Lettre=" + dataa.numero;
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
Datab.deconnecter();
DatagGrid.Items.Remove(dataa);
}
}
private void update_table_rdv()
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
SqlCommand cmd = new SqlCommand("SP_Update_table_rdv", Datab.cnx);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param;
param = cmd.Parameters.Add("@dt", SqlDbType.DateTime);
param.Value = DateTime.Now;
cmd.ExecuteNonQuery();
Datab.deconnecter();
}
public void addtoDatagGrid(string nom, string prenom, DateTime date, string adresse, string grp, string numt, int id)
{
DataofPatient dofpatient = new DataofPatient();
dofpatient.nom = nom; dofpatient.prenom = prenom; dofpatient.date = date;
dofpatient.adr = adresse; dofpatient.grp = grp; dofpatient.num = numt;
dofpatient.numero = id;
DatagGrid.Items.Add(dofpatient);
ConnexionBDD Datab = new ConnexionBDD(); Datab.connecter();
String Command = @"select Nom,Prenom,Date_de_naissance,Adresse,Groupe_sanguin,Num_Tel";
Command += @",Id_Patient from Patient LEFT OUTER JOIN Person on Person.Id_Person=Patient.Id_Person order by Nom";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx); SqlDataAdapter DAPTR = new SqlDataAdapter(Macmd); DATBL = new DataTable();
DAPTR.Fill(DATBL); Datab.deconnecter();
}
private void Username_LostFocus(object sender, RoutedEventArgs e)
{
//Masquer le message de la saisi
if (this.Username.Text.Trim() == "")
{
userverif = false;
//Case vide
}
else
{
if (this.Username.Text.Length <= 5)
{
userverif = false;
//Mot de passe court (- de 5 )
}
else
{
if (this.Username.Text == this.username)
{
userverif = true;
}
else
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = @"SELECT COUNT(*) FROM Doctor WHERE Username='******'";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
if (dr.Read())
{
int nb = (int)dr[0];
if (nb != 0)
{
//Deja utilisé
userverif = false;
}
else
{
userverif = true;
//Entrée valide
}
}
Datab.deconnecter();
}
}
}
}
private void loadRdvasupp()
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = @"select Id_RDV,Date_Rdv from [Rendez-vous]";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
DateTime dt; int id;
while (dr.Read())
{
id = int.Parse(dr[0].ToString());
dt = DateTime.Parse(dr[1].ToString());
RdvAsuppr rdv = new RdvAsuppr(id, dt);
listasupp.Add(rdv);
}
Datab.deconnecter();
}
public int CompterMedic(int idord, String nomMedic, String Form)
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
Datab.cmd.CommandType = CommandType.StoredProcedure;
Datab.cmd.CommandText = "SP_CompterMedic";
Datab.cmd.Parameters.Add("@IdOrdo", SqlDbType.Int).Value = idord;
Datab.cmd.Parameters.Add("@Medic", SqlDbType.NVarChar, 50).Value = nomMedic;
Datab.cmd.Parameters.Add("@Form", SqlDbType.NVarChar, 30).Value = Form;
SqlParameter Sort = new SqlParameter("@compt", SqlDbType.Int);
Sort.Direction = ParameterDirection.Output;
Datab.cmd.Parameters.Add(Sort);
Datab.cmd.Connection = Datab.cnx;
Datab.cmd.ExecuteNonQuery();
Datab.deconnecter();
return((int)Sort.Value);
}
private void get_Medcin(int idmed, ref string nommed, ref string Adresse, ref string Spec)
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = @"select Nom,Prenom,Spécialité,Adresse from Doctor LEFT OUTER JOIN Person";
Command = Command + " on Doctor.Id_Person=Person.Id_Person where Id_Doctor=" + idmed;
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
if (dr.Read())
{
nommed = dr[0].ToString() + " " + dr[1].ToString();
Spec = dr[2].ToString();
Adresse = dr[3].ToString();
}
Datab.deconnecter();
}
private void loadCert()
{
table = new DataTable();
DataGridTextColumn g0 = new DataGridTextColumn();
DataGridTextColumn g1 = new DataGridTextColumn();
DataGridTextColumn g2 = new DataGridTextColumn();
g0.Binding = new Binding("numero"); g0.Header = ""; g0.MaxWidth = 0;
g1.Binding = new Binding("nb"); g1.Header = "Durée de repos(jour)";
g2.Binding = new Binding("commentaire"); g2.Header = "Commentaire"; g2.MaxWidth = 150;
DatagGrid.Columns.Add(g0); DatagGrid.Columns.Add(g1); DatagGrid.Columns.Add(g2);
DatagGrid.Columns[0].DisplayIndex = 3;
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command;
if (ADMIN)
{
Command = "select * from Certeficat_medical where Id_FC in (SELECT Id_FC from Contient where Id_DM=" + IDDOSS + ")";
}
else
{
Command = "select * from Certeficat_medical where Id_FC in (select Id_Fiche_Consultation from Fiche_Consultation where Id_Fiche_Consultation in (SELECT Id_FC from Contient where Id_DM=" + IDDOSS + ") and Id_Med=" + IDMED + ")";
}
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
while (dr.Read())
{
DataofCert ordodata = new DataofCert();
ordodata.numero = int.Parse(dr[0].ToString());
ordodata.nb = int.Parse(dr[2].ToString());
ordodata.commentaire = dr[3].ToString();
DatagGrid.Items.Add(ordodata);
}
dr.Close();
SqlDataAdapter Daptr = new SqlDataAdapter(Macmd);
Daptr.Fill(table);
Datab.deconnecter();
}
private void Loadpatient()
{
DATBL = new DataTable();
DataGridTextColumn g0 = new DataGridTextColumn(); g0.Binding = new Binding("nom"); g0.Header = "Nom";
DataGridTextColumn g1 = new DataGridTextColumn(); g1.Binding = new Binding("prenom"); g1.Header = "Prenom";
DataGridTextColumn g2 = new DataGridTextColumn(); g2.Binding = new Binding("date"); g2.Header = "Date de naissance"; g2.MaxWidth = 150;
DataGridTextColumn g3 = new DataGridTextColumn(); g3.Binding = new Binding("adr"); g3.Header = "Adresse"; g3.MaxWidth = 150;
DataGridTextColumn g4 = new DataGridTextColumn(); g4.Binding = new Binding("grp"); g4.Header = "Groupe sanguin";
DataGridTextColumn g5 = new DataGridTextColumn(); g5.Binding = new Binding("num"); g5.Header = "Numero Telephone";
DataGridTextColumn g6 = new DataGridTextColumn(); g6.Binding = new Binding("numero"); g6.Header = "Référence Patient"; g6.MaxWidth = 0;
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);
g2.ClipboardContentBinding.StringFormat = "d";
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
String Command = @"select Nom,Prenom,Date_de_naissance,Adresse,Groupe_sanguin,Num_Tel";
Command += @",Id_Patient from Patient LEFT OUTER JOIN Person on Person.Id_Person=Patient.Id_Person order by Nom";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
SqlDataReader dr = Macmd.ExecuteReader();
while (dr.Read())
{
DataofPatient dofpatient = new DataofPatient();
dofpatient.nom = dr[0].ToString(); dofpatient.prenom = dr[1].ToString(); dofpatient.date = DateTime.Parse(dr[2].ToString());
dofpatient.adr = dr[3].ToString(); dofpatient.grp = dr[4].ToString(); dofpatient.num = dr[5].ToString();
dofpatient.numero = int.Parse(dr[6].ToString());
DatagGrid.Items.Add(dofpatient);
}
dr.Close();
SqlDataAdapter DAPTR = new SqlDataAdapter(Macmd);
DATBL = new DataTable();
DAPTR.Fill(DATBL);
Datab.deconnecter();
}
private void valider_ic_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
if (passverif && userverif && this.Spécialité.Text.Trim() != "")
{
if (ChangePassword.IsChecked == true)
{
if (Password.Password.Length > 5)
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
string type;
if (this.Med.IsChecked == true)
{
type = "Medcin";
}
else
{
type = "MedcinAdmin";
}
string pass = App.CrypterMdp(this.Password.Password);
String Command = @"update Doctor set Username='******',Passwordd='" + pass + "',Spécialité='";
Command += this.Spécialité.Text + "',CompteAdmin='" + type + "' where Username='******'";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
App.gestcpt.page_modifier_support.Visibility = System.Windows.Visibility.Hidden;
Datab.deconnecter();
App.gestcpt = new PageGestionCompte();
App.gest_adm.Gestion_support.NavigationService.Navigate(App.gestcpt);
}
else
{
MessageBox.Show("Mot de passe trés court");
}
}
else
{
ConnexionBDD Datab = new ConnexionBDD();
Datab.connecter();
string type;
if (this.Med.IsChecked == true)
{
type = "Medcin";
}
else
{
type = "MedcinAdmin";
}
string pass = App.CrypterMdp(this.Password.Password);
String Command = @"update Doctor set Username='******',Spécialité='";
Command += this.Spécialité.Text + "',CompteAdmin='" + type + "' where Username='******'";
SqlCommand Macmd = new SqlCommand(Command, Datab.cnx);
Macmd.ExecuteNonQuery();
App.gestcpt.page_modifier_support.Visibility = System.Windows.Visibility.Hidden;
Datab.deconnecter();
App.gestcpt = new PageGestionCompte();
App.gest_adm.Gestion_support.NavigationService.Navigate(App.gestcpt);
}
}
else
{
//Données non valides
}
}
