public ActionResult Add(VM_Specialties special) { var auth_id = User.Identity.GetUserId(); var docId = db.doctors.Where(s => s.userId == auth_id).Select(s => s.userId).FirstOrDefault(); var CheckExist = (from s in db.DoctorSpecialists where s.DoctorID == docId.ToString() && s.SpecialtyID == special.SelectedId select s.ID).Count(); if (CheckExist > 0) { special.ListSpecialties = SpecialtyService.GetAllSpecialty(); special.ListDoctorSpecialties = SpecialtyService.GetAllSpecialtyByDocId(docId); ModelState.AddModelError("SelectedId", "Selected specialty is already added"); return(View(special)); } else { var AddSpecialty = new DoctorSpecialist() { AspNetUser = db.AspNetUsers.FirstOrDefault(e => e.Id == auth_id), DoctorID = docId.ToString(), SpecialtyID = special.SelectedId }; db.DoctorSpecialists.Add(AddSpecialty); db.SaveChanges(); } special.ListSpecialties = SpecialtyService.GetAllSpecialty(); special.ListDoctorSpecialties = SpecialtyService.GetAllSpecialtyByDocId(docId); return(View(special)); }
// POST: specialties/Delete/5 public ActionResult Delete(int id) { VM_Specialties special = new VM_Specialties(); var auth_id = User.Identity.GetUserId(); var docId = db.doctors.Where(s => s.userId == auth_id).Select(s => s.userId).FirstOrDefault(); DoctorSpecialist ds = (from item in db.DoctorSpecialists where item.DoctorID == docId.ToString() && item.SpecialtyID == id select item).FirstOrDefault(); //var DataSpecialty = (from data in db.doctorSpecialists // where data.doctorId == docId && data.specialtyId == id // select data).FirstOrDefault(); db.DoctorSpecialists.Remove(ds); db.SaveChanges(); return(RedirectToAction("Add")); }