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));
}
