public ActionResult Create(ConsultantDetails consultantdetails) { //if (ModelState.IsValid) //{ // db.ConsultantDetails.Add(consultantdetails); // db.SaveChanges(); // return RedirectToAction("Index"); //} //return View(consultantdetails); using (BSSDbContext db = new BSSDbContext()) { ConsultantDetails consultant = db.ConsultantDetails.FirstOrDefault(c => c.ConsultantName.ToLower() == consultantdetails.ConsultantName.ToLower()); // Check if consultant already exists if (consultant == null) { // Insert name into the profile table db.ConsultantDetails.Add(new ConsultantDetails { ConsultantName = consultantdetails.ConsultantName }); db.SaveChanges(); return RedirectToAction("Index"); } else { ModelState.AddModelError("ConsultantName", "Consultant Name already exists. Please enter a different Consultant Name."); } } return View(consultantdetails); }
public ActionResult Edit(ConsultantDetails consultantdetails) { if (ModelState.IsValid) { db.Entry(consultantdetails).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(consultantdetails); }