private void timer_Tick(object sender, EventArgs e) { TimeClass timeobject = new TimeClass(); hourlabelstrip.Text = timeobject.clockshape(); datelabelstrip.Text = timeobject.dateshape(); AgendaClass ev = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string hora = DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString() + ":" + DateTime.Now.Second.ToString(); string fechal = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString();; string fechashort = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString(); string orden = "SELECT DESCRIPCION, HORA, PRIORIDAD FROM " + UserAccessForm.getusername() + "_events_table WHERE (HORA='" + hora + "' AND ( FECHA='" + fechal + "' or `FECHA DE RECORDATORIO`='" + fechashort + "'))AND ACTIVO='SI';"; if (ev.getnametarea(orden)) { DireccionGestor.setsombrestatic(ev.getname()); DireccionGestor.setotrostatic(ev.gettime()); DireccionGestor.setprioridadstatic(ev.getprioridad()); DireccionGestor.setestadostatic(true); SystemSounds.Hand.Play(); MessageBox.Show("SON LAS " + ev.gettime() + " ES HORA DE " + ev.getname()); } cuenta++; if (cuenta == 5000) { cuenta = 0; backbuttonstrip.PerformClick(); } }