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);
}
