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