コード例 #1
0
        public IEnumerable <copy_correction> AllUncheckedQuestions(copy_correction copy)
        {
            string query = @"SELECT 
                                session,
                                class_id,
                                section_id,
                                subject_id,
                                chapter_id,
                                work_type,
                                work_id,
                                work_name,
                                work_date
                            FROM
                                mst_class_notebook
                            WHERE
                                work_id NOT IN (SELECT 
                                        work_id
                                    FROM
                                        copy_correction
                                    WHERE
                                        sr_number = @sr_number AND session = @session)
                                    AND session = @session
                                    AND subject_id = @subject_id
                                    AND class_id = @class_id
                                    AND section_id = @section_id
                                    AND chapter_id = @chapter_id
                            ORDER BY work_date DESC , work_type";

            var result = con.Query <copy_correction>(query, new { sr_number = copy.sr_number, session = copy.session, subject_id = copy.subject_id, class_id = copy.class_id, section_id = copy.section_id, chapter_id = copy.chapter_id });

            return(result);
        }
コード例 #2
0
        public ActionResult AllUncheckedQuestions(int sr_number, string session, int class_id, int subject_id, int chapter_id, int section_id)
        {
            copy_correctionMain main = new copy_correctionMain();
            copy_correction     copy = new copy_correction();

            copy.sr_number  = sr_number;
            copy.session    = session;
            copy.subject_id = subject_id;
            copy.class_id   = class_id;
            copy.section_id = section_id;
            copy.chapter_id = chapter_id;


            ViewData["session"]    = session;
            ViewData["subject_id"] = subject_id;
            ViewData["class_id"]   = class_id;
            ViewData["section_id"] = section_id;
            ViewData["sr_number"]  = sr_number;

            var result = main.AllUncheckedQuestions(copy);

            foreach (var corr in result)
            {
                corr.sr_number         = sr_number;
                corr.chapter_id        = chapter_id;
                corr.teacher_correctby = int.Parse(Request.Cookies["loginUserId"].Value.ToString());
                corr.class_id          = class_id;
                corr.section_id        = section_id;
                corr.subject_id        = subject_id;
            }

            return(View(result));
        }
コード例 #3
0
        public ActionResult Student_Copy(copy_correction copy)
        {
            using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
            {
                string query = @"SELECT 
                                    COUNT(*)
                                FROM
                                    mst_std_class a,
                                    mst_std_section b
                                WHERE
                                    a.session = b.session
                                        AND a.sr_num = b.sr_num
                                        AND a.class_id = @class_id
                                        AND b.section_id = @section_id
                                        AND a.sr_num = @sr_number";

                int flag = con.Query <int>(query, new { sr_number = copy.sr_number, class_id = copy.class_id, section_id = copy.section_id }).SingleOrDefault();

                if (flag == 0)
                {
                    ModelState.AddModelError(String.Empty, "Student not found.");
                    return(View(copy));
                }

                return(RedirectToAction("AllUncheckedChapters", new { sr_number = copy.sr_number, session = copy.session, subject_id = copy.subject_id, class_id = copy.class_id, section_id = copy.section_id }));
            }
        }
コード例 #4
0
        public ActionResult Student_Copy(string session, int subject_id, int class_id, int section_id)
        {
            copy_correction copy = new copy_correction();

            copy.subject_id = subject_id;
            copy.session    = session;
            copy.class_id   = class_id;
            copy.section_id = section_id;

            return(View(copy));
        }
コード例 #5
0
        public ActionResult AllUncheckedChapters(int sr_number, string session, int subject_id, int class_id, int section_id)
        {
            copy_correctionMain main = new copy_correctionMain();
            copy_correction     copy = new copy_correction();

            copy.sr_number  = sr_number;
            copy.session    = session;
            copy.subject_id = subject_id;
            copy.class_id   = class_id;
            copy.section_id = section_id;


            ViewData["session"]    = session;
            ViewData["subject_id"] = subject_id;
            ViewData["class_id"]   = class_id;
            ViewData["section_id"] = section_id;
            ViewData["sr_number"]  = sr_number;

            return(View(main.AllUncheckedChapterList(copy)));
        }
コード例 #6
0
        public IEnumerable <mst_chapter> AllUncheckedChapterList(copy_correction copy)
        {
            string query = @"SELECT 
                                    session,
                                    class_id,
                                    section_id,
                                    subject_id,
                                    chapter_id,
                                    chapter_name,
                                    chapter_start_date,
                                    chapter_end_date
                                FROM
                                    mst_chapter
                                WHERE
                                    CONCAT(class_id,
                                            section_id,
                                            subject_id,
                                            chapter_id) IN (SELECT DISTINCT
                                            CONCAT(class_id,
                                                        section_id,
                                                        subject_id,
                                                        chapter_id)
                                        FROM
                                            mst_class_notebook
                                        WHERE
                                            work_id NOT IN (SELECT 
                                                    work_id
                                                FROM
                                                    copy_correction
                                                WHERE
                                                    sr_number = @sr_number AND session = @session)
                                                AND session = @session)
                                        AND session = @session
                                        AND subject_id = @subject_id
                                        AND class_id = @class_id
                                        AND section_id = @section_id";

            var result = con.Query <mst_chapter>(query, new { sr_number = copy.sr_number, session = copy.session, subject_id = copy.subject_id, class_id = copy.class_id, section_id = copy.section_id });

            return(result);
        }