public ActionResult Found_RequestData() { var gridModel = new FoundCardsGridModel(); SetupFoundGridModel(gridModel.CardsGrid); var cards = (from c in db.Cards.Where(w => w.Status == 1) join v in db.Vehicles on c.Vehicle equals v.Id join u in db.aspnet_CustomProfile on c.UserId equals u.UserId into cu from cus in cu.DefaultIfEmpty() join d in db.Depts on c.DeptId equals d.DeptId into cd from cds in cd.DefaultIfEmpty() select new { c.Id, IsInUser = true, c.CardNo, c.LossDate, v.PlateNo, v.MotorNo, v.BrandModel, cus.FullName, cds.DeptName }).ToList(); return(gridModel.CardsGrid.DataBind(cards.AsQueryable())); }
public ActionResult Found() { var gridModel = new FoundCardsGridModel(); SetupFoundGridModel(gridModel.CardsGrid); return(View(gridModel)); }
public ActionResult Found_EditData(Guid Id) { var gridModel = new FoundCardsGridModel(); SetupFoundGridModel(gridModel.CardsGrid); if (gridModel.CardsGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow) { MembershipUser user = Membership.GetUser(); Guid userId = Guid.Parse(user.ProviderUserKey.ToString()); using (var context = db) { var card = context.Cards.Where(w => w.Id == Id).FirstOrDefault(); card.Status = 0; card.FoundUserId = userId; card.FoundDate = DateTime.Now; context.SaveChanges(); } } return(RedirectToAction("Found")); }