public void supprRow(int id) { bool suppr = false; int i = 0; while (i < Rdv_DataGrid.Items.Count && !suppr) { DataOfRdv datardv = (DataOfRdv)(Rdv_DataGrid.Items[i]); if (id == datardv.numero) { Rdv_DataGrid.Items.Remove(datardv); suppr = true; } i++; } }
private void butouisup_Click(object sender, RoutedEventArgs e) { //DataGrid Dg = (Rdv_DataGrid) as DataGrid; //DataRowView Drv = Dg.SelectedItem as DataRowView; //if (Drv != null) //{ // ConnexionBDD Datab = new ConnexionBDD(); // Datab.connecter(); // DateTime dt = (DateTime)Drv["Date"]; // this.deletefromNotif(dt); // int imp = (int)Drv["Important"]; // String lieu = Drv["Lieu"].ToString(); // String cmnt = Drv["Commentaire"].ToString(); // SqlCommand cmd = new SqlCommand("SP_DELETE_RDV", Datab.cnx); // cmd.CommandType = CommandType.StoredProcedure; // SqlParameter param1, param2, param3, param4; // param1 = cmd.Parameters.Add("@dt", SqlDbType.DateTime); // param1.Value = dt; // param2 = cmd.Parameters.Add("@imp", SqlDbType.Int); // param2.Value = imp; // param3 = cmd.Parameters.Add("@lieu", SqlDbType.NVarChar, 50); // param3.Value = lieu; // param4 = cmd.Parameters.Add("@cmnt", SqlDbType.NVarChar, 1000); // param4.Value = cmnt; // cmd.ExecuteNonQuery(); // load_tab_grid(); //} if (Rdv_DataGrid.SelectedIndex > -1) { DataOfRdv datardv = (DataOfRdv)(Rdv_DataGrid.SelectedItem); ConnexionBDD Datab = new ConnexionBDD(); Datab.connecter(); string Command = @"DELETE FROM [Rendez-vous] where Id_RDV=" + datardv.numero; SqlCommand Macmd = new SqlCommand(Command, Datab.cnx); Macmd.ExecuteNonQuery(); Command = @"DELETE from Avoir_RDV where Id_RDV=" + datardv.numero; Macmd = new SqlCommand(Command, Datab.cnx); Macmd.ExecuteNonQuery(); Rdv_DataGrid.Items.Remove(datardv); confirmsupp.Visibility = System.Windows.Visibility.Hidden; Recconfirmsupp.Visibility = System.Windows.Visibility.Hidden; Stacksuppsucc.Visibility = System.Windows.Visibility.Visible; RecStacksuppsucc.Visibility = System.Windows.Visibility.Visible; RdvGrd.IsEnabled = false; this.vider(); } }
public void Ajouter_DataGrid(int id, string date, int imp, string lieu, string comm, string nom) { DataOfRdv RDVV = new DataOfRdv(); RDVV.numero = id; RDVV.date = DateTime.Parse(date); RDVV.lieu = lieu; RDVV.commentaire = comm; RDVV.nom = nom; if (imp == 1) { RDVV.important = "Oui"; RDVV.img = Animations.GetImage(@"Images\star_Light.png"); } else { RDVV.important = "Non"; RDVV.img = Animations.GetImage(@"Images\star_noLight.png"); } Rdv_DataGrid.Items.Add(RDVV); }
private void Rdv_DataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (Rdv_DataGrid.SelectedIndex > -1) { modifier_but.IsEnabled = true; annuler_but.IsEnabled = false; valider_but.IsEnabled = false; DataOfRdv datardv = (DataOfRdv)(Rdv_DataGrid.SelectedItem); Daterdv_Datepicker.Text = datardv.date.ToString().Remove(10); if (datardv.date.Hour.ToString().Length == 1) { heur_combo.Text = "0" + datardv.date.Hour; } else { heur_combo.Text = datardv.date.Hour.ToString(); } if (datardv.date.Minute.ToString().Length == 1) { min_combo.Text = "0" + datardv.date.Minute; } else { min_combo.Text = datardv.date.Minute.ToString(); } if (datardv.important == "Oui") { import_checkbox.IsChecked = true; } else { import_checkbox.IsChecked = false; } lieu_textbox.Text = datardv.lieu; cmnt_textbox.Text = datardv.commentaire; if (datardv.nom == " ") { Rdv_perso_checkbox.IsChecked = true; bl = true; } else { Rdv_perso_checkbox.IsChecked = false; textbox_name_pat.Text = datardv.nom; } } } catch (Exception exc) { } //try //{ // bl = false; // DataGrid Dg = sender as DataGrid; // DataRowView Drv = Dg.SelectedItem as DataRowView; // if (Drv != null) // { // String Dtt = null; // Dtt = Drv["Date"].ToString(); // Daterdv_Datepicker.Text = Dtt.Remove(10); // String h = Dtt.Remove(0, 10); // int heu = int.Parse(h.Remove(3)); // String mi = h.Remove(6); // int mii = int.Parse(mi.Remove(0, 4)); // heur_combo.Text = heu.ToString(); ; // min_combo.Text = mii.ToString(); // if (int.Parse(Drv["Important"].ToString()) == 1) import_checkbox.IsChecked = true; // else import_checkbox.IsChecked = false; // lieu_textbox.Text = Drv["Lieu"].ToString(); // cmnt_textbox.Text = Drv["Commentaire"].ToString(); // if (Drv["Num_Patient"].ToString() != "") // { // Rdv_perso_checkbox.IsChecked = true; // Id_radio.IsChecked = true; // Id_box.Text = Drv["Num_Patient"].ToString(); // bl = true; // } // else // { // Rdv_perso_checkbox.IsChecked = false; // Id_radio.IsChecked = false; // Id_box.Text = ""; // } // ConnexionBDD Datab = new ConnexionBDD(); // Datab.connecter(); // Datab.cmd.CommandType = CommandType.StoredProcedure; // Datab.cmd.CommandText = "SP_Rech_RDV"; // Datab.cmd.Parameters.Add("@d_r", SqlDbType.DateTime).Value = Dtt; // Datab.cmd.Connection = Datab.cnx; // SqlDataReader dr; // dr = Datab.cmd.ExecuteReader(); // if (dr.Read()) // { // id_r = (int)dr["Id_RDV"]; // } // dr.Close(); // valider_but.IsEnabled = false; // modifier_but.IsEnabled = true; // } //} //catch (Exception exc) { } }
private void modifier_but_Click(object sender, RoutedEventArgs e) { //ConnexionBDD Datab = new ConnexionBDD(); //Datab.connecter(); //Dte_rdv = DateTime.Parse(Daterdv_Datepicker.Text); //heur_rdv = int.Parse(heur_combo.Text); //min_rdv = int.Parse(min_combo.Text); //DateTime D = new DateTime(Dte_rdv.Year, Dte_rdv.Month, Dte_rdv.Day, heur_rdv, min_rdv, 00); //lieu_rdv = lieu_textbox.Text; //cmnt_rdv = cmnt_textbox.Text; //if (import_checkbox.IsChecked == true) important = 1; //else important = 0; //if (bl == true) idd_pat = int.Parse(Id_box.Text); //SqlCommand cmd = new SqlCommand("SP_Update_RDV", Datab.cnx); //cmd.CommandType = CommandType.StoredProcedure; //SqlParameter param1; //param1 = cmd.Parameters.Add("@dte", SqlDbType.DateTime); //param1.Value = D; //SqlParameter param2; //param2 = cmd.Parameters.Add("@imp", SqlDbType.Int); //param2.Value = important; //SqlParameter param3; //param3 = cmd.Parameters.Add("@cmnt", SqlDbType.NVarChar, 1000); //param3.Value = cmnt_rdv; //SqlParameter param4; //param4 = cmd.Parameters.Add("@lieu", SqlDbType.NVarChar, 50); //param4.Value = lieu_rdv; //SqlParameter param5; //param5 = cmd.Parameters.Add("@id_rd", SqlDbType.Int); //param5.Value = id_r; //cmd.ExecuteNonQuery(); //if (bl == true) //{ // string Command = @"Update [Rendez-vous] SET Id_Patient = " + idd_pat + " WHERE Id_RDV=" + id_r; // SqlCommand Macmd = new SqlCommand(Command, Datab.cnx); // Macmd.ExecuteNonQuery(); //} //vider(); //load_tab_grid(); int index = Rdv_DataGrid.SelectedIndex; if (Rdv_DataGrid.SelectedIndex > -1) { DataOfRdv datardv = (DataOfRdv)(Rdv_DataGrid.SelectedItem); Rdv_DataGrid.Items.RemoveAt(index); DateTime dt = DateTime.Parse(Daterdv_Datepicker.Text); datardv.date = new DateTime(dt.Year, dt.Month, dt.Day, int.Parse(heur_combo.Text), int.Parse(min_combo.Text), 0); if (import_checkbox.IsChecked == true) { datardv.important = "Oui"; datardv.img = Animations.GetImage(@"Images\star_Light.png"); } else { datardv.important = "Non"; datardv.img = Animations.GetImage(@"Images\star_noLight.png"); } datardv.lieu = lieu_textbox.Text; datardv.commentaire = cmnt_textbox.Text; datardv.nom = textbox_name_pat.Text; Rdv_DataGrid.Items.Insert(index, datardv); ConnexionBDD Datab = new ConnexionBDD(); Datab.connecter(); SqlCommand cmd = new SqlCommand("SP_Update_RDV", Datab.cnx); cmd.CommandType = CommandType.StoredProcedure; SqlParameter param1; param1 = cmd.Parameters.Add("@dte", SqlDbType.DateTime); param1.Value = datardv.date; SqlParameter param2; param2 = cmd.Parameters.Add("@imp", SqlDbType.Int); if (datardv.important == "Oui") { param2.Value = 1; } else { param2.Value = 0; } SqlParameter param3; param3 = cmd.Parameters.Add("@cmnt", SqlDbType.NVarChar, 1000); param3.Value = datardv.commentaire; SqlParameter param4; param4 = cmd.Parameters.Add("@lieu", SqlDbType.NVarChar, 50); param4.Value = datardv.lieu; SqlParameter param5; param5 = cmd.Parameters.Add("@id_rd", SqlDbType.Int); param5.Value = datardv.numero; cmd.ExecuteNonQuery(); valider_but.IsEnabled = true; annuler_but.IsEnabled = true; modifier_but.IsEnabled = false; this.vider(); } }