Here is the controller I created that shows the donors names and emails. This assumes that you have added the ADO Data Entity to model. It, oddly, also required me to create a new donor class to store the results of the query. It was the only way it would pass the results to the View
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data.Entity;
namespace CommunityAssistMVCProject.Models
{
public class DonorController : Controller
{
//
// GET: /Donor/
Donor d;
CommunityAssistEntities cae = new CommunityAssistEntities();
public ActionResult Index()
{
var don = (from p in cae.Donations
orderby p.Person.PersonLastName
where p.PersonKey == p.Person.PersonKey
select new { p.Person.PersonLastName, p.Person.PersonFirstName, p.Person.PersonUsername }).Distinct();
List<Donor> donors = new List<Donor>();
foreach (var x in don)
{
d = new Donor();
d.LastName = x.PersonLastName;
d.FirstName = x.PersonFirstName;
d.Email = x.PersonUsername;
donors.Add(d);
}
return View(donors);
}
}
public class Donor
{
public string PersonKey { get; set; }
public string LastName { get; set; }
public string FirstName { get; set; }
public string Email { get; set; }
}
}
No comments:
Post a Comment