public ActionResult Create([Bind(Include = "FirstName,LastName,Title")] Person person)
{
if (ModelState.IsValid)
{
using (var pp = new AdventureWorksDataContext())
{
person.ModifiedDate = DateTime.Now;
person.PersonType = "EM";
person.BusinessEntityID = 1;
var businessEntity = new BusinessEntity();
businessEntity.ModifiedDate = DateTime.Now;
businessEntity.Person = person;
businessEntity.rowguid = Guid.NewGuid( );
person.BusinessEntity = businessEntity;
pp.BusinessEntities.InsertOnSubmit(businessEntity);
pp.Persons.InsertOnSubmit(person);
pp.SubmitChanges();
}
return RedirectToAction("Index");
}
return View(person);
}
public ActionResult Index()
{
ViewBag.Title = "Person Index";
List<Person> list;
using (var pp = new AdventureWorksDataContext())
{
list = (from item in pp.Persons
select item).ToList();
}
ViewBag.Persons = list.Take(100);
return View();
}
public ActionResult SortIndex1()
{
ViewBag.Title = "Sorted Person Index";
List<Person> list;
using (var pp = new AdventureWorksDataContext())
{
var dat = (from item in pp.Persons
select item).ToArray();
list = (from item in dat
orderby item.LastName, item.FirstName
select item).ToList();
}
ViewBag.Persons = list.Take(100);
return View();
}
