private void btnGrid_Click(object sender, RoutedEventArgs e) { if (DatagGrid.SelectedIndex != -1) { DataofCert dfg = (DataofCert)(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[4].ToString(); try { System.Diagnostics.Process process = new System.Diagnostics.Process(); process.StartInfo.FileName = path; process.Start(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } } } }
private void Supprimer_Click_1(object sender, RoutedEventArgs e) { if (DatagGrid.SelectedIndex >= 0) { DataofCert dataa = (DataofCert)(DatagGrid.SelectedItem); ConnexionBDD Datab = new ConnexionBDD(); Datab.connecter(); String Command = "DELETE FROM Certeficat_medical where Id_Cert_Med=" + dataa.numero; SqlCommand Macmd = new SqlCommand(Command, Datab.cnx); Macmd.ExecuteNonQuery(); Datab.deconnecter(); DatagGrid.Items.Remove(dataa); } }
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 Button_Click2(object sender, RoutedEventArgs e) { if (verif()) { int i = int.Parse(this.nb.Text); if (this.Nbre_jour.Text == "Semaine") { i = i * 7; } if (this.Nbre_jour.Text == "Mois") { i = i * 30; } if (this.Nbre_jour.Text == "Ans") { i = i * 365; } Certaficat_Médical certi = new Certaficat_Médical(i, this.comment.Text); certi.Set_Id_fc(IDFC); certi.insert_nvl_certaficat_medic(); DataofCert ordodata = new DataofCert(); ordodata.numero = certi.Get_Id_Cert(); ordodata.nb = i; ordodata.commentaire = this.comment.Text; DatagGrid.Items.Add(ordodata); //FILEDIALOG 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 PDF|*.pdf"; string documents = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); path = documents + save.InitialDirectory + @"\CureIt\" + path + "_" + this.IDPAT + @"\Certificiats"; MessageBox.Show(path); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } save.InitialDirectory = path; save.FileName = "Certificat" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second; if (save.ShowDialog() == true) { string nomdoc = save.FileName; MiseEnFormLettre forme = new MiseEnFormLettre(IDDOSS, IDMED); MiseEnFormCert form = new MiseEnFormCert(IDDOSS, IDMED); Document doc = forme.CreateDoc(nomdoc); doc.Open(); doc = form.Remplir_doc(doc, this.comment.Text, int.Parse(this.nb.Text), this.Nbre_jour.Text, IDMED, IDDOSS); doc.Close(); ConnexionBDD Datab = new ConnexionBDD(); Datab.connecter(); string filename = save.FileName.Replace("'", "''"); String Command = @"update Certeficat_medical set Fichier='" + filename + "' where Id_Cert_Med=" + certi.Get_Id_Cert(); SqlCommand Macmd = new SqlCommand(Command, Datab.cnx); Macmd.ExecuteNonQuery(); App.iff.support_fonction.NavigationService.Navigate(new Page_Certificat(IDFC, IDDOSS, IDMED, ADMIN, true, IDPAT)); this.AffichageStack.Visibility = Visibility.Hidden; this.Affichage2.Visibility = Visibility.Visible; } StackcertbienAjouer.Visibility = System.Windows.Visibility.Visible; RecStackcertbienAjouer.Visibility = System.Windows.Visibility.Visible; grdcert.IsEnabled = false; } else { Stacknonrempcert.Visibility = System.Windows.Visibility.Visible; RecStacknonrempcert.Visibility = System.Windows.Visibility.Visible; grdcert.IsEnabled = false; } }