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