public ActionResult Edit(int?id)
        {
            var Emid = User.Identity.GetUserId();

            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            InterviewRecords interviewRecords = dbinterview.GetById(id);

            if (interviewRecords == null)
            {
                return(HttpNotFound());
            }
            ViewBag.selectd = db.InterviewRecords.Where(n => n.InterviewID == id).Select(n => n.Interviewee_Name).First();

            var userlist = from n in dbasp.GetAll()
                           join m in dbsub.GetAll()
                           on n.Id equals m.UserID
                           where m.EmploteeID == Emid
                           select new UserData
            {
                Name   = n.Name,
                UserID = n.Id
            };

            ViewBag.userlist  = userlist;
            ViewBag.C_Type_ID = new SelectList(db.InterviewType, "InterviewType_ID", "TypeName", interviewRecords.C_Type_ID);
            return(View(interviewRecords));
        }
        public ActionResult abd()
        {
            Random random = new Random();

            for (int i = 0; i < 150; i++)
            {
                if (i % 7 == 1 || i%7 == 3)
                {
                    var v = random.Next(1, 15);
                    InterviewRecords records = new InterviewRecords();
                    records.UserID = "640335af-e64a-482c-a10a-61173a9321df";
                    records.EmployeeID = "886710ef-aaf3-408c-8a94-cc3d7e7de151";
                    records.Interviewer_Name = "陳韋光";
                    records.Interviewee_Name = "鄭依婷";
                    records.C_Type_ID = 5;
                    records.C_Location = "無";
                    records.StartTime = DateTime.Now.AddDays(-150+i);
                    records.InterviewContent = "";
                    records.CreateTime = DateTime.Now.AddDays(-150 + i +1);
                    records.LastModifyTime = DateTime.Now.AddDays(-v);

                    db.InterviewRecords.Add(records);
                }
            }
           
            db.SaveChanges();

            var a = (from n in db.InterviewRecords
                     select n).Count();
   
            return Json(a, JsonRequestBehavior.AllowGet);
        }
        public ActionResult DeleteConfirmed(int id)
        {
            InterviewRecords interviewRecords = dbinterview.GetById(id);

            //db.InterviewRecords.Remove(interviewRecords);
            dbinterview.Delete(interviewRecords);
            return(RedirectToAction("Index"));
        }
        // GET: CRM/InterviewRecords/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            InterviewRecords interviewRecords = dbinterview.GetById(id);

            if (interviewRecords == null)
            {
                return(HttpNotFound());
            }
            return(View(interviewRecords));
        }
        // GET: CRM/InterviewRecords/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            InterviewRecords interviewRecords = dbinterview.GetById(id);

            if (interviewRecords == null)
            {
                return(HttpNotFound());
            }
            ViewBag.user = interviewRecords.UserID;
            return(PartialView(interviewRecords));
        }
        public ActionResult Edit(InterviewRecords interviewRecords)
        {
            var i  = db.AspNetUsers.Find(User.Identity.GetUserId());
            var id = User.Identity.GetUserId();

            if (ModelState.IsValid)
            {
                interviewRecords.LastModifyTime   = DateTime.Now;
                interviewRecords.Interviewer_Name = i.Name;
                interviewRecords.EmployeeID       = id;
                db.Entry(interviewRecords).State  = EntityState.Modified;
                dbinterview.Update(interviewRecords);
                return(RedirectToAction("Index"));
            }
            ViewBag.C_Type_ID = new SelectList(db.InterviewType, "InterviewType_ID", "TypeName", interviewRecords.C_Type_ID);
            return(View(interviewRecords));
        }
        public ActionResult Create([Bind(Include = "InterviewID,UserID,Interviewer_Name,Interviewee_Name,C_Type_ID,StartTime,C_Location,InterviewContent,CreateTime,LastModifyTime")] InterviewRecords interviewRecords)
        {
            var i  = db.AspNetUsers.Find(User.Identity.GetUserId());
            var id = User.Identity.GetUserId();

            if (ModelState.IsValid)
            {
                interviewRecords.CreateTime     = DateTime.Now;
                interviewRecords.LastModifyTime = DateTime.Now;
                interviewRecords.EmployeeID     = id;
                db.InterviewRecords.Add(interviewRecords);

                dbinterview.Create(interviewRecords);
                return(RedirectToAction("Index"));
            }


            ViewBag.C_Type_ID = new SelectList(db.InterviewType, "InterviewType_ID", "TypeName", interviewRecords.C_Type_ID);
            return(View(interviewRecords));
        }