public ActionResult Delete(long Id)
{
using (var db = new NespeDbContext())
{
var drc = db.RequestInfoSet;
var dr = (from t in drc where t.Id == Id select t).FirstOrDefault();
if (dr == null)
{
base.ModelState.AddModelError("Action.Delete.Invalid.Id", "Invalid Id");
return RedirectToAction("Index");
}
var model = new RequestInfoModel { Selected = dr };
return View(model);
}
}
public ActionResult Delete(RequestInfoModel model, FormCollection formCollection)
{
if (ModelState.IsValid)
{
using (var db = new NespeDbContext())
{
var drc = db.RequestInfoSet;
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");
}
}
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);
}
//
// GET: /RequestInfo/
public ActionResult Index()
{
using (var db = new NespeDbContext())
{
var drc = db.RequestInfoSet;
var model = new RequestInfoModel { };
model.Items = (from t in drc select t).ToList();
return View(model);
}
}
public ActionResult Create()
{
var model = new RequestInfoModel { Selected = new RequestInfo { } };
return View(model);
}
public ActionResult Edit(RequestInfoModel model, FormCollection formCollection)
{
if (ModelState.IsValid)
{
using (var db = new NespeDbContext())
{
var selected = model.Selected;
var drc = db.RequestInfoSet;
//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);
}
