/// <summary>
/// Sets the selected values in the controls, using the parameters loaded from a file
/// </summary>
/// <param name="AParameters"></param>
public void SetControls(TParameterList AParameters)
{
txtCity.Text = AParameters.Get("param_city").ToString();
txtCounty.Text = AParameters.Get("param_county").ToString();
txtPostCodeFrom.Text = AParameters.Get("param_postcode_from").ToString();
txtPostCodeTo.Text = AParameters.Get("param_postcode_to").ToString();
cmbRegion.SetSelectedString(AParameters.Get("param_region").ToString(), -1);
cmbCountry.SetSelectedString(AParameters.Get("param_country").ToString(), -1);
chkCurrentAddressesOnly.Checked = AParameters.Get("param_only_addresses_valid_on").ToBool();
dtpAddressStartFrom.Date = AParameters.Get("param_address_start_from").ToDate();
dtpAddressStartTo.Date = AParameters.Get("param_address_start_to").ToDate();
dtpAddressEndFrom.Date = AParameters.Get("param_address_end_from").ToDate();
dtpAddressEndTo.Date = AParameters.Get("param_address_end_to").ToDate();
EnableDisableDateFields();
if (!cmbRegion.Table.Rows.Contains(new object[] { "" }))
{
// add a blank row to the combobox
DataRow BlankRow = cmbRegion.Table.NewRow();
BlankRow[PPostcodeRegionTable.GetRegionDBName()] = "";
cmbRegion.Table.Rows.InsertAt(BlankRow, 0);
}
cmbRegion.cmbCombobox.SelectedIndex = 0;
}
public static DataTable GetPostCodeRegionsAndRanges()
{
List <OdbcParameter> SqlParameterList = new List <OdbcParameter>();
DataTable RegionsRangesTable = new DataTable();
if (TLogging.DL >= 9)
{
Console.WriteLine("GetPostCodeRegionsAndRanges called!");
}
TDBTransaction Transaction = new TDBTransaction();
DBAccess.ReadTransaction(
ref Transaction,
delegate
{
string SqlStmt =
"SELECT " + PPostcodeRegionRangeTable.GetTableDBName() + "." + PPostcodeRegionRangeTable.GetRegionDBName() +
", " + PPostcodeRegionTable.GetDescriptionDBName() + ", " +
PPostcodeRegionRangeTable.GetTableDBName() + "." + PPostcodeRegionRangeTable.GetRangeDBName() + ", " +
PPostcodeRangeTable.GetFromDBName() + ", " + PPostcodeRangeTable.GetToDBName() +
" FROM " + PPostcodeRegionRangeTable.GetTableDBName() + " INNER JOIN " + PPostcodeRangeTable.GetTableDBName() + " ON " +
PPostcodeRegionRangeTable.GetTableDBName() + "." + PPostcodeRegionRangeTable.GetRangeDBName() + " = " +
PPostcodeRangeTable.GetTableDBName() + "." + PPostcodeRangeTable.GetRangeDBName() + " INNER JOIN " +
PPostcodeRegionTable.GetTableDBName() +
" ON " + PPostcodeRegionTable.GetTableDBName() + "." + PPostcodeRegionTable.GetRegionDBName() + " = " +
PPostcodeRegionRangeTable.GetTableDBName() + "." + PPostcodeRegionRangeTable.GetRegionDBName() +
" ORDER BY " + PPostcodeRegionTable.GetRegionDBName();
RegionsRangesTable = Transaction.DataBaseObj.SelectDT(SqlStmt, "events",
Transaction, SqlParameterList.ToArray());
});
return(RegionsRangesTable);
}
