public static FilteredRequest formatTimestamps(FilteredRequest request)
{
if (!string.IsNullOrEmpty(request.dateFrom))
{
if (request.timeFrom != null)
{
request.dateFrom = $"{request.dateFrom} {request.timeFrom["hour"]}:{request.timeFrom["minute"]}:{request.timeFrom["second"]}";
if (request.timeTo == null)
{
string defaultTimeTo = "23:59:59";
request.dateTo = $"{request.dateTo} {defaultTimeTo}";
}
else
{
request.dateTo = $"{request.dateTo} {request.timeTo["hour"]}:{request.timeTo["minute"]}:{request.timeTo["second"]}";
}
}
}
return(request);
}
public QueryBuilder(FilteredRequest request)
{
this.request = request;
this.SQL = QueryStubs.getFilteredResults();
}
