public void WhenAddFilterField(string filterField, Table criteria)
{
foreach (var criteriaRow in criteria.Rows)
{
AdHocQueryDialog.AddFilterField(filterField, criteriaRow);
}
}
public void WhenAddOutputFields(Table outputFields)
{
foreach (var outputField in outputFields.Rows)
{
AdHocQueryDialog.FilterBy(outputField["Path"]);
AdHocQueryDialog.AddOutputField(outputField["Field"]);
}
}
public void WhenSetSaveOptions(Table saveOptions)
{
foreach (var option in saveOptions.Rows)
{
option["Name"] = option["Name"] + uniqueStamp;
AdHocQueryDialog.SetSaveOptions(option);
}
AdHocQueryDialog.SaveAndClose();
}
public void WhenFilterBy(string filter)
{
try
{
AdHocQueryDialog.FilterBy(filter); //filter the query
}
catch (Exception ex)
{
throw new Exception("Error: could not filter an adhoc query. " + ex.Message);
}
}
public void WhenAddFilterField(string filterField, Table criteria)
{
try
{ //select criteria for the filtering
foreach (var criteriaRow in criteria.Rows)
{
AdHocQueryDialog.AddFilterField(filterField, criteriaRow);
}
}
catch (Exception ex)
{
throw new Exception("Error: could not add a filter field to an adhoc query. " + ex.Message);
}
}
public void WhenAddOutputFields(Table outputFields)
{
try
{ //select output fields for the query
foreach (var outputField in outputFields.Rows)
{
AdHocQueryDialog.FilterBy(outputField["Path"]);
AdHocQueryDialog.AddOutputField(outputField["Field"]);
}
}
catch (Exception ex)
{
throw new Exception("Error: could not add output fields to an adhoc query. " + ex.Message);
}
}
public void WhenSetSaveOptions(Table saveOptions)
{
try
{
//set save options for the adhoc query
foreach (var option in saveOptions.Rows)
{
AdHocQueryDialog.SetSaveOptions(option);
}
AdHocQueryDialog.Save();
}
catch (Exception ex)
{
throw new Exception("Error: could not set save options to an adhoc query. " + ex.Message);
}
}
private static void CreateUnacknowledgedRevenueSelection(string selectionName)
{
InformationLibraryPanel.AddAdHocQuery("Revenue");
AdHocQueryDialog.FilterBy("Revenue");
AdHocQueryDialog.AddFilterField("Transaction type", CreateTransactionCriteria());
AdHocQueryDialog.AddFilterField("Date", CreateDateCriteria());
AdHocQueryDialog.FilterBy("Revenue\\Revenue Letters");
AdHocQueryDialog.AddFilterField("Acknowledge date", CreateAcknowledgeDateCriteria());
AdHocQueryDialog.FilterBy("Revenue");
AdHocQueryDialog.AddOutputField("Transaction type");
AdHocQueryDialog.FilterBy("Revenue\\Constituent");
AdHocQueryDialog.AddOutputField("Last/Organization/Group/Household name");
AdHocQueryDialog.SetSaveOptions(CreateSaveOptions(selectionName));
Dialog.Save();
}
public void WhenSetQuerySaveOptions(Table saveOptions)
{
try
{
//save the details which are in the table for the Save Options for the query
foreach (var option in saveOptions.Rows)
{
option["Name"] = option["Name"] + uniqueStamp;
AdHocQueryDialog.SetSaveOptions(option);
}
AdHocQueryDialog.SaveAndClose(); // save and close the query
System.Threading.Thread.Sleep(4000); //pause because otherwise the code runs so rapidly that the next line is not invoked in time
}
catch (Exception ex)
{
throw new Exception("Error: Could not save the query options. " + ex.Message);
}
}
public void WhenFilterBy(string filter)
{
AdHocQueryDialog.FilterBy(filter);
}
