public string GetQuery()
{
List <string> queries = new List <string>();
if (!string.IsNullOrEmpty(SerialNumberFilter))
{
queries.Add($"x.SerialNumber.ToLower().StartsWith(\"{ SerialNumberFilter.ToLower() }\")");
}
if (!string.IsNullOrEmpty(ModelFilter))
{
queries.Add($"x.Model.Name.ToLower().StartsWith(\"{ ModelFilter.ToLower() }\")");
}
if (!string.IsNullOrEmpty(ClassificationFilter))
{
queries.Add($"x.Classification.Model.ToLower().StartsWith(\"{ ClassificationFilter.ToLower() }\")");
}
if (!string.IsNullOrEmpty(LastUpdateFilter))
{
if (DateTime.TryParse(LastUpdateFilter, out var result))
{
queries.Add($"DateTime.Parse(x.LastUpdate) >= DateTime.Parse(\"{result.ToString("MM/dd/yyyy")}\")");
}
}
if (!string.IsNullOrEmpty(EventsCountFilter))
{
queries.Add($"x.DeviceEvents.Count() >= { EventsCountFilter }");
}
if (!string.IsNullOrEmpty(LastStatusFilter))
{
queries.Add($"x.LastStatus.ToLower().StartsWith(\"{LastStatusFilter.ToLower()}\")");
}
string query = InitializeQuery;
if (queries.Count > 0)
{
query += string.Join(" && ", queries);
}
return(queries.Count == 0 ? string.Empty : query);
}
