public bool Create(UserRoleRelationship model)
{
try
{
//Initialization empty item
var item = new UserRoleRelationship();
//Set value for item with value from model
item.Id = model.Id;
item.UserId = model.UserId;
item.RoleId = model.RoleId;
item.CreatedBy = model.CreatedBy;
item.CreatedTime = model.CreatedTime;
item.ModifiedBy = model.ModifiedBy;
item.ModifiedTime = model.ModifiedTime;
item.IsDeleted = model.IsDeleted;
item.DeletedBy = model.DeletedBy;
item.DeletedTime = model.DeletedTime;
//Add item to entity
context.UserRoleRelationships.Add(item);
//Save to database
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Update(UserRoleRelationship model)
{
try
{
//Get item UserRoleRelationship with Id from database
var item = context.UserRoleRelationships.Where(i => i.Id == model.Id).FirstOrDefault();
//Set value item with value from model
item.Id = model.Id;
item.UserId = model.UserId;
item.RoleId = model.RoleId;
item.CreatedBy = model.CreatedBy;
item.CreatedTime = model.CreatedTime;
item.ModifiedBy = model.ModifiedBy;
item.ModifiedTime = model.ModifiedTime;
item.IsDeleted = model.IsDeleted;
item.DeletedBy = model.DeletedBy;
item.DeletedTime = model.DeletedTime;
//Save change to database
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public async Task <IEnumerable <Role> > GetUserRoles(Guid userId)
{
var user = new User
{
AzureId = userId
};
var userRoleRelationship = new UserRoleRelationship("user", "role");
var cypherFluentQuery = new CypherFluentQuery(_graphClientFunc)
.MatchEntity(user)
.MatchRelationship(userRoleRelationship)
.Return(role => role.As <Role>());
var result = await cypherFluentQuery.ResultsAsync;
return(result);
}
public async Task AddUserRole(Guid userId, RoleType roleType)
{
var user = new User
{
AzureId = userId
};
var role = new Role
{
RoleType = roleType
};
var userRoleRelationship = new UserRoleRelationship("user", "role");
var query = new CypherFluentQuery(_graphClientFunc)
.MatchEntity(user)
.MergeEntity(role)
.CreateRelationship(userRoleRelationship);
await _repositoryPolicy.ExecuteAsync(async() => await query.ExecuteWithoutResultsAsync());
}
