コード例 #1
0
        /// <summary>
        /// Move the questions from temporary table to staging table
        /// </summary>
        /// <param name="Questions"></param>
        /// <returns></returns>
        public ActionResult GenerateQuestions(QuestionModels Questions)
        {
            int SID = Convert.ToInt32(Session["ExamID"]);

            if (SID != 0)
            {
                Questions.SchoolID = SID;
                Questions.UserId   = Convert.ToInt32(Session["UserId"]);

                HttpClient httpClient = new HttpClient();
                httpClient.BaseAddress = new Uri(appKey.GetapiURL());
                httpClient.DefaultRequestHeaders.Accept.Add(
                    new MediaTypeWithQualityHeaderValue("application/json"));
                HttpContent content = new StringContent(Questions.ToString(), Encoding.UTF8, "application/json");

                var response = httpClient.PostAsJsonAsync("Questions/GenerateQuestions", Questions).Result;


                if (response.IsSuccessStatusCode)
                {
                    return(Json(response.IsSuccessStatusCode, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    return(RedirectToAction("logins", "logins"));
                }
            }
            else
            {
                return(RedirectToAction("logins", "logins"));
            }
        }
コード例 #2
0
        /// <summary>
        /// SAVE QUESTIONS
        /// </summary>
        /// <param name="questionModels"></param>
        /// <returns></returns>
        public ActionResult CreateQuestion(QuestionModels questionModels)
        {
            if (!string.IsNullOrEmpty(Convert.ToString(Session["UserId"])))
            {
                int        UserId    = Convert.ToInt32(Session["UserId"]);
                int        ChapterId = Convert.ToInt32(Session["ChapterId"]);
                HttpClient client    = new HttpClient();
                client.BaseAddress = new Uri(appKey.GetapiURL());
                client.DefaultRequestHeaders.Accept.Add(
                    new MediaTypeWithQualityHeaderValue("application/json"));
                HttpContent content  = new StringContent(questionModels.ToString(), Encoding.UTF8, "application/json");
                var         response = client.PostAsJsonAsync("Questions/CreateQuestions", questionModels).Result;
                if (response.IsSuccessStatusCode)
                {
                    return(Json(response.IsSuccessStatusCode, JsonRequestBehavior.AllowGet));
                }

                else
                {
                    return(RedirectToAction("logins", "logins"));
                }
            }
            else
            {
                return(RedirectToAction("logins", "logins"));
            }
        }
コード例 #3
0
        //
        // GET: /Question/Edit/5

        public ActionResult Edit(int id = 0)
        {
            QuestionModels questionmodels = db.Questions.Find(id);

            if (questionmodels == null)
            {
                return(HttpNotFound());
            }
            if (questionmodels.User.UserName != User.Identity.Name)
            {
                return(RedirectToAction("Details/" + id));
            }
            if (questionmodels.ReferredUser != null)
            {
                var x = db.UserProfiles.Where(u => u.UserName != User.Identity.Name && u.Major.MajorId == questionmodels.Major.MajorId).OrderByDescending(u => u.Rate).Take(10);
                if (x.Count() == 0)
                {
                    x = db.UserProfiles.Where(u => u.UserName != User.Identity.Name).OrderByDescending(u => u.Rate).Take(10);
                }
                ViewBag.Users = x;
            }
            IEnumerable <SelectListItem> List = from major in db.Majors.OrderBy(o => o.MajorType).ToList()
                                                select new SelectListItem
            {
                Value = major.MajorId.ToString(),
                Text  = major.MajorType.ToString()
            };

            ViewBag.Cat = List;
            return(View(questionmodels));
        }
コード例 #4
0
ファイル: QuestionsController.cs プロジェクト: arjunkha/COBIN
        public ActionResult Create(int?Id)
        {
            QuestionModels model = new QuestionModels();

            model.SectionId = Id;
            return(View(model));
        }
コード例 #5
0
        public string UploadOptionDImage(IEnumerable files, QuestionModels model)
        {
            string Hidden      = model.OptionDHidden;
            string _PassObject = UploadImage(files, model, Hidden);

            return(_PassObject);
        }
コード例 #6
0
        public string UploadStatusImage(IEnumerable files)
        {
            QuestionModels model       = new QuestionModels();
            string         Hidden      = "Status";
            string         _PassObject = UploadImage(files, model, Hidden);

            return(_PassObject);
        }
コード例 #7
0
        //
        // GET: /Admin/MangeQuestions/Delete/5

        public ActionResult Delete(int id = 0)
        {
            QuestionModels Questions = db.Questions.Find(id);
            if (Questions == null)
            {
                return HttpNotFound();
            }
            return View(Questions);
        }
コード例 #8
0
        public ActionResult Details(int id = 0)
        {
            QuestionModels questionmodels = db.Questions.Find(id);

            if (questionmodels == null)
            {
                return(HttpNotFound());
            }
            questionmodels.Views++;
            db.SaveChanges();
            return(View(questionmodels));
        }
コード例 #9
0
        public ActionResult Edit(QuestionModels questionmodels, string Type, int?ChoosenUserId)
        {
            IEnumerable <SelectListItem> List = from major in db.Majors.OrderBy(o => o.MajorType).ToList()
                                                select new SelectListItem
            {
                Value = major.MajorId.ToString(),
                Text  = major.MajorType.ToString()
            };

            ViewBag.Cat = List;
            //if (ModelState.IsValid)
            //{
            UserProfile ChoosenUser = db.UserProfiles.Find(ChoosenUserId);
            var         oq          = db.Questions.Find(questionmodels.QuestionId);

            if (Type == "Paid")
            {
                if (questionmodels.Major.MajorId == 1)
                {
                    return(View(questionmodels));
                }
                if (ChoosenUser == null)
                {
                    var x = db.UserProfiles.Where(u => u.UserName != User.Identity.Name && u.Major.MajorId == questionmodels.Major.MajorId).OrderByDescending(u => u.Rate).Take(10);
                    if (x.Count() == 0)
                    {
                        x = db.UserProfiles.Where(u => u.UserName != User.Identity.Name).OrderByDescending(u => u.Rate).Take(10);
                    }
                    ViewBag.Users = x;
                    return(View(questionmodels));
                }
                ChoosenUser.RefferdQuestions.Add(questionmodels);
            }
            else
            {
                if (oq.ReferredUser != null)
                {
                    oq.ReferredUser.RefferdQuestions.Remove(questionmodels);
                }
            }
            questionmodels.ReferredUser = ChoosenUser;
            oq.Major        = db.Majors.Find(questionmodels.Major.MajorId);
            oq.ReferredUser = questionmodels.ReferredUser;
            oq.Text         = questionmodels.Text;
            oq.Title        = questionmodels.Title;

            db.SaveChanges();
            return(RedirectToAction("/Details/" + questionmodels.QuestionId));
            //}
            //return View(questionmodels);
        }
コード例 #10
0
        public IHttpActionResult GenerateQuestion([FromBody] QuestionModels Questions)
        {
            bool Status = false;

            try
            {
                Status = Questions.GenerateQuestion();
                return(ResponseMessage(Request.CreateResponse(Status)));
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Request.CreateResponse(ex.ToString().Trim())));
            }
        }
