public async Task <ActionResult> Edit([Bind(Include = "Id,LiaisonId,LiaisonGroupId,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy")] LiaisonGroup_Liaison_Mapping LiaisonGroup_Liaison_Mapping)
        {
            if (ModelState.IsValid)
            {
                _db.Entry(LiaisonGroup_Liaison_Mapping).State = EntityState.Modified;
                await _db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            ViewBag.PhysicianId       = new SelectList(_db.Physicians, "Id", "ContactId", LiaisonGroup_Liaison_Mapping.LiaisonId);
            ViewBag.PhysiciansGroupId = new SelectList(_db.PhysiciansGroup, "Id", "GroupName", LiaisonGroup_Liaison_Mapping.LiaisonGroupId);
            return(View(LiaisonGroup_Liaison_Mapping));
        }
        // GET: LiaisonGroup_LiaisonMapping/Details/5
        public async Task <ActionResult> Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            LiaisonGroup_Liaison_Mapping LiaisonGroup_LiaisonMapping = await _db.LiaisonGroup_Liaison_Mappings.FindAsync(id);

            if (LiaisonGroup_LiaisonMapping == null)
            {
                return(HttpNotFound());
            }
            return(View(LiaisonGroup_LiaisonMapping));
        }
        public async Task <ActionResult> Create([Bind(Include = "Id,LiaisonId,LiaisonGroupId,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy")] LiaisonGroup_Liaison_Mapping LiaisonGroup_Liaison_Mapping)
        {
            if (ModelState.IsValid)
            {
                _db.LiaisonGroup_Liaison_Mappings.Add(LiaisonGroup_Liaison_Mapping);
                await _db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            var physicians = _db.Liaisons.ToList().Select(x => new { Id = x.Id, Name = x.FirstName + " " + x.LastName }).ToList();

            ViewBag.PhysicianId       = new SelectList(physicians, "Id", "Name").OrderBy(p => p.Text);
            ViewBag.PhysiciansGroupId = new SelectList(_db.liaisonGroups, "Id", "GroupName");

            return(View(LiaisonGroup_Liaison_Mapping));
        }
        public async Task <JsonResult> SaveDoctorClinicMapping(int ClinicID, List <int> DoctorID)
        {
            var results = _db.LiaisonGroup_Liaison_Mappings.Where(x => x.LiaisonGroupId == ClinicID).ToList();

            _db.LiaisonGroup_Liaison_Mappings.RemoveRange(results);
            _db.SaveChanges();
            foreach (var item in DoctorID)
            {
                LiaisonGroup_Liaison_Mapping physicianGroup_Physician_Mapping = new LiaisonGroup_Liaison_Mapping();
                physicianGroup_Physician_Mapping.LiaisonId      = item;
                physicianGroup_Physician_Mapping.LiaisonGroupId = ClinicID;
                physicianGroup_Physician_Mapping.CreatedBy      = User.Identity.GetUserId();
                physicianGroup_Physician_Mapping.CreatedOn      = DateTime.Now;
                _db.LiaisonGroup_Liaison_Mappings.Add(physicianGroup_Physician_Mapping);
            }
            await _db.SaveChangesAsync();

            return(Json(true));
        }