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));
        }
        public ActionResult DeleteConfirmed(Guid id)
        {
            HouseholdTransportation householdTransportation = db.HouseholdTransportation.Find(id);

            db.HouseholdTransportation.Remove(householdTransportation);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // GET: HouseholdTransportation/Delete/5
        public ActionResult Delete(Guid?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            HouseholdTransportation householdTransportation = db.HouseholdTransportation.Find(id);

            if (householdTransportation == null)
            {
                return(HttpNotFound());
            }
            return(View(householdTransportation));
        }
        // GET: HouseholdTransportation/Details/5
        public ActionResult Details(Guid?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            HouseholdTransportation householdTransportation = db.HouseholdTransportation.Find(id);

            // tole je dodano za izpis tabele voženj v view od household details
            var transportationLogHousehold = db.TransportationLog.Where(x => x.TransportationLogID == householdTransportation.TransportationLogID);

            ViewBag.tHousehold = transportationLogHousehold;


            if (householdTransportation == null)
            {
                return(HttpNotFound());
            }
            return(View(householdTransportation));
        }
        public ActionResult Create([Bind(Include = "TransportationLogID,FirstName,LastName,Address,PostCode,City,Date,Note,Attachment,Description")] HouseholdTransportation householdTransportation, string LogID)
        {
            if (ModelState.IsValid)
            {
                householdTransportation.HouseholdTransportationID = Guid.NewGuid();
                householdTransportation.TransportationLogID       = Guid.Parse(LogID);

                householdTransportation.DateCreated  = DateTime.Now;
                householdTransportation.DateModified = householdTransportation.DateCreated;

                householdTransportation.CreatedBy  = Guid.Parse(User.Identity.GetUserId());
                householdTransportation.ModifiedBy = householdTransportation.CreatedBy;

                db.HouseholdTransportation.Add(householdTransportation);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            // ViewBag.TransportationLogID = new SelectList(db.TransportationLog, "TransportationLogID", "Location", householdTransportation.TransportationLogID);
            return(View(householdTransportation));
        }