Hi everyone,
I currently have a repository setup that loads forms a person would need to fill out when a view controller action is accessed... the way i have it setup is as follows:
public ActionResult View(long id)
{
Patient patient = patientRepo.GetPatient(id);
if (patient == null)
return View("NotFound");
var forms = formRepo.GetFormsForPatient(id);
return View(new PatientViewModel(patient, forms));
}
the viewmodel is:
public class PatientViewModel
{
//properties
public Patient Patient { get; set; }
public IQueryable<Form> Forms { get; set; }
//constructor
public PatientViewModel(Patient patient, IQueryable<Form> forms)
{
Patient = patient;
Forms = forms;
}
}
and finally my forms repo method looks like this:
public IQueryable<Form> GetFormsForPatient(long id)
{
List<Form> formsReturn = new List<Form>();
var forms = from form in db.Forms
where form.PatientID == id
select form;
foreach (var form in forms)
formsReturn.Add(form);
return formsReturn.AsQueryable();
}
the problem is when i try to loop through my forms object and access some relational data to the forms table (the forms table holds the relation between form and patient, there is another table holding form data that needs to be loaded) I get a null reference when trying to do something like
<% foreach (var form in Model.Forms)
{ %>
<p>Form: <%= Html.Encode(form.FormTextBank.FormName) %></p>
<p><%= form.FormTextBank.FormText %></p>
<% } %>
can anyone spot anything wrong?