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