public FdpDerivative FdpDerivativeSave(FdpDerivative derivative)
{
FdpDerivative retVal = new EmptyFdpDerivative();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ProgrammeId", derivative.ProgrammeId.GetValueOrDefault(), DbType.Int32);
para.Add("@Gateway", derivative.Gateway, DbType.String);
para.Add("@DerivativeCode", derivative.DerivativeCode, DbType.String);
para.Add("@BodyId", derivative.BodyId.GetValueOrDefault(), DbType.Int32);
para.Add("@EngineId", derivative.EngineId.GetValueOrDefault(), DbType.String);
para.Add("@TransmissionId", derivative.TransmissionId.GetValueOrDefault(), DbType.Int32);
retVal = conn.Query <FdpDerivative>("dbo.Fdp_Derivative_Save", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
private void InitialiseMembers()
{
Derivative = new EmptyFdpDerivative();
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 = DerivativeAction.NotSet;
OxoDerivatives = Enumerable.Empty <Derivative>();
}
public FdpDerivative FdpDerivativeGet(DerivativeFilter filter)
{
FdpDerivative retVal = new EmptyFdpDerivative();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpDerivativeId", filter.DerivativeId.GetValueOrDefault(), DbType.Int32);
retVal = conn.Query <FdpDerivative>("dbo.Fdp_Derivative_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public FdpDerivative FdpDerivativeDelete(FdpDerivative derivativeToDelete)
{
FdpDerivative retVal = new EmptyFdpDerivative();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@FdpDerivativeId", derivativeToDelete.FdpDerivativeId.GetValueOrDefault(), DbType.Int32);
retVal = conn.Query <FdpDerivative>("dbo.Fdp_Derivative_Delete", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
private void InitialiseMembers()
{
Derivative = new EmptyFdpDerivative();
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 = DerivativeAction.NotSet;
OxoDerivatives = Enumerable.Empty<Derivative>();
}
public FdpDerivative FdpDerivativeSave(FdpDerivative derivative)
{
FdpDerivative retVal = new EmptyFdpDerivative();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ProgrammeId", derivative.ProgrammeId.GetValueOrDefault(), DbType.Int32);
para.Add("@Gateway", derivative.Gateway, DbType.String);
para.Add("@DerivativeCode", derivative.DerivativeCode, DbType.String);
para.Add("@BodyId", derivative.BodyId.GetValueOrDefault(), DbType.Int32);
para.Add("@EngineId", derivative.EngineId.GetValueOrDefault(), DbType.String);
para.Add("@TransmissionId", derivative.TransmissionId.GetValueOrDefault(), DbType.Int32);
retVal = conn.Query<FdpDerivative>("dbo.Fdp_Derivative_Save", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpDerivative FdpDerivativeGet(DerivativeFilter filter)
{
FdpDerivative retVal = new EmptyFdpDerivative();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpDerivativeId", filter.DerivativeId.GetValueOrDefault(), DbType.Int32);
retVal = conn.Query<FdpDerivative>("dbo.Fdp_Derivative_Get", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public FdpDerivative FdpDerivativeDelete(FdpDerivative derivativeToDelete)
{
FdpDerivative retVal = new EmptyFdpDerivative();
using (IDbConnection conn = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@FdpDerivativeId", derivativeToDelete.FdpDerivativeId.GetValueOrDefault(), DbType.Int32);
retVal = conn.Query<FdpDerivative>("dbo.Fdp_Derivative_Delete", para, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
