public ActionResult Create(HotelDetails hoteldetails)
        {
            //if (ModelState.IsValid)
            //{
            //    db.HotelDetails.Add(hoteldetails);
            //    db.SaveChanges();
            //    return RedirectToAction("Index");
            //}

            //return View(hoteldetails);

            using (BSSDbContext db = new BSSDbContext())
            {
                HotelDetails Hotel = db.HotelDetails.FirstOrDefault(h => h.HotelName.ToLower() == hoteldetails.HotelName.ToLower());

                // Check if Hotel already exists
                if (Hotel == null)
                {
                    // Insert name into the profile table
                    db.HotelDetails.Add(new HotelDetails { HotelName = hoteldetails.HotelName });
                    db.SaveChanges();
                    return RedirectToAction("Index");

                }
                else
                {
                    ModelState.AddModelError("HotelName", "Hotel Name already exists. Please enter a different Hotel Name.");
                }
            }
            return View(hoteldetails);
        }
        public ActionResult Create(AgentDetails agentdetails)
        {
            //if (ModelState.IsValid)
            //{
            //    db.AgentDetails.Add(agentdetails);
            //    db.SaveChanges();
            //    return RedirectToAction("Index");
            //}

            //return View(agentdetails);

            using (BSSDbContext db = new BSSDbContext())
            {
                AgentDetails Agent = db.AgentDetails.FirstOrDefault(a => a.AgentName.ToLower() == agentdetails.AgentName.ToLower());

                // Check if Agent already exists
                if (Agent == null)
                {
                    // Insert name into the profile table
                    db.AgentDetails.Add(new AgentDetails { AgentName = agentdetails.AgentName });
                    db.SaveChanges();
                    return RedirectToAction("Index");

                }
                else
                {
                    ModelState.AddModelError("AgentName", "Agent name already exists. Please enter a different Agent name.");
                }
            }
            return View(agentdetails);
        }
        public ActionResult Create(UserType usertype)
        {
            //if (ModelState.IsValid)
            //{
            //    db.UserTypes.Add(usertype);
            //    db.SaveChanges();
            //    return RedirectToAction("Index");
            //}

            //return View(usertype);
            using (BSSDbContext db = new BSSDbContext())
            {
                UserType usrtyp = db.UserTypes.FirstOrDefault(u => u.UserTypeName.ToLower() == usertype.UserTypeName.ToLower());

                // Check if usertype already exists
                if (usrtyp == null)
                {
                    // Insert name into the profile table
                    db.UserTypes.Add(new UserType { UserTypeName = usertype.UserTypeName });
                    db.SaveChanges();
                    return RedirectToAction("Index");

                }
                else
                {
                    ModelState.AddModelError("UserTypeName", "UserType Name already exists. Please enter a different UserType Name.");
                }
            }
            return View(usertype);
        }