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();
            }
        }
示例#2
0
        private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            try {
                AgendaClass show         = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                string      userDataName = UserAccessForm.getusername() + "_events_table";
                string      dato         = this.dataGridView1.CurrentCell.Value.ToString();
                comboeventoname.Text = dato;
                string orden = "select * from " + userDataName + " where `DESCRIPCION` = '" + comboeventoname.Text + "' ORDER BY PRIORIDAD ASC;";
                show.fillboxes(comboeventoname, fechabox, activobox, timebox, orden);

                if (activobox.Text == "NO")
                {
                    quitarbutton.Enabled = false;
                }
                else
                {
                    quitarbutton.Enabled = true;
                }

                if (comboeventoname.Text != "")
                {
                    editbutton.Enabled = true;
                }
                else
                {
                    editbutton.Enabled = false;
                }

                DireccionGestor.setsombrestatic(comboeventoname.Text);
                DireccionGestor.setotrostatic(fechabox.Value.Day.ToString() + "/" + fechabox.Value.Month.ToString() + "/" + fechabox.Value.Year.ToString());
            }
            catch (NullReferenceException pafh) { pafh.ToString(); }
        }
示例#3
0
        private void buscarbutton_Click(object sender, EventArgs e)
        {
            string      fechacontrol      = control.Value.Day.ToString() + "/" + control.Value.Month.ToString() + "/" + control.Value.Year.ToString();
            string      horacontrol       = control.Value.Hour.ToString() + ":" + control.Value.Minute.ToString() + ":" + control.Value.Second.ToString();
            string      fechacontrolshort = control.Value.Day.ToString() + "/" + control.Value.Month.ToString();
            string      fecha             = fechabox.Value.Day.ToString() + "/" + fechabox.Value.Month.ToString() + "/" + fechabox.Value.Year.ToString();
            string      fechashort        = fechabox.Value.Day.ToString() + "/" + fechabox.Value.Month.ToString();
            string      hora         = timebox.Value.Hour.ToString() + ":" + timebox.Value.Minute.ToString() + ":" + timebox.Value.Second.ToString();
            AgendaClass show         = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
            string      userDataName = UserAccessForm.getusername() + "_events_table";
            string      orden        = "select DESCRIPCION, `FECHA DE RECORDATORIO`, HORA from " + userDataName + " where (`DESCRIPCION` = '" + comboeventoname.Text + "' or FECHA ='" + fecha + "' or HORA ='" + hora + "' or `FECHA DE RECORDATORIO`='" + fechashort + "')AND ACTIVO ='" + activobox.Text + "'  ORDER BY PRIORIDAD ASC;";

            if (fecha == fechacontrol || fechashort == fechacontrolshort)
            {
                orden = "select DESCRIPCION, `FECHA DE RECORDATORIO`, HORA from " + userDataName + " where (`DESCRIPCION` = '" + comboeventoname.Text + "'  or HORA ='" + hora + "' )AND ACTIVO ='" + activobox.Text + "'  ORDER BY PRIORIDAD ASC;";
            }
            else if (hora == horacontrol)
            {
                orden = "select DESCRIPCION, `FECHA DE RECORDATORIO`, HORA from " + userDataName + " where (`DESCRIPCION` = '" + comboeventoname.Text + "' or FECHA ='" + fecha + "' or `FECHA DE RECORDATORIO`='" + fechashort + "')AND ACTIVO ='" + activobox.Text + "'  ORDER BY PRIORIDAD ASC;";
            }
            else if (fecha == fechacontrol || fechashort == fechacontrolshort || hora == horacontrol)
            {
                orden = "select DESCRIPCION, `FECHA DE RECORDATORIO`, HORA from " + userDataName + " where (`DESCRIPCION` = '" + comboeventoname.Text + "')AND ACTIVO ='" + activobox.Text + "' ORDER BY PRIORIDAD ASC;";
            }
            else
            {
                orden = "select DESCRIPCION, `FECHA DE RECORDATORIO`, HORA from " + userDataName + " where (`DESCRIPCION` = '" + comboeventoname.Text + "' or FECHA ='" + fecha + "' or HORA ='" + hora + "' or `FECHA DE RECORDATORIO`='" + fechashort + "')AND ACTIVO ='" + activobox.Text + "'  ORDER BY PRIORIDAD ASC;";
            }

            show.ShowDataGridfound(dataGridView1, orden);

            cuentalabel.Text = show.getcuenta().ToString();
        }