コード例 #11
0
        //
        // GET: /Question/Delete/5

        public ActionResult Delete(int id = 0)
        {
            QuestionModels questionmodels = db.Questions.Find(id);

            if (questionmodels.User.UserName != User.Identity.Name)
            {
                return(RedirectToAction("Index"));
            }
            if (questionmodels == null)
            {
                return(HttpNotFound());
            }
            return(View(questionmodels));
        }
コード例 #12
0
 public string ProfileUpload(IEnumerable files)
 {
     if (!string.IsNullOrEmpty(Convert.ToString(files)))
     {
         QuestionModels model       = new QuestionModels();
         string         Hidden      = "profile";
         string         _PassObject = UploadImage(files, model, Hidden);
         return(_PassObject);
     }
     else
     {
         return("empty");
     }
 }
コード例 #13
0
        public IHttpActionResult CreateQuestions([FromBody] QuestionModels questionModels)
        {
            bool Status = false;

            try
            {
                Status = questionModels.CreateQuestion();
                return(ResponseMessage(Request.CreateResponse(Status)));
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Request.CreateResponse(Status)));
            }
        }
コード例 #14
0
ファイル: DBContext.cs プロジェクト: samn91/Answer
        public void DeleteAnswer(AnswerModels answer)
        {
            UserProfile    user     = answer.User;
            QuestionModels question = answer.Question;

            if (user != null)
            {
                user.Answers.Remove(answer);
            }
            if (question != null)
            {
                question.Answers.Remove(answer);
            }
            Answers.Remove(answer);
        }
