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);
}
