private void ShowDetailsManual(PPostcodeRegionRow ARow)
{
grdRanges.Columns.Clear();
grdRanges.AddTextColumn(Catalog.GetString("Range Name"), FMainDS.PPostcodeRegionRange.ColumnRange, 260);
grdRanges.AddTextColumn(Catalog.GetString("From"), FMainDS.PPostcodeRegionRange.ColumnFrom, 140);
grdRanges.AddTextColumn(Catalog.GetString("To"), FMainDS.PPostcodeRegionRange.ColumnTo, 140);
grdRanges.Selection.EnableMultiSelection = true;
DataView MyDataView = FMainDS.PPostcodeRegionRange.DefaultView;
MyDataView.AllowNew = false;
// do not apply these properties if the grid is empty
if (ARow != null)
{
MyDataView.RowFilter = PPostcodeRegionRangeTable.GetRegionDBName() + " = " + "'" + ARow.Region + "'";
MyDataView.Sort = "p_range_c ASC";
btnAdd.Enabled = true;
}
else
{
btnAdd.Enabled = false;
}
grdRanges.DataSource = new DevAge.ComponentModel.BoundDataView(MyDataView);
MyDataView = FMainDS.PPostcodeRegion.DefaultView;
MyDataView.AllowNew = false;
MyDataView.Sort = "p_region_c ASC";
grdDetails.DataSource = new DevAge.ComponentModel.BoundDataView(MyDataView);
btnRemove.Enabled = false;
}
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);
}
private bool DeleteRowManual(PPostcodeRegionRow ARowToDelete, ref String ACompletionMessage)
{
ACompletionMessage = String.Empty;
FMainDS.PPostcodeRegionRange.DefaultView.Sort = PPostcodeRegionRangeTable.GetRegionDBName();
DataRowView[] RangeRowsToDelete = FMainDS.PPostcodeRegionRange.DefaultView.FindRows(ARowToDelete.Region);
foreach (DataRowView RangeRowToDelete in RangeRowsToDelete)
{
RangeRowToDelete.Row.Delete();
}
ARowToDelete.Delete();
return(true);
}
