//刪除 public ActionResult delete(int?id) { tMemberList x = db.tMemberList.FirstOrDefault(s => s.fId == id); db.tMemberList.Remove(x); db.SaveChanges(); return(RedirectToAction("list")); }
public ActionResult edit(tMemberList x) { tMemberList s = db.tMemberList.FirstOrDefault(m => m.fId == x.fId); //pass by address s.fId = x.fId; s.fCommunityId = x.fCommunityId; s.fJoinDate = x.fJoinDate; s.fMemberId = x.fMemberId; s.fAccessRightId = x.fAccessRightId; db.SaveChanges(); return(RedirectToAction("list")); }
public ActionResult edit(int?id) { tMemberList s = db.tMemberList.FirstOrDefault(m => m.fId == id); var arr_MemberName = from t in db.tMember select t; ViewBag.fMemberId = arr_MemberName.Select(x => new SelectListItem { Text = x.fName, Value = x.fId.ToString(), Selected = s.fMemberId == x.fId, }); var arr_CommunityName = from t in db.tCommunity select t; ViewBag.fCommunityId = arr_CommunityName.Select(x => new SelectListItem { Text = x.fName, Value = x.fId.ToString(), Selected = s.fCommunityId == x.fId, } ); var arr_AccessName = from t in db.tAccessRight select t; ViewBag.fAccessRightId = arr_AccessName.Select(x => new SelectListItem { Text = x.fName, Value = x.fId.ToString(), Selected = s.fAccessRightId == x.fId, } ); //var arr = from t in db.tMember // select t; //ViewBag.fMemberId = arr.Select(x => new SelectListItem //{ // Text = x.fName, // Value = x.fId.ToString(), //}); return(View(s)); }
public ActionResult create(tMemberList x) { db.tMemberList.Add(x); db.SaveChanges(); return(RedirectToAction("list")); }