public OrganizerSubjects(Formulario Padre, MySQL_DB Connection, int course_ID)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
InitializeComponent();
this.Padre = Padre;
this.Connection = Connection;
this.course_ID = course_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++)
{
FILTRO.Items.Add(Connection.getData(x, 0));
}
LISTA.Children.Add(new TaskBlankSpace());
if (course_ID == -1)
{
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("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 ASG_CUR_ID_PK ASC, ASG_NOMBRE 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("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("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 ASG_CUR_ID_PK ASC, ASG_NOMBRE ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
LISTA.Children.Add(new Subject(Padre, Connection, int.Parse(Connection.getData(x, 0))));
}
}
else
{
LBL_NOTFOUND.Visibility = Visibility.Visible;
}
}
else
{
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_ID_PK FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK = " + this.course_ID.ToString() + " ORDER BY ASG_CUR_ID_PK ASC, ASG_NOMBRE 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("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT ASG_ID_PK FROM ASG_ASIGNATURAS WHERE ASG_CUR_ID_PK = " + this.course_ID.ToString() + " ORDER BY ASG_CUR_ID_PK ASC, ASG_NOMBRE ASC");
if (Connection.Conectar())
{
Connection.Desconectar();
}
LISTA.Children.Add(new Subject(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;
}
