internal static string GetBranchesQuery(DateFilter dateFilter) { if (dateFilter.FilterType == DateFilter.Type.AllTime) { return(QueryConstants.BranchesBeginningQuery); } string whereClause = QueryConstants.GetDateWhereClause( dateFilter.GetFilterDate(DateTime.UtcNow)); return(string.Format("{0} {1}", QueryConstants.BranchesBeginningQuery, whereClause)); }