//查看詳細違規紀錄
public ActionResult InquireDetail(string memID = "M000000003")
{
var activityVio = (from a in db.Join_Fun_Activities
join b in db.Violation
on a.actId equals b.CorrespondingEventID
where a.hostId == memID
select b).ToList();
var RemarkVio = (from a in db.Member_Remarks
join b in db.Violation
on a.remarkSerial equals b.CorrespondingEventID
where a.FromMemId == memID
select b).ToList();
var BoardVio = (from a in db.Message_Board
join b in db.Violation
on a.mboardSerial equals b.CorrespondingEventID
where a.memId == memID
select b).ToList();
var MemberVio = db.Violation.Where(m => m.CorrespondingEventID == memID).ToList();
//將會員、留言板、評價、揪團違規查詢結果合併
var AllVio = activityVio.Union(RemarkVio).Union(BoardVio).Union(MemberVio);
MemberInquireVM detail = new MemberInquireVM()
{
Violation = AllVio.OrderByDescending(m => m.vioId).Where(m => m.implement_admId != null),
};
ViewBag.nick = db.Member.Where(m => m.memId == memID).Select(m => m.memNick).FirstOrDefault();
return(View(detail));
}
//編輯違規項目
public ActionResult InquireEdit(string vioId, string memId)
{
MemberInquireVM edit = new MemberInquireVM()
{
Member = db.Member.ToList(),
Violation = db.Violation.Where(m => m.vioId == vioId),
punishment = db.Punishment.ToList()
};
ViewBag.vioId = db.Violation.Where(m => m.vioId == vioId).Select(m => m.vioId).FirstOrDefault();
ViewBag.oldpunid = db.Violation.Where(m => m.vioId == vioId).FirstOrDefault().punishId;
ViewBag.sus = db.Member.Where(m => m.memId == memId).FirstOrDefault().Suspend;
return(View(edit));
}
