Example #1
0
        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()));
        }
Example #2
0
        public ActionResult Loss()
        {
            var gridModel = new LossCardsGridModel();

            SetupLossGridModel(gridModel.CardsGrid);
            return(View(gridModel));
        }
Example #3
0
        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"));
        }