public void SetComplementsSql(Boolean dernierDocument) { if (dernierDocument || Properties.Settings.Default.idSuperviseurActif == 0) { complementSQL1 = " TOP(10)"; complementSQL2 = ""; modeAffichageDixDerniers = true; } else { Superviseur supv = new Superviseur(Properties.Settings.Default.idSuperviseurActif); if (supv._derniereVacation.Date != DateTime.MaxValue.Date && supv._idSuperviseur != 0) { complementSQL1 = " TOP(20)"; complementSQL2 = " WHERE dateTimeEditionBDD >= '" + supv._derniereVacation.ToString("yyyy-MM-dd") + "' "; modeAffichageDixDerniers = false; } else { SetComplementsSql(true); } } }
private void UpdateSuperviseurDerniereVacation(object sender, ElapsedEventArgs e) { App._myTimerSuperviseur.Enabled = false; Superviseur newSupv = new Superviseur(Properties.Settings.Default.idSuperviseurActif); newSupv.UpdateDerniereVacation(); }
private void SetSuperviseur() { if (Properties.Settings.Default.idSuperviseurActif != 0) { Superviseur newSupv = new Superviseur(Properties.Settings.Default.idSuperviseurActif); this.labelSuperviseur.Content = Properties.Settings.Default.subdivisionTablette + " (" + UC_WIDGET_TimelinePresentation.GetVacationName(DateTime.Now) + ") - " + newSupv._prenomSuperviseur.Substring(0, 1) + ". " + newSupv._nomSuperviseur; App._myTimerSuperviseur.Start(); } else { this.labelSuperviseur.Content = Properties.Settings.Default.subdivisionTablette + " (" + UC_WIDGET_TimelinePresentation.GetVacationName(DateTime.Now) + ")"; } App.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Render, new Action( delegate() { App._myControleAccueil.widgetDernierDocuments.Update(true); } ) ); }
private static void UpdateSuperviseurs() { Dictionary<string, object> arg = new Dictionary<string, object>(); arg.Add("@sub", Properties.Settings.Default.subdivisionTablette); MySqlDataReader Reader = ConnectorMySql.ExecCommand(@"SELECT * FROM Superviseurs WHERE subdivisionSuperviseur = @sub", arg); List<Superviseur> myList = GetSuperviseurs(); if (Reader != null) { while (Reader.Read()) { Superviseur newSupv = new Superviseur(GetDBUInt32("idSuperviseur", Reader), GetDBString("nomSuperviseur", Reader), GetDBString("prenomSuperviseur", Reader), GetDBDateTime("derniereVacation", Reader), GetDBString("subdivisionSuperviseur", Reader), GetDBString("sectionSuperviseur", Reader)); bool isPresent = false; foreach (Superviseur oldSupv in myList) { //Si le superviseur existe déjà if (oldSupv._idSuperviseur == newSupv._idSuperviseur) { isPresent = true; if (oldSupv._derniereVacation.Date != DateTime.MaxValue.Date && (oldSupv._derniereVacation > newSupv._derniereVacation || newSupv._derniereVacation.Date == DateTime.MaxValue.Date)) { oldSupv.UpdateDerniereVacationInDistantDB(); } newSupv.UpdateInLocalDB(); break; } } if (!isPresent) { newSupv.StoreInLocalDB(); } } ConnectorMySql.Close(Reader); App.Current.Dispatcher.BeginInvoke( System.Windows.Threading.DispatcherPriority.Normal, new Action( delegate() { if (App.Current.MainWindow != null) { MainWindow wind = App.Current.MainWindow as MainWindow; wind.RefreshMenuSuperviseurs(); } } )); } }