public ActionResult Edit([Bind(Include = "HouseholdTransportationID,TransportationLogID,FirstName,LastName,Address,PostCode,City,Date,Note,Attachment,Description")] HouseholdTransportationViewModel HouseholdTransportationViewModel)
        {
            if (ModelState.IsValid)
            {
                HouseholdTransportation model = db.HouseholdTransportation.Find(HouseholdTransportationViewModel.HouseholdTransportationID);

                model.FirstName           = HouseholdTransportationViewModel.FirstName;
                model.LastName            = HouseholdTransportationViewModel.LastName;
                model.Address             = HouseholdTransportationViewModel.Address;
                model.PostCode            = HouseholdTransportationViewModel.PostCode;
                model.City                = HouseholdTransportationViewModel.City;
                model.Date                = HouseholdTransportationViewModel.Date;
                model.Note                = HouseholdTransportationViewModel.Note;
                model.Attachment          = HouseholdTransportationViewModel.Attachment;
                model.Description         = HouseholdTransportationViewModel.Description;
                model.TransportationLogID = HouseholdTransportationViewModel.TransportationLogID;

                model.DateModified = DateTime.Now;
                model.ModifiedBy   = Guid.Parse(User.Identity.GetUserId());

                db.Entry(model).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            ViewBag.TransportationLogID = new SelectList(db.TransportationLog, "TransportationLogID", "Location", HouseholdTransportationViewModel.TransportationLogID);
            return(View(HouseholdTransportationViewModel));
        }
        // GET: HouseholdTransportation/Edit/5
        public ActionResult Edit(Guid?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            HouseholdTransportation householdTransportation = db.HouseholdTransportation.Find(id);

            HouseholdTransportationViewModel view = new HouseholdTransportationViewModel();

            view.HouseholdTransportationID = householdTransportation.HouseholdTransportationID;
            view.TransportationLogID       = householdTransportation.TransportationLogID;
            view.FirstName   = householdTransportation.FirstName;
            view.LastName    = householdTransportation.LastName;
            view.Address     = householdTransportation.Address;
            view.PostCode    = householdTransportation.PostCode;
            view.City        = householdTransportation.City;
            view.Date        = householdTransportation.Date;
            view.Note        = householdTransportation.Note;
            view.Attachment  = householdTransportation.Attachment;
            view.Description = householdTransportation.Description;

            if (householdTransportation == null)
            {
                return(HttpNotFound());
            }
            ViewBag.TransportationLogID = new SelectList(db.TransportationLog, "TransportationLogID", "Location", householdTransportation.TransportationLogID);
            return(View(view));
        }