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() })); }
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() })); }