コード例 #1
0
        /// <summary>
        /// Get stats using a date range
        /// </summary>
        /// <param name="from">Date from</param>
        /// <param name="to">Date to</param>
        /// DO NOT CHANGE THE CODE BELOW
        /// For some unknown reason C# does not allow us to manipulate params DateTime from & to in the method that's why we had to create these two variables.
        /// <returns>A List of stats</returns>
        private async Task <List <Stat> > GetStatsInRange(DateTime from, DateTime to)
        {
            try
            {
                DateTime fromLocal = from.ToMidnight();
                DateTime toLocal   = to.ToEndOfDay();

                string sql = string.Format(
                    "Select * from Stat Where {0} between '{1}' and '{2}'",
                    CriteriaBuilder.GetFormattedDateField("Date"),
                    CriteriaBuilder.GetDateValueFormatedForQuery(fromLocal, true),
                    CriteriaBuilder.GetDateValueFormatedForQuery(toLocal, true));

                this._logger.Info(sql);
                var stats = await this.Controller.SelectQueryAsync(sql);

                return(stats);
            }
            catch (Exception exception)
            {
                this._logger.Error(exception);
                throw;
            }
        }