//---------------------------------------------------------------------
//---------------------------------------------------------------------
// CHANGED: CR39 (Split and merge complete messages)
// Return true or false success so the main class knows
// whether to notify the user following the completion of
// the merge.
//
private bool PerformLogicalMerge(bool physicallyMerge)
{
bool success = true;
try
{
if (_viewModelMain.IncidsSelectedMapCount <= 0)
{
return(false);
}
_mergeFeaturesWindow = new WindowMergeFeatures();
_mergeFeaturesWindow.Owner = App.Current.MainWindow;
_mergeFeaturesWindow.WindowStartupLocation = WindowStartupLocation.CenterOwner;
_mergeFeaturesWindow.MaxHeight = App.Current.MainWindow.ActualHeight;
HluDataSet.incidDataTable selectTable = new HluDataSet.incidDataTable();
_viewModelMain.HluTableAdapterManager.incidTableAdapter.Fill(selectTable,
ViewModelWindowMainHelpers.IncidSelectionToWhereClause(ViewModelWindowMain.IncidPageSize,
_viewModelMain.IncidTable.incidColumn.Ordinal, _viewModelMain.IncidTable, _viewModelMain.IncidsSelectedMap));
HluDataSet.incid_mm_polygonsDataTable polygons = new HluDataSet.incid_mm_polygonsDataTable();
_viewModelMain.GetIncidMMPolygonRows(ViewModelWindowMainHelpers.GisSelectionToWhereClause(
_viewModelMain.GisSelection.Select(), _viewModelMain.GisIDColumnOrdinals,
ViewModelWindowMain.IncidPageSize, polygons), ref polygons);
_mergeFeaturesViewModelLogical = new ViewModelMergeFeatures <HluDataSet.incidDataTable,
HluDataSet.incidRow>(selectTable, _viewModelMain.GisIDColumnOrdinals,
_viewModelMain.IncidTable.incidColumn.Ordinal, polygons.Select(r => r).ToArray(),
_viewModelMain.GISApplication);
_mergeFeaturesViewModelLogical.DisplayName = "Select INCID To Keep";
_mergeFeaturesViewModelLogical.RequestClose += new ViewModelMergeFeatures <HluDataSet.incidDataTable,
HluDataSet.incidRow> .RequestCloseEventHandler(_mergeFeaturesViewModelLogical_RequestClose);
_mergeFeaturesWindow.DataContext = _mergeFeaturesViewModelLogical;
_mergeResultFeatureIndex = -1;
_mergeFeaturesWindow.ShowDialog();
if (_mergeResultFeatureIndex == -1)
{
return(false);
}
_viewModelMain.ChangeCursor(Cursors.Wait, "Processing ...");
_viewModelMain.DataBase.BeginTransaction(true, IsolationLevel.ReadCommitted);
try
{
string keepIncid = selectTable[_mergeResultFeatureIndex].incid;
// assign selected incid to selected features except keepIncid
DataTable historyTable = _viewModelMain.GISApplication.MergeFeaturesLogically(
keepIncid, _viewModelMain.HistoryColumns);
if ((historyTable == null) || (historyTable.Rows.Count == 0))
{
throw new Exception("Failed to update GIS layer.");
}
// assign selected incid and new toid_fragment_id to selected features except keepIncid in DB shadow copy
string toidFragmentFormat = String.Format("D{0}",
_viewModelMain.HluDataset.incid_mm_polygons.toid_fragment_idColumn.MaxLength);
List <KeyValuePair <int, object> > updateFields = new List <KeyValuePair <int, object> >();
var keepPolygon = polygons.FirstOrDefault(r => r.incid == keepIncid);
if (keepPolygon != null)
{
updateFields = (from c in polygons.Columns.Cast <DataColumn>()
where (c.Ordinal != _viewModelMain.HluDataset.incid_mm_polygons.incidColumn.Ordinal) &&
(c.Ordinal != _viewModelMain.HluDataset.incid_mm_polygons.toidColumn.Ordinal) &&
(c.Ordinal != _viewModelMain.HluDataset.incid_mm_polygons.toid_fragment_idColumn.Ordinal) &&
(c.Ordinal != _viewModelMain.HluDataset.incid_mm_polygons.shape_lengthColumn.Ordinal) &&
(c.Ordinal != _viewModelMain.HluDataset.incid_mm_polygons.shape_areaColumn.Ordinal)
select new KeyValuePair <int, object>(c.Ordinal, keepPolygon[c.Ordinal])).ToList();
}
var updatePolygons = from r in polygons
where r.incid != keepIncid
orderby r.toid, r.toid_fragment_id
select r;
// update shadow DB copy of GIS layer
foreach (HluDataSet.incid_mm_polygonsRow r in updatePolygons)
{
r.incid = keepIncid;
for (int i = 0; i < updateFields.Count; i++)
{
r[updateFields[i].Key] = updateFields[i].Value;
}
}
if (_viewModelMain.HluTableAdapterManager.incid_mm_polygonsTableAdapter.Update(polygons) == -1)
{
throw new Exception(String.Format("Failed to update {0} table.", _viewModelMain.HluDataset.incid_mm_polygons.TableName));
}
// insert history rows (fixed value keepIncid)
Dictionary <int, string> fixedValues = new Dictionary <int, string>();
fixedValues.Add(_viewModelMain.HluDataset.history.incidColumn.Ordinal, keepIncid);
ViewModelWindowMainHistory vmHist = new ViewModelWindowMainHistory(_viewModelMain);
vmHist.HistoryWrite(fixedValues, historyTable, ViewModelWindowMain.Operations.LogicalMerge);
// count incid records no longer in use
List <string> deleteIncids = new List <string>();
IDataReader delReader = _viewModelMain.DataBase.ExecuteReader(String.Format(
"SELECT {0} FROM {1} WHERE {0} IN ({2}) GROUP BY {0} HAVING COUNT(*) = 0",
_viewModelMain.DataBase.QuoteIdentifier(_viewModelMain.IncidTable.incidColumn.ColumnName),
_viewModelMain.DataBase.QualifyTableName(_viewModelMain.IncidTable.TableName),
selectTable.Aggregate(new StringBuilder(), (sb, r) => sb.Append("," +
_viewModelMain.DataBase.QuoteValue(r.incid))).Remove(0, 1)),
_viewModelMain.DataBase.Connection.ConnectionTimeout, CommandType.Text);
if (delReader == null)
{
throw new Exception("Error reading incid database table.");
}
while (delReader.Read())
{
deleteIncids.Add(delReader.GetString(0));
}
delReader.Close();
// delete any incid records no longer in use
if (deleteIncids.Count > 0)
{
int numAffected = _viewModelMain.DataBase.ExecuteNonQuery(String.Format(
"DELETE FROM {0} WHERE {1} IN ({2})",
_viewModelMain.DataBase.QualifyTableName(_viewModelMain.HluDataset.incid.TableName),
_viewModelMain.DataBase.QuoteValue(_viewModelMain.HluDataset.incid.incidColumn.ColumnName),
String.Join(",", deleteIncids.Select(i => _viewModelMain.DataBase.QuoteValue(i)).ToArray())),
_viewModelMain.DataBase.Connection.ConnectionTimeout, CommandType.Text);
if (numAffected > 0)
{
_viewModelMain.IncidRowCount(true);
}
}
_viewModelMain.ViewModelUpdate.UpdateIncidModifiedColumns(keepIncid);
if (physicallyMerge && (MessageBox.Show("Perform physical merge as well?", "HLU: Physical Merge",
MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No) == MessageBoxResult.Yes))
{
// restore the selection
_viewModelMain.GisSelection.Clear();
foreach (HluDataSet.incid_mm_polygonsRow r in polygons)
{
DataRow newRow = _viewModelMain.GisSelection.NewRow();
for (int i = 0; i < _viewModelMain.GisIDColumnOrdinals.Length; i++)
{
newRow[i] = r[_viewModelMain.GisIDColumnOrdinals[i]];
}
_viewModelMain.GisSelection.Rows.Add(newRow);
}
PerformPhysicalMerge();
}
else
{
_viewModelMain.DataBase.CommitTransaction();
_viewModelMain.HluDataset.AcceptChanges();
// Re-count the incid records in the database.
_viewModelMain.IncidRowCount(true);
// Reset the incid and map selections but don't move
// to the first incid in the database.
_viewModelMain.ClearFilter(false);
// Synch with the GIS selection.
//---------------------------------------------------------------------
// FIX: 027 Force refill of Incid table after split/merge
// Force the Incid table to be refilled because it has been
// updated directly in the database rather than via the
// local copy.
_viewModelMain.RefillIncidTable = true;
//---------------------------------------------------------------------
_viewModelMain.ReadMapSelection(true);
}
}
catch
{
_viewModelMain.DataBase.RollbackTransaction();
throw;
}
}
catch (Exception ex)
{
success = false;
MessageBox.Show("Merge operation failed. The error message returned was:\n\n" +
ex.Message, "HLU Merge Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally { _viewModelMain.ChangeCursor(Cursors.Arrow, null); }
return(success);
}
/// <summary>
/// Writes changes made to current incid back to database and GIS layer.
/// Also synchronizes shadow copy of GIS layer in DB and writes history.
/// </summary>
internal bool Update()
{
_viewModelMain.DataBase.BeginTransaction(true, IsolationLevel.ReadCommitted);
try
{
_viewModelMain.ChangeCursor(Cursors.Wait, "Saving ...");
int incidCurrRowIx = _viewModelMain.IncidCurrentRowIndex;
//---------------------------------------------------------------------
// FIXED: KI97 (Last modified date and user)
// CHANGED: CR3 (IHS version)
// Previously only changes to fields on the incid table triggered the
// last modified date & user fields to be updated.
// Update the last modified date & user fields and the ihs version on
// the incid table regardless of which attributes have been changed.
//if (_viewModelMain.IsDirtyIncid())
//{
IncidCurrentRowDerivedValuesUpdate(_viewModelMain);
//---------------------------------------------------------------------
// FIX: 028 Only update DateTime fields to whole seconds
// Fractions of a second can cause rounding differences when
// comparing DateTime fields later in some databases.
DateTime currDtTm = DateTime.Now;
DateTime nowDtTm = new DateTime(currDtTm.Year, currDtTm.Month, currDtTm.Day, currDtTm.Hour, currDtTm.Minute, currDtTm.Second, DateTimeKind.Local);
//---------------------------------------------------------------------
_viewModelMain.IncidCurrentRow.last_modified_date = nowDtTm;
_viewModelMain.IncidCurrentRow.last_modified_user_id = _viewModelMain.UserID;
_viewModelMain.IncidCurrentRow.ihs_version = _viewModelMain.IhsVersion;
if (_viewModelMain.HluTableAdapterManager.incidTableAdapter.Update(
(HluDataSet.incidDataTable)_viewModelMain.HluDataset.incid.GetChanges()) == -1)
{
throw new Exception(String.Format("Failed to update '{0}' table.",
_viewModelMain.HluDataset.incid.TableName));
}
//}
//---------------------------------------------------------------------
if ((_viewModelMain.IncidIhsMatrixRows != null) && _viewModelMain.IsDirtyIncidIhsMatrix())
{
if (_viewModelMain.HluTableAdapterManager.incid_ihs_matrixTableAdapter.Update(
(HluDataSet.incid_ihs_matrixDataTable)_viewModelMain.HluDataset.incid_ihs_matrix.GetChanges()) == -1)
{
throw new Exception(String.Format("Failed to update '{0}' table.",
_viewModelMain.HluDataset.incid_ihs_matrix.TableName));
}
}
if ((_viewModelMain.IncidIhsFormationRows != null) && _viewModelMain.IsDirtyIncidIhsFormation())
{
if (_viewModelMain.HluTableAdapterManager.incid_ihs_formationTableAdapter.Update(
(HluDataSet.incid_ihs_formationDataTable)_viewModelMain.HluDataset.incid_ihs_formation.GetChanges()) == -1)
{
throw new Exception(String.Format("Failed to update '{0}' table.",
_viewModelMain.HluDataset.incid_ihs_formation.TableName));
}
}
if ((_viewModelMain.IncidIhsManagementRows != null) && _viewModelMain.IsDirtyIncidIhsManagement())
{
if (_viewModelMain.HluTableAdapterManager.incid_ihs_managementTableAdapter.Update(
(HluDataSet.incid_ihs_managementDataTable)_viewModelMain.HluDataset.incid_ihs_management.GetChanges()) == -1)
{
throw new Exception(String.Format("Failed to update '{0}' table.",
_viewModelMain.HluDataset.incid_ihs_management.TableName));
}
}
if ((_viewModelMain.IncidIhsComplexRows != null) && _viewModelMain.IsDirtyIncidIhsComplex())
{
if (_viewModelMain.HluTableAdapterManager.incid_ihs_complexTableAdapter.Update(
(HluDataSet.incid_ihs_complexDataTable)_viewModelMain.HluDataset.incid_ihs_complex.GetChanges()) == -1)
{
throw new Exception(String.Format("Failed to update '{0}' table.",
_viewModelMain.HluDataset.incid_ihs_complex.TableName));
}
}
if (_viewModelMain.IsDirtyIncidBap())
{
UpdateBap();
}
if (_viewModelMain.IncidSourcesRows != null)
{
int j = 0;
for (int i = 0; i < _viewModelMain.IncidSourcesRows.Length; i++)
{
if (_viewModelMain.IncidSourcesRows[i] != null)
{
_viewModelMain.IncidSourcesRows[i].sort_order = ++j;
}
}
if (_viewModelMain.HluTableAdapterManager.incid_sourcesTableAdapter.Update(
(HluDataSet.incid_sourcesDataTable)_viewModelMain.IncidSourcesTable.GetChanges()) == -1)
{
throw new Exception(String.Format("Failed to update {0} table.",
_viewModelMain.HluDataset.incid_sources.TableName));
}
}
// update all GIS rows corresponding to this incid
List <SqlFilterCondition> incidCond = new List <SqlFilterCondition>(new SqlFilterCondition[] {
new SqlFilterCondition(_viewModelMain.HluDataset.incid_mm_polygons,
_viewModelMain.HluDataset.incid_mm_polygons.incidColumn, _viewModelMain.Incid)
});
var q = _viewModelMain.HluDataset.lut_ihs_habitat
.Where(r => r.code == _viewModelMain.IncidCurrentRow.ihs_habitat);
string ihsHabitatCategory = q.Count() == 1 ? q.ElementAt(0).category : null;
DataTable historyTable = _viewModelMain.GISApplication.UpdateFeatures(new DataColumn[] {
_viewModelMain.HluDataset.incid_mm_polygons.ihs_categoryColumn,
_viewModelMain.HluDataset.incid_mm_polygons.ihs_summaryColumn
},
new object[] { ihsHabitatCategory, _viewModelMain.IncidIhsSummary },
_viewModelMain.HistoryColumns, incidCond);
if (historyTable == null)
{
throw new Exception("Error updating GIS layer.");
}
else if (historyTable.Rows.Count == 0)
{
throw new Exception("No GIS features to update.");
}
// likewise update DB shadow copy of GIS layer
if (_viewModelMain.DataBase.ExecuteNonQuery(String.Format("UPDATE {0} SET {1} = {3}, {2} = {4} WHERE {5}",
_viewModelMain.DataBase.QualifyTableName(_viewModelMain.HluDataset.incid_mm_polygons.TableName),
_viewModelMain.DataBase.QuoteIdentifier(
_viewModelMain.HluDataset.incid_mm_polygons.ihs_categoryColumn.ColumnName),
_viewModelMain.DataBase.QuoteIdentifier(
_viewModelMain.HluDataset.incid_mm_polygons.ihs_summaryColumn.ColumnName),
_viewModelMain.DataBase.QuoteValue(ihsHabitatCategory),
_viewModelMain.DataBase.QuoteValue(_viewModelMain.IncidIhsSummary),
_viewModelMain.DataBase.WhereClause(false, true, true, incidCond)),
_viewModelMain.DataBase.Connection.ConnectionTimeout, CommandType.Text) == -1)
{
throw new Exception("Failed to update database copy of GIS layer.");
}
// save history returned from GIS
Dictionary <int, string> fixedValues = new Dictionary <int, string>();
fixedValues.Add(_viewModelMain.HluDataset.history.incidColumn.Ordinal, _viewModelMain.Incid);
ViewModelWindowMainHistory vmHist = new ViewModelWindowMainHistory(_viewModelMain);
vmHist.HistoryWrite(fixedValues, historyTable, ViewModelWindowMain.Operations.AttributeUpdate);
_viewModelMain.DataBase.CommitTransaction();
_viewModelMain.HluDataset.AcceptChanges();
_viewModelMain.Saved = true;
_viewModelMain.IncidRowCount(true);
_viewModelMain.IncidCurrentRowIndex = incidCurrRowIx;
return(true);
}
catch (Exception ex)
{
_viewModelMain.DataBase.RollbackTransaction();
if (_viewModelMain.HaveGisApp)
{
_viewModelMain.Saved = false;
MessageBox.Show("Your changes could not be saved. The error message returned was:\n\n" +
ex.Message, "HLU: Save Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
else
{
return(true);
}
}
finally
{
_viewModelMain.SavingAttempted = true;
_viewModelMain.Saving = false;
_viewModelMain.ChangeCursor(Cursors.Arrow, null);
}
}
private void Export(int userExportId, bool exportDescriptions, bool selectedOnly)
{
string tempPath = null;
try
{
string tableAlias = GetTableAlias();
if (tableAlias == null)
{
throw new Exception("Failed to find a table alias that does not match a table name in the HLU dataset.");
}
// refresh export fields from DB
_viewModelMain.HluTableAdapterManager.exportsFieldsTableAdapter.ClearBeforeFill = true;
_viewModelMain.HluTableAdapterManager.exportsFieldsTableAdapter.Fill(
_viewModelMain.HluDataset.exports_fields, String.Format("{0} = {1} ORDER BY {2}, {3}",
_viewModelMain.DataBase.QuoteIdentifier(
_viewModelMain.HluDataset.exports_fields.export_idColumn.ColumnName), userExportId,
_viewModelMain.DataBase.QuoteIdentifier(
_viewModelMain.HluDataset.exports_fields.table_nameColumn.ColumnName),
_viewModelMain.DataBase.QuoteIdentifier(
_viewModelMain.HluDataset.exports_fields.field_ordinalColumn.ColumnName)));
if (_viewModelMain.HluDataset.exports_fields.Count == 0)
{
throw new Exception(String.Format("No export fields are defined for format '{0}'.",
_viewModelMain.HluDataset.exports.FindByexport_id(userExportId).export_name));
}
DataTable exportTable;
List <int> fieldCountList;
StringBuilder targetList;
StringBuilder fromClause;
int incidOrdinal;
ExportJoins(exportDescriptions, tableAlias, out exportTable,
out fieldCountList, out targetList, out fromClause, out incidOrdinal);
string whereClause = String.Empty;
List <List <SqlFilterCondition> > exportFilter = null;
if (!_viewModelExport.SelectedOnly)
{
SqlFilterCondition cond = new SqlFilterCondition("AND",
_viewModelMain.IncidTable, _viewModelMain.IncidTable.incidColumn, null);
cond.Operator = "IS NOT NULL";
exportFilter = new List <List <SqlFilterCondition> >(new List <SqlFilterCondition>[] {
new List <SqlFilterCondition>(new SqlFilterCondition[] { cond })
});
}
else
{
if ((_viewModelMain.IncidSelectionWhereClause == null) &&
(_viewModelMain.GisSelection != null) && (_viewModelMain.GisSelection.Rows.Count > 0))
{
_viewModelMain.IncidSelectionWhereClause = ViewModelWindowMainHelpers.GisSelectionToWhereClause(
_viewModelMain.GisSelection.Select(), _viewModelMain.GisIDColumnOrdinals,
ViewModelWindowMain.IncidPageSize, _viewModelMain.HluDataset.incid);
}
exportFilter = _viewModelMain.IncidSelectionWhereClause;
}
string sql = ScratchDb.UnionQuery(targetList.ToString(), fromClause.ToString(),
incidOrdinal, exportFilter, _viewModelMain.DataBase);
_viewModelMain.ChangeCursor(Cursors.Wait, "Exporting ...");
int exportRowCount;
tempPath = ExportMdb(sql, exportTable, incidOrdinal, fieldCountList, out exportRowCount);
if (!String.IsNullOrEmpty(tempPath) && (exportRowCount > 0))
{
_viewModelMain.GISApplication.Export(tempPath, exportTable.TableName, exportRowCount);
}
else
{
throw new Exception("Export query did not retrieve any rows");
}
_viewModelMain.IncidSelection = null;
_viewModelMain.GisSelection = null;
_viewModelMain.OnPropertyChanged("IsFiltered");
_viewModelMain.OnPropertyChanged("StatusIncid");
}
catch (Exception ex)
{
MessageBox.Show(String.Format("Export failed. The error message was:\n\n{0}.",
ex.Message), "HLU: Export", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
if (!String.IsNullOrEmpty(tempPath))
{
string[] tempFiles = Directory.GetFiles(Path.GetDirectoryName(tempPath),
Path.GetFileNameWithoutExtension(tempPath) + ".*");
foreach (string fName in tempFiles)
{
try { File.Delete(fName); }
catch { _viewModelMain.ExportMdbs.Add(fName); }
}
}
_viewModelMain.ChangeCursor(Cursors.Arrow, null);
}
}