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();
}
}
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(); }
}
private void editbutton_Click(object sender, EventArgs e)
{
if (comboeventoname.Text == "")
{
MessageBox.Show("DEBE SELECCIONAR UNA TAREA PARA EDITAR");
}
else
{
DireccionGestor.setsombrestatic(comboeventoname.Text);
DireccionGestor.setotrostatic(fechabox.Value.Day.ToString() + "/" + fechabox.Value.Month.ToString() + "/" + fechabox.Value.Year.ToString());
DireccionGestor.setorigen("modificar");
agendaAdd agendaobject = new agendaAdd();
agendaobject.WindowState = FormWindowState.Normal;
agendaobject.Show();
}
}
private void editbutton_Click(object sender, EventArgs e)
{
DireccionGestor.setorigen("editor");
DireccionGestor.setsombrestatic(namelabel.Text);
DireccionGestor.setotrostatic(joblabel.Text);
string userDataName = UserAccessForm.getusername() + "_employee_table";
EmployeeClass student = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
string orden = "SELECT * FROM " + userDataName + " WHERE `NOMBRE COMPLETO`= '" + namelabel.Text + "' and EDAD = '" + agelabel.Text + "';";
DireccionGestor.setorigen("editor");
DireccionGestor.setordensql(orden);
EmployeeForm studentaddobject = new EmployeeForm();
studentaddobject.WindowState = FormWindowState.Maximized;
studentaddobject.Show();
this.Close();
}
private void editbutton_Click(object sender, EventArgs e)
{
DireccionGestor.setsombrestatic(namelabel.Text);
DireccionGestor.setotrostatic(gradelabel.Text);
string userDataName = UserAccessForm.getusername() + "_student_table";
StudentsClass student = new StudentsClass();
string orden = "select * from " + userDataName + " where `NOMBRE COMPLETO` = '" + namelabel.Text + "' and CURSO= '" + gradelabel.Text + "';";
DireccionGestor.setorigen("editor");
DireccionGestor.setordensql(orden);
StudentForm studentaddobject = new StudentForm();
studentaddobject.WindowState = FormWindowState.Maximized;
studentaddobject.Show();
this.Close();
}
private void editbutton_Click(object sender, EventArgs e)
{
if (cargobox.Text == "" || edadbox.Text == "" || comboname.Text == "")
{
MessageBox.Show("Hay datos importantes faltantes.");
if (cargobox.Text == "")
{
cargobox.BackColor = Color.Red;
}
if (edadbox.Text == "")
{
edadbox.BackColor = Color.Red;
}
if (comboname.Text == "")
{
comboname.BackColor = Color.Red;
}
}
else
{
DireccionGestor.setsombrestatic(comboname.Text);
DireccionGestor.setedadstatic(int.Parse(edadbox.Text));
DireccionGestor.setotrostatic(cargobox.Text);
string userDataName = UserAccessForm.getusername() + "_employee_table";
EmployeeClass student = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
string orden = "SELECT * FROM " + userDataName + " WHERE `NOMBRE COMPLETO`= '" + comboname.Text + "' and EDAD = '" + edadbox.Text + "' and ID='" + EmployeeClass.getids() + "';";
DireccionGestor.setorigen("editor");
DireccionGestor.setordensql(orden);
if (student.fillcombos(comboname, edadbox, cargobox, orden) == true)
{
EmployeeForm studentaddobject = new EmployeeForm();
studentaddobject.WindowState = FormWindowState.Maximized;
studentaddobject.Show();
this.Close();
}
}
}
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 editbutton_Click(object sender, EventArgs e)
{
if (gradebox.Text == "" || edadbox.Text == "" || namebox.Text == "")
{
MessageBox.Show("Hay datos importantes faltantes.");
if (gradebox.Text == "")
{
gradebox.BackColor = Color.Red;
}
if (edadbox.Text == "")
{
edadbox.BackColor = Color.Red;
}
if (namebox.Text == "")
{
namebox.BackColor = Color.Red;
}
}
else
{
DireccionGestor.setsombrestatic(namebox.Text);
DireccionGestor.setedadstatic(int.Parse(edadbox.Text));
DireccionGestor.setotrostatic(gradebox.Text);
string userDataName = UserAccessForm.getusername() + "_student_table";
StudentsClass student = new StudentsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
string orden = "select * from " + userDataName + " where `NOMBRE COMPLETO` = '" + namebox.Text + "' and EDAD = '" + edadbox.Text + "' and CURSO= '" + gradebox.Text + "';";
if (student.fillcombos(namebox, edadbox, gradebox, orden) == true)
{
DireccionGestor.setorigen("editor");
DireccionGestor.setordensql(orden);
StudentForm studentaddobject = new StudentForm();
studentaddobject.WindowState = FormWindowState.Maximized;
studentaddobject.Show();
this.Close();
}
}
}