public EmptyTakeRateDocument()
{
UnderlyingOxoDocument = new EmptyOxoDocument();
Vehicle = new EmptyVehicle();
Market = new EmptyMarket();
MarketGroup = new EmptyMarketGroup();
}
public MarketGroup FdpMarketGroupGet(TakeRateFilter filter)
{
MarketGroup retVal = new EmptyMarketGroup();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@MarketGroupId", filter.MarketGroupId, DbType.Int32);
para.Add("@FdpVolumeHeaderId", filter.TakeRateId, DbType.Int32);
using (var multi = conn.QueryMultiple("dbo.Fdp_MarketGroup_Get", para, commandType: CommandType.StoredProcedure))
{
retVal = multi.Read <MarketGroup>().FirstOrDefault();
var markets = multi.Read <Market>().ToList();
if (retVal != null)
{
retVal.Markets = markets.ToList();
}
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public EmptyTakeRateDocument()
{
UnderlyingOxoDocument = new EmptyOxoDocument();
Vehicle = new EmptyVehicle();
Market = new EmptyMarket();
MarketGroup = new EmptyMarketGroup();
}
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 MarketGroup FdpMarketGroupGet(TakeRateFilter filter)
{
MarketGroup retVal = new EmptyMarketGroup();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@MarketGroupId", filter.MarketGroupId, DbType.Int32);
para.Add("@FdpVolumeHeaderId", filter.TakeRateId, DbType.Int32);
using (var multi = conn.QueryMultiple("dbo.Fdp_MarketGroup_Get", para, commandType: CommandType.StoredProcedure))
{
retVal = multi.Read<MarketGroup>().FirstOrDefault();
var markets = multi.Read<Market>().ToList();
if (retVal != null)
retVal.Markets = markets.ToList();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
