public ActionResult parameterIndex(string userid) { var i = db.AspNetUsers.Find(User.Identity.GetUserId()); var id = User.Identity.GetUserId(); if ((i == null) || (id == null)) { return(RedirectToAction("Login", "Account", new { Area = "" })); } //var interviewRecords = db.InterviewRecords.Include(i => i.InterviewType); var l = dbinterview.GetAll(); //傳回自己負責的會員名稱跟ID 放在dropdownlist var user = dbsub.GetAll().Where(n => n.EmploteeID == id).Select(n => new { UserID = n.UserID, UserName = n.Username }); l = l.Where(n => n.EmployeeID == id).OrderBy(n => n.StartTime); if (l.Count() == 0) { ViewBag.message = "沒有內容"; return(View()); } ViewBag.UserDropdown = user; ViewBag.abc = user.Where(n => n.UserID == userid).Select(n => n.UserID); ViewBag.EmployeeID = id; ViewBag.userid = userid; return(View("Index", l)); }
public ActionResult MasterIndex(int page = 1) { int IndexPage = page < 1 ? 1 : page; var i = db.AspNetUsers.Find(User.Identity.GetUserId()); var emid = User.Identity.GetUserId(); if ((i == null) || (emid == null)) { return(RedirectToAction("Login", "Account", new { Area = "" })); } var EmployeeData = db.AspNetUsers.Find(User.Identity.GetUserId()); //var id = User.Identity.GetUserId(); //var sub = dbsub.GetAll().Where(n => n.EmploteeID == id).OrderBy(n =>n.Username); //ViewBag.EmID = id; ViewBag.EmData = EmployeeData; ////var result = sub.ToPagedList(IndexPage, pagesize); //return View(sub); var abc = from n in dbasp.GetAll() join m in dbsub.GetAll() on n.Id equals m.UserID where m.EmploteeID == emid select new UserData { UserName = n.UserName, Name = n.Name, BirthDay = n.BirthDay, Email = n.Email, MailingAddress = n.MailingAddress, PhoneNumber = n.PhoneNumber, Telephone = n.Telephone, Title = n.Title, UserID = n.Id }; return(View(abc)); }
public ActionResult Viewcreate_partial() { var id = User.Identity.GetUserId(); var aspall = dbasp.GetAll(); var IsEmall = dbIsEm.GetAll().Select(n => new { EmMail = n.UserId });//mail var Usersub = dbsub.GetAll().Select(n => new { ID = n.UserID });//id //篩掉自己 var result = dbasp.GetAll().Where(n => n.Id != id); foreach (var Emmail in IsEmall)//篩掉員工 { result = result.Where(n => n.UserName != Emmail.EmMail); } foreach (var Userid in Usersub)//篩掉已有關聯的會員 { result = result.Where(n => n.Id != Userid.ID); } //取得員工姓名跟ID ViewBag.EmIDandName = aspall.Where(n => n.Id == id).Select(n => new { Username = n.Name, UserID = n.Id }); return View(result); }