public ActionResult Edit(int Id) { PeopleViewModel model = new PeopleViewModel(); using (CrudMVCRazorFetchEntities1 db = new CrudMVCRazorFetchEntities1()) { var oPeople = db.people.Find(Id); model.Name = oPeople.name; model.Age = oPeople.age; model.Id = oPeople.id; } return(View(model)); }
public ActionResult Delete(int Id) { try { using (CrudMVCRazorFetchEntities1 db = new CrudMVCRazorFetchEntities1()) { var oPeople = db.people.Find(Id); db.people.Remove(oPeople); db.SaveChanges(); } return(Content("1")); } catch (Exception ex) { return(Content(ex.Message)); } }
public ActionResult Update(PeopleViewModel model) { try { using (CrudMVCRazorFetchEntities1 db = new CrudMVCRazorFetchEntities1()) { var oPeople = db.people.Find(model.Id); oPeople.name = model.Name; oPeople.age = model.Age; db.Entry(oPeople).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(Content("1")); } catch (Exception ex) { return(Content(ex.Message)); } }
public ActionResult Save(PeopleViewModel model) { try { using (CrudMVCRazorFetchEntities1 db = new CrudMVCRazorFetchEntities1()) { var oPeople = new people(); oPeople.name = model.Name; oPeople.age = model.Age; db.people.Add(oPeople); db.SaveChanges(); } return(Content("1")); } catch (Exception ex) { return(Content(ex.Message)); } }
public ActionResult List() { List <ListPeopleViewModel> lst = new List <ListPeopleViewModel>(); using (CrudMVCRazorFetchEntities1 db = new CrudMVCRazorFetchEntities1()) { lst = (from d in db.people orderby d.id descending select new ListPeopleViewModel { Id = d.id, Name = d.name, Age = d.age }).ToList(); } return(View(lst)); }