public TestQuestionListModel GetAllQuestionsForSubject(int SubId) { string connectionString = "server=localhost;uid=root;password=Reset1234;database=OnlineTestManagement;"; TestQuestionListModel model = new TestQuestionListModel(); model.QuestionList = new List <Question>(); string queryString = "SELECT Id, Question FROM OnlineTestManagement.Test where SubjectId=" + SubId + ";"; using (MySqlConnection connection = new MySqlConnection(connectionString)) { MySqlCommand command = new MySqlCommand(queryString, connection); connection.Open(); MySqlDataReader reader = command.ExecuteReader(); // Call Read before accessing data. while (reader.Read()) { Question obj = new Question(); obj.Id = (int)reader[0]; obj.Text = reader[1].ToString(); model.QuestionList.Add(obj); } // Call Close when done reading. connection.Close(); } return(model); }
public IViewComponentResult InvokeAsync(int SubId, bool IsPartial) { TestQuestionListModel ResponseModel = _testService.GetAllQuestionsForSubject(SubId); ViewBag.ShowEmptyState = !IsPartial; return(View(ResponseModel)); }
public TestQuestionListModel GetAllQuestionsForSubject(int SubId) { TestQuestionListModel model = _testRepository.GetAllQuestionsForSubject(SubId); return(model); }