public List <SubjectModels> GetSubjectList(int ExamId, int _Params) { List <SubjectModels> subjectModelsList = new List <SubjectModels>(); SubjectModels subjectModels = new SubjectModels(); if (_Params == 0) { subjectModels.ExamID = ExamId; } else { subjectModels.ExamID = ExamId; } if (!string.IsNullOrEmpty(Convert.ToString(subjectModels.UserId))) { DataTable dtSubjectList = new DataTable(); dtSubjectList = subjectModels.GetSubjectList(_Params); if (dtSubjectList.Rows.Count > 0) { foreach (DataRow dr in dtSubjectList.Rows) { SubjectModels subjectModelsTypes = new SubjectModels(); subjectModelsTypes.SubjectId = Convert.ToInt32(dr[0]); subjectModelsTypes.ExamID = Convert.ToInt32(dr[1]); subjectModelsTypes.Subject = Convert.ToString(dr[2]); subjectModelsTypes.Description = Convert.ToString(dr[3]); subjectModelsList.Add(subjectModelsTypes); } } } return(subjectModelsList); }
public List <SubjectModels> GetChapterList(int SubjectId, int UserId) { List <SubjectModels> subjectModelsList = new List <SubjectModels>(); SubjectModels subjectModels = new SubjectModels(); subjectModels.SubjectId = SubjectId; subjectModels.UserId = UserId; if (!string.IsNullOrEmpty(Convert.ToString(subjectModels.UserId))) { dtChapterList = subjectModels.GetChapterList(); if (dtChapterList.Tables[0].Rows.Count > 0) { for (int iChapter = 0; iChapter < dtChapterList.Tables[0].Rows.Count; iChapter++) { SubjectModels subjectModelsTypes = new SubjectModels(); //subjectModelsTypes.StandardId = Convert.ToInt32(dtChapterList.Tables[0].Rows[iChapter]["StandardId"]); subjectModelsTypes.SubjectId = Convert.ToInt32(dtChapterList.Tables[0].Rows[iChapter]["SubjectId"]); subjectModelsTypes.ExamID = Convert.ToInt32(dtChapterList.Tables[0].Rows[iChapter]["exam_id"]); subjectModelsTypes.ExamName = Convert.ToString(dtChapterList.Tables[0].Rows[iChapter]["exam_name"]); subjectModelsTypes.NoOfQuestions = Convert.ToInt32(dtChapterList.Tables[0].Rows[iChapter]["no_of_questions"]); if (!string.IsNullOrEmpty(Convert.ToString(dtChapterList.Tables[0].Rows[iChapter]["exam_time"]))) { subjectModelsTypes.ExamTime = Convert.ToString(dtChapterList.Tables[0].Rows[iChapter]["exam_time"]); } if (!string.IsNullOrEmpty(Convert.ToString(dtChapterList.Tables[0].Rows[iChapter]["Marks"]))) { subjectModelsTypes.Marks = Convert.ToInt32(dtChapterList.Tables[0].Rows[iChapter]["Marks"]); } if (!string.IsNullOrEmpty(Convert.ToString(dtChapterList.Tables[0].Rows[iChapter]["ExamFinished"]))) { subjectModelsTypes.TimeFinished = Convert.ToString(dtChapterList.Tables[0].Rows[iChapter]["ExamFinished"]).ToString().Trim(); } else { subjectModelsTypes.TimeFinished = string.Empty; } if (!string.IsNullOrEmpty(Convert.ToString(dtChapterList.Tables[0].Rows[iChapter]["CreatedOn"]))) { subjectModelsTypes.Date = Convert.ToDateTime(dtChapterList.Tables[0].Rows[iChapter]["CreatedOn"]).ToShortDateString().ToString().Trim(); } else { subjectModelsTypes.Date = string.Empty; } if (!string.IsNullOrEmpty(Convert.ToString(dtChapterList.Tables[0].Rows[iChapter]["Total"]))) { subjectModelsTypes.TotalQuestions = Convert.ToInt32(dtChapterList.Tables[0].Rows[iChapter]["Total"]); } subjectModelsList.Add(subjectModelsTypes); } } } return(subjectModelsList); }
public ActionResult Index(string id = null) { SubjectModels model = new SubjectModels { SubjectId = Guid.NewGuid().ToString() }; return(View(model)); }
public async Task <ActionResult> Add(SubjectModels model) { if (!ModelState.IsValid) { return(View("Error")); } try { StudnetDB studnetDB = new StudnetDB(); studnetDB.Subjects.Add(entity: new Subject() { SubjectId = model.SubjectId, SubjectName = model.Name }); await studnetDB.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); } catch { return(View("Error")); } }