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