Beispiel #1
0
        // If a time span is selected in the Time period tab then the switch/case statement below will handle that value.
        // Each case calls the TimePeriodHelper class to set the start and end dates.
        private string GetQueryTimeSpan()
        {
            string paramContainer = "&start-date={0}&end-date={1}";

            _timeHelper = new TimePeriodHelper();
            bool startQuarterDate = true;

            switch (TimePeriod)
            {
            case TimePeriod.Today:
                return(string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startToday()), ToUnifiedCultureFormat(_timeHelper.endToday())));

            case TimePeriod.Yesterday:
                return(string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startYesterDay()), ToUnifiedCultureFormat(_timeHelper.endYesterDay())));

            case TimePeriod.Week:
                return(string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startWeekDay()), ToUnifiedCultureFormat(_timeHelper.endWeekDay())));

            case TimePeriod.WeekAnglo:
                return(string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startWeekDayAnglo()), ToUnifiedCultureFormat(_timeHelper.endWeekDayAnglo())));

            case TimePeriod.LastMonth:
                return(string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.monthStart()), ToUnifiedCultureFormat(_timeHelper.monthEnd())));

            case TimePeriod.LastQuarter:
                return(string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.LastQuarter(startQuarterDate)), ToUnifiedCultureFormat(_timeHelper.LastQuarter(startQuarterDate = false))));

            case TimePeriod.LastYear:
                return(string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startLastYear()), ToUnifiedCultureFormat(_timeHelper.endLastYear())));

            case TimePeriod.ThisYear:
                return(string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startThisYear()), ToUnifiedCultureFormat(_timeHelper.endThisYear())));

            case TimePeriod.PeriodNotSpecified:
                return(string.Format(paramContainer, StartDate, EndDate));

            default:
                throw new Exception("Date interval missing or incomplete");
            }
        }
Beispiel #2
0
        // If a time span is selected in the Time period tab then the switch/case statement below will handle that value.
        // Each case calls the TimePeriodHelper class to set the start and end dates.
        private string GetQueryTimeSpan()
        {
            string paramContainer = "&start-date={0}&end-date={1}";
            _timeHelper = new TimePeriodHelper();
            bool startQuarterDate = true;

            switch (TimePeriod)
            {
                case TimePeriod.Today:
                    return string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startToday()), ToUnifiedCultureFormat(_timeHelper.endToday()));
                case TimePeriod.Yesterday:
                    return string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startYesterDay()), ToUnifiedCultureFormat(_timeHelper.endYesterDay()));
                case TimePeriod.Week:
                    return string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startWeekDay()), ToUnifiedCultureFormat(_timeHelper.endWeekDay()));
                case TimePeriod.WeekAnglo:
                    return string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startWeekDayAnglo()), ToUnifiedCultureFormat(_timeHelper.endWeekDayAnglo()));
                case TimePeriod.LastMonth:
                    return string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.monthStart()), ToUnifiedCultureFormat(_timeHelper.monthEnd()));
                case TimePeriod.LastQuarter:
                    return string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.LastQuarter(startQuarterDate)), ToUnifiedCultureFormat(_timeHelper.LastQuarter(startQuarterDate = false)));
                case TimePeriod.LastYear:
                    return string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startLastYear()), ToUnifiedCultureFormat(_timeHelper.endLastYear()));
                    case TimePeriod.ThisYear:
                    return string.Format(paramContainer, ToUnifiedCultureFormat(_timeHelper.startThisYear()), ToUnifiedCultureFormat(_timeHelper.endThisYear()));
                case TimePeriod.PeriodNotSpecified:
                    return string.Format(paramContainer, StartDate, EndDate);
                default:
                    throw new Exception("Date interval missing or incomplete");
            }
        }