public ListResponse <UserPermissionRow> List(IDbConnection connection, UserPermissionListRequest request)
{
Check.NotNull(request, "request");
Check.NotNull(request.UserID, "userID");
string prefix = "";
string module = request.Module.TrimToEmpty();
string submodule = request.Submodule.TrimToEmpty();
if (module.Length > 0)
{
prefix = module;
}
if (submodule.Length > 0)
{
prefix += ":" + submodule;
}
var response = new ListResponse <UserPermissionRow>();
response.Entities = GetExisting(connection, request.UserID.Value, request.Module, request.Submodule);
return(response);
}
public ListResponse <UserPermissionRow> List(IDbConnection connection, UserPermissionListRequest request)
{
if (request is null)
{
throw new ArgumentNullException("request");
}
if (request.UserID is null)
{
throw new ArgumentNullException("userID");
}
string prefix = "";
string module = request.Module.TrimToEmpty();
string submodule = request.Submodule.TrimToEmpty();
if (module.Length > 0)
{
prefix = module;
}
if (submodule.Length > 0)
{
prefix += ":" + submodule;
}
var response = new ListResponse <UserPermissionRow>();
response.Entities = GetExisting(connection, request.UserID.Value, request.Module, request.Submodule);
return(response);
}
public ListResponse <string> ListRolePermissions(IDbConnection connection, UserPermissionListRequest request)
{
if (request is null)
{
throw new ArgumentNullException("request");
}
if (request.UserID is null)
{
throw new ArgumentNullException("userID");
}
string prefix = "";
var module = request.Module.TrimToEmpty();
var submodule = request.Submodule.TrimToEmpty();
if (module.Length > 0)
{
prefix = module;
}
if (submodule.Length > 0)
{
prefix += ":" + submodule;
}
var rp = RolePermissionRow.Fields.As("rp");
var ur = UserRoleRow.Fields.As("ur");
var query = new SqlQuery()
.From(rp)
.Select(rp.PermissionKey)
.Distinct(true)
.OrderBy(rp.PermissionKey);
query.Where(rp.RoleId.In(
query.SubQuery()
.From(ur)
.Select(ur.RoleId)
.Where(ur.UserId == request.UserID.Value)
));
return(new ListResponse <string>
{
Entities = connection.Query <string>(query).ToList()
});
}
public ActionResult MyAction()
{
var fileRowResponse = this.InTransaction("Default", (uow) =>
{
//var saveFileResponse = new AisFileResultsRepository().Create(uow, new SaveRequest<AisFileResultsRow>
//{
// Entity = new AisFileResultsRow
// {
// FileId = 1,
// ReqId = 1,
// ReqType = 0
// }
//});
//var res1 = new GroupRepository().Create(uow, new SaveRequest<GroupRow>
//{
// Entity = new GroupRow
// {
// Name = "tanhn",
// Parent = "tanhn",
// Shortname = "tanhn",
// Priority = 1,
// Status = (statusvalue?)1
// }
//});
UserPermissionListRequest request = new UserPermissionListRequest();
request.UserID = 1;
var test = new UserPermissionRepository().List(uow.Connection, request);
var saveFileResponse = new TesttRepository().Create(uow, new SaveRequest <TesttRow>
{
Entity = new TesttRow
{
Name = "tanhn"
}
});
return(saveFileResponse);
});
Result <ActionResult> res;
res = new Result <ActionResult>(fileRowResponse);
return(res);
}
public ListResponse <string> ListRolePermissions(IDbConnection connection, UserPermissionListRequest request)
{
return(new MyRepository().ListRolePermissions(connection, request));
}
public ListResponse <MyRow> List(IDbConnection connection, UserPermissionListRequest request)
{
return(new MyRepository().List(connection, request));
}
public UserPermissionListResponse List(IDbConnection connection, UserPermissionListRequest request)
{
return new MyRepository().List(connection, request);
}
public ListResponse<string> ListRolePermissions(IDbConnection connection, UserPermissionListRequest request)
{
return new MyRepository().ListRolePermissions(connection, request);
}
