public ActionResult KeyManage() { var gridModel = new KeyManageGridModel(); SetupkeyMangeGrid(gridModel.KeyManageGrid); return(View(gridModel)); }
public ActionResult KeyManage_RequestData() { var gridModel = new KeyManageGridModel(); SetupkeyMangeGrid(gridModel.KeyManageGrid); var keys = (from e in db.ekey join u in db.aspnet_CustomProfile on e.UserId equals u.UserId into eu from eus in eu.DefaultIfEmpty() select new { e.HardwareID, e.CardNo, e.CreateDate, e.IsUse, e.UserId, eus.FullName }).ToList(); var lkeys = keys.Select(s => new{ s.HardwareID, s.CardNo, s.CreateDate, s.IsUse, UserId = s.UserId.ToString(), s.FullName }); return(gridModel.KeyManageGrid.DataBind(lkeys.ToList().AsQueryable())); }
public ActionResult KeyManage_EditData(DXInfo.Models.ekey key) { var gridModel = new KeyManageGridModel(); SetupkeyMangeGrid(gridModel.KeyManageGrid); if (gridModel.KeyManageGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow) { using (var context = db) { var oldkey = context.ekey.Where(w => w.HardwareID == key.HardwareID).FirstOrDefault(); if (oldkey != null) { oldkey.IsUse = key.IsUse; oldkey.UserId = key.UserId; context.SaveChanges(); } } } return(RedirectToAction("KeyManage")); }