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 } }