Ejemplo n.º 1
0
        public ActionResult Round1()
        {
            if (Session["USER"] == null)
            {
                return(RedirectToAction("../Account/ManagementLogin"));
            }
            var model = new ScoreRound1Model {
            };

            return(View("Round1", model));
        }
Ejemplo n.º 2
0
        public ActionResult doProcessRound1(ScoreRound1Model model)
        {
            if (Session["USER"] == null)
            {
                return(RedirectToAction("../Account/ManagementLogin"));
            }

            int _levelId = Convert.ToInt16(model.studentLevel);



            var items = from ss in db.TB_STUDENT_SEAT
                        join r in db.TB_SCORE_ROUND_1 on ss.STUDENT_CODE equals r.STD_CODE
                        join s in db.TB_APPLICATION_STUDENT on ss.STUDENT_ID equals s.STD_ID
                        where s.STD_LEVEL_ID == _levelId && s.STD_NATION != 2
                        orderby s.STD_LEVEL_ID ascending, r.ROUND_SCORE descending
                select new
            {
                StdCode      = ss.STUDENT_CODE,
                Score        = r.ROUND_SCORE,
                StudentLevel = _levelId,
                s.STD_NATION,
                r.ROUND_SCORE
            };

            if (items != null)
            {
                StringBuilder sb    = new StringBuilder();
                int           index = 1;
                foreach (var item in items)
                {
                    TB_SCORE_ROUND_1 sr = db.TB_SCORE_ROUND_1.Where(s => s.STD_CODE == item.StdCode).FirstOrDefault();
                    if (sr != null)
                    {
                        if (item.StudentLevel == 5)
                        {
                            //check condition
                            if (index >= 1 && index <= 10)
                            {
                                sr.PRIZE_ID = 1;//เข้ารอบเพชรยอดมงกุฏ
                            }
                            else if (index > 10 && index <= 20)
                            {
                                sr.PRIZE_ID = 2;//รางวัลชอมเชย
                            }
                            else
                            {
                                sr.PRIZE_ID = 4;
                            }
                        }
                        else
                        {
                            if (index >= 1 && index <= 10)
                            {
                                sr.PRIZE_ID = 1;//เข้ารอบเพชรยอดมงกุฏ
                            }
                            else if (index > 10 && index <= 50)
                            {
                                sr.PRIZE_ID = 2;//รางวัลชอมเชย
                            }
                            else if (index > 50 && index <= 100)
                            {
                                sr.PRIZE_ID = 3;//รางวัลผ่านเกณฑ์
                            }
                            else
                            {
                                sr.PRIZE_ID = 4;
                            }
                        }

                        index++;
                        if (index % 200 == 0)
                        {
                            db.SaveChanges();
                        }
                    }
                }

                db.SaveChanges();
            }
            ViewBag.ResultMsg = "ปรับคะแนน 100 อันดับ ระดับชั้นที่ " + model.studentLevel + " รอบเจียรไนเพชรเรียบร้อยแล้ว";
            return(View("ProcessRound1"));
        }
Ejemplo n.º 3
0
        public ActionResult doProcessRound2(ScoreRound1Model model)
        {
            if (Session["USER"] == null)
            {
                return(RedirectToAction("../Account/ManagementLogin"));
            }

            int _levelId = Convert.ToInt16(model.studentLevel);


            var round2Result = from stdSeat in db.TB_STUDENT_SEAT
                               join std in db.TB_APPLICATION_STUDENT on stdSeat.STUDENT_ID equals std.STD_ID
                               join r1 in db.TB_SCORE_ROUND_1 on stdSeat.STUDENT_CODE equals r1.STD_CODE
                               join r2 in db.TB_SCORE_ROUND_2 on stdSeat.STUDENT_CODE equals r2.STD_CODE
                               where std.STD_LEVEL_ID == _levelId && std.STD_NATION != 2
                               orderby(r2.SCORE_1_11 + r2.SCORE_1_12 + r2.SCORE_1_13 + r2.SCORE_1_14 + r2.SCORE_1_15 +
                                       r2.SCORE_1_21 + r2.SCORE_1_22 + r2.SCORE_1_23 + r2.SCORE_1_24 + r2.SCORE_1_25 +
                                       r2.SCORE_1_31 + r2.SCORE_1_32 + r2.SCORE_1_33 + r2.SCORE_1_34 + r2.SCORE_1_35 +
                                       r2.SCORE_2_11 + r2.SCORE_2_12 + r2.SCORE_2_13 + r2.SCORE_2_14 +
                                       r2.SCORE_2_21 + r2.SCORE_2_22 + r2.SCORE_2_23 + r2.SCORE_2_24 +
                                       r2.SCORE_2_31 + r2.SCORE_2_32 + r2.SCORE_2_33 + r2.SCORE_2_34

                                       ) descending
                               select new
            {
                studentCode     = std.TB_STUDENT_SEAT.STUDENT_CODE,
                studentFullName = std.TB_M_TITLE.TITLE_NAME_TH + "" + std.STD_NAME + "  " + std.STD_SURNAME,
                round1Score     = r1.ROUND_SCORE,
                round2Score     = (r2.SCORE_1_11 + r2.SCORE_1_12 + r2.SCORE_1_13 + r2.SCORE_1_14 + r2.SCORE_1_15 +
                                   r2.SCORE_1_21 + r2.SCORE_1_22 + r2.SCORE_1_23 + r2.SCORE_1_24 + r2.SCORE_1_25 +
                                   r2.SCORE_1_31 + r2.SCORE_1_32 + r2.SCORE_1_33 + r2.SCORE_1_34 + r2.SCORE_1_35 +
                                   r2.SCORE_2_11 + r2.SCORE_2_12 + r2.SCORE_2_13 + r2.SCORE_2_14 +
                                   r2.SCORE_2_21 + r2.SCORE_2_22 + r2.SCORE_2_23 + r2.SCORE_2_24 +
                                   r2.SCORE_2_31 + r2.SCORE_2_32 + r2.SCORE_2_33 + r2.SCORE_2_34)
            };

            if (round2Result != null)
            {
                int index = 1;
                foreach (var item in round2Result)
                {
                    TB_SCORE_ROUND_2 round2 = db.TB_SCORE_ROUND_2.Where(s => s.STD_CODE == item.studentCode).FirstOrDefault();
                    if (round2 != null)
                    {
                        if (index == 1)
                        {
                            round2.PRIZE_ID = 5;//เหรียญทอง
                        }
                        else if (index == 2)
                        {
                            round2.PRIZE_ID = 6;//เหรียญเงิน
                        }
                        else if (index == 3)
                        {
                            round2.PRIZE_ID = 7;//เหรียญทองแดง
                        }
                        else if (index <= 10)
                        {
                            round2.PRIZE_ID = 8;//ชมเชย
                        }
                        else
                        {
                            round2.PRIZE_ID = 4;
                        }
                        round2.ROUND_1_SCORE = item.round1Score;
                        index++;
                    }
                }
                db.SaveChanges();
            }
            ViewBag.ResultMsg = "ประมวลผลคะแนน ระดับชั้นที่ " + model.studentLevel + " รอบเพชรยอดมงกุฏเรียบร้อยแล้ว";
            return(View("ProcessRound2"));
        }