public ActionResult DeleteConfirmed(int id)
        {
            nguoidi nguoidi = db.nguoidis.Find(id);

            db.nguoidis.Remove(nguoidi);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // GET: nguoidis/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            nguoidi nguoidi = db.nguoidis.Find(id);

            if (nguoidi == null)
            {
                return(HttpNotFound());
            }
            return(View(nguoidi));
        }
        public ActionResult Create([Bind(Include = "Id,IdDoan,DSNhanvien,DSKhach")] nguoidi nguoidi, int idtour)
        {
            if (ModelState.IsValid)
            {
                db.nguoidis.Add(nguoidi);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            var tours = db.tours.Join(db.doans, t => t.Id, d => d.IdTour, (t, d) => new { t.Id, t.Ten });

            ViewBag.IdTour = new SelectList(tours, "Id", "Ten", idtour);
            ViewBag.idt    = idtour;
            var doans = db.doans.Where(w => w.IdTour == idtour);

            ViewBag.IdDoan = new SelectList(doans, "Id", "Ten", nguoidi.IdDoan);
            //-----------------ListBox Danh sách khách----------------------------//
            List <SelectListItem> listKhach = new List <SelectListItem>();

            if (nguoidi.DSKhach != null)
            {
                string[] IdKs = nguoidi.DSKhach.Split(',');
                foreach (string item in IdKs)
                {
                    int idk = Convert.ToInt32(item);
                    var k   = db.khachhangs.Where(w => w.Id == idk).Select(s => new { Ten_CMND = s.Ten + "---" + s.CMND }).FirstOrDefault();
                    listKhach.Add(new SelectListItem {
                        Text = k.Ten_CMND, Value = k.Ten_CMND
                    });
                }
            }
            ViewBag.DSKhach = listKhach;
            //-----------------ListBox Danh sách nhân viên----------------------------//
            List <SelectListItem> listNhanVien = new List <SelectListItem>();

            if (nguoidi.DSNhanvien != null)
            {
                string[] IdNs = nguoidi.DSNhanvien.Split(',');
                foreach (string item in IdNs)
                {
                    var n = db.AspNetUsers.Where(w => w.Id.Equals(item)).Select(s => new { Ten_NV = s.TenNhanVien + "---" + s.NhiemVu }).FirstOrDefault();
                    listNhanVien.Add(new SelectListItem {
                        Text = n.Ten_NV, Value = n.Ten_NV
                    });
                }
            }
            ViewBag.DSNhanVien = listNhanVien;

            return(View(nguoidi));
        }
        // GET: nguoidis/Edit/5
        public ActionResult Edit(int?id, string StrN, string StrK)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            nguoidi nguoidi = db.nguoidis.Find(id);

            if (nguoidi == null)
            {
                return(HttpNotFound());
            }
            ViewBag.IdDoan = new SelectList(db.doans, "Id", "Ten", nguoidi.IdDoan);
            ViewBag.StrK   = StrK ?? nguoidi.DSKhach;
            ViewBag.StrN   = StrN ?? nguoidi.DSNhanvien;
            //-----------------ListBox Danh sách khách----------------------------//
            string KStr = StrK ?? nguoidi.DSKhach;//(StrK == null) ? nguoidi.DSKhach : StrK;

            string[] IdKs = KStr.Split(',');
            List <SelectListItem> listKhach = new List <SelectListItem>();

            foreach (string item in IdKs)
            {
                int idk = Convert.ToInt32(item);
                var k   = db.khachhangs.Where(w => w.Id == idk).Select(s => new { Ten_CMND = s.Ten + "---" + s.CMND }).FirstOrDefault();
                listKhach.Add(new SelectListItem {
                    Text = k.Ten_CMND, Value = k.Ten_CMND
                });
            }
            ViewBag.DSKhach = listKhach;
            //-----------------ListBox Danh sách nhân viên----------------------------//
            string NvStr = StrN ?? nguoidi.DSNhanvien;//(StrN == null) ? nguoidi.DSNhanvien : StrN;

            string[] IdNs = NvStr.Split(',');
            List <SelectListItem> listNhanVien = new List <SelectListItem>();

            foreach (string item in IdNs)
            {
                var n = db.AspNetUsers.Where(w => w.Id.Equals(item)).Select(s => new { Ten_NV = s.TenNhanVien + "---" + s.NhiemVu }).FirstOrDefault();
                listNhanVien.Add(new SelectListItem {
                    Text = n.Ten_NV, Value = n.Ten_NV
                });
            }
            ViewBag.DSNhanVien = listNhanVien;

            return(View(nguoidi));
        }