protected void lbAdd_Click(object sender, EventArgs e)
{
if (lbAllPermissions.SelectedIndex >= 0)
{
Permission p = new Permission();
PermissionDO pdo = new PermissionDO();
int id = Utilities.ConvertToInt(hfID.Value);
int pid = Utilities.ConvertToInt(lbAllPermissions.SelectedValue);
int upid = pdo.AddPermissionToUser(id, pid);
if (upid > 0)
{
LoadPermissionsListAll(id);
LoadPermissionListUser(id);
nlUser.SetCleanNotification("Разрешение успешно добавлено.");
}
else
{
nlUser.SetDirtyNotification("Произошла ошибка при добавлении разрешения.");
}
}
else
{
nlUser.SetDirtyNotification("Не выбрано разрешение.");
}
}
protected void lbDelete_Click(object sender, EventArgs e)
{
if (lbUserPermissions.SelectedIndex >= 0)
{
Permission p = new Permission();
PermissionDO pdo = new PermissionDO();
int id = Utilities.ConvertToInt(hfID.Value);
int pid = Utilities.ConvertToInt(lbUserPermissions.SelectedValue);
bool ok = pdo.DeletePermissionFromUser(id, pid);
if (ok)
{
LoadPermissionsListAll(id);
LoadPermissionListUser(id);
nlUser.SetCleanNotification("Разрешение успешно снято.");
}
else
{
nlUser.SetDirtyNotification("Произошла ошибка при снятии разрешения.");
}
}
else
{
nlUser.SetDirtyNotification("Не выбрано разрешение.");
}
}
/// <summary>
/// Получение списка разрешений для пользователя
/// </summary>
public void GetPermissions()
{
PermissionDO pDO = new PermissionDO();
UniversalEntity ue = new UniversalEntity();
ue = pDO.RetrievePermissionsByUser(_ID);
foreach (Permission p in ue)
{
_Permissions.Add(p);
}
}
private void LoadPermissionsListAll(int id)
{
lbAllPermissions.Items.Clear();
Permission p = new Permission();
PermissionDO pdo = new PermissionDO();
UniversalEntity ue = new UniversalEntity();
ue = pdo.RetrievePermissionsByUserLeft(id);
if (ue.Count > 0)
{
for (int i = 0; i < ue.Count; i++)
{
p = (Permission)ue[i];
lbAllPermissions.Items.Add(new ListItem(p.PermissionName, p.ID.ToString()));
}
}
}
public static PermissionDO ToDataObject(this Permission permission)
{
if (permission == null)
{
throw new ArgumentNullException(nameof(permission));
}
var entity = new PermissionDO
{
Id = permission.Id,
TenantId = permission.TenantId,
Name = permission.Name,
Description = permission.Description,
CreatedBy = permission.CreatedBy,
CreatedTime = permission.CreatedTime,
UpdatedBy = permission.UpdatedBy,
UpdatedTime = permission.UpdatedTime
};
return(entity);
}
private void InsertPermisssion()
{
GridViewRow g = gvPermissions.FooterRow;
Permission p = new Permission();
PermissionDO pdo = new PermissionDO();
TextBox tbPermission = g.FindControl("tbPermission") as TextBox;
if (!string.IsNullOrEmpty(tbPermission.Text))
{
p.PermissionName = tbPermission.Text;
int cid = pdo.CreatePermission(p);
if (cid != 0)
{
nlPermission.SetCleanNotification("Разрешение успешно созданно.");
gvPermissions.DataBind();
}
else
{
nlPermission.SetDirtyNotification("Ошибка при создании разрешения");
}
}
}
/// <summary>
/// Updates the permission.
/// </summary>
/// <returns><c>true</c>, if permission was updated, <c>false</c> otherwise.</returns>
/// <param name="tenantId">Tenant identifier.</param>
/// <param name="operatorId">Operator identifier.</param>
/// <param name="permission">Permission.</param>
public bool UpdatePermission(int tenantId, int operatorId, PermissionDO permission)
{
Execute("UPDATE public.permission SET name = @name, updatedby=@updatedby, updatedtime=@updatedtime WHERE tenantid=@tenantid and id = @Id", permission);
return(true);
}
/// <summary>
/// Creates the permission.
/// </summary>
/// <returns>The permission.</returns>
/// <param name="tenantId">Tenant identifier.</param>
/// <param name="operatorId">Operator identifier.</param>
/// <param name="permission">Permission.</param>
public int CreatePermission(int tenantId, int operatorId, PermissionDO permission)
{
return(ExecuteScalar("INSERT INTO public.permission (tenantid, name, description, createdby, createdtime, updatedby, updatedtime) VALUES(@tenantid,@name, @description, @createdby, @createdtime, @updatedby, @updatedtime) RETURNING id", permission));
}
