public EmptyTakeRateDocument()
{
UnderlyingOxoDocument = new EmptyOxoDocument();
Vehicle = new EmptyVehicle();
Market = new EmptyMarket();
MarketGroup = new EmptyMarketGroup();
}
public EmptyTakeRateDocument()
{
UnderlyingOxoDocument = new EmptyOxoDocument();
Vehicle = new EmptyVehicle();
Market = new EmptyMarket();
MarketGroup = new EmptyMarketGroup();
}
private void InitialiseMembers()
{
CurrentImport = new EmptyImportQueue();
CurrentException = new EmptyImportError();
CurrentAction = enums.ImportAction.NotSet;
CurrentFeatureGroup = string.Empty;
CurrentFeatureSubGroup = new EmptyFeatureGroup();
CurrentFeature = new EmptyFeature();
CurrentMarket = new EmptyMarket();
AvailableDocuments = Enumerable.Empty <OXODoc>();
AvailableEngines = Enumerable.Empty <ModelEngine>();
AvailableTransmissions = Enumerable.Empty <ModelTransmission>();
AvailableBodies = Enumerable.Empty <ModelBody>();
AvailableTrim = Enumerable.Empty <OxoTrim>();
AvailableSpecialFeatures = Enumerable.Empty <SpecialFeature>();
AvailableMarkets = Enumerable.Empty <Market>();
AvailableFeatures = Enumerable.Empty <FdpFeature>();
AvailableFeatureGroups = Enumerable.Empty <FeatureGroup>();
AvailableDerivatives = Enumerable.Empty <Derivative>();
AvailableImportDerivatives = Enumerable.Empty <ImportDerivative>();
AvailableImportTrimLevels = Enumerable.Empty <ImportTrim>();
AvailableExceptionTypes = Enumerable.Empty <ImportExceptionType>();
AvailableImportStatuses = Enumerable.Empty <ImportStatus>();
AvailableTrimLevels = Enumerable.Empty <TrimLevel>();
IdentifierPrefix = "Page";
}
public Market TopMarketDelete(Market marketToDelete)
{
Market retVal = new EmptyMarket();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@MarketId", marketToDelete.Id, DbType.Int32);
para.Add("@CdsId", CurrentCDSID, DbType.String);
retVal = conn.Query <Market>("dbo.Fdp_TopMarket_Delete", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (SqlException sx)
{
Log.Error(sx);
throw;
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public TakeRateDocument()
{
UnderlyingOxoDocument = new EmptyOxoDocument();
MarketGroup = new EmptyMarketGroup();
Market = new EmptyMarket();
Vehicle = new EmptyVehicle();
TakeRateData = new EmptyTakeRateData();
Mode = TakeRateResultMode.PercentageTakeRate;
TakeRateSummary = new List <TakeRateSummary>();
}
public TakeRateDocument()
{
UnderlyingOxoDocument = new EmptyOxoDocument();
MarketGroup = new EmptyMarketGroup();
Market = new EmptyMarket();
Vehicle = new EmptyVehicle();
TakeRateData = new EmptyTakeRateData();
Mode = TakeRateResultMode.PercentageTakeRate;
TakeRateSummary = new List<TakeRateSummary>();
}
public Market MarketGet(int id)
{
Market retVal = new EmptyMarket();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@p_Id", id, DbType.Int32);
var results = conn.Query <Market>("dbo.OXO_Market_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
private void InitialiseMembers()
{
CurrentImport = new EmptyImportQueue();
CurrentException = new EmptyImportError();
CurrentAction = enums.ImportAction.NotSet;
CurrentFeatureGroup = string.Empty;
CurrentFeatureSubGroup = new EmptyFeatureGroup();
CurrentFeature = new EmptyFeature();
CurrentMarket = new EmptyMarket();
AvailableDocuments = Enumerable.Empty<OXODoc>();
AvailableEngines = Enumerable.Empty<ModelEngine>();
AvailableTransmissions = Enumerable.Empty<ModelTransmission>();
AvailableBodies = Enumerable.Empty<ModelBody>();
AvailableTrim = Enumerable.Empty<OxoTrim>();
AvailableSpecialFeatures = Enumerable.Empty<SpecialFeature>();
AvailableMarkets = Enumerable.Empty<Market>();
AvailableFeatures = Enumerable.Empty<FdpFeature>();
AvailableFeatureGroups = Enumerable.Empty<FeatureGroup>();
AvailableDerivatives = Enumerable.Empty<Derivative>();
AvailableImportDerivatives = Enumerable.Empty<ImportDerivative>();
AvailableImportTrimLevels = Enumerable.Empty<ImportTrim>();
AvailableExceptionTypes = Enumerable.Empty<ImportExceptionType>();
AvailableImportStatuses = Enumerable.Empty<ImportStatus>();
AvailableTrimLevels = Enumerable.Empty<TrimLevel>();
IdentifierPrefix = "Page";
}
public MarketMapping()
{
MappedMarket = new EmptyMarket();
IsGlobalMapping = false;
IsActive = true;
}
public Market TopMarketDelete(Market marketToDelete)
{
Market retVal = new EmptyMarket();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@MarketId", marketToDelete.Id, DbType.Int32);
para.Add("@CdsId", CurrentCDSID, DbType.String);
retVal = conn.Query<Market>("dbo.Fdp_TopMarket_Delete", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (SqlException sx)
{
Log.Error(sx);
throw;
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public Market MarketGet(int id)
{
Market retVal = new EmptyMarket();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@p_Id", id, DbType.Int32);
var results = conn.Query<Market>("dbo.OXO_Market_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public MarketMapping()
{
MappedMarket = new EmptyMarket();
IsGlobalMapping = false;
IsActive = true;
}