public FdpMarketMapping FdpMarketMappingDelete(FdpMarketMapping mapping)
{
FdpMarketMapping retVal = new EmptyFdpMarketMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpMarketMappingId", mapping.FdpMarketMappingId, DbType.String);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query <FdpMarketMapping>("dbo.Fdp_MarketMapping_Delete", para, commandType: CommandType.StoredProcedure);
if (!results.Any())
{
return(retVal);
}
retVal = results.First();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public async Task <ActionResult> MapMissingMarket(ImportExceptionParameters parameters)
{
var filter = ImportQueueFilter.FromExceptionId(parameters.ExceptionId.Value);
var importView = await GetModelFromParameters(parameters);
var marketMapping = new FdpMarketMapping()
{
ImportMarket = parameters.ImportMarket,
MarketId = parameters.MarketId,
ProgrammeId = parameters.ProgrammeId,
Gateway = parameters.Gateway,
IsGlobalMapping = parameters.IsGlobalMapping
};
importView.CurrentException = await DataContext.Import.MapMarket(filter, marketMapping);
await DeactivateException(importView.CurrentException);
await ReProcessException(importView.CurrentException);
return(Json(JsonActionResult.GetSuccess(), JsonRequestBehavior.AllowGet));
}
public FdpMarketMapping FdpMarketMappingSave(FdpMarketMapping mapping)
{
FdpMarketMapping retVal = new EmptyFdpMarketMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@ImportMarket", mapping.ImportMarket, DbType.String);
para.Add("@MappedMarketId", mapping.MarketId, DbType.Int32);
if (!mapping.IsGlobalMapping)
{
para.Add("@ProgrammeId", mapping.ProgrammeId, DbType.Int32);
para.Add("@Gateway", mapping.Gateway, DbType.String);
}
para.Add("@IsGlobalMapping", mapping.IsGlobalMapping, DbType.Boolean);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query <FdpMarketMapping>("dbo.Fdp_MarketMapping_Save", para, commandType: CommandType.StoredProcedure);
if (!results.Any())
{
return(retVal);
}
retVal = results.First();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public async Task <ActionResult> CopyAll(MarketMappingParameters parameters)
{
var derivativeMappingView = await GetModelFromParameters(parameters);
if (derivativeMappingView.MarketMapping is EmptyFdpMarketMapping)
{
return(JsonGetFailure("MarketMapping does not exist"));
}
derivativeMappingView.MarketMapping = await DataContext.Market.CopyFdpMarketMappingsToGateway(FdpMarketMapping.FromParameters(parameters), parameters.CopyToGateways);
if (derivativeMappingView.MarketMapping is EmptyFdpMarketMapping)
{
return(JsonGetFailure(string.Format("MarketMappings could not be copied", derivativeMappingView.MarketMapping.ImportMarket)));
}
return(JsonGetSuccess());
}
public async Task <ActionResult> Delete(MarketMappingParameters parameters)
{
var derivativeMappingView = await GetModelFromParameters(parameters);
if (derivativeMappingView.MarketMapping is EmptyFdpMarketMapping)
{
return(JsonGetFailure("MarketMapping does not exist"));
}
derivativeMappingView.MarketMapping = await DataContext.Market.DeleteFdpMarketMapping(FdpMarketMapping.FromParameters(parameters));
if (derivativeMappingView.MarketMapping is EmptyFdpMarketMapping)
{
return(JsonGetFailure(string.Format("MarketMapping '{0}' could not be deleted", derivativeMappingView.MarketMapping.ImportMarket)));
}
return(JsonGetSuccess());
}
public Task <FdpMarketMapping> CopyFdpMarketMappingsToGateway(FdpMarketMapping fdpMarketMapping, IEnumerable <string> enumerable)
{
throw new NotImplementedException();
}
public async Task <FdpMarketMapping> DeleteFdpMarketMapping(FdpMarketMapping marketMappingToDelete)
{
return(await Task.FromResult <FdpMarketMapping>(_marketDataStore.FdpMarketMappingDelete(marketMappingToDelete)));
}
public async Task <ImportError> MapMarket(ImportQueueFilter filter, FdpMarketMapping mapping)
{
var task = await Task.FromResult(_marketDataStore.FdpMarketMappingSave(mapping));
return(await Task.FromResult(_importDataStore.ImportErrorGet(filter)));
}
