Beispiel #1
0
        public object ParseRowToObject(MLDataRow row)
        {
            object newSet = DataSetClass.GetInstance();

            foreach (var field in row.Data)
            {
                newSet.GetType().GetField(field.Key).SetValue(newSet, field.Value);
            }
            return(newSet);
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.Session["user"] == null)
        {

            Response.Redirect("LogIn.aspx");
        }
        else
        {

            if (Page.Session["exname"] == null)
            {
                Response.Redirect("InsCreateExam");

            }
            else
            {
                if ((Page.Session["rep"] == null) || (Page.Session["exname"] == null) || (Page.Session["section"] == null))
                {
                    Response.Redirect("InsReports");

                }
                else
                {

                    term = Page.Session["term"].ToString();

                    course = Page.Session["course"].ToString();
                    sec = Page.Session["section"].ToString();
                    exname = Page.Session["exname"].ToString();
                    rep = Page.Session["rep"].ToString();
                    user = Page.Session["user"].ToString();

                    if ((rep == "examan") || (rep == "exam_a") || (rep == "exam_b"))
                    {
                        Button1.Visible = true;
                        Button2.Visible = true;
                    }
                    else
                    {
                        Button1.Visible = false;
                        Button2.Visible = false;
                    }
                    ///////////
                    if (rep == "grades")
                    {

                        {

                            SqlConnection Scon;
                            SqlDataReader Reader;
                            SqlCommand Cmd; StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt"); line = sr.ReadLine();
                            string path2 = Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"CIT exams.mdf";
                            string sConnection = "Data Source=" + line + "\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                            string sql;
                            sql = "Select * From term";
                            Scon = new SqlConnection(sConnection);
                            Scon.Open();
                            Cmd = new SqlCommand(sql, Scon);
                            Reader = Cmd.ExecuteReader();

                            while (Reader.Read())
                            {
                                term = Reader["term"].ToString();
                            }
                            Reader.Close();
                            Scon.Close();

                        }
                        {

                            StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt");
                            line = sr.ReadLine();
                            string sConnection = "Data Source=" + line + "\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                            string sql = "SELECT exam_results.user_id, exam_results.exam_code, exam_results.d_taken, exam_results.score, exam_results.pname, exam_results.section, exam_results.course, classlist.stud_name, course.term, course.course_desc, ratio.rat FROM exam_results INNER JOIN classlist ON exam_results.course = classlist.course_code AND exam_results.section = classlist.sec AND exam_results.user_id = classlist.stud_id INNER JOIN course ON classlist.sec = course.course_sec AND exam_results.section = course.course_sec AND exam_results.course = course.course_id AND classlist.prof_id = course.sec_handler INNER JOIN ratio ON exam_results.exam_code = ratio.exname   where course.term = '" + term + "' and  exam_results.course ='" + course + "' and exam_results.section ='" + sec + "' ORDER BY    exam_results.exam_code ASC, exam_results.score DESC, classlist.stud_name ASC ";
                            SqlConnection con = new SqlConnection(sConnection);
                            con.Open();
                            SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
                            ReportDocument cryRpt = new ReportDocument();
                            DataSetClass ds = new DataSetClass();

                            adapter.Fill(ds.Tables[0]);

                            cryRpt.Load(Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"Grades.rpt");
                            cryRpt.SetDataSource(ds.Tables[0]);

                            CrystalReportViewer1.ReportSource = cryRpt;

                            CrystalReportViewer1.RefreshReport();
                            CrystalReportViewer1.RefreshReport();
                        }
                    }
                    if (rep == "class")
                    {

                        {

                            SqlConnection Scon;
                            SqlDataReader Reader;
                            SqlCommand Cmd; StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt"); line = sr.ReadLine();
                            string path2 = Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"CIT exams.mdf";
                            string sConnection = "Data Source=" + line + "\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                            string sql;
                            sql = "Select * From term";
                            Scon = new SqlConnection(sConnection);
                            Scon.Open();
                            Cmd = new SqlCommand(sql, Scon);
                            Reader = Cmd.ExecuteReader();

                            while (Reader.Read())
                            {
                               term = Reader["term"].ToString();
                            }
                            Reader.Close();
                            Scon.Close();

                        }
                        {

                            StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt");
                            line = sr.ReadLine();
                            string sConnection = "Data Source=" + line + "\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                            string sql = "Select * From classlist where stud_course_id LIKE '"+"%"+term+"' and  course_code ='" + course + "' and sec ='" + sec + "' ORDER BY stud_name ASC  ";
                            SqlConnection con = new SqlConnection(sConnection);
                            con.Open();
                            SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
                            ReportDocument cryRpt = new ReportDocument();
                            DataSetClass ds = new DataSetClass();

                            adapter.Fill(ds.Tables[0]);

                            cryRpt.Load(Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"classlist.rpt");
                            cryRpt.SetDataSource(ds.Tables[0]);

                            CrystalReportViewer1.ReportSource = cryRpt;

                            CrystalReportViewer1.RefreshReport();
                            CrystalReportViewer1.RefreshReport();
                        }
                    }
                        if (rep == "itfull")
                    {
                        SqlConnection Scon;

                        SqlCommand Cmd;
                        StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt");
                        line = sr.ReadLine();
                        string path = Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"CIT exams.mdf";
                        string sConnection = "Data Source="+line+"\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                     // string sql = "SELECT        classlist.stud_name, question_table.ques_desc, question_table.ans_a, answers.ans, classlist.stud_id, classlist.prof_id, classlist.course_code, classlist.sec,   exam_results.score, exam_results.pname, exam_results.d_taken FROM   classlist INNER JOIN  answers ON classlist.stud_id = answers.user_id INNER JOIN question_table ON classlist.prof_id = question_table.ins_id INNER JOIN exam_results ON classlist.stud_id = exam_results.user_id AND question_table.exam_code = exam_results.exam_code AND  answers.exam_code = exam_results.exam_code AND classlist.course_code = exam_results.course AND classlist.sec = exam_results.section AND answers.user_id = exam_results.user_id WHERE  question_table.exam_code='"+exname+"'ORDER BY classlist.stud_name    ";
                        string sql = "SELECT        classlist.stud_name, question_table.ques_desc, question_table.ans_a, answers.ans, classlist.stud_id, classlist.prof_id, classlist.course_code, classlist.sec, exam_results.score, exam_results.pname, exam_results.d_taken, question_table.l_o FROM classlist INNER JOIN answers ON classlist.stud_id = answers.user_id INNER JOIN question_table ON classlist.prof_id = question_table.ins_id AND answers.exam_code = question_table.exam_code AND  answers.ques_id = question_table.ques_id INNER JOIN  exam_results ON classlist.stud_id = exam_results.user_id AND question_table.exam_code = exam_results.exam_code AND answers.exam_code = exam_results.exam_code AND classlist.course_code = exam_results.course AND classlist.sec = exam_results.section AND  answers.user_id = exam_results.user_id WHERE  question_table.exam_code='" + exname + "'ORDER BY exam_results.score DESC ,classlist.stud_name    ";
                            Scon = new SqlConnection(sConnection);
                        Scon.Open();
                        Cmd = new SqlCommand(sql, Scon);

                        SqlDataAdapter adapter = new SqlDataAdapter(sql, Scon);
                        ReportDocument cryRpt = new ReportDocument();
                        ItemAnalFull ds = new ItemAnalFull();

                        adapter.Fill(ds.Tables[0]);

                        cryRpt.Load(Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"ItemAnalFull.rpt");
                        cryRpt.SetDataSource(ds.Tables[0]);

                        CrystalReportViewer1.ReportSource = cryRpt;

                        CrystalReportViewer1.RefreshReport();
                        CrystalReportViewer1.RefreshReport();
                    }
                    if (rep == "not")
                    {
                        SqlConnection Scon;

                        SqlCommand Cmd;
                        StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt");
                        line = sr.ReadLine();
                        string path = Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"CIT exams.mdf";
                        string sConnection = "Data Source="+line+"\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                        string sql = "SELECT exam_results.score, exam_results.d_taken, exam_results.pname, exam_results.course, exam_results.section, exam_results.user_id, classlist.stud_name, classlist.stud_id FROM classlist INNER JOIN exam_results ON classlist.stud_id = exam_results.user_id AND classlist.course_code = exam_results.course   WHERE  exam_results.course = '" + course + "' and exam_results.section = '" + sec + "' AND classlist.prof_id = '" + user + "' AND exam_results.exam_code = '" + exname + "' AND  exam_results.d_taken != '" + "NOT TAKEN" + "'";

                        Scon = new SqlConnection(sConnection);
                        Scon.Open();
                        Cmd = new SqlCommand(sql, Scon);

                        SqlDataAdapter adapter = new SqlDataAdapter(sql, Scon);
                        ReportDocument cryRpt = new ReportDocument();
                        DataSetNoticeStud ds = new DataSetNoticeStud();

                        adapter.Fill(ds.Tables[0]);

                        cryRpt.Load(Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"NoteExam.rpt");
                        cryRpt.SetDataSource(ds.Tables[0]);

                        CrystalReportViewer1.ReportSource = cryRpt;

                        CrystalReportViewer1.RefreshReport();

                    }
                    if (rep == "anal")
                    {
                        SqlConnection Scon;
                        SqlDataReader Reader;
                        SqlCommand Cmd;
                        StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt");
                        line = sr.ReadLine();
                        string path = Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"CIT exams.mdf";
                        string sConnection = "Data Source="+line+"\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                        string sql = "SELECT  question_table.ques_desc, exams.pname, it_anal.ques_id_id, it_anal.cor, it_anal.incor, it_anal.ques_id, it_anal.exname FROM   it_anal INNER JOIN   question_table ON it_anal.ques_id = question_table.ques_id AND it_anal.exname = question_table.exam_code INNER JOIN  exams ON it_anal.exname = exams.exname WHERE question_table.exam_code = '" + exname + "' ORDER BY cor DESC";
                        Scon = new SqlConnection(sConnection);
                        Scon.Open();
                        Cmd = new SqlCommand(sql, Scon);

                        SqlDataAdapter adapter = new SqlDataAdapter(sql, Scon);
                        ReportDocument cryRpt = new ReportDocument();
                        ItAnalVer2 ds = new ItAnalVer2();
                        adapter.Fill(ds.Tables[0]);
                        cryRpt.Load(Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"ItemAnalysis.rpt");
                        cryRpt.SetDataSource(ds.Tables[0]);
                        CrystalReportViewer1.ReportSource = cryRpt;
                        CrystalReportViewer1.RefreshReport();

                    }
                    if (rep == "exam_a")
                    {
                        SqlConnection Scon;
                        SqlDataReader Reader;
                        SqlCommand Cmd;
                        StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt");
                        line = sr.ReadLine();
                        string path = Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"CIT exams.mdf";
                        string sConnection = "Data Source="+line+"\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                        string sql = "SELECT     exam_report.ques_desc,   exam_report.ins_id, exam_report.exname, exam_report.pname, exam_report.exset, exam_report.extype, exam_report.ques_id, exam_report.c0,  exam_report.c1, exam_report.c2, exam_report.c3, exam_report.c4, exam_report.ans, exam_report.lo, exam_report.co, exam_report.pt, course.course_desc,  course.course_sec, course.course_id, course.sec_handler, course.term FROM            exam_report INNER JOIN  course ON exam_report.ins_id = course.sec_handler WHERE exname = '" + exname + "' AND exset = '" + "A" + "' AND sec_handler = '" + user + "' and course_id = '" + course + "' AND course_sec = '" + sec + "' AND term ='"+term+"'";
                        Scon = new SqlConnection(sConnection);
                        Scon.Open();
                        Cmd = new SqlCommand(sql, Scon);
                        Reader = Cmd.ExecuteReader();
                        while (Reader.Read())
                        {

                        }
                        Reader.Close();
                        Scon.Close();

                        SqlConnection con = new SqlConnection(sConnection);
                        con.Open();
                        SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
                        ReportDocument cryRpt = new ReportDocument();
                        DataReportExam ds = new DataReportExam();

                        adapter.Fill(ds.Tables[0]);

                        cryRpt.Load(Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"Exams_A.rpt");
                        cryRpt.SetDataSource(ds.Tables[0]);

                        CrystalReportViewer1.ReportSource = cryRpt;

                        CrystalReportViewer1.RefreshReport();

                    }
                    if (rep == "examan")
                    {
                        string adaptit = "";
                        SqlConnection Scon;
                        SqlDataReader Reader;
                        SqlCommand Cmd;
                        StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt");
                        line = sr.ReadLine();
                        string path = Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"CIT exams.mdf";
                        string sConnection = "Data Source=" + line + "\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                        string sql = "SELECT     exam_report.ques_desc,   exam_report.ins_id, exam_report.exname, exam_report.pname, exam_report.exset, exam_report.extype, exam_report.ques_id, exam_report.c0,  exam_report.c1, exam_report.c2, exam_report.c3, exam_report.c4, exam_report.ans, exam_report.lo, exam_report.co, exam_report.pt, course.course_desc,  course.course_sec, course.course_id, course.sec_handler, course.term FROM            exam_report INNER JOIN  course ON exam_report.ins_id = course.sec_handler WHERE exname = '" + exname + "' AND exset = '" + "A" + "' AND sec_handler = '" + user + "' and course_id = '" + course + "'  AND course_sec = '" + sec + "' AND term ='" + term + "'";

                        Scon = new SqlConnection(sConnection);
                        Scon.Open();
                        Cmd = new SqlCommand(sql, Scon);
                        Reader = Cmd.ExecuteReader();
                        while (Reader.Read())
                        {

                        }

                        SqlConnection con = new SqlConnection(sConnection);
                        con.Open();
                        SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
                        ReportDocument cryRpt = new ReportDocument();
                        DataReportExam ds = new DataReportExam();

                        adapter.Fill(ds.Tables[0]);

                    cryRpt.Load(Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"Exams_B.rpt");
                        cryRpt.SetDataSource(ds.Tables[0]);

                        CrystalReportViewer1.ReportSource = cryRpt;

                        CrystalReportViewer1.RefreshReport();

                    }
                    if (rep == "exam_b")
                    {
                        SqlConnection Scon;
                        SqlDataReader Reader;
                        SqlCommand Cmd;  StreamReader sr = new StreamReader(Request.PhysicalApplicationPath.ToString() + "//dBLoc.txt");  line = sr.ReadLine();
                        string path = Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"CIT exams.mdf";
                        string sConnection = "Data Source="+line+"\\SQLEXPRESS;Database=CIT;User=sydrick;password=1234567";
                        string sql = "SELECT     exam_report.ques_desc,   exam_report.ins_id, exam_report.exname, exam_report.pname, exam_report.exset, exam_report.extype, exam_report.ques_id, exam_report.c0,  exam_report.c1, exam_report.c2, exam_report.c3, exam_report.c4, exam_report.ans, exam_report.lo, exam_report.co, exam_report.pt, course.course_desc,  course.course_sec, course.course_id, course.sec_handler, course.term FROM            exam_report INNER JOIN  course ON exam_report.ins_id = course.sec_handler WHERE exname = '" + exname + "' AND exset = '" + "B" + "' AND sec_handler = '" + user + "'and course_id = '" + course + "' AND course_sec = '"+sec+"'AND term ='"+term+"' ORDER BY extype DESC, ans DESC";
                        // string sql = "SELECT  ins_id, ques_desc, ans_a, ans_b, ans_c, ans_d, ans_e, exam_code FROM question_table WHERE  ins_id= '" + user + "' and exam_code = '" + exname + "'   ORDER BY  ques_desc ASC, typeEx ASC ";
                        Scon = new SqlConnection(sConnection);
                        Scon.Open();
                        Cmd = new SqlCommand(sql, Scon);
                        Reader = Cmd.ExecuteReader();
                        while (Reader.Read())
                        {

                        }
                        Reader.Close();
                        Scon.Close();

                        SqlConnection con = new SqlConnection(sConnection);
                        con.Open();
                        SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
                        ReportDocument cryRpt = new ReportDocument();
                        DataReportExam ds = new DataReportExam();

                        adapter.Fill(ds.Tables[0]);

                        cryRpt.Load(Server.HtmlEncode(Request.PhysicalApplicationPath).ToString() + @"Exams_A.rpt");
                        cryRpt.SetDataSource(ds.Tables[0]);

                        CrystalReportViewer1.ReportSource = cryRpt;

                        CrystalReportViewer1.RefreshReport();
                    }
                }

            }
        }
    }