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); }