private string AddСondition(FilterHandler.FilterDescription filter, List <FindHandler.FieldParameters> listOfField)
{
string result = "";
var field = listOfField.Where(kvp => kvp.application_name == filter.field).First().db_name;
var typeFilter = FilterHandler.TakeFilter(filter.typeOfFilter);
if (filter.typeOfFilter == TypeOfFilter.TypesOfFilter.isFilled)
{
result += "NOT ";
}
if (!filter.isDate)
{
result += string.Format(field + " " + typeFilter + "\"{0}\"", filter.value);
}
else
{
string day = filter.value.Substring(0, 2);
string month = filter.value.Substring(3, 2);
string year = filter.value.Substring(6, 4);
result += string.Format(field + " " + typeFilter + " \'{0}-{1}-{2}\'", year, month, day);
//result += string.Format(" DATE_FORMAT(" + field + ", '%d.%m.%Y') = \'{0}\'", filter.value);
}
/*if (filter.typeOfFilter == TypeOfFilter.TypesOfFilter.contains)
* {
* result += ") ";
* }*/
return(result);
}