コード例 #15
0
        public ActionResult DeleteConfirmed(int id)
        {
            QuestionModels questionmodels = db.Questions.Find(id);

            questionmodels.User.Answers.RemoveAll(a => a.Question == questionmodels);
            for (int i = 0; i < questionmodels.Answers.Count; i++)
            {
                var item = questionmodels.Answers[i];
                db.Answers.Remove(item);
            }
            questionmodels.Answers.Clear();
            questionmodels.User.Questions.Remove(questionmodels);
            db.Questions.Remove(questionmodels);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
コード例 #16
0
        //
        // GET: /Admin/MangeQuestions/Edit/5

        public ActionResult Edit(int id = 0)
        {
            QuestionModels Questions = db.Questions.Find(id);
            IEnumerable<SelectListItem> List = from major in db.Majors.OrderBy(o => o.MajorType).ToList()
                                               select new SelectListItem
                                               {
                                                   Value = major.MajorId.ToString(),
                                                   Text = major.MajorType.ToString()
                                               };
            ViewBag.Cat = List;
            if (Questions == null)
            {
                return HttpNotFound();
            }
            return View(Questions);
        }
コード例 #17
0
        public ActionResult Create(QuestionModels questionmodels, string Type, int?ChoosenUserId)
        {
            IEnumerable <SelectListItem> List = from major in db.Majors.OrderBy(o => o.MajorType).ToList()
                                                select new SelectListItem
            {
                Value = major.MajorId.ToString(),
                Text  = major.MajorType.ToString()
            };

            ViewBag.Cat = List;
            if (ModelState.IsValid)
            {
                UserProfile user        = db.GetUser(User.Identity.Name);
                UserProfile ChoosenUser = db.UserProfiles.Find(ChoosenUserId);
                questionmodels.Date = DateTime.Now;
                questionmodels.User = user;
                if (Type == "Paid")
                {
                    if (questionmodels.Major.MajorId == 1)
                    {
                        return(View(questionmodels));
                    }
                    if (ChoosenUser == null)
                    {
                        var x = db.UserProfiles.Where(u => u.UserId != user.UserId && u.Major.MajorId == questionmodels.Major.MajorId).OrderByDescending(u => u.Rate).Take(10);
                        if (x.Count() == 0)
                        {
                            x = db.UserProfiles.Where(u => u.UserId != user.UserId).OrderByDescending(u => u.Rate).Take(10);
                        }
                        ViewBag.Users = x;
                        return(View(questionmodels));
                    }
                    questionmodels.ReferredUser = ChoosenUser;
                    ChoosenUser.RefferdQuestions.Add(questionmodels);
                }
                else
                {
                    questionmodels.ReferredUser = null;
                }
                questionmodels.Major = db.Majors.Find(questionmodels.Major.MajorId);
                user.Questions.Add(questionmodels);
                db.Questions.Add(questionmodels);
                db.SaveChanges();
                return(RedirectToAction("Details/" + questionmodels.QuestionId));
            }
            return(View(questionmodels));
        }
コード例 #18
0
        public IHttpActionResult Image(int ChapterId, string Question_Image)
        {
            bool Status = false;

            try
            {
                QuestionModels chapterExamModels = new QuestionModels();
                chapterExamModels.ChapterId      = ChapterId;
                chapterExamModels.Question_Image = Question_Image;
                Status = chapterExamModels.UploadImage();
                return(ResponseMessage(Request.CreateResponse(Status)));
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Request.CreateResponse(Status)));
            }
        }
