public List <SqlParameter> MapParamsForDelete(UserClaimData entity)
{
var sql_params = new List <SqlParameter>();
sql_params.Add(new SqlParameter("@ClaimId", entity.Id));
return(sql_params);
}
public List <SqlParameter> MapParamsForUpsert(UserClaimData entity)
{
var sql_params = new List <SqlParameter>();
sql_params.Add(new SqlParameter("@ClaimId", entity.Id));
sql_params.Add(new SqlParameter("@UserId", entity.UserID));
sql_params.Add(new SqlParameter("@ClaimType", entity.ClaimType));
sql_params.Add(new SqlParameter("@ClaimValue", entity.ClaimValue));
sql_params.Add(GetIdentityOutParam());
return(sql_params);
}
public IEnumerable <UserData> GetAllForClaim(UserClaimData claim)
{
var pcol = new List <SqlParameter>()
{
new SqlParameter("@ClaimType", claim.ClaimType),
new SqlParameter("@ClaimValue", claim.ClaimValue)
};
using (entity_context)
{
return(MapRows(entity_context.ExecuteProcedureAsSqlDataReader("usp_user_all_for_claim", pcol)));
}
}
public int RemoveClaims(User user, IEnumerable <UserClaim> claims)
{
IUserClaimRepository uc_repo = _data_repository_factory.GetIdentityDataRepository <IUserClaimRepository>();
foreach (var uc in claims)
{
UserClaimData ucd = new UserClaimData()
{
UserID = user.UserId, Id = uc.ClaimID, ClaimType = uc.ClaimType, ClaimValue = uc.ClaimValue
};
uc_repo.Delete(ucd);
}
return(1);
}
public int ReplaceClaim(User user, UserClaim claim, UserClaim newClaim)
{
IUserClaimRepository uc_repo = _data_repository_factory.GetIdentityDataRepository <IUserClaimRepository>();
UserClaimData rem_ucd = new UserClaimData()
{
UserID = user.UserId, Id = claim.ClaimID,
ClaimType = claim.ClaimType, ClaimValue = claim.ClaimValue
};
uc_repo.Delete(rem_ucd);
UserClaimData new_ucd = new UserClaimData()
{
UserID = user.UserId, Id = newClaim.ClaimID,
ClaimType = newClaim.ClaimType, ClaimValue = newClaim.ClaimValue
};
return(uc_repo.Save(new_ucd));
}
