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 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); }
public async Task <ActionResult> AddMissingDerivative(ImportExceptionParameters parameters) { var filter = ImportQueueFilter.FromExceptionId(parameters.ExceptionId.Value); var importView = await GetModelFromParameters(parameters); var derivative = new FdpDerivative() { ProgrammeId = parameters.ProgrammeId.GetValueOrDefault(), Gateway = parameters.Gateway, DerivativeCode = parameters.DerivativeCode, BodyId = parameters.BodyId.GetValueOrDefault(), EngineId = parameters.EngineId.GetValueOrDefault(), TransmissionId = parameters.TransmissionId.GetValueOrDefault() }; importView.CurrentException = await DataContext.Import.AddDerivative(filter, derivative); await DeactivateException(importView.CurrentException); await ReProcessException(importView.CurrentException); return(Json(JsonActionResult.GetSuccess(), JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> Delete(DerivativeParameters parameters) { var derivativeView = await GetModelFromParameters(parameters); if (derivativeView.Derivative is EmptyFdpDerivative) { return(JsonGetFailure(string.Format("Derivative does not exist", parameters.DerivativeId))); } derivativeView.Derivative = await DataContext.Vehicle.DeleteFdpDerivative(FdpDerivative.FromParameters(parameters)); if (derivativeView.Derivative is EmptyFdpDerivative) { return(JsonGetFailure(string.Format("Derivative '{0}' could not be deleted", derivativeView.Derivative.DerivativeCode))); } return(JsonGetSuccess()); }
// Derivatives and mappings public async Task <FdpDerivative> DeleteFdpDerivative(FdpDerivative derivativeToDelete) { return(await Task.FromResult(_derivativeDataStore.FdpDerivativeDelete(derivativeToDelete))); }
public async Task <ImportError> AddDerivative(ImportQueueFilter filter, FdpDerivative derivativeToAdd) { var task = await Task.FromResult(_derivativeDataStore.FdpDerivativeSave(derivativeToAdd)); return(await Task.FromResult(_importDataStore.ImportErrorGet(filter))); }