public FdpFeatureMapping FdpFeatureMappingCopy(FdpFeatureMapping featureMappingToCopy, int targetDocumentId)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpFeatureMappingId", featureMappingToCopy.FdpFeatureMappingId, DbType.Int32);
para.Add("@TargetDocumentId", targetDocumentId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var rows = conn.Execute("Fdp_FeatureMapping_Copy", para, commandType: CommandType.StoredProcedure);
retVal = FdpFeatureMappingGet(new FeatureMappingFilter {
FeatureMappingId = featureMappingToCopy.FdpFeatureMappingId
});
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpFeatureMapping FeatureMappingSave(FdpFeatureMapping featureMapping)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ImportFeatureCode", featureMapping.ImportFeatureCode, DbType.String);
para.Add("@DocumentId", featureMapping.DocumentId, DbType.Int32);
para.Add("@FeatureId", featureMapping.FeatureId, DbType.Int32);
para.Add("@FeaturePackId", featureMapping.FeaturePackId, DbType.Int32);
var results = conn.Query <FdpFeatureMapping>("Fdp_FeatureMapping_Save", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpFeatureMapping FdpFeatureMappingDelete(FdpFeatureMapping featureMappingToDelete)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpFeatureMappingId", featureMappingToDelete.FdpFeatureMappingId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query <FdpFeatureMapping>("Fdp_FeatureMapping_Delete", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public async Task <ActionResult> MapOxoFeature(ImportExceptionParameters parameters)
{
var filter = ImportQueueFilter.FromExceptionId(parameters.ExceptionId.GetValueOrDefault());
var feature = FdpFeature.FromIdentifier(parameters.FeatureIdentifier);
var importView = await GetModelFromParameters(parameters);
var importFeatures = (IEnumerable <string>)TempData["MapOxoFeature"];
foreach (var importFeature in importFeatures)
{
var featureMapping = new FdpFeatureMapping()
{
ImportFeatureCode = importFeature,
DocumentId = parameters.DocumentId.GetValueOrDefault(),
ProgrammeId = parameters.ProgrammeId.GetValueOrDefault(),
Gateway = parameters.Gateway,
FeatureCode = feature.FeatureCode
};
if (feature.FeaturePackId.HasValue)
{
featureMapping.FeaturePackId = feature.FeaturePackId;
}
else
{
featureMapping.FeatureId = feature.FeatureId;
}
await DataContext.Import.MapFeature(filter, featureMapping);
}
await DeactivateException(importView.CurrentException);
await ReProcessException(importView.CurrentException);
return(Json(JsonActionResult.GetSuccess(), JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> MapMissingFeature(ImportExceptionParameters parameters)
{
var filter = ImportQueueFilter.FromExceptionId(parameters.ExceptionId.Value);
var importView = await GetModelFromParameters(parameters);
var feature = importView.AvailableFeatures
.First(f => f.FeatureCode.Equals(parameters.FeatureCode, StringComparison.InvariantCultureIgnoreCase));
var featureMapping = new FdpFeatureMapping()
{
ImportFeatureCode = parameters.ImportFeatureCode,
ProgrammeId = parameters.ProgrammeId.GetValueOrDefault(),
Gateway = parameters.Gateway,
FeatureId = feature.FeatureId,
FeaturePackId = feature.FeaturePackId
};
importView.CurrentException = await DataContext.Import.MapFeature(filter, featureMapping);
await DeactivateException(importView.CurrentException);
await ReProcessException(importView.CurrentException);
return(Json(JsonActionResult.GetSuccess(), JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> Copy(FeatureMappingParameters parameters)
{
parameters.CopyToGateways = (IEnumerable <string>)TempData["CopyToGateways"];
var derivativeMappingView = await GetModelFromParameters(parameters);
if (derivativeMappingView.FeatureMapping is EmptyFdpFeatureMapping)
{
return(JsonGetFailure("FeatureMapping does not exist"));
}
derivativeMappingView.FeatureMapping = await DataContext.Vehicle.CopyFdpFeatureMappingToDocument(FdpFeatureMapping.FromParameters(parameters), parameters.TargetDocumentId.GetValueOrDefault());
if (derivativeMappingView.FeatureMapping is EmptyFdpFeatureMapping)
{
return(JsonGetFailure(string.Format("FeatureMapping '{0}' could not be copied", derivativeMappingView.FeatureMapping.ImportFeatureCode)));
}
return(JsonGetSuccess());
}
public async Task <ActionResult> Delete(FeatureMappingParameters parameters)
{
var derivativeMappingView = await GetModelFromParameters(parameters);
if (derivativeMappingView.FeatureMapping is EmptyFdpFeatureMapping)
{
return(JsonGetFailure("FeatureMapping does not exist"));
}
derivativeMappingView.FeatureMapping = await DataContext.Vehicle.DeleteFdpFeatureMapping(FdpFeatureMapping.FromParameters(parameters));
if (derivativeMappingView.FeatureMapping is EmptyFdpFeatureMapping)
{
return(JsonGetFailure(string.Format("FeatureMapping '{0}' could not be deleted", derivativeMappingView.FeatureMapping.ImportFeatureCode)));
}
return(JsonGetSuccess());
}
public async Task <FdpFeatureMapping> CopyFdpFeatureMappingToDocument(FdpFeatureMapping fdpFeatureMapping, int targetDocumentId)
{
return(await Task.FromResult(_featureDataStore.FdpFeatureMappingCopy(fdpFeatureMapping, targetDocumentId)));
}
public async Task <FdpFeatureMapping> DeleteFdpFeatureMapping(FdpFeatureMapping featureMappingToDelete)
{
return(await Task.FromResult(_featureDataStore.FdpFeatureMappingDelete(featureMappingToDelete)));
}
public async Task <ImportError> MapFeature(ImportQueueFilter filter, FdpFeatureMapping featureMapping)
{
var task = await Task.FromResult(_featureDataStore.FeatureMappingSave(featureMapping));
return(await Task.FromResult(_importDataStore.ImportErrorGet(filter)));
}
