public ActionResult Edit(int id)
        {
            using (var db = new db_Entities ()) {

                Item item = db.Items.FirstOrDefault (i => i.ItemId == id);
                return View (item);
            }
        }
Example #2
0
        public ToDoViewModel()
        {
            using (var context = new db_Entities())
            {
                Items = context.Items.ToList();

            }
        }
 public ActionResult Create(FormCollection collection)
 {
     try {
         using(var db = new db_Entities())
         {
             var myItem = ToDoViewModel.ToItem(collection);
             myItem.CreatedOn = DateTime.Now;
             db.Items.Add(myItem);
             db.SaveChanges();
             return RedirectToAction ("Index", "Home");
         }
     } catch (Exception ex){
         throw ex;
         return View ();
     }
 }
 public ActionResult Edit(int id, FormCollection collection)
 {
     try {
         using (var db = new db_Entities ()) {
             Item updatedItem = ToDoViewModel.ToItem(collection);
             Item myItem = db.Items.FirstOrDefault(i=> i.ItemId == updatedItem.ItemId);
             if(myItem != null){
                 myItem.Description = updatedItem.Description;
                 myItem.Name = updatedItem.Name;
                 myItem.CompletedOn = updatedItem.CompletedOn;
                 db.SaveChanges();
             }
             return RedirectToAction ("Index", "Home");
         }
     } catch (Exception ex)
     {
         return RedirectToAction ("Index", "Home");
     }
 }
 public ActionResult _Details(int id)
 {
     Item displayItem;
     using (var db = new db_Entities ()) {
         displayItem = db.Items.FirstOrDefault (i => i.ItemId == id);
     }
     return PartialView (displayItem);
 }