public FdpDerivativeMapping FdpDerivativeMappingGet(DerivativeMappingFilter filter)
{
FdpDerivativeMapping retVal = new EmptyFdpDerivativeMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpDerivativeMappingId", filter.DerivativeMappingId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query <FdpDerivativeMapping>("Fdp_DerivativeMapping_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpDerivativeMapping FdpDerivativeMappingCopy(FdpDerivativeMapping derivativeMappingToCopy, int toDocumentId)
{
FdpDerivativeMapping retVal = new EmptyFdpDerivativeMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpDerivativeMappingId", derivativeMappingToCopy.FdpDerivativeMappingId, DbType.Int32);
para.Add("@DocumentId", toDocumentId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var rows = conn.Execute("Fdp_DerivativeMapping_Copy", para, commandType: CommandType.StoredProcedure);
retVal = FdpDerivativeMappingGet(new DerivativeMappingFilter {
DerivativeMappingId = derivativeMappingToCopy.FdpDerivativeMappingId
});
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpDerivativeMapping FdpDerivativeMappingDelete(FdpDerivativeMapping derivativeMapping)
{
FdpDerivativeMapping retVal = new EmptyFdpDerivativeMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpDerivativeMappingId", derivativeMapping.FdpDerivativeMappingId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query <FdpDerivativeMapping>("Fdp_DerivativeMapping_Delete", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpDerivativeMapping FdpDerivativeMappingDelete(FdpDerivativeMapping derivativeMapping)
{
FdpDerivativeMapping retVal = new EmptyFdpDerivativeMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpDerivativeMappingId", derivativeMapping.FdpDerivativeMappingId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query<FdpDerivativeMapping>("Fdp_DerivativeMapping_Delete", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
private void InitialiseMembers()
{
DerivativeMapping = new EmptyFdpDerivativeMapping();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty <Programme>();
Bodies = Enumerable.Empty <ModelBody>();
Engines = Enumerable.Empty <ModelEngine>();
Transmissions = Enumerable.Empty <ModelTransmission>();
Gateways = Enumerable.Empty <Gateway>();
CarLines = Enumerable.Empty <CarLine>();
ModelYears = Enumerable.Empty <ModelYear>();
CurrentAction = DerivativeMappingAction.NotSet;
Documents = Enumerable.Empty <OXODoc>();
}
public FdpDerivativeMapping FdpDerivativeMappingSave(FdpDerivativeMapping derivativeMapping)
{
FdpDerivativeMapping retVal = new EmptyFdpDerivativeMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@ImportDerivativeCode", derivativeMapping.ImportDerivativeCode, DbType.String);
para.Add("@DocumentId", derivativeMapping.DocumentId, DbType.Int32);
//para.Add("@ProgrammeId", derivativeMapping.ProgrammeId, DbType.Int32);
//para.Add("@Gateway", derivativeMapping.Gateway, DbType.String);
if (!string.IsNullOrEmpty(derivativeMapping.DerivativeCode))
{
para.Add("@DerivativeCode", derivativeMapping.DerivativeCode, DbType.String);
}
para.Add("@BodyId", derivativeMapping.BodyId, DbType.Int32);
para.Add("@EngineId", derivativeMapping.EngineId, DbType.Int32);
para.Add("@TransmissionId", derivativeMapping.TransmissionId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query <FdpDerivativeMapping>("Fdp_DerivativeMapping_Save", para, commandType: CommandType.StoredProcedure);
var fdpDerivativeMappings = results as IList <FdpDerivativeMapping> ?? results.ToList();
if (fdpDerivativeMappings.Any())
{
retVal = fdpDerivativeMappings.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpDerivativeMapping FdpDerivativeMappingGet(DerivativeMappingFilter filter)
{
FdpDerivativeMapping retVal = new EmptyFdpDerivativeMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpDerivativeMappingId", filter.DerivativeMappingId.GetValueOrDefault(), DbType.Int32);
var results = conn.Query<FdpDerivativeMapping>("Fdp_DerivativeMapping_Get", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
private void InitialiseMembers()
{
DerivativeMapping = new EmptyFdpDerivativeMapping();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty<Programme>();
Bodies = Enumerable.Empty<ModelBody>();
Engines = Enumerable.Empty<ModelEngine>();
Transmissions = Enumerable.Empty<ModelTransmission>();
Gateways = Enumerable.Empty<Gateway>();
CarLines = Enumerable.Empty<CarLine>();
ModelYears = Enumerable.Empty<ModelYear>();
CurrentAction = DerivativeMappingAction.NotSet;
Documents = Enumerable.Empty<OXODoc>();
}
public FdpDerivativeMapping FdpDerivativeMappingCopy(FdpDerivativeMapping derivativeMappingToCopy, int toDocumentId)
{
FdpDerivativeMapping retVal = new EmptyFdpDerivativeMapping();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpDerivativeMappingId", derivativeMappingToCopy.FdpDerivativeMappingId, DbType.Int32);
para.Add("@DocumentId", toDocumentId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var rows = conn.Execute("Fdp_DerivativeMapping_Copy", para, commandType: CommandType.StoredProcedure);
retVal = FdpDerivativeMappingGet(new DerivativeMappingFilter { DerivativeMappingId = derivativeMappingToCopy.FdpDerivativeMappingId });
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpDerivativeMapping FdpDerivativeMappingSave(FdpDerivativeMapping derivativeMapping)
{
FdpDerivativeMapping retVal = new EmptyFdpDerivativeMapping();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@ImportDerivativeCode", derivativeMapping.ImportDerivativeCode, DbType.String);
para.Add("@DocumentId", derivativeMapping.DocumentId, DbType.Int32);
//para.Add("@ProgrammeId", derivativeMapping.ProgrammeId, DbType.Int32);
//para.Add("@Gateway", derivativeMapping.Gateway, DbType.String);
if (!string.IsNullOrEmpty(derivativeMapping.DerivativeCode))
{
para.Add("@DerivativeCode", derivativeMapping.DerivativeCode, DbType.String);
}
para.Add("@BodyId", derivativeMapping.BodyId, DbType.Int32);
para.Add("@EngineId", derivativeMapping.EngineId, DbType.Int32);
para.Add("@TransmissionId", derivativeMapping.TransmissionId, DbType.Int32);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = conn.Query<FdpDerivativeMapping>("Fdp_DerivativeMapping_Save", para, commandType: CommandType.StoredProcedure);
var fdpDerivativeMappings = results as IList<FdpDerivativeMapping> ?? results.ToList();
if (fdpDerivativeMappings.Any())
{
retVal = fdpDerivativeMappings.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}