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 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 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();
}
}
}
private void addbuttonstrip_Click(object sender, EventArgs e)
{
if (DireccionGestor.getorigen() == "inicio")
{
if (reasonbox.Text == "" || cuantitybox.Text == "" || explanationbox.Text == "")
{
MessageBox.Show("Hay datos importantes vacios, termine el formulario.");
if (reasonbox.Text == "")
{
reasonbox.BackColor = Color.Red;
}
else
{
reasonbox.BackColor = Color.Green;
}
if (cuantitybox.Text == "")
{
cuantitybox.BackColor = Color.Red;
}
else
{
cuantitybox.BackColor = Color.Green;
}
if (explanationbox.Text == "")
{
explanationbox.BackColor = Color.Red;
}
else
{
explanationbox.BackColor = Color.Green;
}
}
else
{
try
{
string userDataName = UserAccessForm.getusername() + "_movements_table";
MovementsClass save = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
double cuantity = double.Parse(cuantitybox.Text);
string date = datebox.Value.Day.ToString() + "/" + datebox.Value.Month.ToString() + "/" + datebox.Value.Year.ToString();
string hour = horabox.Value.Hour.ToString() + ":" + horabox.Value.Minute.ToString() + ":" + horabox.Value.Second.ToString();
DireccionGestor.setotrostatic("refresh");
if (save.setProfit(date, hour, reasonbox.Text, cuantity, monedatipo.Text, datebox.Value.Day.ToString(), datebox.Value.Month.ToString()
, datebox.Value.Year.ToString(), horabox.Value.Hour.ToString(), horabox.Value.Minute.ToString(), horabox.Value.Second.ToString(),
explanationbox.Text, fondoorigen.Text, userDataName))
{
save.OrderID(userDataName);
MessageBox.Show("NUEVO INGRESO DE DINERO A LAS " + hour + " HA SIDO REGISTRADO");
if (MessageBox.Show("REGISTRAR OTRO INGRESO DE DINERO?", "REGISTRAR", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
save = new MovementsClass();
this.Close();
IngresosForm menu = new IngresosForm();
menu.WindowState = FormWindowState.Normal;
menu.Show();
}
else
{
save = new MovementsClass();
this.Close();
}
}
else
{
MessageBox.Show("INGRESO DE DINERO A LAS " + hour + " HA SIDO REGISTRADO");
if (MessageBox.Show("REGISTRAR OTRO INGRESO DE DINERO?", "REGISTRAR", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
save = new MovementsClass();
this.Close();
IngresosForm menu = new IngresosForm();
menu.WindowState = FormWindowState.Normal;
menu.Show();
}
else
{
save = new MovementsClass();
this.Close();
}
}
}
catch (FormatException datethis) { MessageBox.Show(datethis.ToString()); }
catch (InvalidCastException datethose) { MessageBox.Show(datethose.ToString()); }
}
}
else if (DireccionGestor.getorigen() == "editor")
{
if (reasonbox.Text == "" || cuantitybox.Text == "" || explanationbox.Text == "")
{
MessageBox.Show("Hay datos importantes vacios, termine el formulario.");
if (reasonbox.Text == "")
{
reasonbox.BackColor = Color.Red;
}
else
{
reasonbox.BackColor = Color.Green;
}
if (cuantitybox.Text == "")
{
cuantitybox.BackColor = Color.Red;
}
else
{
cuantitybox.BackColor = Color.Green;
}
if (explanationbox.Text == "")
{
explanationbox.BackColor = Color.Red;
}
else
{
explanationbox.BackColor = Color.Green;
}
}
else
{
try
{
string userDataName = UserAccessForm.getusername() + "_movements_table";
MovementsClass save = new MovementsClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport());
double cuantity = double.Parse(cuantitybox.Text);
string date = datebox.Value.Day.ToString() + "/" + datebox.Value.Month.ToString() + "/" + datebox.Value.Year.ToString();
string hour = horabox.Value.Hour.ToString() + ":" + horabox.Value.Minute.ToString() + ":" + horabox.Value.Second.ToString();
//`FECHA DEL MOVIMIENTO` ,`HORA DEL MOVIMIENTO` ,MOTIVO ,INGRESO, `TIPO DE MONEDA`, DIA, MES, AÑO, HORA, MINUTO, SEGUNDO, EXPLICACION, `FORMA DE PAGO` ) values ('" + datemovement + "', '" + timemovement + "' , '" + reasonmovement + "', '" + profit + "','" + tipomoneda + "','" + dia + "','" + mes + "','" + anio + "','" + hora + "','" + minuto + "','" + segundo + "','" + explicacion + "','" + origenfondo + "'
DireccionGestor.setotrostatic("refresh");
string orden = "UPDATE " + userDataName + " SET `FECHA DEL MOVIMIENTO`='" + date + "', `HORA DEL MOVIMIENTO`='" + hour + "', MOTIVO='" + reasonbox.Text + "', INGRESO='" + cuantity + "', `TIPO DE MONEDA`='" + monedatipo.Text + "',DIA='" + datebox.Value.Day.ToString() + "', MES='" + datebox.Value.Month.ToString() + "', AÑO='" + datebox.Value.Year.ToString() + "', HORA='" + datebox.Value.Hour.ToString() + "', MINUTO='" + datebox.Value.Minute.ToString() + "', SEGUNDO='" + datebox.Value.Second.ToString() + "', EXPLICACION='" + explanationbox.Text + "', `FORMA DE PAGO`='" + fondoorigen.Text + "' WHERE ID='" + MovementsClass.getdato()[0] + "' AND `FECHA DEL MOVIMIENTO`='" + MovementsClass.getdato()[2] + "' AND `HORA DEL MOVIMIENTO`='" + MovementsClass.getdato()[3] + "';";
save.ordensql(orden);
MessageBox.Show("INGRESO DE LAS " + MovementsClass.getdato()[3] + " EL DIA " + MovementsClass.getdato()[2] + " HA SIDO EDITADO");
this.Close();
}
catch (FormatException datethis) { MessageBox.Show(datethis.ToString()); }
catch (InvalidCastException datethose) { MessageBox.Show(datethose.ToString()); }
}
}
}