public Today(Formulario Padre, MySQL_DB Connection)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
InitializeComponent();
this.Padre = Padre;
this.Connection = Connection;
LBL_FECHA.Content = "Hoy es " + DateTime.Now.ToLongDateString();
string fecha_hoy = DateTime.Now.ToString("yyyyMMdd");
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT COUNT(*) FROM TAR_TAREAS WHERE TAR_F_OBJETIVO = " + fecha_hoy + " AND TAR_USR_ID_PK = " + Padre.getUsrID().ToString());
if (Connection.Conectar())
{
Connection.Desconectar();
}
LBL_NUM_TAREAS.Content = Connection.getData(0, 0);
Connection.ChangeTable("HOR_HORARIOS", null);
Connection.ChangeSelect("SELECT HOR_ID_PK, HOR_D_SEMANA FROM HOR_HORARIOS, ASG_ASIGNATURAS, CUR_CURSOS WHERE HOR_ASG_ID_PK = ASG_ID_PK AND ASG_CUR_ID_PK = CUR_ID_PK AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + " ORDER BY HOR_F_COMIENZO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
int count = 0;
LISTA.Children.Add(new TaskBlankSpace());
if (Connection.countRows() > 0)
{
int iterations = Connection.countRows();
for (int x = 0; x < iterations; x++)
{
Connection.ChangeTable("HOR_HORARIOS", null);
Connection.ChangeSelect("SELECT HOR_ID_PK, HOR_D_SEMANA FROM HOR_HORARIOS, ASG_ASIGNATURAS, CUR_CURSOS WHERE HOR_ASG_ID_PK = ASG_ID_PK AND ASG_CUR_ID_PK = CUR_ID_PK AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + " ORDER BY HOR_F_COMIENZO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
if (isToday(Connection.getData(x, 1)))
{
LISTA.Children.Add(new TodaySchedule(Padre, Connection, int.Parse(Connection.getData(x, 0))));
count++;
}
}
}
LISTA.Children.Add(new TaskBlankSpace());
LBL_INFO_CLASES.Content = "Hoy tienes " + count.ToString() + " clases";
if (count == 0)
{
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
this.Padre.Size = new System.Drawing.Size(476, 503);
this.Padre.BTN_Exit.Visible = true;
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void TXT_COMBO_CURSO_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
TXT_COMBO_ASIGNATURA.Items.Clear();
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_NOMBRE FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK = (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_NOMBRE LIKE '" + TXT_COMBO_CURSO.Items[TXT_COMBO_CURSO.SelectedIndex].ToString() + "' AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + ")");
if (Connection.Conectar())
{
Connection.Desconectar();
}
for (int x = 0; x < Connection.countRows(); x++)
{
TXT_COMBO_ASIGNATURA.Items.Add(Connection.getData(x, 0));
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_ELIMINAR_Click(object sender, System.Windows.RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (MessageBox.Show("¡Atención!\n¿Estás seguro de que quieres borrar el curso?\nTen en cuenta que todas las asignaturas, horarios y tareas vinculadas con el mismo también se borrarán !", "Información", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT * FROM CUR_CURSOS WHERE CUR_ID_PK = " + this.course_ID.ToString());
if (Connection.Conectar())
{
Connection.Delete_String("DELETE FROM CUR_CURSOS WHERE CUR_ID_PK = " + this.course_ID.ToString());
Connection.Delete_Execute();
Connection.Desconectar();
}
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_ID_PK FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK = " + this.course_ID.ToString());
if (Connection.Conectar())
{
Connection.Desconectar();
}
int iterations = Connection.countRows();
if (iterations > 0)
{
for (int x = 0; x < iterations; x++)
{
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_ID_PK FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK = " + this.course_ID.ToString());
if (Connection.Conectar())
{
string asg_ID = Connection.getData(0, 0);
Connection.Delete_String("DELETE FROM ASG_ASIGNATURAS WHERE ASG_ID_PK = " + asg_ID);
Connection.Delete_Execute();
Connection.Delete_String("DELETE FROM HOR_HORARIOS WHERE HOR_ASG_ID_PK = " + asg_ID);
Connection.Delete_Execute();
Connection.Delete_String("DELETE FROM TAR_TAREAS WHERE TAR_ASG_ID_PK = " + asg_ID);
Connection.Delete_Execute();
Connection.Desconectar();
}
}
}
Padre.elementHost.Child = new OrganizerCourses(Padre, Connection, false);
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
public OrganizerNewSubjects(Formulario Padre, MySQL_DB Connection, int ID)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
InitializeComponent();
this.Padre = Padre;
this.Connection = Connection;
this.subject_ID = ID;
this.Padre.Size = new System.Drawing.Size(476, 503);
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT CUR_NOMBRE FROM CUR_CURSOS WHERE CUR_USR_ID_PK = " + Padre.getUsrID().ToString());
if (Connection.Conectar())
{
Connection.Desconectar();
}
for (int x = 0; x < Connection.countRows(); x++)
{
TXT_COMBO_CURSO.Items.Add(Connection.getData(x, 0));
}
if (subject_ID != -1)
{
this.BTN_CREARASIGNATURA.Content = "Guardar los cambios";
this.BTN_BORRAR.Visibility = System.Windows.Visibility.Visible;
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT * FROM ASG_ASIGNATURAS WHERE ASG_ID_PK = " + this.subject_ID.ToString());
if (Connection.Conectar())
{
Connection.Desconectar();
}
TXT_NOMBRE.Text = Connection.getData(0, 2);
TXT_LUGAR.Text = Connection.getData(0, 3);
Connection.ChangeSelect("SELECT CUR_NOMBRE FROM CUR_CURSOS WHERE CUR_ID_PK = " + Connection.getData(0, 1));
Connection.ChangeTable("CUR_CURSOS", null);
if (Connection.Conectar())
{
Connection.Desconectar();
}
TXT_COMBO_CURSO.Text = Connection.getData(0, 0);
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
public TaskNew(Formulario Padre, MySQL_DB Connection, int ID)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
InitializeComponent();
this.Padre = Padre;
this.Connection = Connection;
this.task_ID = ID;
this.Padre.Size = new System.Drawing.Size(476, 503);
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT CUR_NOMBRE FROM CUR_CURSOS WHERE CUR_USR_ID_PK = " + Padre.getUsrID().ToString());
if (Connection.Conectar())
{
Connection.Desconectar();
}
for (int x = 0; x < Connection.countRows(); x++)
{
TXT_COMBO_CURSO.Items.Add(Connection.getData(x, 0));
}
if (task_ID != -1)
{
this.BTN_CREARTAREA.Content = "Guardar los cambios";
this.BTN_BORRAR.Visibility = System.Windows.Visibility.Visible;
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT * FROM TAR_TAREAS WHERE TAR_ID_PK = " + this.task_ID.ToString());
if (Connection.Conectar())
{
Connection.Desconectar();
}
TXT_TITULO.Text = Connection.getData(0, 1);
TXT_DESCRIPCION.Text = Connection.getData(0, 2);
if (!(string.IsNullOrEmpty(Connection.getData(0, 3))))
{
TXT_F_OBJETIVO.Text = DateTime.Parse(Connection.getData(0, 3)).ToShortDateString();
}
TXT_COMBO_PRIORIDAD.SelectedIndex = int.Parse(Connection.getData(0, 6));
TXT_COMBO_TIPO.SelectedIndex = int.Parse(Connection.getData(0, 7));
if (int.Parse(Connection.getData(0, 5)) != -1)
{
string asg_ID = Connection.getData(0, 5);
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT CUR_NOMBRE FROM CUR_CURSOS WHERE CUR_ID_PK = (SELECT ASG_CUR_ID_PK FROM ASG_ASIGNATURAS WHERE ASG_ID_PK = " + asg_ID + ")");
if (Connection.Conectar())
{
Connection.Desconectar();
}
TXT_COMBO_CURSO.Text = Connection.getData(0, 0);
TXT_COMBO_ASIGNATURA.Items.Clear();
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_NOMBRE FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK = (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_NOMBRE LIKE '" + TXT_COMBO_CURSO.Items[TXT_COMBO_CURSO.SelectedIndex].ToString() + "')");
if (Connection.Conectar())
{
Connection.Desconectar();
}
for (int x = 0; x < Connection.countRows(); x++)
{
TXT_COMBO_ASIGNATURA.Items.Add(Connection.getData(x, 0));
}
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_NOMBRE FROM ASG_ASIGNATURAS WHERE ASG_ID_PK = (SELECT TAR_ASG_ID_PK FROM TAR_TAREAS WHERE TAR_ID_PK = " + this.task_ID.ToString() + ")");
if (Connection.Conectar())
{
Connection.Desconectar();
}
TXT_COMBO_ASIGNATURA.Text = Connection.getData(0, 0);
}
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
public OrganizerSchedules(Formulario Padre, MySQL_DB Connection, int subject_ID)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
InitializeComponent();
this.Padre = Padre;
this.Connection = Connection;
this.subject_ID = subject_ID;
this.Padre.Size = new System.Drawing.Size(476, 503);
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_NOMBRE FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK IN (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + ")");
if (Connection.Conectar())
{
Connection.Desconectar();
}
for (int x = 0; x < Connection.countRows(); x++)
{
FILTRO.Items.Add(Connection.getData(x, 0));
}
LISTA.Children.Add(new TaskBlankSpace());
if (subject_ID == -1)
{
Connection.ChangeTable("HOR_HORARIOS", null);
Connection.ChangeSelect("SELECT HOR_ID_PK FROM HOR_HORARIOS WHERE HOR_ASG_ID_PK IN (SELECT ASG_ID_PK FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK IN (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + ")) ORDER BY HOR_ASG_ID_PK ASC, HOR_F_COMIENZO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
int num_schedules = Connection.countRows();
if (num_schedules > 0)
{
for (int x = 0; x < num_schedules; x++)
{
Connection.ChangeTable("HOR_HORARIOS", null);
Connection.ChangeSelect("SELECT HOR_ID_PK FROM HOR_HORARIOS WHERE HOR_ASG_ID_PK IN (SELECT ASG_ID_PK FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK IN (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + ")) ORDER BY HOR_ASG_ID_PK ASC, HOR_F_COMIENZO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
LISTA.Children.Add(new Schedule(Padre, Connection, int.Parse(Connection.getData(x, 0))));
}
}
else
{
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
}
else
{
Connection.ChangeTable("HOR_HORARIOS", null);
Connection.ChangeSelect("SELECT HOR_ID_PK FROM HOR_HORARIOS WHERE HOR_ASG_ID_PK = " + this.subject_ID + " ORDER BY HOR_ASG_ID_PK ASC, HOR_F_COMIENZO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
int num_subjects = Connection.countRows();
if (num_subjects > 0)
{
for (int x = 0; x < num_subjects; x++)
{
Connection.ChangeTable("HOR_HORARIOS", null);
Connection.ChangeSelect("SELECT HOR_ID_PK FROM HOR_HORARIOS WHERE HOR_ASG_ID_PK = " + this.subject_ID + " ORDER BY HOR_ASG_ID_PK ASC, HOR_F_COMIENZO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
LISTA.Children.Add(new Schedule(Padre, Connection, int.Parse(Connection.getData(x, 0))));
}
}
else
{
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
}
LISTA.Children.Add(new TaskBlankSpace());
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
public OrganizerCourses(Formulario Padre, MySQL_DB Connection, bool old_courses)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
InitializeComponent();
this.Padre = Padre;
this.Connection = Connection;
this.old_courses = old_courses;
this.Padre.Size = new System.Drawing.Size(476, 503);
LISTA.Children.Add(new TaskBlankSpace());
if (old_courses)
{
BTN_OLDCOURSES.Content = "Cursos actuales";
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_F_FINAL < DATE_FORMAT(NOW(),'%Y-%m-%d') AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + " ORDER BY CUR_NOMBRE ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
int num_courses = Connection.countRows();
if (num_courses > 0)
{
for (int x = 0; x < num_courses; x++)
{
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_F_FINAL < DATE_FORMAT(NOW(),'%Y-%m-%d') AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + " ORDER BY CUR_NOMBRE ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
LISTA.Children.Add(new Course(Padre, Connection, int.Parse(Connection.getData(x, 0))));
}
}
else
{
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
}
else
{
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_F_FINAL >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + " ORDER BY CUR_NOMBRE ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
int num_courses = Connection.countRows();
if (num_courses > 0)
{
for (int x = 0; x < num_courses; x++)
{
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_F_FINAL >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + " ORDER BY CUR_NOMBRE ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
LISTA.Children.Add(new Course(Padre, Connection, int.Parse(Connection.getData(x, 0))));
}
}
else
{
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
}
LISTA.Children.Add(new TaskBlankSpace());
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
public OrganizerNewSchedule(Formulario Padre, MySQL_DB Connection, int ID)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
InitializeComponent();
this.Padre = Padre;
this.Connection = Connection;
this.schedule_ID = ID;
this.Padre.Size = new System.Drawing.Size(476, 503);
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT CUR_NOMBRE FROM CUR_CURSOS WHERE CUR_USR_ID_PK = " + Padre.getUsrID().ToString());
if (Connection.Conectar())
{
Connection.Desconectar();
}
for (int x = 0; x < Connection.countRows(); x++)
{
TXT_COMBO_CURSO.Items.Add(Connection.getData(x, 0));
}
if (schedule_ID != -1)
{
this.BTN_CREARHORARIO.Content = "Guardar los cambios";
this.BTN_BORRAR.Visibility = System.Windows.Visibility.Visible;
Connection.ChangeTable("HOR_HORARIOS", null);
Connection.ChangeSelect("SELECT * FROM HOR_HORARIOS WHERE HOR_ID_PK = " + this.schedule_ID.ToString());
if (Connection.Conectar())
{
Connection.Desconectar();
}
TXT_H_COMIENZO.Text = Connection.getData(0, 2);
TXT_H_FINALIZACION.Text = Connection.getData(0, 3);
set_Days(Connection.getData(0, 4));
string asg_ID = Connection.getData(0, 1);
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT CUR_NOMBRE FROM CUR_CURSOS WHERE CUR_ID_PK = (SELECT ASG_CUR_ID_PK FROM ASG_ASIGNATURAS WHERE ASG_ID_PK = " + asg_ID + ")");
if (Connection.Conectar())
{
Connection.Desconectar();
}
TXT_COMBO_CURSO.Text = Connection.getData(0, 0);
TXT_COMBO_ASIGNATURA.Items.Clear();
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_NOMBRE FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK = (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_NOMBRE LIKE '" + TXT_COMBO_CURSO.Items[TXT_COMBO_CURSO.SelectedIndex].ToString() + "')");
if (Connection.Conectar())
{
Connection.Desconectar();
}
for (int x = 0; x < Connection.countRows(); x++)
{
TXT_COMBO_ASIGNATURA.Items.Add(Connection.getData(x, 0));
}
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_NOMBRE FROM ASG_ASIGNATURAS WHERE ASG_ID_PK = (SELECT HOR_ASG_ID_PK FROM HOR_HORARIOS WHERE HOR_ID_PK = " + this.schedule_ID.ToString() + ")");
if (Connection.Conectar())
{
Connection.Desconectar();
}
TXT_COMBO_ASIGNATURA.Text = Connection.getData(0, 0);
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
public TaskList(Formulario Padre, MySQL_DB Connection, int ID_Filtro)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
InitializeComponent();
this.Padre = Padre;
this.Connection = Connection;
this.ID_Filtro = ID_Filtro;
this.Padre.Size = new System.Drawing.Size(476, 503);
LISTA.Children.Add(new TaskBlankSpace());
switch (ID_Filtro)
{
case 0: //Fecha-Limite
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT TAR_ID_PK,TAR_F_OBJETIVO FROM TAR_TAREAS WHERE TAR_USR_ID_PK = " + Padre.getUsrID().ToString() + " AND ISNULL(TAR_F_COMPLETADA) ORDER BY TAR_F_OBJETIVO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
int num_task = Connection.countRows();
if (num_task > 0)
{
string separatordate = "Sin fecha";
if (!(string.IsNullOrEmpty(Connection.getData(0, 1))))
{
separatordate = DateTime.Parse(Connection.getData(0, 1)).ToLongDateString();
if (DateTime.Parse(separatordate).CompareTo(DateTime.Now.Date) == 0)
{
LISTA.Children.Add(new TaskSeparator("Hoy, " + separatordate));
}
else
{
LISTA.Children.Add(new TaskSeparator(separatordate));
}
}
else
{
LISTA.Children.Add(new TaskSeparator(separatordate));
}
for (int x = 0; x < num_task; x++)
{
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT TAR_ID_PK,TAR_F_OBJETIVO FROM TAR_TAREAS WHERE TAR_USR_ID_PK = " + Padre.getUsrID().ToString() + " AND ISNULL(TAR_F_COMPLETADA) ORDER BY TAR_F_OBJETIVO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
if (!(string.IsNullOrEmpty(Connection.getData(x, 1))))
{
if (separatordate != DateTime.Parse(Connection.getData(x, 1)).ToLongDateString())
{
separatordate = DateTime.Parse(Connection.getData(x, 1)).ToLongDateString();
LISTA.Children.Add(new TaskBlankSpace());
if (DateTime.Parse(separatordate).CompareTo(DateTime.Now.Date) == 0)
{
LISTA.Children.Add(new TaskSeparator("Hoy, " + separatordate));
}
else
{
LISTA.Children.Add(new TaskSeparator(separatordate));
}
}
}
LISTA.Children.Add(new Task(Padre, Connection, int.Parse(Connection.getData(x, 0))));
}
}
else
{
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
break;
case 1: //Asignatura
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT TAR_ID_PK,TAR_F_OBJETIVO,ASG_NOMBRE FROM TAR_TAREAS LEFT OUTER JOIN ASG_ASIGNATURAS ON ASG_ID_PK = TAR_ASG_ID_PK WHERE TAR_USR_ID_PK = " + Padre.getUsrID().ToString() + " AND ISNULL(TAR_F_COMPLETADA) ORDER BY ASG_NOMBRE ASC, TAR_F_OBJETIVO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
num_task = Connection.countRows();
if (num_task > 0)
{
string separatorcourse = Connection.getData(0, 2);
if (string.IsNullOrEmpty(separatorcourse))
{
LISTA.Children.Add(new TaskSeparator("Otras tareas"));
}
else
{
LISTA.Children.Add(new TaskSeparator(Connection.getData(0, 2)));
}
for (int x = 0; x < num_task; x++)
{
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT TAR_ID_PK,TAR_F_OBJETIVO,ASG_NOMBRE FROM TAR_TAREAS LEFT OUTER JOIN ASG_ASIGNATURAS ON ASG_ID_PK = TAR_ASG_ID_PK WHERE TAR_USR_ID_PK = " + Padre.getUsrID().ToString() + " AND ISNULL(TAR_F_COMPLETADA) ORDER BY ASG_NOMBRE ASC, TAR_F_OBJETIVO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
if (separatorcourse != Connection.getData(x, 2))
{
separatorcourse = Connection.getData(x, 2);
LISTA.Children.Add(new TaskBlankSpace());
if (string.IsNullOrEmpty(separatorcourse))
{
LISTA.Children.Add(new TaskSeparator("Otras tareas"));
}
else
{
LISTA.Children.Add(new TaskSeparator(separatorcourse));
}
}
LISTA.Children.Add(new Task(Padre, Connection, int.Parse(Connection.getData(x, 0))));
}
}
else
{
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
break;
case 2: //Prioridad
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT TAR_ID_PK,TAR_PRIORIDAD FROM TAR_TAREAS WHERE TAR_USR_ID_PK = " + Padre.getUsrID().ToString() + " AND ISNULL(TAR_F_COMPLETADA) ORDER BY TAR_PRIORIDAD DESC, TAR_F_OBJETIVO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
num_task = Connection.countRows();
if (num_task > 0)
{
string separatorprioridad = Connection.getData(0, 1);
switch (int.Parse(separatorprioridad))
{
case 2:
LISTA.Children.Add(new TaskSeparator("Prioridad Alta"));
break;
case 1:
LISTA.Children.Add(new TaskSeparator("Prioridad Media"));
break;
case 0:
LISTA.Children.Add(new TaskSeparator("Prioridad Baja"));
break;
}
for (int x = 0; x < num_task; x++)
{
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT TAR_ID_PK,TAR_PRIORIDAD FROM TAR_TAREAS WHERE TAR_USR_ID_PK = " + Padre.getUsrID().ToString() + " AND ISNULL(TAR_F_COMPLETADA) ORDER BY TAR_PRIORIDAD DESC, TAR_F_OBJETIVO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
if (separatorprioridad != Connection.getData(x, 1))
{
separatorprioridad = Connection.getData(x, 1);
LISTA.Children.Add(new TaskBlankSpace());
switch (int.Parse(separatorprioridad))
{
case 2:
LISTA.Children.Add(new TaskSeparator("Prioridad Alta"));
break;
case 1:
LISTA.Children.Add(new TaskSeparator("Prioridad Media"));
break;
case 0:
LISTA.Children.Add(new TaskSeparator("Prioridad Baja"));
break;
}
}
LISTA.Children.Add(new Task(Padre, Connection, int.Parse(Connection.getData(x, 0))));
}
}
else
{
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
break;
case 3: //Completadas
BTN_COMPLETADAS.Content = "Ver Pendientes";
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT TAR_ID_PK,TAR_F_OBJETIVO FROM TAR_TAREAS WHERE TAR_USR_ID_PK = " + Padre.getUsrID().ToString() + " AND NOT ISNULL(TAR_F_COMPLETADA) ORDER BY TAR_F_OBJETIVO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
int num_task_completed = Connection.countRows();
if (num_task_completed > 0)
{
string separatordate = "Sin fecha";
if (!(string.IsNullOrEmpty(Connection.getData(0, 1))))
{
separatordate = DateTime.Parse(Connection.getData(0, 1)).ToLongDateString();
if (DateTime.Parse(separatordate).CompareTo(DateTime.Now.Date) == 0)
{
LISTA.Children.Add(new TaskSeparator("Hoy, " + separatordate));
}
else
{
LISTA.Children.Add(new TaskSeparator(separatordate));
}
}
else
{
LISTA.Children.Add(new TaskSeparator(separatordate));
}
for (int x = 0; x < num_task_completed; x++)
{
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT TAR_ID_PK,TAR_F_OBJETIVO FROM TAR_TAREAS WHERE TAR_USR_ID_PK = " + Padre.getUsrID().ToString() + " AND NOT ISNULL(TAR_F_COMPLETADA) ORDER BY TAR_F_OBJETIVO ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
if (!(string.IsNullOrEmpty(Connection.getData(x, 1))))
{
if (separatordate != DateTime.Parse(Connection.getData(x, 1)).ToLongDateString())
{
separatordate = DateTime.Parse(Connection.getData(x, 1)).ToLongDateString();
LISTA.Children.Add(new TaskBlankSpace());
if (DateTime.Parse(separatordate).CompareTo(DateTime.Now.Date) == 0)
{
LISTA.Children.Add(new TaskSeparator("Hoy, " + separatordate));
}
else
{
LISTA.Children.Add(new TaskSeparator(separatordate));
}
}
}
LISTA.Children.Add(new Task(Padre, Connection, int.Parse(Connection.getData(x, 0))));
}
}
else
{
LBL_NOTFOUND.Content = "No tienes tareas completadas";
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
break;
}
LISTA.Children.Add(new TaskBlankSpace());
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_Identificarse_Click(object sender, RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (Connection.testConnection())
{
if (!(string.IsNullOrEmpty(TXT_USUARIO.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_PASSWORD.Password.Trim().Replace('\'', ' '))))
{
Connection.ChangeTable("USR_USUARIOS", null);
Connection.ChangeSelect("SELECT * FROM USR_USUARIOS WHERE BINARY USR_NICK = '" + TXT_USUARIO.Text.Trim().Replace('\'', ' ') + "' AND BINARY USR_PASSWORD = '******'\'', ' ')) + "'");
if (Connection.Conectar())
{
if (Connection.countRows() == 1)
{
if (Connection.getData(0, 9) == "Activo")
{
Padre.menuHoy.Visible = true;
Padre.menuTareas.Visible = true;
Padre.menuPlanificador.Visible = true;
Padre.menuPerfil.Visible = true;
Padre.TXT_USUARIO.Text = TXT_USUARIO.Text.Trim().Replace('\'', ' ');
Padre.setUsrID(int.Parse(Connection.getData(0, 0)));
Connection.Update_String("UPDATE USR_USUARIOS SET USR_F_ULTIMA_V = '" + DateTime.Now.ToString("yyyyMMdd") + "', USR_LAST_IP = '" + ObtenerIP.ExternalIPAddress.ToString() + "' WHERE USR_ID_PK = " + Padre.getUsrID());
Connection.Update_Execute();
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Login','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "'," + Padre.getUsrID() + ")");
Connection.Insert_Execute();
Padre.elementHost.Child = new Today(Padre, Connection);
}
else
{
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Inactive Login','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "'," + Connection.getData(0, 0) + ")");
Connection.Insert_Execute();
MessageBox.Show("Error, tu cuenta de usuario no está activada.\nSolicita a un administrador su activación", "Información");
}
}
else
{
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Bad Login','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "', 0)");
Connection.Insert_Execute();
MessageBox.Show("Error, usuario y/o contraseña incorrectos.\nRecuerda que ambos campos son sensibles a mayúsculas y minúsculas.", "Información");
TXT_PASSWORD.Password = "";
}
Connection.Desconectar();
}
}
else
{
MessageBox.Show("¡Debes introducir el usuario y la contraseña!", "Información");
}
}
else
{
MessageBox.Show("Error, no se ha podido establecer conexión con el servidor", "Información");
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_CREATE_ACCOUNT_Click(object sender, RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (Connection.testConnection())
{
if (!(string.IsNullOrEmpty(TXT_NICK.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_PASSWORD.Password.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_RE_PASSWORD.Password.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_NOMBRE.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_EMAIL.Text.Trim().Replace('\'', ' '))))
{
if (TXT_PASSWORD.Password.Trim().Replace('\'', ' ') == TXT_RE_PASSWORD.Password.Trim().Replace('\'', ' '))
{
Connection.ChangeTable("USR_USUARIOS", null);
Connection.ChangeSelect("SELECT USR_NICK FROM USR_USUARIOS WHERE BINARY UPPER(USR_NICK) = '" + TXT_NICK.Text.ToUpper().Trim().Replace('\'', ' ') + "'");
if (Connection.Conectar())
{
Connection.Desconectar();
}
if (!(Connection.countRows() > 0))
{
Connection.Conectar();
Connection.Insert_String("INSERT INTO USR_USUARIOS (USR_NICK,USR_PASSWORD,USR_NOMBRE,USR_EMAIL,USR_F_REGISTRO,USR_F_ULTIMA_V,USR_LAST_IP) VALUES (" +
"'" + TXT_NICK.Text.Trim().Replace('\'', ' ') + "','" + EncriptarMD5.Encript(TXT_PASSWORD.Password.Trim().Replace('\'', ' ')) + "','" + TXT_NOMBRE.Text.Trim().Replace('\'', ' ') + "','" + TXT_EMAIL.Text.Trim().Replace('\'', ' ') + "','" + DateTime.Now.ToString("yyyyMMdd") + "','" + DateTime.Now.ToString("yyyyMMdd") + "','" + ObtenerIP.ExternalIPAddress.ToString() + "')");
Connection.Insert_Execute();
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Register User','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "', 0)");
Connection.Insert_Execute();
Connection.Desconectar();
MessageBox.Show("¡Cuenta creada!\nRecuerda que es necesario que un administrador la active para poder usarla", "Información");
Padre.elementHost.Child = new Login(Padre, Connection);
}
else
{
if (Connection.Conectar())
{
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Bad Register User','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "', 0)");
Connection.Insert_Execute();
Connection.Desconectar();
}
MessageBox.Show("Lo siento, ese nick ya está siendo utilizado", "Información");
TXT_NICK.Text = "";
TXT_PASSWORD.Password = "";
TXT_RE_PASSWORD.Password = "";
}
}
else
{
MessageBox.Show("¡No has introducido correctamente ambas contraseñas!", "Información");
TXT_PASSWORD.Password = "";
TXT_RE_PASSWORD.Password = "";
}
}
else
{
MessageBox.Show("¡Debes rellenar todos los datos!", "Información");
TXT_PASSWORD.Password = "";
TXT_RE_PASSWORD.Password = "";
}
}
else
{
MessageBox.Show("Error, no se ha podido establecer conexión con el servidor", "Información");
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
