public async Task <IActionResult> TinhLaiNhatKy() { try { var or = _context.CV_QT_WorkNote.Where(x => x.DateEnd != null).ToList(); foreach (var item in or) { item.WorkTime = SpaceTimeOnDay.CalSpaceTimeOnDay(item.DateStart ?? DateTime.Now, item.DateEnd ?? DateTime.Now) / 60; } await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception) { return(NoContent()); } }
public async Task <ActionResult <IEnumerable <CV_QT_MyWork> > > r1SpaceTimeOnDay() { try { TimeSpan ts17 = new TimeSpan(17, 00, 0); RequestToken token = CommonData.GetDataFromToken(User); var datesDefault = TransforDate.FromDateToDouble(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 01)); var dateeDefault = TransforDate.FromDateToDouble(DateTime.Now); var reports = (from a in _context.CV_QT_StartPauseHistory where a.UserCreateId == token.UserID && a.Done != true && a.CreateDate.Month == DateTime.Now.Month orderby a.Id select new { a.Id, a.CreateDate, a.CycleWork, a.MyWorkId, a.UserCreateId }).ToList(); if (reports.Count() < 2) { return(new ObjectResult(new { error = 0 })); } List <CV_QT_SpaceTimeOnDay> listSpace = new List <CV_QT_SpaceTimeOnDay>(); for (int i = 0; i < reports.Count() - 1; i++) { if (reports[i].CreateDate.Hour >= 17 && reports[i].CreateDate.Minute > 3) { continue; } if (reports[i].CycleWork == 2) { CV_QT_SpaceTimeOnDay obj = new CV_QT_SpaceTimeOnDay() { SpaceStart = TransforDate.FromDateToDouble(reports[i].CreateDate), SpaceEnd = TransforDate.FromDateToDouble(reports[i + 1].CreateDate), Time = SpaceTimeOnDay.CalSpaceTimeOnDay(reports[i].CreateDate, reports[i + 1].CreateDate), MyWorkId = reports[i].MyWorkId, UserId = reports[i].UserCreateId }; if (obj.Time >= 30) { listSpace.Add(obj); } } } var objup = _context.CV_QT_StartPauseHistory.Where(x => x.UserCreateId == token.UserID && x.Done != true); foreach (var item in objup) { item.Done = true; } _context.CV_QT_StartPauseHistory.UpdateRange(objup); await _context.AddRangeAsync(listSpace); await _context.SaveChangesAsync(); return(new ObjectResult(new { error = 0 })); } catch (Exception e) { return(new ObjectResult(new { error = 1 })); } }