public ActionResult Loss_RequestData() { var gridModel = new LossCardsGridModel(); SetupLossGridModel(gridModel.CardsGrid); var cards = (from c in db.Cards.Where(w => w.Status == 0) 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.CreateDate, v.PlateNo, v.MotorNo, v.BrandModel, cus.FullName, cds.DeptName }).ToList(); return(gridModel.CardsGrid.DataBind(cards.AsQueryable())); }
public ActionResult Loss() { var gridModel = new LossCardsGridModel(); SetupLossGridModel(gridModel.CardsGrid); return(View(gridModel)); }
public ActionResult Loss_EditData(Guid Id) { var gridModel = new LossCardsGridModel(); SetupLossGridModel(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 = 1; card.LossUserId = userId; card.LossDate = DateTime.Now; context.SaveChanges(); } } return(RedirectToAction("Loss")); }