public ActionResult editlodge(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            Lodges lodge = db.Lodges.Find(id);

            Addresses adres = db.Addresses.Find(lodge.AdresId);

            AddLodgeViewModels addLodge = new AddLodgeViewModels
            {
                City        = adres.City,
                Streed      = adres.Streed,
                PostCode    = adres.PostCode,
                HouseNumber = adres.HouseNumber,
                Counrty     = adres.Counrty,
                State       = adres.State,
                Code        = lodge.Code,
                LodgeID     = lodge.LodgeId,
                AddresID    = lodge.AdresId,
                LodgeTypeId = lodge.LodgeTypeId,
                Disabled    = lodge.Disabled
            };

            return(View(addLodge));
        }
        public ActionResult editlodgeapply(AddLodgeViewModels model)
        {
            ViewBag.lodges = db.Lodges.ToList();
            if (ModelState.IsValid)
            {
                Addresses oldadress = db.Addresses.Find(model.AddresID);

                oldadress.HouseNumber = model.HouseNumber;
                oldadress.PostCode    = model.PostCode;
                oldadress.Streed      = model.Streed;

                Lodges oldLodge = db.Lodges.Find(model.LodgeID);

                oldLodge.Disabled         = model.Disabled;
                db.Entry(oldLodge).State  = EntityState.Modified;
                db.Entry(oldadress).State = EntityState.Modified;
                db.SaveChanges();
            }
            return(RedirectToAction("lodge"));
        }
        public ActionResult Addlodgessubmit(AddLodgeViewModels model, string LodgeTypes)
        {
            if (ModelState.IsValid)
            {
                var adress = new Addresses {
                    PostCode = model.PostCode, Streed = model.Streed, HouseNumber = model.HouseNumber, City = "Ubud", Counrty = "Bali", State = "Bali"
                };

                db.Addresses.Add(adress);
                db.SaveChanges();

                Lodges lodges = new Lodges
                {
                    Code        = model.Code,
                    AdresId     = (from n in db.Addresses orderby n.AdresId descending select n.AdresId).First(),
                    LodgeTypeId = Convert.ToInt32(LodgeTypes)
                };
                db.Lodges.Add(lodges);
                db.SaveChanges();
            }
            return(RedirectToAction("lodge"));
        }