public ActionResult UploadVideoTest()
        {
            var vtests = RetrieveExcelTest();
            var vid    = Request.Form["activevid"];

            if (vtests.Count > 1)
            {
                var giftoffer  = Request.Form["giftoffer"];
                var testnotice = Request.Form["testnotice"];
                var imgpath    = RetrieveGiftImg();
                VTestVM.CleanTest(vid);


                for (var lidx = 1; lidx < vtests.Count; lidx++)
                {
                    if (!string.IsNullOrEmpty(vtests[lidx][0]) && !string.IsNullOrEmpty(vtests[lidx][2]))
                    {
                        var tempvm = new VTestVM();
                        tempvm.VID         = vid;
                        tempvm.TestID      = TechVideoVM.GetUniqKey();
                        tempvm.TestNotice  = testnotice;
                        tempvm.GiftOffer   = giftoffer;
                        tempvm.GiftPath    = imgpath;
                        tempvm.TestContent = vtests[lidx][0];
                        tempvm.TestType    = vtests[lidx][1];
                        tempvm.Answer      = vtests[lidx][2];

                        var aw = new List <string>();
                        for (var idx = 0; idx < 6; idx++)
                        {
                            aw.Add(vtests[lidx][idx + 3]);
                        }
                        tempvm.OptionalAnswers = Newtonsoft.Json.JsonConvert.SerializeObject(aw);
                        tempvm.StoreTestVM();
                    }
                }//end for
            }
            var routedict = new RouteValueDictionary();

            routedict.Add("activeid", vid);
            return(RedirectToAction("TechnicalVideo", "TVideoSite", routedict));
        }
        public ActionResult TechnicalVideo(string activeid, string searchkey)
        {
            UserAuth();

            if (string.Compare(ViewBag.username, ViewBag.compName) == 0)
            {
                return(RedirectToAction("Welcome"));
            }

            var vm = TechVideoVM.RetrieveVideo(searchkey);

            if (vm.Count > 0)
            {
                RetrieveVideoTile(vm);
                if (string.IsNullOrEmpty(activeid))
                {
                    ViewBag.ActiveVideo = vm[0];
                }
                else
                {
                    foreach (var item in vm)
                    {
                        if (string.Compare(activeid, item.VID) == 0)
                        {
                            ViewBag.ActiveVideo = item;
                        }
                    }
                    if (ViewBag.ActiveVideo == null)
                    {
                        ViewBag.ActiveVideo = vm[0];
                    }
                }

                if (ViewBag.ActiveVideo != null)
                {
                    ViewBag.ActiveVideo.TestList = VTestVM.RetrieveRandomTest(ViewBag.ActiveVideo.VID, 10);
                }
            }

            return(View(vm));
        }
        public JsonResult CheckUserAnswer()
        {
            UserAuth();

            var video_id    = Request.Form["video_id"];
            var uname       = Request.Form["uname"];
            var useranswers = (List <UserAnswer>)Newtonsoft.Json.JsonConvert.DeserializeObject(Request.Form["data"], (new List <UserAnswer>()).GetType());

            double score   = 0;
            var    answers = new List <object>();

            var uns = "";
            var cns = "";

            foreach (var item in useranswers)
            {
                var onetest = VTestVM.RetrieveTestByTestID(item.q_id);
                if (onetest.Count > 0)
                {
                    var uanswer    = item.answer.Substring(0, item.answer.Length - 1);
                    var idxanswer  = "";
                    var tempanswer = onetest[0].Answer.Trim().ToUpper()
                                     .Replace(",", "").Replace(" ", "").Replace(";", "").ToCharArray();

                    for (var aidx = 0; aidx < tempanswer.Length; aidx++)
                    {
                        idxanswer = idxanswer + tempanswer[aidx].ToString() + ",";
                    }
                    idxanswer = idxanswer.Substring(0, idxanswer.Length - 1);

                    uns = uns + uanswer.ToUpper() + ";";
                    cns = cns + idxanswer + ";";

                    if (string.Compare(uanswer.ToUpper(), idxanswer) == 0)
                    {
                        score = score + 1;
                    }

                    answers.Add(new
                    {
                        q_id    = onetest[0].TestID,
                        q_type  = onetest[0].TestType,
                        answer  = idxanswer,
                        uanswer = uanswer
                    });
                }
            }

            score = score / useranswers.Count * 100.0;

            VTestScore.StoreUserScore(ViewBag.compName, uname, video_id, cns, uns, score.ToString());

            var ret = new JsonResult();

            ret.Data = new
            {
                score   = score,
                answers = answers
            };
            return(ret);
        }