private Clinic_Specialty CreateSpecialty(string description, Clinic clinic) { Clinic_Specialty specialty; using (var dbContext = new ApplicationDbContext()) { var specialtyData = dbContext.Specialties.FirstOrDefault(s => s.Description == description); if (specialtyData == null) { specialtyData = new SpecialtyData { Description = description }; dbContext.Specialties.Add(specialtyData); } dbContext.SaveChanges(); specialty = new Clinic_Specialty { DataId = specialtyData.Id, UserId = clinic.UserId }; dbContext.Clinic_Specialties.Add(specialty); dbContext.SaveChanges(); } return(specialty); }
public ActionResult CreateNew(SpecialtyData data) { var CheckExist = (from item in db.Specialists where item.SpecialistName == data.specialty select item.ID).Count(); if (CheckExist > 0) { ModelState.AddModelError("specialty", "Specialty is already exist"); return(RedirectToAction("Add")); } else { var NewSpecialty = new Specialist() { SpecialistName = data.specialty }; db.Specialists.Add(NewSpecialty); db.SaveChanges(); } return(RedirectToAction("Add")); }