public async Task<OxoDerivative> UpdateBrochureModelCode(OxoDerivative derivative) { return await Task.FromResult(_derivativeDataStore.BrochureModelCodeUpdate(derivative)); }
public OxoDerivative BrochureModelCodeUpdate(OxoDerivative derivative) { using (var conn = DbHelper.GetDBConnection()) { try { var para = DynamicParameters.FromCDSId(CurrentCDSID); para.Add("@DocumentId", derivative.DocumentId, DbType.Int32); para.Add("@BodyId", derivative.BodyId, DbType.String); para.Add("@EngineId", derivative.EngineId, DbType.Int32); para.Add("@TransmissionId", derivative.TransmissionId, DbType.Int32); para.Add("@DerivativeCode", derivative.DerivativeCode, DbType.String); var results = conn.Query<OxoDerivative>("Fdp_BrochureModelCode_Update", para, commandType: CommandType.StoredProcedure); var derivatives = results as IList<OxoDerivative> ?? results.ToList(); if (results != null && derivatives.Any()) { derivative = derivatives.First(); } } catch (Exception ex) { Log.Error(ex); throw; } } return derivative; }