示例#4
0
        private void limpiarbutton_Click(object sender, EventArgs e)
        {
            comboeventoname.Text = "";
            activobox.Text       = "";
            timebox.Text         = DateTime.Now.TimeOfDay.ToString();
            fechabox.Text        = DateTime.Now.TimeOfDay.ToString();
            AgendaClass show = new AgendaClass();

            show.ShowDataGrid(dataGridView1, UserAccessForm.getusername());
            cuentalabel.Text = show.getcuenta().ToString();
        }
示例#5
0
        private void comboeventoname_SelectedIndexChanged(object sender, EventArgs e)
        {
            AgendaClass show         = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
            string      userDataName = UserAccessForm.getusername() + "_events_table";
            string      orden        = "select DESCRIPCION, `FECHA DE RECORDATORIO`, HORA from " + userDataName + " where  DESCRIPCION= '" + comboeventoname.Text + "' AND ACTIVO ='" + activobox.Text + "'  ORDER BY PRIORIDAD ASC;";

            show.ShowDataGridfound(dataGridView1, orden);


            cuentalabel.Text = show.getcuenta().ToString();
        }
示例#6
0
        private void quitarbutton_Click(object sender, EventArgs e)
        {
            string userdataname = UserAccessForm.getusername() + "_events_table";

            string      orden = "UPDATE " + userdataname + " SET ACTIVO = 'NO' WHERE  `DESCRIPCION`= '" + nombre + "' ;";
            AgendaClass kit   = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());

            kit.ordensql(orden);
            MessageBox.Show("TAREA " + nombre + " DESACTIVADA");

            quitarbutton.Enabled = false;
        }
示例#7
0
        private void AgendaEvents_Load(object sender, EventArgs e)
        {
            control.Hide();
            editbutton.Enabled   = false;
            quitarbutton.Enabled = false;
            activobox.Text       = "SI";
            AgendaClass ver = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());

            ver.ShowDataGrid(dataGridView1, UserAccessForm.getusername());
            ver = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());

            string orden = "SELECT `DESCRIPCION` FROM " + UserAccessForm.getusername() + "_events_table ORDER BY PRIORIDAD ASC;";

            ver.Fillcombo(comboeventoname, orden);
            cuentalabel.Text = ver.getcuenta().ToString();
        }
示例#8
0
        private void quitarbutton_Click(object sender, EventArgs e)
        {
            if (quitarbutton.Text == "NO")
            {
                MessageBox.Show("LA TAREA DEBE DE ESTAR ACTIVA");
            }
            else if (comboeventoname.Text == "")
            {
                MessageBox.Show("DEBE SELECCIONAR UNA TAREA PARA DESACTIVAR");
            }
            else
            {
                string userdataname = UserAccessForm.getusername() + "_events_table";

                string      orden = "UPDATE " + userdataname + " SET ACTIVO = 'NO' WHERE  `DESCRIPCION`= '" + comboeventoname.Text + "';";
                AgendaClass kit   = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                kit.ordensql(orden);
                MessageBox.Show("TAREA DESACTIVADA");
                kit.ShowDataGrid(dataGridView1, UserAccessForm.getusername());
            }
        }
示例#9
0
 private void datainicio_CellContentClick(object sender, DataGridViewCellEventArgs e)
 {
     if (nombre != "")
     {
         quitarbutton.Enabled = true;
     }
     else
     {
         quitarbutton.Enabled = false;
     }
     try {
         AgendaClass show         = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
         string      userDataName = UserAccessForm.getusername() + "_events_table";
         string      dato         = this.datainicio.CurrentCell.Value.ToString();
         nombre = dato;
         string orden = "select * from " + userDataName + " where `DESCRIPCION` = '" + nombre + "' ORDER BY PRIORIDAD ASC;";
         show.getname(nombre, fecha, prioridad, orden);
         DireccionGestor.setsombrestatic(nombre);
         DireccionGestor.setotrostatic(fecha);
     } catch (NullReferenceException pafh) { pafh.ToString(); }
 }
        private void cancelbutton_Click(object sender, EventArgs e)
        {
            if (DireccionGestor.getorigen() == "buscador" || DireccionGestor.getorigen() == "modificar")
            {
                AgendaEvents agendaobject = new AgendaEvents();
                agendaobject.WindowState = FormWindowState.Normal;
                agendaobject.Show();
            }
            else if (DireccionGestor.getorigen() == "editor")
            {
                AgendaEvents agendaobject = new AgendaEvents();
                agendaobject.WindowState = FormWindowState.Normal;
                agendaobject.Show();
            }
            else
            {
                AgendaClass save = new AgendaClass();
            }

            this.Close();
        }
        private void timera_Tick(object sender, EventArgs e)
        {
            if (refresh == "refresh")
            {
                refresh = "";
                LoginClass show = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                show.ShowDataGrid(findinggrid);
                namebox.Text          = "";
                tipobox.Text          = "";
                encontradoslabel.Text = show.getcuenta().ToString();
            }



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

            cuenta++;
            if (cuenta == 4000)
            {
                cuenta = 0;
                backstripbutton.PerformClick();
            }
            if (cuenta == 1000)
            {
                opcionpanel.Hide();
            }
        }
