public ActionResult List()
{
ListSurvey question = new ListSurvey();
question.questions = db.Questions.ToList();
question.surveys = db.Surveys.ToList();
return(View(question));
//return View();
}
public ActionResult List(string id)
{
string basequery = "Select * from questions";
List <Question> questions = db.Questions.SqlQuery(basequery).ToList();
string query = "Select * from surveys where questionid=@id";
SqlParameter parameter = new SqlParameter("@id", id);
List <Survey> answers = db.Surveys.SqlQuery(query, parameter).ToList();
var ListSurvey = new ListSurvey();
ListSurvey.surveys = answers;
ListSurvey.questions = questions;
return(View(ListSurvey));
}
