private IQueryable<PersonDepartment> Query(NespeObjectContext db)
{
var drc = db.PersonDepartmentSet;
//return (from t in drc from p in db.PersonSet from d in db.DepartmentSet where d.Id == t.Department_Id && p.Id == t.Person_Id select Normalize(t, p, d));
//return (from t in drc from p in db.PersonSet from d in db.DepartmentSet where d.Id == t.Department_Id && p.Id == t.Person_Id select (tl, pl, dl)=> t);
return (from t in drc select t);
}
public ActionResult Edit(long Id)
{
//using (var db = new NespeDbContext())
using (var db = new NespeObjectContext())
{
var drc = db.PersonSet;
var dr = (from t in drc where t.Id == Id select t).FirstOrDefault();
if (dr == null)
{
base.ModelState.AddModelError("Action.Edit.Invalid.Id", "Invalid Id");
return RedirectToAction("Index");
}
var model = new PersonModel { Selected = dr };
return View(model);
}
}
private PersonDepartment Get(long Id, NespeObjectContext db)
{
return (from t in Query(db) where t.Id == Id select t).FirstOrDefault();
}