Parent.EvaluationHomePage.aspx.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Parent_EvaluationHomePage : System.Web.UI.Page
{
    // TO MAKE THIS FILE WORK
    // go to parent student table and set ParentEmailAddress to the parent account you are logging in from

    protected void Page_Load(object sender, EventArgs e)
    {

        string parentID = Session["UserID"].ToString();
        DataTable dt = new DataTable();
        SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);
        connection.Open();
        string cmdText = "select StudentEmailAddress from dbo.ParentStudent where ParentEmailAddress = '" + parentID + "'";
        SqlCommand cmd = new SqlCommand(cmdText, connection);
        cmd.ExecuteNonQuery();
        SqlDataAdapter adp = new SqlDataAdapter(cmd); // read in data from query results
        adp.Fill(dt);
        string studentID = dt.Rows[0][0].ToString();
        System.Diagnostics.Debug.WriteLine(studentID);
        // need to pass in the email address of whichever student is logged in to see their own evaluations
        GenerateTable(studentID);

    }

    private void GenerateTable(string studentID)
    {
        string ID = studentID;

        DataTable dt = CreateDataTable1(ID);
        DataTable dt2 = CreatDataTable2();
        DataTable dtBoth = myJoinMethod(dt, dt2, "EvalResponseID", "CourseID");

        System.Diagnostics.Debug.WriteLine(dtBoth.Rows[0][0].ToString());
        System.Diagnostics.Debug.WriteLine(dtBoth.Rows[0][1].ToString());
        System.Diagnostics.Debug.WriteLine(dtBoth.Rows[0][2].ToString());
        System.Diagnostics.Debug.WriteLine(dtBoth.Rows[0][3].ToString());
        System.Diagnostics.Debug.WriteLine(dtBoth.Rows[0][4].ToString());





        Table table = new Table();
        GridView grid = new GridView();
        TableRow row = null;
        table.CellSpacing = 20;
        table.CellPadding = 10;
        table.GridLines = GridLines.Vertical;

        //Add the Headers
        row = new TableRow();
        TableHeaderCell course = new TableHeaderCell();
        course.Text = "Class Name";
        row.Cells.Add(course);
        TableHeaderCell viewEval = new TableHeaderCell();
        viewEval.Text = "View Evaluation";
        row.Cells.Add(viewEval);
        table.Rows.Add(row);
        // determine which datatable has more rows so for loop captures everything
        int rowCount = dtBoth.Rows.Count;
        //System.Diagnostics.Debug.WriteLine(rowCount);
        for (int i = 0; i < rowCount; i++)
        {
            System.Diagnostics.Debug.WriteLine(dtBoth.Rows[i][1].ToString());
            System.Diagnostics.Debug.WriteLine(dtBoth.Rows[i][4].ToString());
            if (dtBoth.Rows[i][1].ToString() == dtBoth.Rows[i][4].ToString())
            {
                // Row containing the class names that the studentID passed in has taken (EvaluateeEmail to see how many evaluations have been filled out ABOUT a student)
                row = new TableRow();
                TableCell courseName = new TableCell();
                courseName.Text = dtBoth.Rows[i][3].ToString();
                row.Cells.Add(courseName);

                TableCell eval = new TableCell();
                LinkButton evalLink = new LinkButton();
                evalLink.Text = "View This Evaluation";
                evalLink.Click += evalLink_Click;
                evalLink.CommandArgument = dt.Rows[i][0].ToString();
                eval.Controls.Add(evalLink);
                row.Cells.Add(eval);
                table.Rows.Add(row);

            }





        }



        form1.Controls.Add(table);
    }

    private void evalLink_Click(object sender, EventArgs e)
    {

        LinkButton btn = (LinkButton)(sender);
        string evalResponseID = btn.CommandArgument;
        Session["EvalResponseID"] = evalResponseID;
        System.Diagnostics.Debug.WriteLine(Session["EvalResponseID"].ToString());
        Response.Redirect("Student.ViewEvaluations.aspx", false);


    }

    // This method creates a data table containing all the evaluations that have been filled out ABOUT a particular student
    // "and not respondentEmail = ..." is in the query so that evaluations filled out BY students do not get returned
    private DataTable CreateDataTable1(string ID)
    {
        DataTable dt = new DataTable();
        SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);
        connection.Open();
        string cmdText = "select EvalResponseID, RespondentEmail, EvaluateeEmail from EvalResponse where EvaluateeEmail = '" + Session["UserID"] + "' and NOT RespondentEmail = '" + Session["userID"].ToString() + "'";
        // ^^^ TODO: change this query to accept the session variable of the student email that is passed in (replace testStud@WBL.org)
        SqlCommand cmd = new SqlCommand(cmdText, connection);
        cmd.ExecuteNonQuery();
        SqlDataAdapter adp = new SqlDataAdapter(cmd); // read in data from query results
        adp.Fill(dt);

        return dt;
    }

    // this method returns all the classes and the teachers that teach them
    private DataTable CreatDataTable2()
    {
        DataTable dt = new DataTable();
        SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString);
        connection.Open();
        string cmdText = "select dbo.Course.CourseID, CourseName, EmailAddress from dbo.Course inner join dbo.CourseStaff ON dbo.Course.CourseID=dbo.CourseStaff.CourseID";
        SqlCommand cmd = new SqlCommand(cmdText, connection);
        cmd.ExecuteNonQuery();
        SqlDataAdapter adp = new SqlDataAdapter(cmd); // read in data from query results
        adp.Fill(dt);

        return dt;
    }

    public DataTable myJoinMethod(DataTable LeftTable, DataTable RightTable,
            String LeftPrimaryColumn, String RightPrimaryColumn)
    {
        //first create the datatable columns 
        DataSet mydataSet = new DataSet();
        mydataSet.Tables.Add("  ");
        DataTable myDataTable = mydataSet.Tables[0];

        //add left table columns 
        DataColumn[] dcLeftTableColumns = new DataColumn[LeftTable.Columns.Count];
        LeftTable.Columns.CopyTo(dcLeftTableColumns, 0);

        foreach (DataColumn LeftTableColumn in dcLeftTableColumns)
        {
            if (!myDataTable.Columns.Contains(LeftTableColumn.ToString()))
                myDataTable.Columns.Add(LeftTableColumn.ToString());
        }

        //now add right table columns 
        DataColumn[] dcRightTableColumns = new DataColumn[RightTable.Columns.Count];
        RightTable.Columns.CopyTo(dcRightTableColumns, 0);

        foreach (DataColumn RightTableColumn in dcRightTableColumns)
        {
            if (!myDataTable.Columns.Contains(RightTableColumn.ToString()))
            {
                if (RightTableColumn.ToString() != RightPrimaryColumn)
                    myDataTable.Columns.Add(RightTableColumn.ToString());
            }
        }

        //add left-table data to mytable 
        foreach (DataRow LeftTableDataRows in LeftTable.Rows)
        {
            myDataTable.ImportRow(LeftTableDataRows);
        }

        ArrayList var = new ArrayList(); //this variable holds the id's which have joined 

        ArrayList LeftTableIDs = new ArrayList();
        LeftTableIDs = this.DataSetToArrayList(0, LeftTable);

        //import righttable which having not equal Id's with lefttable 
        foreach (DataRow rightTableDataRows in RightTable.Rows)
        {
            if (LeftTableIDs.Contains(rightTableDataRows[0]))
            {
                string wherecondition = "[" + myDataTable.Columns[0].ColumnName + "]='"
                        + rightTableDataRows[0].ToString() + "'";
                DataRow[] dr = myDataTable.Select(wherecondition);
                int iIndex = myDataTable.Rows.IndexOf(dr[0]);

                foreach (DataColumn dc in RightTable.Columns)
                {
                    if (dc.Ordinal != 0)
                        myDataTable.Rows[iIndex][dc.ColumnName.ToString().Trim()] =
                rightTableDataRows[dc.ColumnName.ToString().Trim()].ToString();
                }
            }
            else
            {
                int count = myDataTable.Rows.Count;
                DataRow row = myDataTable.NewRow();
                row[0] = rightTableDataRows[0].ToString();
                myDataTable.Rows.Add(row);
                foreach (DataColumn dc in RightTable.Columns)
                {
                    if (dc.Ordinal != 0)
                        myDataTable.Rows[count][dc.ColumnName.ToString().Trim()] =
                rightTableDataRows[dc.ColumnName.ToString().Trim()].ToString();
                }
            }
        }

        return myDataTable;
    }

    private ArrayList DataSetToArrayList(int p, DataTable dataTable)
    {
        ArrayList output = new ArrayList();

        foreach (DataRow row in dataTable.Rows)
            output.Add(row[p]);

        return output;
    }
}