public FdpTrimMapping FdpTrimMappingGet(TrimMappingFilter filter)
{
FdpTrimMapping retVal = new EmptyFdpTrimMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpTrimMappingId", filter.TrimMappingId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query <FdpTrimMapping>("Fdp_TrimMapping_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpTrimMapping FdpTrimMappingCopy(FdpTrimMapping trimMappingToCopy, IEnumerable <string> gateways)
{
FdpTrimMapping retVal = new EmptyFdpTrimMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpTrimMappingId", trimMappingToCopy.FdpTrimMappingId, DbType.Int32);
para.Add("@Gateways", gateways.ToCommaSeperatedList(), DbType.String);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var rows = conn.Execute("Fdp_TrimMapping_Copy", para, commandType: CommandType.StoredProcedure);
retVal = FdpTrimMappingGet(new TrimMappingFilter {
TrimMappingId = trimMappingToCopy.FdpTrimMappingId
});
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpTrimMapping FdpTrimMappingDelete(FdpTrimMapping trimMappingToDelete)
{
FdpTrimMapping retVal = new EmptyFdpTrimMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpTrimMappingId", trimMappingToDelete.FdpTrimMappingId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query <FdpTrimMapping>("Fdp_TrimMapping_Delete", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
private void InitialiseMembers()
{
TrimMapping = new EmptyFdpTrimMapping();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty <Programme>();
Gateways = Enumerable.Empty <Gateway>();
CarLines = Enumerable.Empty <CarLine>();
ModelYears = Enumerable.Empty <ModelYear>();
CurrentAction = TrimMappingAction.NotSet;
}
public FdpTrimMapping TrimMappingSave(FdpTrimMapping trimMapping)
{
FdpTrimMapping retVal = new EmptyFdpTrimMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ImportTrim", trimMapping.ImportTrim, DbType.String);
para.Add("@DocumentId", trimMapping.DocumentId, DbType.Int32);
para.Add("@ProgrammeId", trimMapping.ProgrammeId, DbType.Int32);
para.Add("@Gateway", trimMapping.Gateway, DbType.String);
if (trimMapping.TrimId.HasValue)
{
para.Add("@TrimId", trimMapping.TrimId.Value, DbType.Int32);
}
if (trimMapping.FdpTrimId.HasValue)
{
para.Add("@FdpTrimId", trimMapping.FdpTrimId, DbType.Int32);
}
var results = conn.Query <FdpTrimMapping>("Fdp_TrimMapping_Save", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
private void InitialiseMembers()
{
TrimMapping = new EmptyFdpTrimMapping();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty<Programme>();
Gateways = Enumerable.Empty<Gateway>();
CarLines = Enumerable.Empty<CarLine>();
ModelYears = Enumerable.Empty<ModelYear>();
CurrentAction = TrimMappingAction.NotSet;
}
public FdpTrimMapping FdpTrimMappingCopy(FdpTrimMapping trimMappingToCopy, IEnumerable<string> gateways)
{
FdpTrimMapping retVal = new EmptyFdpTrimMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpTrimMappingId", trimMappingToCopy.FdpTrimMappingId, DbType.Int32);
para.Add("@Gateways", gateways.ToCommaSeperatedList(), DbType.String);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var rows = conn.Execute("Fdp_TrimMapping_Copy", para, commandType: CommandType.StoredProcedure);
retVal = FdpTrimMappingGet(new TrimMappingFilter { TrimMappingId = trimMappingToCopy.FdpTrimMappingId });
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpTrimMapping FdpTrimMappingGet(TrimMappingFilter filter)
{
FdpTrimMapping retVal = new EmptyFdpTrimMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpTrimMappingId", filter.TrimMappingId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query<FdpTrimMapping>("Fdp_TrimMapping_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpTrimMapping FdpTrimMappingDelete(FdpTrimMapping trimMappingToDelete)
{
FdpTrimMapping retVal = new EmptyFdpTrimMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpTrimMappingId", trimMappingToDelete.FdpTrimMappingId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query<FdpTrimMapping>("Fdp_TrimMapping_Delete", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpTrimMapping TrimMappingSave(FdpTrimMapping trimMapping)
{
FdpTrimMapping retVal = new EmptyFdpTrimMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ImportTrim", trimMapping.ImportTrim, DbType.String);
para.Add("@DocumentId", trimMapping.DocumentId, DbType.Int32);
para.Add("@ProgrammeId", trimMapping.ProgrammeId, DbType.Int32);
para.Add("@Gateway", trimMapping.Gateway, DbType.String);
if (trimMapping.TrimId.HasValue)
{
para.Add("@TrimId", trimMapping.TrimId.Value, DbType.Int32);
}
if (trimMapping.FdpTrimId.HasValue)
{
para.Add("@FdpTrimId", trimMapping.FdpTrimId, DbType.Int32);
}
var results = conn.Query<FdpTrimMapping>("Fdp_TrimMapping_Save", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
