public ApiResponse <List <Permission> > GetPermissions(GetPermissions req)
{
var result = null as List <Permission>;
using (var connection = new SqlConnection(_connectionString.HotelManagement))
{
var cmd = new SqlCommand(p_Permissions_Get, connection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@UserID", _requestInfo.UserId);
cmd.Parameters.Add("@RetVal", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@RetMsg", SqlDbType.VarChar, 500).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@PermissionID", req.PermissionId);
cmd.Parameters.AddWithValue("@ParentID", req.ParentId);
cmd.Parameters.AddWithValue("@Code", req.Code);
cmd.Parameters.AddWithValue("@Name", req.Name);
cmd.Parameters.AddWithValue("@Description", req.Description);
cmd.Parameters.AddWithValue("@IncludeDisabled", req.IncludeDisabled);
connection.Open();
using (var dr = cmd.ExecuteReader())
{
result = new List <Permission>();
while (dr.Read())
{
result.Add(new Permission
{
PermissionId = dr["PermissionID"].ToSafeInt32(),
ParentId = dr["ParentID"].ToSafeInt32(),
Code = dr["Code"].ToSafeInt32(),
Name = dr["Name"].ToSafeString(),
Description = dr["Description"].ToSafeString(),
Disabled = dr["Disabled"].ToSafeBool(),
CreatedId = dr["CreatedID"].ToSafeInt32(),
CreatedBy = dr["CreatedBy"].ToSafeString(),
CreatedDateTime = dr["CreatedDateTime"].ToSafeDateTime(),
ModifiedId = dr["ModifiedID"].ToSafeInt32(),
ModifiedBy = dr["ModifiedBy"].ToSafeString(),
ModifiedDateTime = dr["ModifiedDateTime"].ToSafeDateTime()
});
}
}
return(new ApiResponse <List <Permission> >
{
Content = result,
Status = new ReturnStatus(cmd.Parameters["@RetVal"].Value.ToSafeInt32(),
cmd.Parameters["@RetMsg"].Value.ToSafeString())
});
}
}
public PermissionsViewModel()
{
_dialogs = new DialogObjects();
_dialogs.SetViewModel(this);
_service = new PermissionsService();
SearchCmd = new DelegateCommand(OnSearchUser);
MenuCmd = new DelegateCommand(OnSetUserPermissions);
GetPermissionsReq = new GetPermissions();
SetPermissionsReq = new SetPermission();
SearchUser = string.Empty;
SearchPermission = string.Empty;
}
public async Task <ActionResult <GetResult> > Get()
{
var siteIds = await _authManager.GetSiteIdsAsync();
if (siteIds.Count == 0)
{
return(new GetResult
{
Unauthorized = true
});
}
var sites = new List <Select <int> >();
foreach (var siteId in siteIds)
{
var permissionSite = await _siteRepository.GetAsync(siteId);
sites.Add(new Select <int>
{
Value = permissionSite.Id,
Label = permissionSite.SiteName
});
}
var site = await _siteRepository.GetAsync(siteIds[0]);
var channel = await _channelRepository.GetAsync(site.Id);
var root = await _channelRepository.GetCascadeAsync(site, channel, async summary =>
{
var count = await _contentRepository.GetCountAsync(site, summary);
return(new
{
Count = count
});
});
var siteUrl = await _pathManager.GetSiteUrlAsync(site, true);
var groupNames = await _contentGroupRepository.GetGroupNamesAsync(site.Id);
var tagNames = await _contentTagRepository.GetTagNamesAsync(site.Id);
var checkedLevels = ElementUtils.GetCheckBoxes(CheckManager.GetCheckedLevels(site, true, site.CheckContentLevel, true));
var columnsManager = new ColumnsManager(_databaseManager, _pathManager);
var columns = await columnsManager.GetContentListColumnsAsync(site, channel, ColumnsManager.PageType.SearchContents);
var permissions = new GetPermissions
{
IsAdd = await _authManager.HasContentPermissionsAsync(site.Id, channel.Id, MenuUtils.ContentPermissions.Add),
IsDelete = await _authManager.HasContentPermissionsAsync(site.Id, channel.Id, MenuUtils.ContentPermissions.Delete),
IsEdit = await _authManager.HasContentPermissionsAsync(site.Id, channel.Id, MenuUtils.ContentPermissions.Edit),
IsArrange = await _authManager.HasContentPermissionsAsync(site.Id, channel.Id, MenuUtils.ContentPermissions.Arrange),
IsTranslate = await _authManager.HasContentPermissionsAsync(site.Id, channel.Id, MenuUtils.ContentPermissions.Translate),
IsCheck = await _authManager.HasContentPermissionsAsync(site.Id, channel.Id, MenuUtils.ContentPermissions.CheckLevel1),
IsCreate = await _authManager.HasSitePermissionsAsync(site.Id, MenuUtils.SitePermissions.CreateContents) || await _authManager.HasContentPermissionsAsync(site.Id, channel.Id, MenuUtils.ContentPermissions.Create),
IsChannelEdit = await _authManager.HasChannelPermissionsAsync(site.Id, channel.Id, MenuUtils.ChannelPermissions.Edit)
};
return(new GetResult
{
Unauthorized = false,
Sites = sites,
SiteId = site.Id,
SiteName = site.SiteName,
SiteUrl = siteUrl,
Root = root,
GroupNames = groupNames,
TagNames = tagNames,
CheckedLevels = checkedLevels,
Columns = columns,
Permissions = permissions
});
}
public List <Permission> GetPermissions(GetPermissions req)
{
return(null);
}
