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")); }
}
