Example #1
0
        public DateTime LastRecordDateTime(long hotelIdentity, RunningTimeType type)
        {
            using (var repo = Repo <RunningTimeRepository>())
            {
                var lastRecord = repo.GetModels(obj => obj.ProjectIdentity == hotelIdentity && obj.Type == type)
                                 .OrderByDescending(item => item.UpdateTime).FirstOrDefault();

                return(lastRecord?.UpdateTime ?? DateTime.MinValue);
            }
        }
Example #2
0
        private long GetRunTimeTicks(IQueryable <RunningTime> queryable, DateTime dueDateTime, ReportType reportType, RunningTimeType runTimeType)
        {
            var startDate = ReportStartDate(dueDateTime, reportType);

            var runningTime = queryable.Where(obj =>
                                              obj.UpdateTime >= startDate &&
                                              obj.UpdateTime < dueDateTime &&
                                              obj.Type == runTimeType);

            if (runningTime.Count() != 0)
            {
                return(runningTime.Sum(item => item.RunningTimeTicks));
            }

            return(0);
        }