public async Task <int> UpdateUserScopeClaim(UserScopeClaimModel model)
{
var storedProcedure = "dbo.UserScopeClaim_Update";
return(await _dataGateway.Execute(storedProcedure,
new
{
Id = model.Id,
userAccountId = model.UserAccountId,
userScopeId = model.UserScopeId,
userClaimId = model.UserClaimId,
role = model.Role
},
_connectionString.SqlConnectionString));
}
public async Task <int> CreateUserScopeClaim(UserScopeClaimModel model)
{
var storedProcedure = "dbo.UserScopeClaim_Create";
DynamicParameters p = new DynamicParameters();
p.Add("userAccountId", model.UserAccountId);
p.Add("userScopeId", model.UserScopeId);
p.Add("userClaimId", model.UserClaimId);
p.Add("role", model.Role);
p.Add("Id", DbType.Int32, direction: ParameterDirection.Output);
await _dataGateway.Execute(storedProcedure, p, _connectionString.SqlConnectionString);
return(p.Get <int>("Id"));
}
