public ActionResult Delete(PersonModel model, FormCollection formCollection)
{
if (ModelState.IsValid)
{
using (var db = new NespeDbContext())
{
var drc = db.PersonSet;
var dr = (from t in drc where t.Id == model.Selected.Id select t).FirstOrDefault();
if (dr == null)
{
base.ModelState.AddModelError("Action.Delete.Invalid.Id", "Invalid Id");
return RedirectToAction("Index");
}
drc.Remove(dr);
db.SaveChanges();
}
return RedirectToAction("Index");
}
return View(model);
}
public ActionResult Create(RequestInfoModel model, FormCollection formCollection)
{
if (ModelState.IsValid)
{
using (var db = new NespeDbContext())
{
var drc = db.RequestInfoSet;
var dr = (from t in drc where t.Name == model.Selected.Name select t).FirstOrDefault();
if (dr != null && dr.Id > 0)
{
return RedirectToAction("Edit", new { Id = dr.Id });
}
else
{
drc.Add(model.Selected);
}
db.SaveChanges();
}
return RedirectToAction("Index");
}
return View(model);
}
public ActionResult Edit(PersonModel model, FormCollection formCollection)
{
if (ModelState.IsValid)
{
using (var db = new NespeDbContext())
{
var selected = model.Selected;
var drc = db.PersonSet;
//drc.Attach(model.Selected);
var dr = (from t in drc where t.Id == model.Selected.Id select t).FirstOrDefault();
if (dr != null)
{
dr.Copy(selected);
selected = dr;
}
else
drc.Add(selected);
db.SaveChanges();
}
return RedirectToAction("Index");
}
return View(model);
}
public ActionResult Create(PersonDepartmentModel model, FormCollection formCollection)
{
if (ModelState.IsValid)
{
using (var db = new NespeDbContext())
{
var drc = db.PersonDepartmentSet;
var selected = model.Selected;
var dr = (from t in drc where t.Person_Id == selected.Person_Id && t.Department_Id == selected.Department_Id select t).FirstOrDefault();
if (dr != null && dr.Id > 0)
{
return RedirectToAction("Edit", new { Id = dr.Id });
}
else
{
Bind(selected, db);
drc.Add(selected);
}
db.SaveChanges();
}
return RedirectToAction("Index");
}
return View(model);
}
public ActionResult Edit(PersonDepartmentModel model, FormCollection formCollection)
{
var selected = model.Selected;
using (var db = new NespeDbContext())
{
Bind(selected, db);
if (ModelState.IsValid)
{
var drc = db.PersonDepartmentSet;
//drc.Attach(model.Selected);
var dr = Get(model.Selected.Id, db);
if (dr != null)
{
dr.Copy(selected);
selected = dr;
}
else
drc.Add(selected);
db.SaveChanges();
return RedirectToAction("Index");
}
}
return View(model);
}