public FdpMarketMapping FdpMarketMappingGet(MarketMappingFilter filter)
{
FdpMarketMapping retVal = new EmptyFdpMarketMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpMarketMappingId", filter.MarketMappingId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query <FdpMarketMapping>("Fdp_MarketMapping_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
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);
}
private void InitialiseMembers()
{
MarketMapping = new EmptyFdpMarketMapping();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty <Programme>();
Gateways = Enumerable.Empty <Gateway>();
CarLines = Enumerable.Empty <CarLine>();
ModelYears = Enumerable.Empty <ModelYear>();
CurrentAction = MarketMappingAction.NotSet;
}
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);
}
private void InitialiseMembers()
{
MarketMapping = new EmptyFdpMarketMapping();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty<Programme>();
Gateways = Enumerable.Empty<Gateway>();
CarLines = Enumerable.Empty<CarLine>();
ModelYears = Enumerable.Empty<ModelYear>();
CurrentAction = MarketMappingAction.NotSet;
}
public FdpMarketMapping FdpMarketMappingGet(MarketMappingFilter filter)
{
FdpMarketMapping retVal = new EmptyFdpMarketMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpMarketMappingId", filter.MarketMappingId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query<FdpMarketMapping>("Fdp_MarketMapping_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
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 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;
}
