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