public ActionResult Create([Bind(Include = "LastName, FirstName, Email, Password, Apartment, Street, City, State, Zipcode, homePhone, WorkPhone")] Personlite pl) { int result = db.usp_Register(pl.LastName, pl.FirstName, pl.Email, pl.Password, pl.Apartment, pl.Street, pl.City, pl.State, pl.Zipcode, pl.HomePhone, pl.WorkPhone); return(View()); }
// GET: Personnel public ActionResult Index() { var peeps = from p in db.Person from pa in p.PersonAddress from c in p.Contact where c.ContactTypeKey == 1 select new { p.PersonKey, p.PersonLastName, p.PersonFirstName, p.PersonEmail, pa.PersonAddressApt, pa.PersonAddressStreet, pa.PersonAddressCity, pa.PersonAddressState, pa.PersonAddressZip, c.ContactNumber }; List <Personlite> peepsList = new List <Personlite>(); foreach (var p in peeps) { Personlite pl = new Personlite(); pl.LastName = p.PersonLastName; pl.FirstName = p.PersonFirstName; pl.Email = p.PersonEmail; pl.Apartment = p.PersonAddressApt; pl.Street = p.PersonAddressStreet; pl.City = p.PersonAddressCity; pl.State = p.PersonAddressState; pl.Zipcode = p.PersonAddressZip; peepsList.Add(pl); } return(View(peepsList)); }