private void ouvr_Click(object sender, RoutedEventArgs e) { if (DatagGrid.SelectedIndex != -1) { DataofOrdo dfg = (DataofOrdo)(DatagGrid.SelectedItem); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; if (row[0].ToString() == dfg.numero.ToString()) { string path = row[3].ToString(); if (!File.Exists(path)) { MessageBox.Show("Le fichier est invalide!"); } else { Visualisation.Visibility = Visibility.Visible; Affichage2.Visibility = Visibility.Hidden; string convertedXpsDoc = string.Concat(System.IO.Path.GetTempPath(), "\\", Guid.NewGuid().ToString(), ".xps"); XpsDocument xpsDocument = ConvertWordToXps(path, convertedXpsDoc); if (xpsDocument != null) { Viewer.Document = xpsDocument.GetFixedDocumentSequence(); } } } } } else { MessageBox.Show("Aucune ligne sélectionnée!"); } }
private void openDirectory_Click(object sender, RoutedEventArgs e) { if (DatagGrid.SelectedIndex != -1) { DataofOrdo dfg = (DataofOrdo)(DatagGrid.SelectedItem); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; if (row[0].ToString() == dfg.numero.ToString()) { string path = row[3].ToString(); path = path.Remove(path.LastIndexOf(@"\")); try { System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo.FileName = path; process.Start(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } } } else { MessageBox.Show("Aucune ligne sélectionnée!"); } }
private void Supprimer_Click_1(object sender, RoutedEventArgs e) { if (DatagGrid.SelectedIndex >= 0) { DataofOrdo dataa = (DataofOrdo)(DatagGrid.SelectedItem); ConnexionBDD Datab = new ConnexionBDD(); Datab.connecter(); String Command = "DELETE FROM Ordonnance where Id_Ordonnance=" + dataa.numero; SqlCommand Macmd = new SqlCommand(Command, Datab.cnx); Macmd.ExecuteNonQuery(); Datab.deconnecter(); DatagGrid.Items.Remove(dataa); } }
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]; DataofOrdo ordodata = new DataofOrdo(); ordodata.numero = int.Parse(dr[0].ToString()); ordodata.date = DateTime.Parse(dr[2].ToString()); DatagGrid.Items.Add(ordodata); } }
private void Terminer_Click(object sender, RoutedEventArgs e) { if (nbre_medic > 0) { // string path = ""; DateTime dat = new DateTime(); Misenforme mm = new Misenforme(); mm.get_Patient(this.idPat, ref path, ref dat); SaveFileDialog save = new SaveFileDialog(); save.Filter = "Fichiers Word|*.docx"; string documents = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); path = documents + save.InitialDirectory + @"\CureIt\" + path + "_" + this.idPat + @"\Ordonnances"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } save.InitialDirectory = path; save.FileName = "Ordonnance" + ordonn.Get_Ordo(); if (save.ShowDialog() == true) { string sav = save.FileName; Misenforme mis = new Misenforme(); mis.CreateWordDocument(sav, this.idMed, this.idPat, this.idOrdo); ConnexionBDD Datab = new ConnexionBDD(); Datab.connecter(); string filename = save.FileName.Replace("'", "''"); String Command = "update Ordonnance set Fichier_Ordo='" + filename + "' where Id_Ordonnance=" + ordonn.Get_Ordo(); SqlCommand Macmd = new SqlCommand(Command, Datab.cnx); Macmd.ExecuteNonQuery(); } // vider(); DataofOrdo ordodata = new DataofOrdo(); ordodata.numero = ordonn.Get_Ordo(); ordodata.date = DateTime.Now; DatagGrid.Items.Add(ordodata); var dataa = new DataTable(); Affich_Medic_Ajouté.ItemsSource = dataa.DefaultView; nbre_medic = 0; App.iff.support_fonction.NavigationService.Navigate(new Page_Ordonnance(idPat, idMed, IDFC, IDDOSS, ADMIN, true)); this.AffichageStack.Visibility = Visibility.Hidden; this.Affichage2.Visibility = Visibility.Visible; //for (int i = Affich_Medic_Ajouté.Items.Count - 1; i >= 0; i--) Affich_Medic_Ajouté.Items.RemoveAt(i); //ffich_Medic_Ajouté.Items.Clear(); } }
//private void Button_Click(object sender, RoutedEventArgs e) //{ // int index = int.Parse(((Button)e.Source).Uid); // GridCursor.Margin = new Thickness(10 + (200 * index), 45, 0, 10); // switch (index) // { // case 0: // this.AffichageStack.Visibility = Visibility.Visible; // this.Affichage2.Visibility = Visibility.Hidden; // break; // case 1: // this.AffichageStack.Visibility = Visibility.Hidden; // this.Affichage2.Visibility = Visibility.Visible; // break; // } //} private void loadOrdo() { table = new DataTable(); DataGridTextColumn g0 = new DataGridTextColumn(); DataGridTextColumn g1 = new DataGridTextColumn(); g0.Binding = new Binding("numero"); g0.Header = ""; g0.MaxWidth = 0; g1.Binding = new Binding("date"); g1.Header = "Date"; g1.ClipboardContentBinding.StringFormat = "d"; DatagGrid.Columns.Add(g0); DatagGrid.Columns.Add(g1); DatagGrid.Columns[0].DisplayIndex = 2; ConnexionBDD Datab = new ConnexionBDD(); Datab.connecter(); String Command; if (ADMIN) { Command = "SELECT * from Ordonnance where Id_FC in (SELECT Id_FC from Contient where Id_DM=" + IDDOSS + ")"; } else { Command = "SELECT * from Ordonnance 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()) { DataofOrdo ordodata = new DataofOrdo(); ordodata.numero = int.Parse(dr[0].ToString()); ordodata.date = DateTime.Parse(dr[2].ToString()); DatagGrid.Items.Add(ordodata); } dr.Close(); SqlDataAdapter Daptr = new SqlDataAdapter(Macmd); Daptr.Fill(table); }
private void btnGrid_Click(object sender, RoutedEventArgs e) { if (DatagGrid.SelectedIndex != -1) { DataofOrdo dfg = (DataofOrdo)(DatagGrid.SelectedItem); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; if (row[0].ToString() == dfg.numero.ToString()) { string path = row[3].ToString(); if (File.Exists((string)path)) { try { System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo.FileName = path; process.Start(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } else { //Fichier n'existe pas vous voulez creer un nouveau ? } } } } else { MessageBox.Show("Aucun compte sélectionné"); } }