public string SaveQuestions(QuestionsEntity questions) { UserSessionInfo objinfo = new UserSessionInfo(); string strResponse = string.Empty; UserSessionInfo sessionInfo = new UserSessionInfo(); // int uid = sessionInfo.userid; using (EvolutyzCornerDataEntities db = new EvolutyzCornerDataEntities()) { try { db.Set <QuestionBank>().Add(new QuestionBank { TechnologyStackId = questions.TechnologyStackId, Question = questions.Question1, Option1 = questions.Option1, Option2 = questions.Option2, Option3 = questions.Option3, Option4 = questions.Option4, Answer = questions.Answer, CreatedDate = DateTime.Now, CreatedBy = objinfo.UserId }); db.SaveChanges(); strResponse = "Record Sucessfully Created "; } catch (Exception ex) { throw ex; } } return(strResponse); }
public string EditQues(QuestionsEntity questions) { UserSessionInfo sessionInfo = new UserSessionInfo(); int uid = sessionInfo.UserId; object input = null; QuestionBank qs = null; string strResponse = string.Empty; using (EvolutyzCornerDataEntities db = new EvolutyzCornerDataEntities()) { qs = db.Set <QuestionBank>().Where(s => s.QBID == questions.Qid).FirstOrDefault <QuestionBank>(); // change required details in disconnected mode (out of DBContext scope) if (qs != null) { qs.QBID = questions.Qid; qs.TechnologyStackId = questions.TechnologyStackId; qs.Question = questions.Question1; qs.Option1 = questions.Option1; qs.Option2 = questions.Option2; qs.Option3 = questions.Option3; qs.Option4 = questions.Option4; qs.Answer = questions.Answer; qs.CreatedDate = System.DateTime.Now; qs.ModifiedBy = uid; qs.ModifiedDate = System.DateTime.Now; // db.Entry(qs).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); strResponse = "Record successfully updated"; } return(strResponse); } }
public ActionResult Questions(QuestionsEntity questions) { string strResponse = string.Empty; try { strResponse = SaveQuestions(questions); } catch (Exception ex) { throw ex; } //return View("Question","Admin"); return(RedirectToAction("FetchQuestions")); }
public ActionResult EditQuestion(QuestionsEntity ques) { string strResponse = string.Empty; try { // ques.QuestionID = Convert.ToInt32(TempData["QuestionID"]); // int UniversalTopicid = Convert.ToInt32(TempData["UniversalTopicid"]); if (ModelState.IsValid) { strResponse = EditQues(ques); } } catch (Exception ex) { throw ex; } return(RedirectToAction("FetchQuestions")); }
public JsonResult Questionsfortopics() { var Questions = DisplayTechnologyQuestions(); Regex rx = new Regex("<[^>]*>"); var result = new List <QuestionsEntity>(); foreach (var item in Questions) { var v_entity = new QuestionsEntity(); if (item.Question1 != null) { v_entity.Question1 = rx.Replace(item.Question1.Replace("\\r\\n", ""), ""); } if (item.Option1 != null) { v_entity.Option1 = rx.Replace(item.Option1.Replace("\\r\\n", ""), ""); } if (item.Option2 != null) { v_entity.Option2 = rx.Replace(item.Option2.Replace("\\r\\n", ""), ""); } if (item.Option3 != null) { v_entity.Option3 = rx.Replace(item.Option3.Replace("\\r\\n", ""), ""); } if (item.Option4 != null) { v_entity.Option4 = rx.Replace(item.Option4.Replace("\\r\\n", ""), ""); } if (item.Solution != null) { v_entity.Solution = rx.Replace(item.Solution.Replace("\\r\\n", ""), ""); } v_entity.Answer = item.Answer; v_entity.Title = item.Title; v_entity.QBID = item.Qid; result.Add(v_entity); } return(Json(result, JsonRequestBehavior.AllowGet)); }