コード例 #19
0
 public ActionResult Edit(QuestionModels Questions)
 {
     if (ModelState.IsValid)
     {
         db.Entry(Questions).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     IEnumerable<SelectListItem> List = from major in db.Majors.OrderBy(o => o.MajorType).ToList()
                                        select new SelectListItem
                                        {
                                            Value = major.MajorId.ToString(),
                                            Text = major.MajorType.ToString()
                                        };
     ViewBag.Cat = List;
     return View(Questions);
 }
コード例 #20
0
ファイル: QuestionsController.cs プロジェクト: arjunkha/COBIN
        public ActionResult Edit(int?Id)
        {
            ClsStatic.ValidateReferral();

            sPlsSVQQuestions_Result rslt  = con.sPlsSVQQuestions("s", Id, null, null, null, null, null, null, null, User.Identity.Name).ToList().FirstOrDefault();
            QuestionModels          model = new QuestionModels();

            model.QuestionId           = rslt.Id;
            model.SectionId            = rslt.Id_SVQ_Sections;
            model.Question_Name        = rslt.Question_Name;
            model.Question_Subtext     = rslt.Question_Subtext;
            model.Question_Code        = rslt.Question_Code;
            model.Measurement_Unit     = rslt.Measurement_Unit.ToString();
            model.Id_Option_Categories = rslt.Id_Option_Groups;
            model.Id_Input_Types       = rslt.Id_Input_Types;

            return(View(model));
        }
コード例 #21
0
ファイル: QuestionsController.cs プロジェクト: arjunkha/COBIN
        public ActionResult Edit(QuestionModels m)
        {
            try
            {
                uPlsSVQQuestions_Result rslt = con.uPlsSVQQuestions("u", m.QuestionId, m.SectionId, m.Id_Input_Types, m.Id_Option_Categories, m.Question_Name, m.Question_Subtext, m.Question_Code, m.Measurement_Unit, User.Identity.Name).FirstOrDefault();
                if (rslt.Code == "000")
                {
                    TempData["Message"] = rslt.Message;
                    TempData["IsPopup"] = "y";
                    return(RedirectToAction("Index", "Questions", new { Id = m.SectionId }));
                }
                else
                {
                    ModelState.AddModelError("", "Error! Code[" + rslt.Code + "]: " + rslt.Message);
                }
            }

            catch
            {
                ModelState.AddModelError("", "Techinical Error Occurred While Processing Your Request");
            }
            return(View(m));
        }
コード例 #22
0
ファイル: DBContext.cs プロジェクト: samn91/Answer
        public void DeleteQuestion(QuestionModels question)
        {
            UserProfile user = question.User;

            while (question.Answers.Count > 0)
            {
                DeleteAnswer(question.Answers[0]);
            }
            question.Answers.Clear();

            if (question.ReferredUser != null)
            {
                question.ReferredUser.RefferdQuestions.Remove(question);
            }
            if (user != null)
            {
                user.Questions.Remove(question);
            }
            if (question != null)
            {
                Questions.Remove(question);
            }
        }
コード例 #23
0
        public string UploadImage(IEnumerable files, QuestionModels model, string Hidden)
        {
            string path     = string.Empty;
            string pic      = string.Empty;
            string ext      = string.Empty;
            string dataIs   = string.Empty;
            int    SID      = Convert.ToInt32(Session["ExamID"]);
            int    UID      = Convert.ToInt32(Session["UserId"]);
            int    UserType = Convert.ToInt32(Session["UserType"]);
            string _Date    = DateTime.Now.Millisecond.ToString().Trim();

            try
            {
                foreach (HttpPostedFileBase file in files)
                {
                    if (Hidden.Equals("Status"))
                    {
                        // Verify that the user selected a file
                        if (file != null && file.ContentLength > 0)
                        {
                            pic  = Path.GetFileName(file.FileName);
                            ext  = Path.GetExtension(file.FileName);
                            path = Path.Combine(Server.MapPath("/images/Status/"), pic + ext);

                            // file is uploaded
                            file.SaveAs(path);
                        }
                        dataIs = Hidden + "|" + "/images/Status/" + pic + ext;
                    }
                    else if (Hidden.Equals("profile"))
                    {
                        // Verify that the user selected a file
                        if (file != null && file.ContentLength > 0)
                        {
                            pic  = Path.GetFileName(SID + "_" + UID);
                            ext  = Path.GetExtension(file.FileName);
                            path = Path.Combine(Server.MapPath("/images/UserProfile/"), pic + ext);

                            if (System.IO.File.Exists(path))
                            {
                                System.IO.File.Delete(path);
                            }
                            // file is uploaded
                            file.SaveAs(path);
                            string Location = ConfigurationManager.AppSettings["Application_URL"].ToString().Trim() + "/images/UserProfile/" + pic + ext;
                            try
                            {
                                if (!string.IsNullOrEmpty(Convert.ToString(Session["ExamID"])))
                                {
                                    int SchoolID = Convert.ToInt32(Session["ExamID"]);
                                    try
                                    {
                                        List <Registration> listEmailList = new List <Registration>();
                                        HttpClient          httpClient    = new HttpClient();
                                        httpClient.BaseAddress = new Uri(appKey.GetapiURL());
                                        httpClient.DefaultRequestHeaders.Accept.Add(
                                            new MediaTypeWithQualityHeaderValue("application/json"));
                                        var response = httpClient.GetAsync("Register/UpdateProfilePicture?SID=" + SID + "&UID=" + UID + "&UserType=" + UserType + "&Location=" + Location).Result;
                                        if (response.IsSuccessStatusCode)
                                        {
                                            dataIs = Hidden + "|" + "/images/UserProfile/" + pic + ext;
                                        }
                                        else
                                        {
                                            dataIs = "false";
                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        string error = ex.ToString().Trim();
                                        dataIs = "false";
                                    }
                                }
                                else
                                {
                                    dataIs = "false";
                                }
                            }
                            catch (Exception ex)
                            {
                                dataIs = ex.ToString().Trim();
                            }
                        }
                        dataIs = Hidden + "|" + "/images/UserProfile/" + pic + ext;
                    }
                    else
                    {
                        // Verify that the user selected a file
                        if (file != null && file.ContentLength > 0)
                        {
                            string StandardId = Session["StandardId"].ToString().Trim();
                            string SubjectId  = Session["SubjectId"].ToString().Trim();
                            string ChapterId  = Session["ChapterId"].ToString().Trim();
                            pic  = Path.GetFileName(StandardId + "_" + SubjectId + "_" + ChapterId + "_" + Hidden + "_" + _Date);
                            ext  = Path.GetExtension(file.FileName);
                            path = Path.Combine(Server.MapPath("/images/profile/"), pic + ext);

                            // file is uploaded
                            file.SaveAs(path);
                        }
                        dataIs = Hidden + "|" + "/images/profile/" + pic + ext;
                    }
                }

                return(dataIs);
            }
            catch (Exception ex)
            {
                return(ex.ToString().Trim());
            }
        }
コード例 #24
0
        public List <QuestionModels> GetAnswerToReviewList(int UserId, int ChapterId)
        {
            List <QuestionModels> viewQuestinoModelsList = new List <QuestionModels>();
            QuestionModels        questionModels         = new QuestionModels();

            questionModels.UserId    = UserId;
            questionModels.ChapterId = ChapterId;
            DataTable dtSubjectList = new DataTable();

            dtSubjectList = questionModels.GetReviweList();
            if (dtSubjectList.Rows.Count > 0)
            {
                foreach (DataRow dr in dtSubjectList.Rows)
                {
                    QuestionModels questionModelsTypes = new QuestionModels();
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["StandardId"]))))
                    {
                        questionModelsTypes.StandardId = Convert.ToInt32(dr["StandardId"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["SubjectId"]))))
                    {
                        questionModelsTypes.SubjectId = Convert.ToInt32(dr["SubjectId"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["ChapterId"]))))
                    {
                        questionModelsTypes.ChapterId = Convert.ToInt32(dr["ChapterId"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["Question"]))))
                    {
                        questionModelsTypes.Question = Convert.ToString(dr["Question"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["Question_Image"]))))
                    {
                        questionModelsTypes.Question_Image = Convert.ToString(dr["Question_Image"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["Question_Description"]))))
                    {
                        questionModelsTypes.Question_Image_Description = Convert.ToString(dr["Question_Description"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["OptionA"]))))
                    {
                        questionModelsTypes.OptionA = Convert.ToString(dr["OptionA"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["OptionA_Image"]))))
                    {
                        questionModelsTypes.OptionA_Image = Convert.ToString(dr["OptionA_Image"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["OptionB"]))))
                    {
                        questionModelsTypes.OptionB = Convert.ToString(dr["OptionB"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["OptionB_Image"]))))
                    {
                        questionModelsTypes.OptionB_Image = Convert.ToString(dr["OptionB_Image"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["OptionC"]))))
                    {
                        questionModelsTypes.OptionC = Convert.ToString(dr["OptionC"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["OptionC_Image"]))))
                    {
                        questionModelsTypes.OptionC_Image = Convert.ToString(dr["OptionC_Image"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["OptionD"]))))
                    {
                        questionModelsTypes.OptionD = Convert.ToString(dr["OptionD"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["OptionD_Image"]))))
                    {
                        questionModelsTypes.OptionD_Image = Convert.ToString(dr["OptionD_Image"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["Answer"]))))
                    {
                        questionModelsTypes.Answer = Convert.ToString(dr["Answer"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["QuestionId"]))))
                    {
                        questionModelsTypes.QuestionId = Convert.ToInt32(dr["QuestionId"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["Answer_Description"]))))
                    {
                        questionModelsTypes.AnswerDescription = Convert.ToString(dr["Answer_Description"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["QuestionId"]))))
                    {
                        questionModelsTypes.AnsweredQuestionId = Convert.ToInt32(dr["QuestionId"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["UID"]))))
                    {
                        questionModelsTypes.UserId = Convert.ToInt32(dr["UID"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["AnswerSelected"]))))
                    {
                        questionModelsTypes.AnswerSelected = Convert.ToString(dr["AnswerSelected"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["Format"]))))
                    {
                        questionModelsTypes.Format = Convert.ToInt32(dr["Format"]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr["Fill_Answer"]))))
                    {
                        questionModelsTypes.FillAnswer = Convert.ToString(dr["Fill_Answer"]);
                    }
                    viewQuestinoModelsList.Add(questionModelsTypes);
                }
            }
            return(viewQuestinoModelsList);
        }
