public FdpFeatureMapping FdpFeatureMappingCopy(FdpFeatureMapping featureMappingToCopy, int targetDocumentId)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpFeatureMappingId", featureMappingToCopy.FdpFeatureMappingId, DbType.Int32);
para.Add("@TargetDocumentId", targetDocumentId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var rows = conn.Execute("Fdp_FeatureMapping_Copy", para, commandType: CommandType.StoredProcedure);
retVal = FdpFeatureMappingGet(new FeatureMappingFilter {
FeatureMappingId = featureMappingToCopy.FdpFeatureMappingId
});
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpFeatureMapping FdpFeatureMappingDelete(FdpFeatureMapping featureMappingToDelete)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpFeatureMappingId", featureMappingToDelete.FdpFeatureMappingId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query <FdpFeatureMapping>("Fdp_FeatureMapping_Delete", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpFeatureMapping FdpFeatureMappingGet(FeatureMappingFilter filter)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpFeatureMappingId", filter.FeatureMappingId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query <FdpFeatureMapping>("Fdp_FeatureMapping_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpFeatureMapping FeatureMappingSave(FdpFeatureMapping featureMapping)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ImportFeatureCode", featureMapping.ImportFeatureCode, DbType.String);
para.Add("@DocumentId", featureMapping.DocumentId, DbType.Int32);
para.Add("@FeatureId", featureMapping.FeatureId, DbType.Int32);
para.Add("@FeaturePackId", featureMapping.FeaturePackId, DbType.Int32);
var results = conn.Query <FdpFeatureMapping>("Fdp_FeatureMapping_Save", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
private void InitialiseMembers()
{
FeatureMapping = new EmptyFdpFeatureMapping();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty <Programme>();
Gateways = Enumerable.Empty <Gateway>();
CarLines = Enumerable.Empty <CarLine>();
ModelYears = Enumerable.Empty <ModelYear>();
CurrentAction = FeatureMappingAction.NotSet;
}
private void InitialiseMembers()
{
FeatureMapping = new EmptyFdpFeatureMapping();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty<Programme>();
Gateways = Enumerable.Empty<Gateway>();
CarLines = Enumerable.Empty<CarLine>();
ModelYears = Enumerable.Empty<ModelYear>();
CurrentAction = FeatureMappingAction.NotSet;
}
public FdpFeatureMapping FdpFeatureMappingCopy(FdpFeatureMapping featureMappingToCopy, int targetDocumentId)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpFeatureMappingId", featureMappingToCopy.FdpFeatureMappingId, DbType.Int32);
para.Add("@TargetDocumentId", targetDocumentId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var rows = conn.Execute("Fdp_FeatureMapping_Copy", para, commandType: CommandType.StoredProcedure);
retVal = FdpFeatureMappingGet(new FeatureMappingFilter { FeatureMappingId = featureMappingToCopy.FdpFeatureMappingId });
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpFeatureMapping FdpFeatureMappingGet(FeatureMappingFilter filter)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpFeatureMappingId", filter.FeatureMappingId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query<FdpFeatureMapping>("Fdp_FeatureMapping_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpFeatureMapping FdpFeatureMappingDelete(FdpFeatureMapping featureMappingToDelete)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpFeatureMappingId", featureMappingToDelete.FdpFeatureMappingId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query<FdpFeatureMapping>("Fdp_FeatureMapping_Delete", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpFeatureMapping FeatureMappingSave(FdpFeatureMapping featureMapping)
{
FdpFeatureMapping retVal = new EmptyFdpFeatureMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ImportFeatureCode", featureMapping.ImportFeatureCode, DbType.String);
para.Add("@DocumentId", featureMapping.DocumentId, DbType.Int32);
para.Add("@FeatureId", featureMapping.FeatureId, DbType.Int32);
para.Add("@FeaturePackId", featureMapping.FeaturePackId, DbType.Int32);
var results = conn.Query<FdpFeatureMapping>("Fdp_FeatureMapping_Save", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
