public static FilterData Like(string propertyName, object value, LikeOperator likeOperator = LikeOperator.None)
{
FilterData fd = DefaultSet(propertyName, value, FilterType.Like);
fd._likeOperator = likeOperator;
return(fd);
}
public static FilterData IsNotNull(string propertyName)
{
FilterData fd = new FilterData();
fd._propertyName = propertyName;
fd._filterType = FilterType.IsNotNull;
return(fd);
}
public static IList <RegistroEntradaSaida> SearchRegistro(string nome, string veiculo, DateTime dtSaidaDe, DateTime dtSaidaAte, DateTime dtRetornoDe, DateTime dtRetornoAte, int tipo, string cpf)
{
List <FilterData> listFilterData = new List <FilterData>();
if (!string.IsNullOrWhiteSpace(nome))
{
listFilterData.Add(FilterData.Like("PessoaNome", nome, LikeOperator.Both));
}
if (!string.IsNullOrWhiteSpace(veiculo))
{
listFilterData.Add(FilterData.Like("Veiculo", veiculo, LikeOperator.Both));
}
if (dtSaidaDe > DateTime.MinValue)
{
listFilterData.Add(FilterData.Ge("DataSaida", dtSaidaDe));
}
if (dtSaidaAte > DateTime.MinValue)
{
listFilterData.Add(FilterData.Lt("DataSaida", dtSaidaAte));
}
//Filtro data Retorno
if (dtRetornoDe > DateTime.MinValue)
{
listFilterData.Add(FilterData.Ge("DataEntrada", dtRetornoDe));
}
if (dtRetornoAte > DateTime.MinValue)
{
listFilterData.Add(FilterData.Lt("DataEntrada", dtRetornoAte));
}
if (!string.IsNullOrWhiteSpace(cpf))
{
listFilterData.Add(FilterData.Like("PesoaCPF", cpf, LikeOperator.Both));
}
listFilterData.Add(FilterData.Eq("Tipo", tipo));
if (listFilterData.Any())
{
FilterCriteria fc = FilterCriteria.And(listFilterData.ToArray());
return(GetAll(fc, orderBy: "DataSaida"));
}
else
{
return(GetAll(orderBy: "DataSaida"));
}
}
public static FilterData Between(string propertyName, object value1, object value2)
{
if (value1 == null || value2 == null)
{
throw new Exception("Value can't be null.");
}
FilterData fd = new FilterData();
fd._filterType = FilterType.Between;
fd._obj1 = value1;
fd._obj2 = value2;
return(fd);
}
private static FilterData DefaultSet(string propertyName, object value, FilterType filterType)
{
if (value == null)
{
throw new Exception("Value can't be null.");
}
FilterData fd = new FilterData();
fd._propertyName = propertyName;
fd._filterType = filterType;
fd._obj1 = value;
return(fd);
}
public void Add(FilterData filterData)
{
if (filterData == null)
{
return;
}
if (!_isFilterData)
{
throw new Exception("Only Filter Criteria can be added.");
}
if (_listFilterData == null)
{
_listFilterData = new FilterData[] { filterData }
}
;
else
{
_listFilterData = _listFilterData.Concat(new FilterData[] { filterData }).ToArray();
}
}
