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; }