示例#12
0
        private void savebuttonstrip_Click(object sender, EventArgs e)
        {
            carga man = new carga();

            if (savebuttonstrip.Text == "GUARDAR")
            {
                man.WindowState = FormWindowState.Normal;

                if (gottendegree.Text == "" || nameEmployeeBox.Text == "" || idBox.Text == "" || telephoneNumberBox.Text == "" || schedule.Text == "" || cargobox.Text == "" || comboNacionalidad.Text == "" || ageBox.Text == "" || mensualitybox.Text == "" || personalReferenceBox.Text == "" || telephoneReferenceBox.Text == "" || relationReferenceBox.Text == "" || AlergyNmaeBox.Text == "" || DolenciaNameBox.Text == "" || nameMedicineBox.Text == "" || MotivoMedicineBox.Text == "")
                {
                    MessageBox.Show("Hay datos importantes vacios, termine el formulario.");



                    if (gottendegree.Text == "")
                    {
                        gottendegree.BackColor = Color.Red;
                    }
                    else
                    {
                        gottendegree.BackColor = Color.Green;
                    }

                    if (nameEmployeeBox.Text == "")
                    {
                        nameEmployeeBox.BackColor = Color.Red;
                    }
                    else
                    {
                        nameEmployeeBox.BackColor = Color.Green;
                    }

                    if (idBox.Text == "")
                    {
                        idBox.BackColor = Color.Red;
                    }
                    else
                    {
                        idBox.BackColor = Color.Green;
                    }

                    if (telephoneNumberBox.Text == "")
                    {
                        telephoneNumberBox.BackColor = Color.Red;
                    }
                    else
                    {
                        telephoneNumberBox.BackColor = Color.Green;
                    }

                    if (schedule.Text == "")
                    {
                        schedule.BackColor = Color.Red;
                    }
                    else
                    {
                        schedule.BackColor = Color.Green;
                    }

                    if (cargobox.Text == "")
                    {
                        cargobox.BackColor = Color.Red;
                    }
                    else
                    {
                        cargobox.BackColor = Color.Green;
                    }

                    if (comboNacionalidad.Text == "")
                    {
                        comboNacionalidad.BackColor = Color.Red;
                    }
                    else
                    {
                        comboNacionalidad.BackColor = Color.Green;
                    }

                    if (ageBox.Text == "")
                    {
                        ageBox.BackColor = Color.Red;
                    }
                    else
                    {
                        ageBox.BackColor = Color.Green;
                    }

                    if (mensualitybox.Text == "")
                    {
                        mensualitybox.BackColor = Color.Red;
                    }
                    else
                    {
                        mensualitybox.BackColor = Color.Green;
                    }

                    if (personalReferenceBox.Text == "")
                    {
                        personalReferenceBox.BackColor = Color.Red;
                    }
                    else
                    {
                        personalReferenceBox.BackColor = Color.Green;
                    }

                    if (telephoneReferenceBox.Text == "")
                    {
                        telephoneReferenceBox.BackColor = Color.Red;
                    }
                    else
                    {
                        telephoneReferenceBox.BackColor = Color.Green;
                    }

                    if (relationReferenceBox.Text == "")
                    {
                        relationReferenceBox.BackColor = Color.Red;
                    }
                    else
                    {
                        relationReferenceBox.BackColor = Color.Green;
                    }

                    if (AlergyNmaeBox.Text == "")
                    {
                        AlergyNmaeBox.BackColor = Color.Red;
                    }
                    else
                    {
                        AlergyNmaeBox.BackColor = Color.Green;
                    }

                    if (DolenciaNameBox.Text == "")
                    {
                        DolenciaNameBox.BackColor = Color.Red;
                    }
                    else
                    {
                        DolenciaNameBox.BackColor = Color.Green;
                    }

                    if (nameMedicineBox.Text == "")
                    {
                        nameMedicineBox.BackColor = Color.Red;
                    }
                    else
                    {
                        nameMedicineBox.BackColor = Color.Green;
                    }

                    if (MotivoMedicineBox.Text == "")
                    {
                        MotivoMedicineBox.BackColor = Color.Red;
                    }
                    else
                    {
                        MotivoMedicineBox.BackColor = Color.Green;
                    }
                }
                else
                {
                    try
                    {
                        string        userDataName = UserAccessForm.getusername() + "_employee_table";
                        EmployeeClass employee     = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                        employee.NameNoCopied(nameEmployeeBox.Text, userDataName);
                        int      age        = int.Parse(ageBox.Text);
                        double   mensuality = double.Parse(mensualitybox.Text);
                        DateTime birthdate  = Convert.ToDateTime(birthDateBox.Value.Date);
                        DateTime timegetin  = Convert.ToDateTime(dategetin.Value.ToShortTimeString());
                        string   access     = userDataName;

                        if (mensualitybox.BackColor == Color.Red)
                        {
                            MessageBox.Show("Arregle el campo no valido");
                        }
                        else
                        {
                            if (employee.NameNoCopied(nameEmployeeBox.Text, userDataName) == true)
                            {
                                man.Close();
                                MessageBox.Show("El Empleado " + nameEmployeeBox.Text + " ya existe.");
                                if (MessageBox.Show("Agregar a otro empleado?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                                {
                                    employee = new EmployeeClass();

                                    DireccionGestor menu = new DireccionGestor();
                                    menu.WindowState = FormWindowState.Normal;
                                    menu.Show();
                                    this.Close();
                                }
                                else
                                {
                                    employee = new EmployeeClass();

                                    EmployeeForm menu = new EmployeeForm();
                                    menu.WindowState = FormWindowState.Normal;
                                    menu.Show();
                                    this.Close();
                                }
                            }
                            else if (employee.NameNoCopied(nameEmployeeBox.Text, userDataName) == false)
                            {
                                if (gottendegree.Text == "" || nameEmployeeBox.Text == "" || idBox.Text == "" || telephoneNumberBox.Text == "" || schedule.Text == "" || cargobox.Text == "" || comboNacionalidad.Text == "" || ageBox.Text == "" || mensualitybox.Text == "" || personalReferenceBox.Text == "" || telephoneReferenceBox.Text == "" || relationReferenceBox.Text == "" || AlergyNmaeBox.Text == "" || DolenciaNameBox.Text == "" || nameMedicineBox.Text == "" || MotivoMedicineBox.Text == "")
                                {
                                    MessageBox.Show("Hay datos importantes vacios, termine el formulario.");
                                }
                                else
                                {
                                    string date       = birthDateBox.Value.Day.ToString() + "/" + birthDateBox.Value.Month.ToString() + "/" + birthDateBox.Value.Year.ToString();
                                    string evento     = birthDateBox.Value.Day.ToString() + "/" + birthDateBox.Value.Month.ToString();
                                    string eventoname = "CUMPLEAÑOS DE " + nameEmployeeBox.Text;

                                    AgendaClass addevent = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                                    addevent.saveData(UserAccessForm.getusername(), eventoname, 1, date, "7:20:0", "NO", "NO", "NO", "NO", "NO", "NO", "NO", evento, "SI", "");

                                    LoginClass add = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                                    add.AddContact(nameEmployeeBox.Text, telephoneNumberBox.Text, direccionbox.Text, emailcombo.Text, UserAccessForm.getusername().ToString());

                                    if (employee.SaveData(userDataName, dategetin, gottendegree.Text, nameEmployeeBox.Text, idBox.Text, birthDateBox, telephoneNumberBox.Text, schedule.Text, cargobox.Text, comboNacionalidad.Text, age, mensuality, personalReferenceBox.Text, telephoneReferenceBox.Text, relationReferenceBox.Text, AlergyNmaeBox.Text, DolenciaNameBox.Text, nameMedicineBox.Text, MotivoMedicineBox.Text, picturetextbox.Text, monedatipo.Text, sexobox.Text, direccionbox.Text, emailcombo.Text))
                                    {
                                        man.Close();
                                        employee.NameNoCopied(nameEmployeeBox.Text, userDataName);
                                        employee.OrderID(userDataName);
                                        MessageBox.Show("NUEVO EMPLEADO " + nameEmployeeBox.Text + " HA SIDO AGREGADO.");

                                        if (MessageBox.Show("Agregar a otro empleado?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                                        {
                                            employee = new EmployeeClass();

                                            DireccionGestor menu = new DireccionGestor();
                                            menu.WindowState = FormWindowState.Normal;
                                            menu.Show();
                                            this.Close();
                                        }
                                        else
                                        {
                                            employee = new EmployeeClass();

                                            EmployeeForm menu = new EmployeeForm();
                                            menu.WindowState = FormWindowState.Normal;
                                            menu.Show();
                                            this.Close();
                                        }
                                    }

                                    else
                                    {
                                        man.Close();

                                        MessageBox.Show("NUEVO EMPLEADO " + nameEmployeeBox.Text + "HA SIDO AGREGADO.");
                                        if (MessageBox.Show("Agregar a otro empleado?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                                        {
                                            employee = new EmployeeClass();

                                            DireccionGestor menu = new DireccionGestor();
                                            menu.WindowState = FormWindowState.Normal;
                                            menu.Show();
                                            this.Close();
                                        }
                                        else
                                        {
                                            employee = new EmployeeClass();

                                            EmployeeForm menu = new EmployeeForm();
                                            menu.WindowState = FormWindowState.Normal;
                                            menu.Show();
                                            this.Close();
                                        }
                                    }
                                }
                            }
                        }
                    }
                    catch (FormatException datethis) { datethis.ToString(); }
                }
            }
            else if (savebuttonstrip.Text == "MODIFICAR")
            {
                man.WindowState = FormWindowState.Normal;

                if (referenciaopcionbox.Text == "NO")
                {
                    man.Close();
                    telephoneNumberBox.Text   = "NINGUNA";
                    relationReferenceBox.Text = "NINGUNA";
                    personalReferenceBox.Text = "NINGUNA";
                }

                try
                {
                    man.Close();
                    string        userDataName = UserAccessForm.getusername() + "_employee_table";
                    EmployeeClass save         = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                    AgendaClass   addevent     = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());


                    double mensuality = double.Parse(mensualitybox.Text);

                    string nameevent  = "CUMPLEAÑOS DE " + nameEmployeeBox.Text;
                    string date       = birthDateBox.Value.Day.ToString() + "/" + birthDateBox.Value.Month.ToString() + "/" + birthDateBox.Value.Year.ToString();
                    string momentdate = birthDateBox.Value.Day.ToString() + "/" + birthDateBox.Value.Month.ToString();

                    save.ModifyData(DireccionGestor.getnombrestatic(), trabajando.Text, userDataName, dategetin, salidapicker, gottendegree.Text, nameEmployeeBox.Text, idBox.Text, birthDateBox,
                                    telephoneNumberBox.Text, schedule.Text, cargobox.Text, comboNacionalidad.Text, int.Parse(ageBox.Text), mensuality, personalReferenceBox.Text, telephoneNumberBox.Text,
                                    relationReferenceBox.Text, AlergyNmaeBox.Text, DolenciaNameBox.Text, nameMedicineBox.Text, MotivoMedicineBox.Text, picturetextbox.Text, monedatipo.Text,
                                    sexobox.Text, direccionbox.Text, emailcombo.Text, EmployeeClass.getids());
                    addevent.modifydata(UserAccessForm.getusername(), DireccionGestor.getnombrestatic(), nameevent, 1, date, "7:20:0", "NO", "NO", "NO", "NO", "NO", "NO", "NO", momentdate, "SI");
                    LoginClass add = new LoginClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                    add.editContact(nameEmployeeBox.Text, telephoneNumberBox.Text, direccionbox.Text, emailcombo.Text, DireccionGestor.getnombrestatic(), UserAccessForm.getusername().ToString());

                    MessageBox.Show("EL EMPLEADO " + nameEmployeeBox.Text + " HA SIDO MODIFICADO");



                    EmployeeClass      studentobject = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                    EmployeeFormSearch buscar        = new EmployeeFormSearch();
                    buscar.WindowState = FormWindowState.Maximized;
                    buscar.Show();
                    this.Close();
                }
                catch (FormatException datethis) { datethis.ToString(); }
            }
        }
示例#13
0
        private void timer_Tick(object sender, EventArgs e)
        {
            //cont.Text = cuenta.ToString();
            cuenta++;
            cuentasonido++;

            TimeClass timeobject = new TimeClass();

            clocklabel.Text = timeobject.clockshape();
            datelabel.Text  = timeobject.dateshape();

            string day = DateTime.Now.DayOfWeek.ToString();

            switch (day)
            {
            case "Monday":
                daylabel.Text = "LUNES";
                break;

            case "Tuesday":
                daylabel.Text = "MARTES";
                break;

            case "Wednesday":
                daylabel.Text = "MIERCOLES";
                break;

            case "Thursday":
                daylabel.Text = "JUEVES";
                break;

            case "Friday":
                daylabel.Text = "VIERNES";
                break;

            case "Saturday":
                daylabel.Text = "SABADO";
                break;

            case "Sunday":
                daylabel.Text = "DOMINGO";
                break;
            }


            AgendaClass ev    = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
            DateTime    fecha = DateTime.Now;

            ev.ShowDataGridinicio(datainicio, UserAccessForm.getusername(), fecha, daylabel.Text);
            cuentalabel.Text = ev.getcuenta().ToString();

            if (cuenta == 600)
            {
                cuenta = 0;
                panel1.Hide();
                eventonamelabel.Text = "";
                eventohoralabel.Text = "";
                estadostatic         = false;
            }

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



            WindowsMediaPlayer wplayer = new WindowsMediaPlayer();
            string             orden   = "SELECT DESCRIPCION, HORA, PRIORIDAD, SONIDO FROM " + UserAccessForm.getusername() + "_events_table WHERE (HORA='" + hora + "' AND ( FECHA='" + fechal + "' or `FECHA DE RECORDATORIO`='" + fechashort + "'))AND ACTIVO='SI';";

            if (ev.getnametarea(eventonamelabel, eventohoralabel, prioridadbox, melodybox, orden))
            {
                SystemSounds.Hand.Play();

                panel1.Show();

                cuenta       = 0;
                cuentasonido = 0;



                setsombrestatic(eventonamelabel.Text);
                setotrostatic(eventohoralabel.Text);
                setprioridadstatic(prioridadbox.Text);
                setestadostatic(true);

                if (prioridadbox.Text == "0")
                {
                    panel1.BackColor = Color.Red;
                }
                else if (prioridadbox.Text == "1")
                {
                    panel1.BackColor = Color.Orange;
                }
                else if (prioridadbox.Text == "2")
                {
                    panel1.BackColor = Color.Yellow;
                }

                if (melodybox.Text != "")
                {
                    estatesong = false;
                    string path        = Environment.GetFolderPath(Environment.SpecialFolder.MyMusic);
                    string combinacion = System.IO.Path.Combine(path, UserAccessForm.getusername());

                    string melodypath = System.IO.Path.Combine(combinacion, melodybox.Text);

                    wplayer.URL = melodypath;
                    wplayer.controls.play();
                }
                else
                {
                    estatesong = true;
                }

                if (MessageBox.Show("SON LAS " + eventohoralabel.Text + " ES HORA DE " + eventonamelabel.Text, "PARAR", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    cuentasonido = 0;

                    estatesong = false;
                }
                else
                {
                    cuentasonido = 0;
                    estatesong   = true;
                }
            }

            if (cuentasonido == 300 && melodybox.Text != "" && estatesong == true)
            {
                if (MessageBox.Show("SON LAS " + eventohoralabel.Text + " ES HORA DE " + eventonamelabel.Text, "PARAR", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    cuentasonido = 0;
                    estatesong   = false;
                }
                else
                {
                    cuentasonido = 0;
                    estatesong   = true;
                }
            }

            if (estatesong == false)
            {
                wplayer.controls.stop();
            }
        }
示例#14
0
        private void DireccionGestor_Load(object sender, EventArgs e)
        {
            pagolabel.Hide();
            cobrolabel.Hide();
            addstudentlabel.Hide();
            verstudentlabel.Hide();
            addempleadolabel.Hide();
            verempleadolabel.Hide();
            ingresolabel.Hide();
            gastolabel.Hide();
            movimientolabel.Hide();
            melodybox.Hide();
            if (estadostatic == true && cuenta < 400)
            {
                if (getestadostatic() == true)
                {
                    eventonamelabel.Text = getnombrestatic();
                    eventohoralabel.Text = getotrostatic();
                    prioridadbox.Text    = getprioridadstatic();
                    setestadostatic(true);

                    if (prioridadbox.Text == "0")
                    {
                        panel1.BackColor = Color.Red;
                    }
                    else if (prioridadbox.Text == "1")
                    {
                        panel1.BackColor = Color.Orange;
                    }
                    else if (prioridadbox.Text == "2")
                    {
                        panel1.BackColor = Color.Yellow;
                    }


                    panel1.Show();
                }
                else
                {
                    panel1.Hide();
                }
            }



            estadostatic = false;


            prioridadbox.Hide();
            quitarbutton.Enabled = false;



            AgendaClass ev    = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
            DateTime    fecha = DateTime.Now;

            ev.ShowDataGridinicio(datainicio, UserAccessForm.getusername(), fecha, daylabel.Text);
            cuentalabel.Text = ev.getcuenta().ToString();

            if (UserAccessForm.getusername() != "")
            {
                //nameuserlabel.Text = UserAccessForm.getusername();
                statelabel.Text   = "Conectado";
                databaseinfo.Text = "MySQL " + UserAccessForm.getdbserver();
            }
        }
        private void agendaAdd_Load(object sender, EventArgs e)
        {
            //SystemSounds.Hand.Play();
            playmusic.Hide();
            stopmusic.Hide();

            activobox.Hide();
            labelactivo.Hide();
            AgendaClass add   = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
            string      orden = "SELECT distinct `SONIDO` FROM " + UserAccessForm.getusername() + "_events_table;";

            add.Fillcombo(melodybox, orden);

            if (DireccionGestor.getorigen() == "modificar")
            {
                activobox.Show();
                labelactivo.Show();
                titlelabel.Text = "EDITAR TAREAS";
                motivoBox.Text  = DireccionGestor.getnombrestatic();
                fecha           = DireccionGestor.getotrostatic();

                if (fecha != "00/00/0000")
                {
                    datebox.Text = fecha;
                }
                else
                {
                    datebox.Enabled = false;
                }


                AgendaClass mod = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
                orden = "SELECT * FROM " + UserAccessForm.getusername() + "_events_table WHERE DESCRIPCION= '" + DireccionGestor.getnombrestatic() + "' and FECHA = '" + DireccionGestor.getotrostatic() + "';";
                mod.filleverything(activobox, priority, shortdate, hora, lunescheck, martescheckBox, miercolescheckBox, juevescheckBox, viernescheckbox, sabadocheckBox, domingocheckBox, comborepeticion, melodybox, orden);

                if (hora != "00:00:00")
                {
                    timeBox.Text = hora;
                }
                else
                {
                    timeBox.Enabled = false;
                }

                //MessageBox.Show("LUNES "+lunes+", MARTES "+martes+", MIERCOLES "+miercoles+", JUEVES "+jueves+", VIERNES "+viernes+", SABADO "+sabado+", DOMINGO "+domingo)



                if (lunescheck.Checked == false && martescheckBox.Checked == false && miercolescheckBox.Checked == false && juevescheckBox.Checked == false && viernescheckbox.Checked == false && sabadocheckBox.Checked == false && domingocheckBox.Checked == false)
                {
                    //comborepeticion.Text = "NO";
                    paneldias.Hide();
                    datebox.Enabled = true;
                }
                else if (lunescheck.Checked == false && martescheckBox.Checked == false && miercolescheckBox.Checked == false && juevescheckBox.Checked == false && viernescheckbox.Checked == false && sabadocheckBox.Checked == false && domingocheckBox.Checked == false)
                {
                    //comborepeticion.Text = "ELEGIR";
                    paneldias.Show();

                    datebox.Enabled = false;
                    fecha           = "00/00/0000";
                }
                else if (lunescheck.Checked == true && martescheckBox.Checked == true && miercolescheckBox.Checked == true && juevescheckBox.Checked == true && viernescheckbox.Checked == true && sabadocheckBox.Checked == false && domingocheckBox.Checked == false)
                {
                    //comborepeticion.Text = "DIARIO";
                    paneldias.Show();

                    datebox.Enabled = false;
                    fecha           = "00/00/0000";
                }
                else if (lunescheck.Checked == true && martescheckBox.Checked == true && miercolescheckBox.Checked == true && juevescheckBox.Checked == true && viernescheckbox.Checked == true && sabadocheckBox.Checked == true && domingocheckBox.Checked == true)
                {
                    //comborepeticion.Text = "TODOS LOS DIAS";
                    paneldias.Show();
                    fecha           = "00/00/0000";
                    datebox.Enabled = false;
                }
            }
            else
            {
                priority.Text        = "NORMAL";
                comborepeticion.Text = "NO";
            }


            OKbutton.BackColor        = Color.Green;
            cancelbutton.BackColor    = Color.Red;
            tareasverbutton.BackColor = Color.Blue;
        }
        private void OKbutton_Click(object sender, EventArgs e)
        {
            string fecharecordatorio = "00/00";

            fecha = datebox.Value.Day.ToString() + "/" + datebox.Value.Month.ToString() + "/" + datebox.Value.Year.ToString();
            string hora = timeBox.Value.Hour.ToString() + ":" + timeBox.Value.Minute.ToString() + ":" + timeBox.Value.Second.ToString();

            AgendaClass agenda = new AgendaClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
            string      user   = UserAccessForm.getusername();

            if (lunescheck.Checked == true)
            {
                dias[0] = "SI";
            }
            else
            {
                dias[0] = "NO";
            }
            if (martescheckBox.Checked == true)
            {
                dias[1] = "SI";
            }
            else
            {
                dias[1] = "NO";
            }
            if (miercolescheckBox.Checked == true)
            {
                dias[2] = "SI";
            }
            else
            {
                dias[2] = "NO";
            }
            if (juevescheckBox.Checked == true)
            {
                dias[3] = "SI";
            }
            else
            {
                dias[3] = "NO";
            }
            if (viernescheckbox.Checked == true)
            {
                dias[4] = "SI";
            }
            else
            {
                dias[4] = "NO";
            }
            if (sabadocheckBox.Checked == true)
            {
                dias[5] = "SI";
            }
            else
            {
                dias[5] = "NO";
            }
            if (domingocheckBox.Checked == true)
            {
                dias[6] = "SI";
            }
            else
            {
                dias[6] = "NO";
            }



            int prioridad = 1;

            if (priority.Text == "MUY IMPORTANTE")
            {
                prioridad = 0;
            }
            else if (priority.Text == "NORMAL")
            {
                prioridad = 1;
            }
            else
            {
                prioridad = 2;
            }



            if (comborepeticion.Text == "NO")
            {
                fecharecordatorio = datebox.Value.Day.ToString() + "/" + datebox.Value.Month.ToString();
            }
            else
            {
                fecharecordatorio = "00/00";
            }

            // 0 - MUY IMPORTANTE
            // 1 - NORMAL
            // 2 - POCO IMPORTANTE

            if (DireccionGestor.getorigen() == "inicio" || DireccionGestor.getorigen() == "buscador")
            {
                string activo = "SI";

                if (motivoBox.Text == "" || priority.Text == "")
                {
                    MessageBox.Show("COMPLETE EL FORMULARIO");
                    if (motivoBox.Text == "")
                    {
                        motivoBox.BackColor = Color.Red;
                    }
                    else
                    {
                        motivoBox.BackColor = Color.Green;
                    }

                    if (priority.Text == "")
                    {
                        priority.BackColor = Color.Red;
                    }
                    else
                    {
                        motivoBox.BackColor = Color.Green;
                    }
                }
                else
                {
                    if (agenda.saveData(user, motivoBox.Text, prioridad, fecha, hora, dias[0], dias[1], dias[2], dias[3], dias[4], dias[5], dias[6], fecharecordatorio, activo, melodybox.Text))
                    {
                        MessageBox.Show("TAREA GUARDADA");
                        if (MessageBox.Show("Agregar otra tarea?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            agenda = new AgendaClass();
                            this.Close();
                        }
                        else
                        {
                            agenda = new AgendaClass();
                            this.Close();
                            agendaAdd menu = new agendaAdd();
                        }
                    }
                    else
                    {
                        MessageBox.Show("TAREA GUARDADA" + " " + agenda.getmessageshow());
                        if (MessageBox.Show("Agregar otra tarea?", "Agregar", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            agenda = new AgendaClass();
                            this.Close();
                        }
                        else
                        {
                            agenda = new AgendaClass();
                            this.Close();
                            agendaAdd menu = new agendaAdd();
                            menu.WindowState = FormWindowState.Normal;
                            menu.Show();
                        }
                    }
                }
            }
            else if (DireccionGestor.getorigen() == "modificar")
            {
                agenda.ordensql("UPDATE " + UserAccessForm.getusername() + "_events_table SET `DESCRIPCION`= '" + motivoBox.Text + "',  `FECHA` ='" + fecha + "',  `HORA` ='" + hora + "',  `PRIORIDAD` = '" + prioridad + "',  `LUNES`='" + dias[0] + "',  `MARTES` ='" + dias[1] + "', `MIERCOLES` ='" + dias[2] + "',  `JUEVES` ='" + dias[3] + "',  `VIERNES` ='" + dias[4] + "',  `SABADO` ='" + dias[5] + "',  `DOMINGO` ='" + dias[6] + "', `FECHA DE RECORDATORIO` ='" + fecharecordatorio + "', `ACTIVO` ='" + activobox.Text + "',`SONIDO`='" + melodybox.Text + "' WHERE  `DESCRIPCION`= '" + DireccionGestor.getnombrestatic() + "' AND FECHA ='" + DireccionGestor.getotrostatic() + "';");
                MessageBox.Show("TAREA MODIFICADA");

                AgendaEvents agendaobject = new AgendaEvents();
                agendaobject.WindowState = FormWindowState.Normal;
                agendaobject.Show();
                this.Close();
            }
        }