コード例 #25
0
        public List <QuestionModels> ViewQuestionList(int ExamId, int SubjectId, int ChapterId)
        {
            List <QuestionModels> viewQuestinoModelsList = new List <QuestionModels>();
            QuestionModels        questionModels         = new QuestionModels();

            questionModels.ExamID    = ExamId;
            questionModels.SubjectId = SubjectId;
            questionModels.ChapterId = ChapterId;
            DataTable dtSubjectList = new DataTable();

            dtSubjectList = questionModels.GetQuestionList();
            if (dtSubjectList.Rows.Count > 0)
            {
                foreach (DataRow dr in dtSubjectList.Rows)
                {
                    QuestionModels questionModelsTypes = new QuestionModels();
                    questionModelsTypes.StandardId = Convert.ToInt32(dr[0]);
                    questionModelsTypes.SubjectId  = Convert.ToInt32(dr[1]);
                    questionModelsTypes.ChapterId  = Convert.ToInt32(dr[2]);
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[3]))))
                    {
                        questionModelsTypes.Question = Convert.ToString(dr[3]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[4]))))
                    {
                        questionModelsTypes.Question_Image = Convert.ToString(dr[4]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[5]))))
                    {
                        questionModelsTypes.Question_Image_Description = Convert.ToString(dr[5]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[6]))))
                    {
                        questionModelsTypes.OptionA = Convert.ToString(dr[6]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[7]))))
                    {
                        questionModelsTypes.OptionA_Image = Convert.ToString(dr[7]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[8]))))
                    {
                        questionModelsTypes.OptionB = Convert.ToString(dr[8]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[9]))))
                    {
                        questionModelsTypes.OptionB_Image = Convert.ToString(dr[9]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[10]))))
                    {
                        questionModelsTypes.OptionC = Convert.ToString(dr[10]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[11]))))
                    {
                        questionModelsTypes.OptionC_Image = Convert.ToString(dr[11]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[12]))))
                    {
                        questionModelsTypes.OptionD = Convert.ToString(dr[12]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[13]))))
                    {
                        questionModelsTypes.OptionD_Image = Convert.ToString(dr[13]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[14]))))
                    {
                        questionModelsTypes.Answer = Convert.ToString(dr[14]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[15]))))
                    {
                        questionModelsTypes.QuestionId = Convert.ToInt32(dr[15]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[16]))))
                    {
                        questionModelsTypes.Subject = Convert.ToString(dr[16]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[17]))))
                    {
                        questionModelsTypes.ChapterName = Convert.ToString(dr[17]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[18]))))
                    {
                        questionModelsTypes.AnswerDescription = Convert.ToString(dr[18]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[19]))))
                    {
                        questionModelsTypes.Format = Convert.ToInt32(dr[19]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[20]))))
                    {
                        questionModelsTypes.FillAnswer = Convert.ToString(dr[20]);
                    }
                    if (!string.IsNullOrEmpty(Convert.ToString(Convert.ToString(dr[21]))))
                    {
                        questionModelsTypes.ExamName = Convert.ToString(dr[21]);
                    }
                    viewQuestinoModelsList.Add(questionModelsTypes);
                }
            }
            return(viewQuestinoModelsList);
        }