private void valid_alert_tache(alerte_class alerte) { methodes meth = new methodes(); if (m == null) { if (taches == null) { page.Show(); page.set_alarm(alerte); this.Close(); } else { alerte.setidalerte((t.get_alert()).getidalerte()); alerte.setidutilis(t.get_id_user()); alerte.setidtach(t.get_id()); t.set_alert(alerte); (t.get_alert()).Modifier_aler_tache_bdd((t.get_alert()).getidalerte(), (t.get_alert())); meth.supprimer_alerte_planifiée(t.get_des()); meth.Creer_tache_planif(alerte, t.get_des(), t.get_date(), "t"); taches.clear_listbox(); taches.afficher(taches.get_list()); this.Close(); } } else { alerte.setidalerte((t.get_alert()).getidalerte()); alerte.setidtach(t.get_id()); m.set_alarm(alerte); m.Show(); this.Close(); } }
private void Creer_tache_planif(alerte_class a, String Design, DateTime planiftemp) { var startInfo = new ProcessStartInfo(); startInfo.FileName = "schtasks.exe"; startInfo.UseShellExecute = false; String myfile = @"<?xml version=""1.0"" encoding=""UTF-16""?> <Task version = ""1.2"" xmlns = ""http://schemas.microsoft.com/windows/2004/02/mit/task"" > <RegistrationInfo > <Date >" + DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss") + @"</Date > <Author > MAISONXP - PC\MAISON XP</Author > <Description >Il faut réussir</Description > </RegistrationInfo > <Triggers > <TimeTrigger > <StartBoundary > " + a.gettemps().ToString("yyyy-MM-ddTHH:mm:ss") + @" </StartBoundary > <Enabled > true </Enabled > </TimeTrigger > </Triggers > <Principals > <Principal> <LogonType > InteractiveToken </LogonType > <RunLevel > LeastPrivilege </RunLevel > </Principal > </Principals > <Settings > <MultipleInstancesPolicy > IgnoreNew </MultipleInstancesPolicy > <DisallowStartIfOnBatteries > false </DisallowStartIfOnBatteries > <StopIfGoingOnBatteries > false </StopIfGoingOnBatteries > <AllowHardTerminate > true </AllowHardTerminate > <StartWhenAvailable > true </StartWhenAvailable > <RunOnlyIfNetworkAvailable > false </RunOnlyIfNetworkAvailable > <IdleSettings > <StopOnIdleEnd > true </StopOnIdleEnd > <RestartOnIdle > false </RestartOnIdle > </IdleSettings > <AllowStartOnDemand > true </AllowStartOnDemand > <Enabled > true </Enabled > <Hidden > false </Hidden > <RunOnlyIfIdle > false </RunOnlyIfIdle > <WakeToRun > true </WakeToRun > <ExecutionTimeLimit > P1D </ExecutionTimeLimit > <Priority > 7 </Priority > </Settings > <Actions Context = ""Author"" > <Exec > <Command > " + System.IO.Directory.GetCurrentDirectory() + @"\Affichage_alerte.exe" + @"</Command> <Arguments >" + @"""" + Design + @"""" + " " + @"""" + a.getson() + @"""" + " " + @"""" + planiftemp.ToString() + @"""" + @"</Arguments> </Exec > </Actions > </Task > "; String pathString = System.IO.Directory.GetCurrentDirectory() + @"tachplanif.xml"; System.IO.File.WriteAllText(pathString, myfile); startInfo.Arguments = @"/Create /XML " + @"""" + pathString + @"""" + " /TN " + @"""" + Design + @""""; startInfo.CreateNoWindow = true; var p1 = Process.Start(startInfo); p1.WaitForExit(); }
public void Modifer_alerte(alerte_class alerte, DateTime temp, int id_tache, int id_éven, int id_user, String Son, bool activ) { alerte.settemps(temp); alerte.setson(Son); alerte.setidévèn(id_évèn); alerte.setidutilis(id_utilis); alerte.setidtach(id_tach); alerte.setactiver(activ); }
private void valider_Click(object sender, RoutedEventArgs e) { if (Date.Text != "" && music.Text != "") { if (Date.Value <= DateTime.Now) { System.Windows.Forms.MessageBox.Show("Vous ne pouvez pas insérer une alerte avec une date antérieure"); } else { alerte_class alerte = new alerte_class(music.Text, id_user, 0, Convert.ToDateTime(Date.Text), /*activer.IsChecked.Value*/ true); //yab9a 0 psq f nouvelle l'identifiant makancho if (this.eve == null) { valid_alert_tache(alerte); } else { valid_alert_event(alerte); } /* if (m == null) * { * if (taches == null) * { * * page.Show(); page.set_alarm(alerte); this.Close(); * } * else * { * alerte.setidalerte((t.get_alert()).getidalerte()); * alerte.setidutilis(t.get_id_user()); * alerte.setidtach(t.get_id()); * t.set_alert(alerte); * (t.get_alert()).Modifier_aler_tache_bdd((t.get_alert()).getidalerte(), (t.get_alert())); * meth.supprimer_alerte_planifiée(t.get_des()); * meth.Creer_tache_planif(alerte, t.get_des(), t.get_date(), "t"); * taches.clear_listbox(); * taches.afficher(taches.get_list()); * * } * } * else { * alerte.setidalerte((t.get_alert()).getidalerte()); * alerte.setidtach(t.get_id()); * m.set_alarm(alerte); * m.Show(); * this.Close(); * } */ } } else { System.Windows.Forms.MessageBox.Show("Veuillez donner des informations"); } }
public void set_alarm(alerte_class a) { t.set_alert(a); Image img = new Image(); img.Source = new BitmapImage(new Uri("modif2.png", UriKind.Relative)); ajouter_alerte.Content = img; info.Text = t.get_alert().gettemps().ToString(); }
public void supprimer(alerte_class alerte) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True"); String query = "Delete from Alertes WHERE Id_alerte='" + alerte.getidalerte() + "'AND id_utilis ='" + alerte.getidutilis() + "'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public modif_alerte(alerte_class a, event_class eve, int id_user, AddEvent addev) { this.eve = new event_class(); this.eve = eve; this.addev = addev; this.id_user = id_user; this.al = a; InitializeComponent(); Date.Value = (al.gettemps()); music.Text = al.getson(); }
public modif_alerte(alerte_class a, tache t, int id_user, modif_tache m) { this.eve = null; this.t = new tache(); this.t = t; this.m = m; this.id_user = id_user; this.al = a; InitializeComponent(); Date.Value = (al.gettemps()); music.Text = al.getson(); }
private void valider_Click(object sender, RoutedEventArgs e) { if (Date.Text != "" && music.Text != "") { if (Date.Value <= DateTime.Now) { System.Windows.Forms.MessageBox.Show("Vous ne pouvez pas insérer une alerte avec une date antérieure"); } else { methodes m = new methodes(); alerte_class alerte = new alerte_class(music.Text, id_user, 0, Convert.ToDateTime(Date.Text), true); if (t == null) { if (new_event) { eve.set_alarm_tonew_event(alerte); } else { eve.set_alarm_event(alerte); } eve.Show(); this.Close(); } else { if (this.m == null) { page.set_alarm(alerte); page.Show(); this.Close();/*ajouter une tacha*/ } else { alerte.setidtach(this.t.get_id()); this.m.set_alarm(alerte); this.m.Show(); this.Close(); /*modifier une tache*/ } } // System.Windows.Forms.MessageBox.Show(alerte.gettemps().ToString("yyyy-MM-ddTHH:mm:ss")+" " + ta.textBox.Text+" "+ Convert.ToDateTime(ta.temps_tache.Text).ToString("yyyy-MM-ddTHH:mm:ss")); } } else { System.Windows.Forms.MessageBox.Show("Veuillez donner des informations"); } }
public void Modifier_aler_even_bdd(int id_alerte, alerte_class alerte) { CultureInfo culture = CultureInfo.CreateSpecificCulture("en-En"); SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True"); String query = "update Alertes set temps=@temps,id_évèn=@id_évèn,id_utilis=@id_utilis,Son=@son WHERE id_alerte=@id"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.Parameters.AddWithValue("@id", id_alerte.ToString()); cmd.Parameters.AddWithValue("@temps", alerte.gettemps().ToString("G", culture)); cmd.Parameters.AddWithValue("@id_évèn", alerte.getidévèn().ToString()); cmd.Parameters.AddWithValue("@id_utilis", alerte.getidutilis().ToString()); cmd.Parameters.AddWithValue("@son", alerte.getson()); cmd.ExecuteNonQuery(); con.Close(); }
public void set_alarm_event(alerte_class a) { if (eve == null) { new_eve.set_alerte(a); info.Text = new_eve.get_alerte().gettemps().ToString(); } else { eve.set_alerte(a); info.Text = eve.get_alerte().gettemps().ToString(); } Image img = new Image(); img.Source = new BitmapImage(new Uri("modif2.png", UriKind.Relative)); ajouter_alerte.Content = img; }
private void valid_alert_event(alerte_class alerte) { methodes meth = new methodes(); if (addev == null) { /* if (evenements == null) * { * * page.Show(); page.set_alarm(alerte); this.Close(); * } * else * {*/ alerte.setidalerte((eve.get_alerte()).getidalerte()); alerte.setidutilis(eve.getIdUtilis()); alerte.setidévèn(eve.getId()); eve.set_alerte(alerte); (eve.get_alerte()).Modifier_aler_even_bdd((eve.get_alerte()).getidalerte(), (eve.get_alerte())); meth.supprimer_alerte_planifiée(eve.getDesig()); meth.Creer_tache_planif(alerte, eve.getDesig(), eve.getDate(), "e"); evenements.clear_listbox(); evenements.afficher(evenements.get_list()); this.Close(); //} } else { if (eve.getId() > 0) { alerte.setidalerte((eve.get_alerte()).getidalerte()); alerte.setidévèn(eve.getId()); addev.set_alarm_event(alerte); addev.Show(); } else { addev.Show(); addev.set_alarm_event(alerte); this.Close(); } this.Close(); } }
public int inserer_alerte_even(alerte_class alerte) { int id_alerte = 0; try { CultureInfo culture = CultureInfo.CreateSpecificCulture("en-En"); SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True"); String query = "INSERT INTO Alertes(temps,id_évèn,activer,son,id_utilis) output INSERTED.id_alerte VALUES ('" + alerte.gettemps().ToString("G", culture) + "','" + alerte.getidévèn().ToString() + "','" + /*activ*/ alerte.getactiver() + "','" + alerte.getson() + "','" + alerte.getidutilis() + "')"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); id_alerte = (int)cmd.ExecuteScalar(); con.Close(); MessageBox.Show("Données enregistrées"); } catch (Exception e) { MessageBox.Show(string.Concat("Erreur : ", e.Message)); } setidalerte(id_alerte); return(id_alerte); }
public void afficher(List <event_class> list) { foreach (event_class con in list) { Grid Item = new Grid(); //header StackPanel big = new StackPanel(); big.Orientation = Orientation.Horizontal; big.HorizontalAlignment = HorizontalAlignment.Left; big.Width = 1200; /*StackPanel info = new StackPanel(); * info.Orientation = Orientation.Horizontal; * info.Width = 670; * /*Label lbl = new Label(); * lbl.Content = con.get_des(); * CheckBox check = new CheckBox(); * info.Children.Add(check); * check.Margin = new Thickness(5, 10, 5, 0); * info.Children.Add(lbl);*/ StackPanel info = new StackPanel(); info.Orientation = Orientation.Horizontal; info.Width = 470; Label lbl = new Label(); lbl.Content = con.getDesig(); CheckBox check = new CheckBox(); info.Children.Add(check); check.Margin = new Thickness(17, 12, 5, 0); info.Children.Add(lbl); //add some buttons to header //modify StackPanel option = new StackPanel(); option.Orientation = Orientation.Horizontal; option.HorizontalAlignment = System.Windows.HorizontalAlignment.Right; option.Width = 80; Button modif = new Button(); Image ch = new Image(); ch.Source = new BitmapImage(new Uri("modif.png", UriKind.Relative)); modif.Content = ch; modif.Height = 30; modif.Width = 30; modif.Background = null; modif.Click += new RoutedEventHandler(modif_Click); option.Children.Add(modif); //delete button Button delete = new Button(); Image del = new Image(); del.Source = new BitmapImage(new Uri("delete1.png", UriKind.Relative)); delete.Click += new RoutedEventHandler(delete_Click); delete.Content = del; delete.Height = 30; delete.Width = 30; delete.Background = null; option.Children.Add(delete); big.Children.Add(info); //stack in the middle /* StackPanel mid = new StackPanel(); * mid.Width = 500; * big.Children.Add(mid);*/ option.Margin = new Thickness(600, -130, 0, 0); DropShadowBitmapEffect shadow = new DropShadowBitmapEffect(); shadow.Direction = 320; shadow.Opacity = 0.6; Item.BitmapEffect = shadow; BrushConverter bc = new BrushConverter(); Item.Background = (Brush)bc.ConvertFrom("#FFFFFF"); big.Children.Add(option); Item.Children.Add(big); //grid of expander StackPanel bigstack = new StackPanel(); bigstack.Width = 600; //priorité /*StackPanel stack1 = new StackPanel(); * stack1.Orientation = Orientation.Horizontal; * Label symb1 = new Label(); * symb1.Content = "Priorité :"; ; * symb1.Height = 30; * symb1.Width = 122; * Label lbl1 = new Label(); * lbl1.Content = con.get_prio(); * stack1.Children.Add(symb1); * stack1.Children.Add(lbl1); * stack1.Margin = new Thickness(0, 30, 0, 0); * bigstack.Children.Add(stack1);*/ //lieu StackPanel stack2 = new StackPanel(); stack2.Orientation = Orientation.Horizontal; Label symb2 = new Label(); symb2.Content = "Lieu :";; symb2.Height = 30; symb2.Width = 122; Label lbl2 = new Label(); lbl2.Content = con.getLieu(); stack2.Children.Add(symb2); stack2.Children.Add(lbl2); stack2.Margin = new Thickness(0, 30, 0, 0); bigstack.Children.Add(stack2); //temps StackPanel stack3 = new StackPanel(); stack3.Orientation = Orientation.Horizontal; Label symb3 = new Label(); symb3.Content = "Date :";; symb3.Height = 30; symb3.Width = 122; Label lbl3 = new Label(); lbl3.Content = con.getDate().Date.ToString("dd/MM/yyyy"); stack3.Children.Add(symb3); stack3.Children.Add(lbl3); bigstack.Children.Add(stack3); StackPanel stack4 = new StackPanel(); stack4.Orientation = Orientation.Horizontal; Label symb4 = new Label(); symb4.Content = "Heure Début :";; symb4.Width = 122; Label lbl4 = new Label(); lbl4.Margin = new Thickness(0, 1, 0, 0); lbl4.Content = con.getDate().ToString("HH:mm"); stack4.Children.Add(symb4); stack4.Children.Add(lbl4); bigstack.Children.Add(stack4); StackPanel stack5 = new StackPanel(); stack5.Orientation = Orientation.Horizontal; Label symb5 = new Label(); symb5.Content = "Heure Fin :";; symb5.Height = 30; symb5.Width = 122; Label lbl5 = new Label(); symb5.Margin = new Thickness(0, -10, 0, 0); lbl5.Content = con.getFin().ToString("HH:mm"); stack5.Children.Add(symb5); stack5.Children.Add(lbl5); bigstack.Children.Add(stack5); bigstack.Margin = new Thickness(-500, 0, 0, 0); Item.Children.Add(bigstack); alerte_class a = con.get_alerte(); if (a != null) { StackPanel stackofalert = new StackPanel(); option.Margin = new Thickness(600, -165, 0, 0); stackofalert.Orientation = Orientation.Horizontal; stackofalert.Width = 1200; Image reveil = new Image(); reveil.Source = new BitmapImage(new Uri("reveil.png", UriKind.Relative)); reveil.Height = 20; reveil.Width = 20; stackofalert.Children.Add(reveil); Label labl6 = new Label(); labl6.Content = a.gettemps().ToString("dd/MM/yyyy HH:mm"); stackofalert.Children.Add(labl6); //modify StackPanel options_alerte = new StackPanel(); options_alerte.Orientation = Orientation.Horizontal; options_alerte.HorizontalAlignment = System.Windows.HorizontalAlignment.Right; options_alerte.Width = 80; Button modify = new Button(); Image pen = new Image(); pen.Source = new BitmapImage(new Uri("modif.png", UriKind.Relative)); modify.Content = pen; modify.Height = 30; modify.Width = 30; modify.Background = null; modify.Click += new RoutedEventHandler(modifyAlert_Click); options_alerte.Children.Add(modify); options_alerte.Margin = new Thickness(800, 0, 0, 0); //delete button Button supp = new Button(); Image su = new Image(); su.Source = new BitmapImage(new Uri("delete1.png", UriKind.Relative)); supp.Click += new RoutedEventHandler(deleteAlert_Click); supp.Content = su; supp.Height = 30; supp.Width = 30; supp.Background = null; options_alerte.Children.Add(supp); stackofalert.Margin = new Thickness(100, 160, 0, 0); stackofalert.Children.Add(options_alerte); Item.Children.Add(stackofalert); } listBox.Items.Add(Item); } }
public void set_alert(alerte_class a) { alarm = a; }
private void Enregistrer_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(dateDatePicker.Text) || string.IsNullOrEmpty(débutTimePicker.Text) || string.IsNullOrEmpty(finTimePicker.Text)) { System.Windows.Forms.MessageBox.Show(" Veillez Entrer la Date et/ou les Horaires !"); } else { DateTime d = Convert.ToDateTime(dateDatePicker.Text + " " + débutTimePicker.Text); DateTime f = Convert.ToDateTime(dateDatePicker.Text + " " + finTimePicker.Text); if (string.IsNullOrEmpty(designation.Text)) { System.Windows.Forms.MessageBox.Show(" Veillez Entrer Une Désignation Correct !"); } else { if ((d > f) || (d < DateTime.Now)) { //System.Windows.MessageBox.Show("d = " + d); //erreur.Visibility = System.Windows.Visibility.Visible; System.Windows.Forms.MessageBox.Show(" Cette Date est Déja Passée Ou Votre Horaires Ne Sont Pas Réglées !"); } else { methodes m = new methodes(); if (m.Exist(d, f, id_user)) { System.Windows.Forms.MessageBox.Show(" L'intervalle de temps donné est occupé veuillez le changer "); } else { t.update(designation.Text, prio.Text, d, f, "Non réalisée"); if (p == null) { page.add_tache_toactivity(t); } else { p.add_tache(t); int id_tache = m.Save_Tache(t.get_des(), t.get_prio(), t.get_date(), t.getfin(), t.get_etat(), a.get_id(), a.get_id_user()); alerte_class alert = t.get_alert(); if (alert != null) { alert.setidtach(id_tache); alert.inserer_alerte_tache(alert); m.Creer_tache_planif(alert, t.get_des(), t.get_date(), "t"); } List <document> list_docs = t.get_documents(); foreach (document doc in list_docs) { m.inserer_document_totache(doc.getTitre(), doc.getEmplac(), id_user, id_tache); } } Close(); } } } } }
public void set_alerte(alerte_class a) { this.a = a; }
private void Enregistrer_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(designation.Text) || string.IsNullOrEmpty(Lieu.Text) || string.IsNullOrEmpty(date.Text) || string.IsNullOrEmpty(debut.Text) || string.IsNullOrEmpty(fin.Text)) { er.Visibility = System.Windows.Visibility.Visible; } else { DateTime d = Convert.ToDateTime(date.Text + " " + debut.Text); DateTime f = Convert.ToDateTime(date.Text + " " + fin.Text); if (f < d) { erreur.Visibility = System.Windows.Visibility.Visible; } else { methodes m = new methodes(); if (eve == null) { // adition d un nouveau evenement if (m.Exist(d, f, id_user)) { System.Windows.MessageBox.Show("occupé"); } else { int id_new_event = m.save_event(designation.Text, d, f, Lieu.Text, this.id_user); new_eve.update_event(designation.Text, Lieu.Text, d, f);; new_eve.setId(id_new_event); alerte_class alert = new_eve.get_alerte(); if (alert != null) { alert.setidévèn(id_new_event); alert.inserer_alerte_even(alert); m.Creer_tache_planif(alert, new_eve.getDesig(), new_eve.getDate(), "e"); } foreach (document doc in list) { m.inserer_document_toevent(doc.getTitre(), doc.getEmplac(), id_user, id_new_event); } page.add_tolist(new_eve); page.clear_listbox(); page.afficher(page.get_list()); Close(); } } else { if (m.Exist_modif_event(d, f, eve.getId(), eve.getId())) { throw new Exception(); } else { string olddesignation = eve.getDesig(); eve.update_event(designation.Text, Lieu.Text, d, f); m.modifier_evenement(eve); if (eve.get_alerte() != null) { m.modifier_tache_planifiée(eve.get_alerte(), designation.Text, eve.getDate(), olddesignation, "e"); (eve.get_alerte()).setidutilis(eve.getIdUtilis()); (eve.get_alerte()).Modifier_aler_even_bdd((eve.get_alerte()).getidalerte(), (eve.get_alerte())); } page.clear_listbox(); page.afficher(page.get_list()); Close(); } } } } }
private void Creer_activite_Click(object sender, RoutedEventArgs e) { if (!string.IsNullOrEmpty(Designation_activité.Text)) { if (comboBox_type.SelectedIndex == 2) { Le_Type = autre_type.Text; } else { Le_Type = comboBox_type.Text; } if (string.IsNullOrEmpty(Le_Type)) { textBlock_stp_type.Visibility = System.Windows.Visibility.Visible; } else { methodes m = new methodes(); List <activ_class> list = page.get_list(); if (pos == -1) { id_act = m.insert_Activite(Designation_activité.Text, Le_Type, id_user); a = new activ_class(id_act, Designation_activité.Text, Le_Type, id_user); page.add_tolist(a); foreach (tache t in taches) { int id_tach = m.Save_Tache(t.get_des(), t.get_prio(), t.get_date(), t.getfin(), t.get_etat(), id_act, id_user); if (id_tach != 0) { alerte_class alert = t.get_alert(); if (alert != null) { alert.setidtach(id_tach); alert.inserer_alerte_tache(alert); m.Creer_tache_planif(alert, t.get_des(), t.get_date(), "t"); } List <document> list_docs = t.get_documents(); foreach (document doc in list_docs) { m.inserer_document_totache(doc.getTitre(), doc.getEmplac(), id_user, id_tach); } } } } else { m.modif_Activ(list[pos], Designation_activité.Text, Le_Type); foreach (tache t in taches) { int id_tach = m.Save_Tache(t.get_des(), t.get_prio(), t.get_date(), t.getfin(), t.get_etat(), id_act, id_user); if (id_tach != 0) { alerte_class alert = t.get_alert(); if (alert != null) { alert.setidtach(id_tach); alert.inserer_alerte_tache(alert); m.Creer_tache_planif(alert, t.get_des(), t.get_date(), "t"); } List <document> list_docs = t.get_documents(); foreach (document doc in list_docs) { m.inserer_document_totache(doc.getTitre(), doc.getEmplac(), id_user, id_tach); } } } list[pos].set_designation(Designation_activité.Text); list[pos].set_type(Le_Type); page.set_list(list); } page.clear_listbox(); page.afficher(page.get_list()); this.Close(); } } else { error.Visibility = System.Windows.Visibility.Visible; } }