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);
}
private void ButtonOK_Click(object sender, RoutedEventArgs e)
{
this.DialogResult = true;
FilterHandler.FilterDescription result = new FilterHandler.FilterDescription();
result.field = comboBoxField.SelectedItem.ToString();
result.typeOfFilter = typesOfFilter.Where(key => key.Value == comboBoxTypeOfFilter.SelectedItem.ToString()).First().Key;
result.value = isDate ? datePickerValue.SelectedDate.Value.ToShortDateString() : textBoxValue.Text;
result.filterValue = comboBoxTypeOfFilter.SelectedItem.ToString();
result.isDate = isDate;
result.active = checkBoxActive.IsChecked.Value;
Result = result;
Close();
}
private void FillPreviousFilter(FilterHandler.FilterDescription lastFilter)
{
comboBoxField.SelectedItem = lastFilter.field;
if (lastFilter.isDate)
{
datePickerValue.SelectedDate = Convert.ToDateTime(lastFilter.value);
}
else
{
textBoxValue.Text = lastFilter.value;
}
checkBoxActive.IsChecked = lastFilter.active;
comboBoxTypeOfFilter.SelectedItem = lastFilter.filterValue;
textBoxValue.Visibility = lastFilter.isDate ? Visibility.Hidden : Visibility.Visible;
datePickerValue.Visibility = lastFilter.isDate ? Visibility.Visible : Visibility.Hidden;
}
public FilterRecordWindow(WaysToOpen way, List <FindHandler.FieldParameters> listOfFields, FilterHandler.FilterDescription lastFilter)
{
InitializeComponent();
isDate = false;
isNumber = false;
this.way = way;
this.listOfFields = listOfFields;
this.typesOfFilter = FilterHandler.FillTypesOfFilter();
this.lastFilter = lastFilter;
setNewTitle();
FillComboBoxes();
if (lastFilter.value != null)
{
isDate = lastFilter.isDate;
isNumber = lastFilter.isNumber;
FillPreviousFilter(lastFilter);
}
}
