public Task SignAgreement(SignEmployerAgreement agreement)
{
var parameters = new DynamicParameters();
parameters.Add("@agreementId", agreement.AgreementId, DbType.Int64);
parameters.Add("@signedById", agreement.SignedById, DbType.Int64);
parameters.Add("@signedByName", agreement.SignedByName, DbType.String);
parameters.Add("@signedDate", agreement.SignedDate, DbType.DateTime);
return(_db.Value.Database.Connection.ExecuteAsync(
sql: "[employer_account].[SignEmployerAgreement]",
param: parameters,
transaction: _db.Value.Database.CurrentTransaction.UnderlyingTransaction,
commandType: CommandType.StoredProcedure));
}
public async Task SignAgreement(SignEmployerAgreement agreement)
{
await WithConnection(async c =>
{
var parameters = new DynamicParameters();
parameters.Add("@agreementId", agreement.AgreementId, DbType.Int64);
parameters.Add("@signedById", agreement.SignedById, DbType.Int64);
parameters.Add("@signedByName", agreement.SignedByName, DbType.String);
parameters.Add("@signedDate", agreement.SignedDate, DbType.DateTime);
var result = await c.ExecuteAsync(
sql: "[employer_account].[SignEmployerAgreement]",
param: parameters,
commandType: CommandType.StoredProcedure);
return result;
});
}
