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 Edit(AgentDetails agentdetails)
 {
     if (ModelState.IsValid)
     {
         db.Entry(agentdetails).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     return View(agentdetails);
 }