/// <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")); } }
/// <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")); } }
// // 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)); }
public ActionResult Create(int?Id) { QuestionModels model = new QuestionModels(); model.SectionId = Id; return(View(model)); }
public string UploadOptionDImage(IEnumerable files, QuestionModels model) { string Hidden = model.OptionDHidden; string _PassObject = UploadImage(files, model, Hidden); return(_PassObject); }
public string UploadStatusImage(IEnumerable files) { QuestionModels model = new QuestionModels(); string Hidden = "Status"; string _PassObject = UploadImage(files, model, Hidden); return(_PassObject); }
// // 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); }
public ActionResult Details(int id = 0) { QuestionModels questionmodels = db.Questions.Find(id); if (questionmodels == null) { return(HttpNotFound()); } questionmodels.Views++; db.SaveChanges(); return(View(questionmodels)); }
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); }
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()))); } }
// // 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)); }
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"); } }
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))); } }
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); }
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")); }
// // 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); }
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)); }
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))); } }
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); }
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)); }
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)); }
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); } }
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()); } }
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); }
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); }