//
// GET: /CAEmployee/
public ActionResult Index()
{
CommunityAssistEntities cad = new CommunityAssistEntities();
var doners = from d in cad.Donations
orderby d.Person.PersonLastName
select new
{
d.Person.PersonLastName,
d.Person.PersonFirstName,
d.Person.Donations,
d.DonationAmount,
d.Person.PersonUsername
};
List<CADoner> donerList = new List<CADoner>();
foreach (var x in doners)
{
CADoner don = new CADoner();
don.LastName = x.PersonLastName;
don.FirstName = x.PersonFirstName;
don.Email = x.PersonUsername;
don.Donation = x.DonationAmount.ToString();
donerList.Add(don);
}
return View(donerList);
}
//
// GET: /CAEmployee/
public ActionResult Index()
{
CommunityAssistEntities cae = new CommunityAssistEntities();
var employees = from e in cae.EmployeeJobTitles
orderby e.Employee.Person.PersonLastName
select new
{
e.Employee.Person.PersonLastName,
e.Employee.Person.PersonFirstName,
e.Employee.Person.PersonUsername,
e.Employee.EmployeeHireDate,
e.Jobtitle.JobTitleName,
e.Employee.EmployeeStatus
};
List<CAEmployee> employeeList = new List<CAEmployee>();
foreach (var x in employees)
{
CAEmployee emp = new CAEmployee();
emp.LastName = x.PersonLastName;
emp.FirstName = x.PersonFirstName;
emp.Email = x.PersonUsername;
emp.HireDate = x.EmployeeHireDate.ToString();
emp.JobTitle = x.JobTitleName;
emp.Status = x.EmployeeStatus;
employeeList.Add(emp);
}
return View(employeeList);
}