示例#1
0
        public async Task <ActionResult <IEnumerable <CV_QT_StartPauseHistory> > > r1GetListHistory(OptionsCv option)
        {
            RequestToken token  = CommonData.GetDataFromToken(User);
            var          tables = from a in _context.CV_QT_StartPauseHistory
                                  join b in _context.CV_QT_MyWork on a.MyWorkId equals b.Id
                                  where a.UserCreateId == token.UserID && a.MyWorkId == option.MyWorkId
                                  select new
            {
                b.TaskCode,
                b.TaskName,
                a.CreateDate,
                a.CycleWork,
                a.Id,
            };

            return(new ObjectResult(new { error = 0, data = await tables.OrderBy(x => x.Id).ToListAsync() }));
        }
示例#2
0
        public async Task <ActionResult <IEnumerable <CV_QT_StartPauseHistory> > > r1GetListHistory(OptionsCv option)
        {
            var userId = Convert.ToInt32(User.Claims.First(c => c.Type == "UserId").Value);
            var tables = from a in _context.CV_QT_StartPauseHistory
                         join b in _context.CV_QT_MyWork on a.MyWorkId equals b.Id
                         where a.UserCreateId == userId && a.MyWorkId == option.MyWorkId
                         select new
            {
                b.TaskCode,
                b.TaskName,
                a.CreateDate,
                a.CycleWork,
                a.Id,
            };

            return(new ObjectResult(new { error = 0, data = await tables.OrderBy(x => x.Id).ToListAsync() }));
        }