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();
}
}
