public Tuple <IEnumerable <GradePhyRecord>, int> GetRecords(QueryGradeRecordViewModel model)
        {
            if (model == null)
            {
                return(null);
            }
            var result = _context.GradePhyRecords.AsQueryable();

            if (model.CreateBy.Valid())
            {
                result = result.Where(r => r.CreateById == model.CreateBy.Value);
            }
            if (model.CreateFor.Valid())
            {
                result = result.Where(r => r.UserId == model.CreateFor.Value);
            }
            if (!model.Create.Valid())
            {
                model.Create = new QueryByDate()
                {
                    Start = DateTime.Now.AddYears(-1), End = DateTime.Now
                }
            }
            ;
            result = result.Where(r => r.Create >= model.Create.Start).Where(r => r.Create <= model.Create.End);
            var list = result.SplitPage(model.Pages.ValidSplitPage());

            return(new Tuple <IEnumerable <GradePhyRecord>, int>(list.Item1.ToList(), list.Item2));
        }
    }
Esempio n. 2
0
        public IActionResult GetGrade([FromBody] QueryGradeRecordViewModel model)
        {
            var result = phyGradeServices.GetRecords(model);

            return(new JsonResult(new EntitiesListViewModel <GradePhyRecord>(result?.Item1, result?.Item2 ?? -1)));
        }