public ActionResult Details(int?id) { if (!id.HasValue) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Model_Questions model = new Model_Questions(); model.ExamID = id.Value; var q = db.Tbl_Question.Where(x => x.Tbl_ExamRemotelyPlan.ERP_ID == id).ToList(); if (q.Count > 0) { model.Questions = q.Select(x => new Model_Question { ID = x.Question_ID, Title = x.Question_Title, Type = x.Tbl_Code.Code_Display, Group = db.Tbl_Code.Where(y => y.Code_ID.Equals(x.Question_GroupCodeID)).FirstOrDefault().Code_Name, Response = db.Tbl_Code.Where(y => y.Code_ID.Equals(x.Question_ResponseID)).FirstOrDefault().Code_Name, Mark = x.Question_Mark, CreationDate = x.Question_CreationDate }).ToList(); } return(View(model)); }
public ActionResult ShowForm(string ID) { var q = db.Tbl_Student.Where(a => a.Student_Code == User.Identity.Name).SingleOrDefault(); if (q != null) { if (q.Student_Form1 && q.Student_Form2) { if (!q.Student_Info) { return(RedirectToAction("index", "PortalStudentInfo")); } else if (!q.Student_TakeTurn) { return(RedirectToAction("index", "PortalTakeTurn")); } else { return(RedirectToAction("index", "Portal")); } } } var F = db.Tbl_Form.Where(a => a.Form_IsDelete == false && a.Form_Guid.ToString() == ID).SingleOrDefault(); if (F != null) { Model_Form _Form = new Model_Form() { Name = F.Form_Name, ID = F.Form_ID, }; _Form.Steps = new List <Model_Steps>(); List <Model_Steps> _Steps = new List <Model_Steps>(); foreach (var S_item in F.Tbl_FormStep.Where(a => a.FS_IsDelete == false).ToList()) { Model_Steps _Step = new Model_Steps() { Name = S_item.FS_Display, }; _Step.Questions = new List <Model_Questions>(); List <Model_Questions> _Questions = new List <Model_Questions>(); foreach (var Q_item in S_item.Tbl_Question.Where(a => a.Question_IsDelete == false).ToList()) { Model_Questions _Question = new Model_Questions() { Titel = Q_item.Question_Title, type = Q_item.Question_TypeCodeID, Name = Q_item.Question_Guid.ToString(), }; _Question.Responses = new List <Model_Responses>(); foreach (var R_item in Q_item.Tbl_Response.Where(a => a.Response_IsDelete == false).ToList()) { _Question.Responses.Add(new Model_Responses() { Text = R_item.Response_Title, Value = R_item.Response_Guid.ToString(), }); } _Step.Questions.Add(_Question); } _Form.Steps.Add(_Step); } return(View(_Form)); } else { } return(View()); }