{"id":191218,"date":"2013-09-18T16:00:10","date_gmt":"2013-09-18T12:00:10","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=191218"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=191218","title":{"rendered":"\u0420\u0430\u0437\u0434\u0435\u043b\u044f\u0439 \u0438 \u0432\u043b\u0430\u0441\u0442\u0432\u0443\u0439. \u0418\u043b\u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432 \u0434\u043b\u044f ASP MVC<\/span>"},"content":{"rendered":"
\t\u041e\u0447\u0435\u043d\u044c \u0447\u0430\u0441\u0442\u043e \u0432 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u044e\u0441\u044c \u0441 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u043e\u0439 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u0440\u0430\u0437\u0434\u0435\u043b\u0430\u043c \u0441\u0430\u0439\u0442\u0430 \u0438 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f.
\u0421\u043d\u0430\u0447\u0430\u043b\u0430 \u043c\u043d\u0435 \u0445\u0432\u0430\u0442\u0430\u043b\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u043e\u0432, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 ASP MVC \u00ab\u0438\u0437 \u043a\u043e\u0440\u043e\u0431\u043a\u0438\u00bb, \u043d\u043e, \u0441\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c, \u044f \u0441\u0442\u043e\u043b\u043a\u043d\u0443\u043b\u0441\u044f \u0441 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u044c\u044e \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0441\u0432\u043e\u0435\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432. \u0415\u0441\u043b\u0438 \u0442\u0435\u0431\u0435, \u0443\u0432\u0430\u0436\u0430\u0435\u043c\u044b\u0439 %habrauser%, \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0440\u0435\u0448\u0438\u0442\u044c \u044d\u0442\u0443 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0443, \u0434\u043e\u0431\u0440\u043e \u043f\u043e\u0436\u0430\u043b\u043e\u0432\u0430\u0442\u044c \u043f\u043e\u0434 \u043a\u0430\u0442.
<\/a> <\/p>\n

\u041d\u0435\u043c\u043d\u043e\u0433\u043e \u043b\u0438\u0440\u0438\u043a\u0438<\/h4>\n

\u0412 \u043e\u0434\u043d\u043e\u043c \u0438\u0437 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432 \u0441\u0442\u043e\u043b\u043a\u043d\u0443\u043b\u0441\u044f \u0441 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u043e\u0439 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u0440\u0430\u0437\u0434\u0435\u043b\u0430\u043c \u0438 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c \u0441\u0430\u0439\u0442\u0430. \u042d\u0442\u043e \u0432\u043d\u0443\u0442\u0440\u0435\u043d\u043d\u0438\u0439 \u0441\u0430\u0439\u0442 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438 \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0438 \u043c\u043e\u0433\u0443\u0442 \u043f\u043b\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0441\u0432\u043e\u0439 \u043e\u0442\u043f\u0443\u0441\u043a. \u0422\u0417 \u0431\u044b\u043b\u043e \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e, \u043d\u0430 \u0443\u0434\u0438\u0432\u043b\u0435\u043d\u0438\u0435, \u0445\u043e\u0440\u043e\u0448\u043e. \u0420\u0430\u0431\u043e\u0442\u0430 \u0448\u043b\u0430 \u0443\u0434\u0430\u0440\u043d\u044b\u043c\u0438 \u0442\u0435\u043c\u043f\u0430\u043c\u0438 \u0438 \u0443\u0436\u0435 \u0447\u0435\u0440\u0435\u0437 \u043c\u0435\u0441\u044f\u0446 \u0440\u0430\u0431\u043e\u0442\u044b \u0431\u044b\u043b \u0433\u043e\u0442\u043e\u0432 \u0440\u0430\u0431\u043e\u0447\u0438\u0439 \u043f\u0440\u043e\u0442\u043e\u0442\u0438\u043f. \u0412\u0441\u0435 \u0431\u044b\u043b\u0438 \u0432 \u0432\u043e\u0441\u0442\u043e\u0440\u0433\u0435 \u0440\u043e\u0432\u043d\u043e \u0434\u043e \u0442\u043e\u0433\u043e \u043c\u043e\u043c\u0435\u043d\u0442\u0430, \u043a\u0430\u043a \u043d\u0435 \u043d\u0430\u0447\u0430\u043b\u0438\u0441\u044c \u00ab\u0443\u0442\u043e\u0447\u043d\u0435\u043d\u0438\u044f\u00bb \u043f\u043e \u0440\u0430\u0431\u043e\u0442\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u044b. \u0410 \u0442\u0430\u043a \u043a\u0430\u043a \u0431\u044e\u0440\u043e\u043a\u0440\u0430\u0442 \u0441\u0438\u0434\u0438\u0442 \u0432 \u043d\u0430\u0448\u0435\u043c \u0447\u0435\u043b\u043e\u0432\u0435\u043a\u0435 \u0441 \u0440\u043e\u0436\u0434\u0435\u043d\u0438\u044f, \u0431\u044b\u043b\u0430 \u043a\u0443\u0447\u0430 \u0441\u043e\u0433\u043b\u0430\u0441\u043e\u0432\u0430\u043d\u0438\u0439 \u0438 \u043e\u0431\u0441\u0443\u0436\u0434\u0435\u043d\u0438\u0439, \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u043c \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u0431\u044b\u043b\u043e \u0447\u0442\u043e-\u0442\u043e \u0432\u0440\u043e\u0434\u0435 \u0442\u0430\u043a\u043e\u0433\u043e: \u00ab\u0412\u0441\u0435 \u043e\u0442\u043b\u0438\u0447\u043d\u043e. \u041d\u043e \u0432\u043e\u0442 \u044d\u0442\u043e \u043d\u0435 \u0434\u043e\u043b\u0436\u0435\u043d \u0432\u0438\u0434\u0435\u0442\u044c \u043e\u0431\u044b\u0447\u043d\u044b\u0439 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c. \u0410 \u044d\u0442\u043e \u0434\u043e\u043b\u0436\u0435\u043d \u0432\u0438\u0434\u0435\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u043e\u0440. \u0410 \u044d\u0442\u043e \u0434\u043e\u043b\u0436\u0435\u043d \u0432\u0438\u0434\u0435\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0441\u043e\u0431\u043e \u0441\u0435\u043a\u0440\u0435\u0442\u043d\u044b\u0439 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u043e\u0440 \u0438 \u043d\u0438\u043a\u0442\u043e \u0434\u0440\u0443\u0433\u043e\u0439!\u00bb. \u0418 \u044d\u0442\u043e, \u043a \u0441\u043e\u0436\u0430\u043b\u0435\u043d\u0438\u044e, \u043d\u0435 \u043a\u043e\u043d\u0435\u0446 \u0431\u0443\u0440\u043d\u043e\u0439 \u0444\u0430\u043d\u0442\u0430\u0437\u0438\u0438 \u0437\u0430\u043a\u0430\u0437\u0447\u0438\u043a\u0430.
\u0421\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u043c\u0438 \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430\u043c\u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u044f\u043c\u0438 \u0438 \u0434\u043e\u0441\u0442\u0443\u043f\u0430\u043c\u0438 \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u043c\u043e\u0436\u043d\u043e, \u043d\u043e \u043e\u0447\u0435\u043d\u044c \u0443\u0436 \u043c\u0443\u0442\u043e\u0440\u043d\u043e. \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u044f \u0432\u0437\u044f\u043b\u0441\u044f \u0437\u0430 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043c\u043e\u0434\u0443\u043b\u044f \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432 \u0434\u043e\u0441\u0442\u0443\u043f\u0430, \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043c\u043e\u0436\u043d\u043e \u043b\u0435\u0433\u043a\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c.<\/p>\n

\u041f\u0440\u0438\u0441\u0442\u0443\u043f\u0430\u044f \u043a \u0440\u0430\u0431\u043e\u0442\u0435<\/h4>\n

\u0414\u043b\u044f \u043d\u0430\u0447\u0430\u043b\u0430 \u0431\u044b\u043b\u0438 \u0432\u044b\u0432\u0435\u0434\u0435\u043d\u044b \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044f \u043a \u043c\u043e\u0434\u0443\u043b\u044e. <\/p>\n

    \n
  1. \u041f\u0440\u043e\u0441\u0442\u043e\u0435 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u0430\u0432 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u043c\u0435\u0442\u043e\u0434\u0430\u043c \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043b\u0435\u0440\u043e\u0432 (\u043f\u043e \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0443 \u0440\u0430\u0431\u043e\u0442\u044b \u0430\u0442\u0442\u0440\u0438\u0431\u0443\u0442\u0430 Authorize) <\/li>\n
  2. \u041f\u0440\u043e\u0441\u0442\u043e\u0439 \u0432 \u0440\u0430\u0431\u043e\u0442\u0435 \u043c\u0435\u0445\u0430\u043d\u0438\u0437\u043c \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c \u0441\u0430\u0439\u0442\u0430 <\/li>\n
  3. \u0412\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0440\u043e\u043b\u0438 \u0441 \u043b\u044e\u0431\u044b\u043c\u0438 \u0432\u0430\u0440\u0438\u0430\u0446\u0438\u044f\u043c\u0438 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 <\/li>\n
  4. \u0412\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0432 \u0440\u0430\u0437\u043d\u044b\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445 <\/li>\n<\/ol>\n

    \u041f\u043e\u0442\u043e\u043c \u0431\u044b\u043b\u0430 \u043f\u0440\u043e\u0432\u0435\u0434\u0435\u043d\u0430 \u00ab\u0440\u0430\u0431\u043e\u0442\u0430\u00bb \u043f\u043e \u0440\u0438\u0441\u043e\u0432\u0430\u043d\u0438\u044e \u0440\u0430\u0437\u043b\u0438\u0447\u043d\u044b\u0445 \u0441\u0445\u0435\u043c \u0438 \u043f\u0440\u043e\u0441\u043c\u043e\u0442\u0440\u0430 \u043e\u0433\u0440\u043e\u043c\u043d\u043e\u0439 \u043a\u0443\u0447\u0438 \u043c\u0430\u0442\u0435\u0440\u0438\u0430\u043b\u043e\u0432 \u043f\u043e \u0442\u0435\u043c\u0435. \u0412 \u0438\u0442\u043e\u0433\u0435 \u0431\u044b\u043b\u0430 \u0432\u044b\u0440\u0430\u0431\u043e\u0442\u0430\u043d\u0430 \u043a\u043e\u043d\u0446\u0435\u043f\u0446\u0438\u044f \u043c\u043e\u0434\u0443\u043b\u044f.
    \u0414\u0430\u043d\u043d\u044b\u0435, \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u044b\u0435 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u043c\u043e\u0434\u0443\u043b\u044f, \u0431\u0443\u0434\u0443\u0442 \u0445\u0440\u0430\u043d\u0438\u0442\u044c\u0441\u044f \u0432 \u0431\u0430\u0437\u0435 MSSQL (\u0430 \u043d\u0430 \u0447\u0435\u043c \u0436\u0435 \u0435\u0449\u0435, \u0435\u0441\u043b\u0438 \u043f\u0438\u0448\u0435\u043c \u043d\u0430 c#). \u0426\u0435\u043d\u0442\u0440\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u043e\u0435 \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u0435\u043b\u0430\u0442\u044c \u043d\u0435 \u0441\u0442\u0430\u043b \u0438\u0437-\u0437\u0430 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u0435\u0439 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u043a\u043e\u0440\u043f\u043e\u0440\u0430\u0442\u0438\u0432\u043d\u043e\u0439 \u0441\u0435\u0442\u0438 \u0438 \u0438\u0434\u0435\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f (\u0432 \u0442\u0435\u043e\u0440\u0438\u0438) \u043d\u0430 \u043b\u044e\u0431\u043e\u043c \u043f\u0440\u043e\u0435\u043a\u0442\u0435. \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u0431\u0443\u0434\u0435\u043c \u043f\u0438\u0441\u0430\u0442\u044c \u0432 \u0431\u0430\u0437\u044b \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432 \u0441\u0432\u043e\u0439 \u043d\u0430\u0431\u043e\u0440 \u0434\u0430\u043d\u043d\u044b\u0445 \u043c\u043e\u0434\u0443\u043b\u044f.
    \u0422\u0430\u043a\u0436\u0435 \u0438\u0441\u0445\u043e\u0434\u044f \u0438\u0437 \u0438\u0434\u0435\u0438, \u0447\u0442\u043e \u043c\u043e\u0434\u0443\u043b\u044c \u0434\u043e\u043b\u0436\u0435\u043d \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 \u043b\u044e\u0431\u044b\u043c \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u043c, \u043e\u043d \u0434\u043e\u043b\u0436\u0435\u043d \u0447\u0438\u0442\u0430\u0442\u044c \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0438\u0437 \u0444\u0430\u0439\u043b\u0430 web.config \u043f\u0440\u043e\u0435\u043a\u0442\u0430, \u043a \u043a\u043e\u0442\u043e\u0440\u043e\u043c\u0443 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d \u043c\u043e\u0434\u0443\u043b\u044c.
    \u041d\u0443 \u0438 \u043f\u0443\u0441\u0442\u044c \u043c\u043e\u0434\u0443\u043b\u044c \u0443\u043c\u0435\u0435\u0442 \u043f\u043e\u0434\u0433\u043e\u0442\u0430\u0432\u043b\u0438\u0432\u0430\u0442\u044c \u0434\u043b\u044f \u0441\u0435\u0431\u044f \u0431\u0430\u0437\u0443 \u0438 \u0434\u0435\u043b\u0430\u0435\u0442 \u043d\u0430\u0447\u0430\u043b\u044c\u043d\u0443\u044e \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044e, \u0447\u0442\u043e\u0431\u044b \u0440\u0430\u0437\u0432\u0435\u0440\u0442\u044b\u0432\u0430\u043d\u0438\u0435 \u043d\u0430 \u043d\u043e\u0432\u043e\u043c \u043f\u0440\u043e\u0435\u043a\u0442\u0435 \u0431\u044b\u043b\u043e \u043f\u0440\u043e\u0441\u0442\u044b\u043c \u043a\u0430\u043a\u2026 \u043a\u0445\u043c. \u041d\u0443 \u0432\u044b \u043f\u043e\u043d\u044f\u043b\u0438.
    \u0418 \u043d\u0430 \u0432\u043a\u0443\u0441\u043d\u043e\u0435, \u043f\u0443\u0441\u0442\u044c \u043e\u043d \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e \u0437\u0430\u043d\u043e\u0441\u0438\u0442 \u0432\u0441\u0435 \u0432\u043d\u043e\u0432\u044c \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u043b\u0438 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u044b \u0438 \u0440\u0430\u0437\u0434\u0435\u043b\u044b \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0438 \u0434\u0430\u0435\u0442 \u0434\u043e\u0441\u0442\u0443\u043f \u00ab\u0441\u0443\u043f\u0435\u0440\u0430\u0434\u043c\u0438\u043d\u0443\u00bb, \u0447\u0442\u043e\u0431\u044b \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u044b \u043d\u0435 \u043f\u0440\u0438\u0448\u043b\u043e\u0441\u044c \u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437 \u043b\u0435\u0437\u0442\u044c \u0432 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438.<\/p>\n

    \u041d\u0430\u0447\u0430\u043b\u043e \u0440\u0430\u0431\u043e\u0442\u044b<\/h5>\n

    \u0414\u043b\u044f \u043d\u0430\u0447\u0430\u043b\u0430 \u0445\u043e\u0447\u0443 \u0441\u043a\u0430\u0437\u0430\u0442\u044c \u043f\u0430\u0440\u0443 \u0441\u043b\u043e\u0432 \u043e \u043f\u043e\u043b\u0443\u0447\u0438\u0432\u0448\u0435\u043c\u0441\u044f \u043c\u043e\u0434\u0443\u043b\u0435. \u0414\u043b\u044f \u0441\u0432\u043e\u0435\u0439 \u0440\u0430\u0431\u043e\u0442\u044b \u043e\u043d \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 \u0441\u0430\u043c\u043e\u043f\u0438\u0441\u043d\u044b\u0439 RoleProvider. \u0418 \u043f\u0440\u0438\u0447\u0438\u043d\u043e\u0439 \u0435\u0433\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u043f\u044f\u0442\u044c \u0436\u0435 \u0441\u0442\u0430\u043b\u0438 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u0438 \u043a\u043e\u0440\u043f\u043e\u0440\u0430\u0442\u0438\u0432\u043d\u043e\u0439 \u0441\u0435\u0442\u0438. \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u043d\u0430 \u043e\u0434\u043d\u043e\u043c \u0438\u0437 \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432 \u0441\u0434\u0435\u043b\u0430\u043d \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043d\u0430\u0445\u043e\u0434\u044f\u0442\u0441\u044f \u0432\u0441\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u043e \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430\u043c\u0438 \u0438 \u043f\u0440\u0438\u0432\u044f\u0437\u043a\u0430 \u043a \u0434\u043e\u043c\u0435\u043d\u043d\u043e\u043c\u0443 \u043b\u043e\u0433\u0438\u043d\u0443. \u041d\u0435 \u0441\u043f\u0440\u0430\u0448\u0438\u0432\u0430\u0439\u0442\u0435 \u043f\u043e\u0447\u0435\u043c\u0443. \u042d\u0442\u043e \u0443\u0441\u0442\u043e\u044f\u0432\u0448\u0435\u0435\u0441\u044f \u043f\u043e\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0432\u0435\u0449\u0435\u0439.
    \u0422\u0430\u043a \u0432\u043e\u0442, \u0434\u043b\u044f \u0432\u043d\u0443\u0442\u0440\u0435\u043d\u043d\u0438\u0445 \u043d\u0443\u0436\u0434 \u0432 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a\u0435 \u0435\u0441\u0442\u044c \u0433\u0440\u0443\u043f\u043f\u044b \u0434\u043b\u044f \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u043e\u0432. \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u0431\u044b\u043b \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u0441\u0432\u043e\u0439 \u043f\u0440\u043e\u0432\u0430\u0439\u0434\u0435\u0440 \u0440\u043e\u043b\u0435\u0439, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u043b \u0441\u0432\u043e\u0438 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438, \u043d\u043e \u043e\u043f\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043b \u0433\u0440\u0443\u043f\u043f\u0430\u043c\u0438 \u0432 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a\u0435 \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435. \u0415\u0433\u043e \u043f\u0440\u0438\u0432\u043e\u0434\u0438\u0442\u044c \u044f \u043d\u0435 \u0431\u0443\u0434\u0443, \u0442\u0430\u043a \u043a\u0430\u043a \u043e\u0441\u043e\u0431\u043e\u0433\u043e \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0430 \u043e\u043d \u043d\u0435 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0438 \u043d\u0438\u0447\u0435\u0433\u043e \u043d\u043e\u0432\u043e\u0433\u043e \u0432 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u0438 \u043f\u0440\u043e\u0432\u0430\u0439\u0434\u0435\u0440\u0430 \u0432\u044b \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u0442\u0435. (\u0432 \u0444\u0440\u0430\u0433\u043c\u0435\u043d\u0442\u0430\u0445 \u043a\u043e\u0434\u0430 \u0431\u0443\u0434\u0435\u0442 \u0432\u0441\u0442\u0440\u0435\u0447\u0430\u0442\u044c\u0441\u044f \u043e\u0431\u0440\u0430\u0449\u0435\u043d\u0438\u0435 \u043a \u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0441\u0442\u0432\u0443 \u0438\u043c\u0435\u043d AuthLib, \u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u0438 \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u043f\u0440\u043e\u0432\u0430\u0439\u0434\u0435\u0440 \u0440\u043e\u043b\u0435\u0439).<\/p>\n

    \u041f\u043e\u043a\u0430 \u043d\u0435 \u043f\u043e\u0448\u0435\u043b \u043a\u043e\u0434, \u044f \u0445\u043e\u0447\u0443 \u043f\u043e\u043f\u0440\u043e\u0441\u0438\u0442\u044c \u043f\u0440\u043e\u0449\u0435\u043d\u0438\u044f \u0437\u0430 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0438 \u0438 \u0434\u0440\u0443\u0433\u043e\u0439 \u043c\u0443\u0441\u043e\u0440 \u0432 \u043a\u043e\u0434\u0435. \u041f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u043d\u044b\u0439 \u043a\u043e\u0434 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0443\u0441\u0442\u0430\u0440\u0435\u0432\u0448\u0438\u043c(\u0432 \u0440\u0435\u0430\u043b\u0438\u044f\u0445 \u0442\u0435\u043a\u0443\u0449\u0438\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u043e\u0432) \u0438 \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d \u0442\u043e\u043b\u044c\u043a\u043e \u0434\u043b\u044f \u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0430\u0446\u0438\u0438 \u0438\u0434\u0435\u0438.<\/i><\/p>\n

    \u041f\u0435\u0440\u0432\u044b\u043c \u0434\u0435\u043b\u043e\u043c \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u043a\u043b\u0430\u0441\u0441, \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0449\u0438\u0439 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f. \u0422\u0430\u043a \u0431\u0443\u0434\u0435\u0442 \u043f\u0440\u043e\u0449\u0435 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0432 \u0431\u0443\u0434\u0443\u0449\u0435\u043c. <\/p>\n

    \u041a\u043b\u0430\u0441\u0441 'C\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a'<\/b><\/p>\n
    \n
    using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data.SqlClient;  namespace Ekzo.BaseClasses {     public class Employee : IEquatable<Employee>     {         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430 \u043f\u043e \u0411\u0414         \/\/\/ <\/summary>         public int Id { get; set; }         \/\/\/ <summary>         \/\/\/ \u0424\u0418\u041e \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430         \/\/\/ <\/summary>         public string Name { get; set; }               \/\/\/ <summary>         \/\/\/ \u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440 \u043a\u043b\u0430\u0441\u0441\u0430         \/\/\/ <\/summary>         \/\/\/ <param name="id">\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0438\u0437 \u0411\u0414<\/param>         public Employee(int id)         {             InitClass(id);         }         \/\/\/ <summary>         \/\/\/ \u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440 \u043a\u043b\u0430\u0441\u0441\u0430         \/\/\/ <\/summary>         \/\/\/ <param name="employeeName">\u0424\u0418\u041e \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430<\/param>         public Employee(string employeeName)         {                             using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))                 {                     using (SqlCommand cmd = new SqlCommand("SELECT employee_id FROM employee WHERE employee_name LIKE @employeeName+'%' AND date_fired IS NULL", conn))                     {                         try                         {                             conn.Open();                             cmd.Parameters.AddWithValue("@employeeName", string.Join("%", employeeName.Split(char.Parse(" "))));                             SqlDataReader reader = cmd.ExecuteReader();                             while (reader.Read())                             {                                 this.Id = reader.GetInt32(0);                             }                             reader.Close();                         }                         catch (Exception ex)                         {                             if (Ekzo.Web.Configuration.s_log != null)                                 Ekzo.Web.Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041e\u0448\u0438\u0431\u043a\u0430 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f]", ex);                         }                     }                 }             if (this.Id != 0)                 InitClass(this.Id);         }         \/\/\/ <summary>         \/\/\/ \u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440 \u043a\u043b\u0430\u0441\u0441\u0430         \/\/\/ <\/summary>         public Employee() { }         \/\/\/ <summary>         \/\/\/ \u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043f\u043e\u043b\u0435\u0439 \u043a\u043b\u0430\u0441\u0441\u0430         \/\/\/ <\/summary>         \/\/\/ <param name="id">\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430 \u043f\u043e \u0411\u0414<\/param>         private void InitClass(int id)         {                 this.Id = id;                 using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))                 {                     using (SqlCommand cmd = new SqlCommand("SELECT employee_name FROM employee WHERE employee_id=@employeeID AND date_fired IS NULL", conn))                     {                         try                         {                             conn.Open();                             cmd.Parameters.AddWithValue("@employeeID", this.Id);                             SqlDataReader reader = cmd.ExecuteReader();                             while (reader.Read())                             {                                 this.Name = reader.GetString(0);                             }                             reader.Close();                          }                         catch (Exception ex)                         {                             if (Ekzo.Web.Configuration.s_log != null)                                 Ekzo.Web.Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041e\u0448\u0438\u0431\u043a\u0430 \u0438\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u043a\u043b\u0430\u0441\u0441\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f]", ex);                         }                     }                 }          }          public bool Equals(Employee x, Employee y)         {             if (x.Name == y.Name && x.Id == y.Id)                 return true;             else                 return false;         }         public override int GetHashCode()         {             int hasEmployeeName = this.Name == null ? 0 : this.Name.GetHashCode();             int hasID = this.Id == 0 ? 0 : this.Id.GetHashCode();              return hasEmployeeName ^ hasID;         }         public bool Equals(Employee other)         {             if (this.Name == other.Name && this.Id == other.Id)                 return true;             else                 return false;         }          bool IEquatable<Employee>.Equals(Employee other)         {             if (this.Name == other.Name && this.Id == other.Id)                 return true;             else                 return false;         }     } } <\/code><\/pre>\n
      <\/div>\n<\/div>\n
      \u0422\u0435\u043f\u0435\u0440\u044c \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u0438\u043c \u043a\u043b\u0430\u0441\u0441\u044b, \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0449\u0438\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u044b \u0441\u0438\u0441\u0442\u0435\u043c\u044b (\u0440\u0430\u0437\u0434\u0435\u043b\u044b, \u0441\u0441\u044b\u043b\u043a\u0438, \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u044b \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u0442.\u0434.)<\/p>\n
    \u041a\u043b\u0430\u0441\u0441 '\u0414\u0435\u0439\u0441\u0442\u0432\u0438\u0435'<\/b><\/p>\n
    \n
    using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Web;  namespace Ekzo.Web.Security.Utilization.Authorization {      \/\/\/ <summary>     \/\/\/ \u041a\u043b\u0430\u0441\u0441 \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0449\u0438\u0439 \u043c\u0435\u0442\u043e\u0434. \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0439 \u0438\u043c\u0435\u043d\u0438 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0438 \u0440\u043e\u043b\u0438, \u0438\u043c\u0435\u044e\u0449\u0435\u0439 \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u043d\u0435\u043c\u0443.     \/\/\/ <\/summary>     public class Action     {         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u043f\u043e \u0411\u0414         \/\/\/ <\/summary>         public int id { get; private set; }         \/\/\/ <summary>         \/\/\/ \u0413\u0440\u0443\u043f\u043f\u044b, \u043a \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0441\u044f \u043c\u0435\u0442\u043e\u0434         \/\/\/ <\/summary>         private int[] _ActionGroups;         \/\/\/ <summary>         \/\/\/ \u0413\u0440\u0443\u043f\u043f\u044b, \u043a \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0441\u044f \u043c\u0435\u0442\u043e\u0434         \/\/\/ <\/summary>         public ActionGroup[] ActionGroups         {             get             {                 List<ActionGroup> Groups = new List<ActionGroup>();                 if (_ActionGroups != null)                 {                     for (int i = 0; i < _ActionGroups.Count(); i++)                         Groups.Add(new ActionGroup(_ActionGroups[i]));                     return Groups.ToArray();                 }                 return null;             }         }         \/\/\/ <summary>         \/\/\/ \u0418\u043c\u044f \u043c\u0435\u0442\u043e\u0434\u0430 \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0435 \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f \u0434\u043e\u0441\u0442\u0443\u043a\u0430         \/\/\/ <\/summary>         public string ActionName { get; set; }         \/\/\/ <summary>         \/\/\/ \u0424\u043b\u0430\u0433 \u0438\u043d\u0434\u0438\u043a\u0430\u0442\u043e\u0440 \u0430\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u0438 \u043f\u0440\u0430\u0432\u0438\u043b\u0430         \/\/\/ <\/summary>         public bool Active { get; private set; }          #region ClassBuilder         public Action() { }         public Action(string ActionName)         {             InitClass(ActionName);         }         public Action(int id)         {             InitClass(null, id);         }         private void InitClass(string name, int id = 0, int actionGroup = 0)         {             if (id != 0) this.id = id;             if (!string.IsNullOrEmpty(name)) this.ActionName = name;             \/\/this._ActionGroups = actionGroup;             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT * FROM Authorization_Actions WHERE id=@id OR Name=@actionName", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", id);                         cmd.Parameters.AddWithValue("@actionName", string.IsNullOrEmpty(name) ? "" : name);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                         {                             this.id = reader.GetInt32(0);                             this.ActionName = reader.GetString(1);                             this.Active = reader.GetBoolean(2);                         }                         reader.Close();                         List<int> actionGroups = new List<int>();                         cmd.CommandText = "SELECT GroupID FROM Authorization_ActionToGroup WHERE ActionID=@id";                         cmd.Parameters.Clear();                         cmd.Parameters.AddWithValue("@id", this.id);                         reader = cmd.ExecuteReader();                         while (reader.Read())                             actionGroups.Add(reader.GetInt32(0));                          this._ActionGroups = actionGroups.ToArray();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f] ", ex);                     }                 }             }         }         #endregion          \/\/\/ <summary>         \/\/\/ \u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u043c\u0435\u0442\u043e\u0434\u0430         \/\/\/ <\/summary>         public void Save()         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"                         IF((SELECT COUNT(*) FROM Authorization_Actions WHERE id=@id OR Name=@name)=0)                          BEGIN                             INSERT INTO Authorization_Actions(Name) VALUES(@name)                             INSERT INTO Authorization_ActionToGroup(ActionID,GroupID) VALUES((SELECT TOP(1) id FROM Authorization_Actions WHERE Name=@name),0)                          END                         ELSE                              UPDATE Authorization_Actions SET Name=@name, Active=@active                                                   SELECT * FROM Authorization_Actions WHERE Name=@name", conn))                 {                     try                     {                         conn.Open();                         if (!string.IsNullOrEmpty(this.ActionName) && this.id == 0) cmd.CommandText = cmd.CommandText.Replace("WHERE id=@id OR Name=@name", "WHERE Name=@name");                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.Parameters.AddWithValue("@name", this.ActionName);                         cmd.Parameters.AddWithValue("@active", this.Active);                         \/\/cmd.Parameters.AddWithValue("@groupID", this._ActionGroup);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         List<int> actionGroups = new List<int>();                         while (reader.Read())                         {                             this.id = reader.GetInt32(0);                             this.ActionName = reader.GetString(1);                             this.Active = reader.GetBoolean(2);                         }                         reader.Close();                         cmd.CommandText = "SELECT GroupID FROM Authorization_ActionToGroup WHERE ActionID=@id";                         cmd.Parameters.Clear();                         cmd.Parameters.AddWithValue("@id", this.id);                         reader = cmd.ExecuteReader();                         while (reader.Read())                             actionGroups.Add(reader.GetInt32(0));                          this._ActionGroups = actionGroups.ToArray();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0432 \u0411\u0414] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043c\u0435\u0442\u043e\u0434\u0430         \/\/\/ <\/summary>         public void Delete()         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM Authorization_Actions WHERE id=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.ExecuteNonQuery();                         cmd.CommandText = "DELETE FROM Autorization_ActionToGroup WHERE ActionID=@id";                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0438\u0437 \u0411\u0414] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0438\u0435 \u043c\u0435\u0442\u043e\u0434\u0430         \/\/\/ <\/summary>         \/\/\/ <returns><\/returns>         public bool IsExist()         {             return IsExist(this.ActionName);         }         \/\/\/ <summary>         \/\/\/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0438\u044f \u043c\u0435\u0442\u043e\u0434\u0430         \/\/\/ <\/summary>         \/\/\/ <param name="ActionName">\u0418\u043c\u044f \u043c\u0435\u0442\u043e\u0434\u0430<\/param>         \/\/\/ <returns><\/returns>         public static bool IsExist(string ActionName)         {             bool result = false;             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT COUNT(*) FROM Authorization_Actions WHERE Name=@name", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@name", ActionName);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             result = reader.GetInt32(0) == 0 ? false : true;                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0438\u044f \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0432 \u0411\u0414] ", ex);                     }                 }             }             return result;         }         \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0432\u0441\u0435\u0445 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u043c\u0435\u0442\u043e\u0434\u043e\u0432         \/\/\/ <\/summary>         \/\/\/ <returns><\/returns>         public static List<Action> GetAllActions()         {             List<Action> result = new List<Action>();             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT id FROM Authorization_Actions ORDER BY Name ", conn))                 {                     try                     {                         conn.Open();                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             result.Add(new Action(reader.GetInt32(0)));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0432\u0441\u0435\u0445 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439] ", ex);                     }                 }             }             return result;         }         \/\/\/ <summary>         \/\/\/ \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043c\u0435\u0442\u043e\u0434\u0430 \u0432 \u0433\u0440\u0443\u043f\u043f\u0443         \/\/\/ <\/summary>         \/\/\/ <param name="groupID"><\/param>         public void AddToGroup(int groupID)         {              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"                         IF((SELECT COUNT(*) FROM Authorization_ActionToGroup WHERE ActionID=@action AND GroupID=@group)=0)                            INSERT INTO Authorization_ActionToGroup(ActionID,GroupID) VALUES(@action,@group)", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@action", groupID);                         cmd.Parameters.AddWithValue("@group", this.id);                         cmd.ExecuteNonQuery();                         new Action(this.id);                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0432 \u0433\u0440\u0443\u043f\u043f\u0443] ", ex);                     }                 }             }         }     } } <\/code><\/pre>\n
      <\/div>\n<\/div>\n
    \u041a\u043b\u0430\u0441\u0441 '\u0413\u0440\u0443\u043f\u043f\u044b \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439'<\/b><\/p>\n
    \n
    using System; using System.Collections.Generic; using System.Linq; using System.Text;  namespace Ekzo.Web.Security.Utilization.Authorization {     \/\/\/ <summary>     \/\/\/ \u041a\u043b\u0430\u0441\u0441 \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u0442 \u0433\u0440\u0443\u043f\u043f\u044b \u043c\u0435\u0442\u043e\u0434\u043e\u0432     \/\/\/ <\/summary>     public class ActionGroup     {         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0433\u0440\u0443\u043f\u043f\u044b \u0432 \u0411\u0414         \/\/\/ <\/summary>         public int id { get; private set; }         \/\/\/ <summary>         \/\/\/ \u0421\u043f\u0438\u0441\u043e\u043a \u0440\u043e\u043b\u0435\u0439, \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u0440\u0430\u0437\u0440\u0435\u0448\u0435\u043d \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u0433\u0440\u0443\u043f\u043f\u0435         \/\/\/ <\/summary>         public SystemRole[] Roles { get; private set; }         \/\/\/ <summary>         \/\/\/ \u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         public string Name { get; private set; }         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0430\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u0438 \u0433\u0440\u0443\u043f\u043f\u044b. \u0415\u0441\u043b\u0438 \u0433\u0440\u0443\u043f\u043f\u0430 \u043d\u0435 \u0430\u043a\u0442\u0438\u0432\u043d\u044b, \u043f\u0440\u0430\u0432\u0438\u043b\u0430 \u043f\u0435\u0440\u0435\u0441\u0442\u0430\u044e\u0442 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c.         \/\/\/ <\/summary>         public bool Active { get; set; }         \/\/\/ <summary>         \/\/\/ \u041c\u0435\u0442\u043e\u0434\u044b \u0433\u0440\u0443\u043f\u043f\u044b.         \/\/\/ <\/summary>         public Action[] GroupActions { get; private set; }         #region ClassBuilder         public ActionGroup(int id)         {             InitClass(null, id);         }         public ActionGroup(string name) { InitClass(name); }         private void InitClass(string name, int id = 0)         {             if (id != 0) this.id = id;             if (!string.IsNullOrEmpty(name)) this.Name = name;             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT * FROM Authorization_ActionGroups WHERE id=@id OR Name=@groupName", conn))                 {                     try                     {                         conn.Open();                         if (!string.IsNullOrEmpty(name) && id == 0) cmd.CommandText = "SELECT * FROM Authorization_ActionGroups WHERE Name=@groupName";                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.Parameters.AddWithValue("@groupName", this.Name == null ? "" : this.Name);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                         {                             this.id = reader.GetInt32(0);                             if (string.IsNullOrEmpty(this.Name)) this.Name = reader.GetString(1);                             this.Active = reader.GetBoolean(2);                         }                         reader.Close();                         cmd.CommandText = "SELECT * FROM Authorization_RoleToActionGroup WHERE ActionGroup=@groupID";                         cmd.Parameters.Clear();                         cmd.Parameters.AddWithValue("@groupID", this.id);                         reader = cmd.ExecuteReader();                         List<SystemRole> rolesList = new List<SystemRole>();                         while (reader.Read())                             rolesList.Add(new SystemRole(this.id, reader.GetString(2)));                         this.Roles = rolesList.ToArray();                         reader.Close();                         cmd.Parameters.Clear();                         cmd.Parameters.AddWithValue("@id", this.id);                         List<Action> actionsList = new List<Action>();                         cmd.CommandText = "SELECT ActionID FROM Authorization_ActionToGroup WHERE GroupID=@id";                         reader = cmd.ExecuteReader();                         while (reader.Read())                         {                             actionsList.Add(new Action(reader.GetInt32(0)));                         }                         this.GroupActions = actionsList.Distinct().ToArray();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f] ", ex);                     }                 }             }         }         #endregion         \/\/\/ <summary>         \/\/\/ \u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         public void Save()         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"                         IF((SELECT COUNT(*) FROM Authorization_ActionGroups WHERE Name=@name)=0)                              INSERT INTO Authorization_ActionGroups(Name) VALUES(@name)                          ELSE                              UPDATE Authorization_ActionGroups SET Name=@name, Active=@active WHERE id=@id                                               SELECT * FROM Authorization_ActionGroups WHERE Name=@name", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.Parameters.AddWithValue("@name", this.Name);                         cmd.Parameters.AddWithValue("@active", this.Active);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                         {                             this.id = reader.GetInt32(0);                             this.Name = reader.GetString(1);                             this.Active = reader.GetBoolean(2);                         }                         reader.Close();                         cmd.CommandText = "SELECT * FROM Authorization_RoleToActionGroup WHERE ActionGroup=@id";                         reader = cmd.ExecuteReader();                         List<SystemRole> rolesList = new List<SystemRole>();                         while (reader.Read())                             rolesList.Add(new SystemRole(reader.GetString(2)));                         this.Roles = rolesList.ToArray();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u044b \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u044b.         \/\/\/ <\/summary>         \/\/\/ <remarks>\u041f\u0440\u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0438 \u0433\u0440\u0443\u043f\u043f\u044b \u0442\u0430\u043a\u0436\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0432\u0441\u0435\u0445 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0445 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432.<\/remarks>         public void Delete()         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM Authorization_ActionGroups WHERE id=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.ExecuteNonQuery();                         cmd.CommandText = "DELETE FROM Authorization_RoleToActionGroup WHERE ActionGroup=@id";                         cmd.ExecuteNonQuery();                         cmd.CommandText = "DELETE FROM Authorization_ActionToGroup WHERE GroupID=@id";                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u044b \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439] ", ex);                     }                 }             }         }          \/\/\/ <summary>         \/\/\/ \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043c\u0435\u0442\u043e\u0434\u0430 \u0438\u0437 \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         \/\/\/ <param name="actionID">\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u043c\u0435\u0442\u043e\u0434\u0430<\/param>         public void DeleteAction(int actionID)         {              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM Authorization_ActionToGroup WHERE ActionID=@action AND GroupID=@group", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@action", actionID);                         cmd.Parameters.AddWithValue("@group", this.id);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0438\u0437 \u0433\u0440\u0443\u043f\u043f\u044b] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u0438\u0437 \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         \/\/\/ <param name="roleID">\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0440\u043e\u043b\u0438<\/param>         public void DeleteRole(int roleID)         {             string roleName = "";             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT group_name FROM groups WHERE group_id=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", roleID);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             roleName = reader.GetString(0);                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u0438\u0437 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a\u0430] ", ex);                     }                 }             }              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM Authorization_RoleToActionGroup WHERE ActionGroup=@group AND Role=@roleName", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@roleName", roleName);                         cmd.Parameters.AddWithValue("@group", this.id);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u0438\u0437 \u0433\u0440\u0443\u043f\u043f\u044b \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0432\u0441\u0435\u0445 \u0433\u0440\u0443\u043f\u043f         \/\/\/ <\/summary>         \/\/\/ <returns><\/returns>         public static List<ActionGroup> GetAllgroups()         {             List<ActionGroup> result = new List<ActionGroup>();              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT id FROM Authorization_ActionGroups", conn))                 {                     try                     {                         conn.Open();                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             result.Add(new ActionGroup(reader.GetInt32(0)));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0433\u0440\u0443\u043f\u043f \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439] ", ex);                     }                 }             }             return result;         }     } }  <\/code><\/pre>\n
      <\/div>\n<\/div>\n
    \u041a\u043b\u0430\u0441\u0441 '\u042d\u043b\u0435\u043c\u0435\u043d\u0442\u044b \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f'<\/b><\/p>\n
    \n
    using System; using System.Collections.Generic; using System.Linq; using System.Text;  namespace Ekzo.Web.Security.Utilization.Authorization {     \/\/\/ <summary>     \/\/\/ \u041a\u043b\u0430\u0441\u0441 \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u0442 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0438\u043c\u0435\u044e\u0442 \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0435 \u0434\u043e\u0441\u0442\u0443\u043f\u0430     \/\/\/ <\/summary>     public class PageControl     {         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430 \u043f\u043e \u0411\u0414 \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432         \/\/\/ <\/summary>         public int id { get; private set; }         \/\/\/ <summary>         \/\/\/ \u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430 \u0432 \u0411\u0414         \/\/\/ <\/summary>         public string Name { get; set; }         \/\/\/ <summary>         \/\/\/ \u0413\u0440\u0443\u043f\u043f\u044b, \u043a \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043f\u0440\u0438\u0432\u044f\u0437\u0430\u043d \u043a\u043e\u043d\u0442\u0440\u043e\u043b         \/\/\/ <\/summary>         public List<PageControlsGroup> Groups { get; set; }          #region ClassBuilder         public PageControl(int id)         {             InitClass(id, null);         }         public PageControl(string name)         {             InitClass(0, name);         }         private void InitClass(int id, string Name)         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 \/\/\u0415\u0441\u043b\u0438 \u043a\u043e\u043d\u0442\u0440\u043e\u043b \u0435\u0449\u0435 \u043d\u0435 \u0437\u0430\u043d\u0435\u0441\u0435\u043d \u0432 \u0411\u0414, \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0435\u0433\u043e \u0432 \u0441\u043f\u0438\u0441\u043e\u043a                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"IF((SELECT COUNT(*) FROM Authorization_Controls WHERE Name=@name OR id=@id)=0)                                                                                                                              INSERT INTO Authorization_Controls(Name) VALUES (@name)", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@name", Name == null ? "" : Name);                         cmd.Parameters.AddWithValue("@id", id);                         cmd.ExecuteNonQuery();                         cmd.CommandText = "SELECT id,Name FROM Authorization_Controls WHERE Name=@name OR id=@id";                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                         {                             this.id = reader.GetInt32(0);                             this.Name = reader.GetString(1);                         }                         reader.Close();                         \/\/\u0415\u0441\u043b\u0438 \u043a\u043e\u043d\u0442\u0440\u043e\u043b \u0435\u0449\u0435 \u043d\u0435 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d \u0432 \u0433\u0440\u0443\u043f\u043f\u0443 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043e\u0432 \u0441\u0443\u043f\u0435\u0440\u0430\u0434\u043c\u0438\u043d\u0430, \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c                         \/\/\u0413\u0440\u0443\u043f\u043f\u0430 \u0441\u0443\u043f\u0435\u0440\u0430\u0434\u043c\u0438\u043d\u0430 -1                         cmd.CommandText = "IF((SELECT COUNT(*) FROM Authorization_ControlToGroup WHERE ControlID=@id AND GroupID=-1)=0) INSERT INTO Authorization_ControlToGroup(ControlID,GroupID) VALUES(@id,-1)";                         cmd.Parameters.Clear();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.Parameters.AddWithValue("@name", this.Name);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }              this.Groups = new List<PageControlsGroup>();             List<int> groupsIDs = new List<int>();              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT GroupID FROM Authorization_ControlToGroup WHERE ControlID=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             groupsIDs.Add(reader.GetInt32(0));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }              for (int i = 0; i < groupsIDs.Count; i++)                 this.Groups.Add(new PageControlsGroup(groupsIDs[i]));          }         #endregion          \/\/\/ <summary>         \/\/\/ \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430 \u0432 \u0433\u0440\u0443\u043f\u043f\u0443         \/\/\/ <\/summary>         \/\/\/ <param name="groupID"><\/param>         public void AddToGroup(int groupID)         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"IF((SELECT COUNT(*) FROM Authorization_ControlToGroup WHERE ControlID=@id AND GroupID=@group)=0)                                                                                                             INSERT INTO Authorization_ControlToGroup(ControlID,GroupID) VALUES(@id,@group)", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.Parameters.AddWithValue("@group", groupID);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0432 \u0433\u0440\u0443\u043f\u043f\u0443] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430         \/\/\/ <\/summary>         public void Save()         {             string commandText = this.id == 0 ? "INSERT INTO Authorization_Controls (Name) VALUES(@name)" : "UPDATE Authorization_Controls SET Name=@name WHERE id=@id";             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(commandText, conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@name", this.Name);                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.ExecuteNonQuery();                         cmd.CommandText = "IF((SELECT COUNT(*) FROM Authorization_ControlToGroup WHERE ControlID=(SELECT TOP(1) id FROM Authorization_Controls WHERE Name=@name) AND GroupID=-1)=0) INSERT INTO Authorization_ControlToGroup(ControlID,GroupID) VALUES(SELECT TOP(1) id FROM Authorization_Controls WHERE Name=@name,-1)";                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430         \/\/\/ <\/summary>         public void Delete()         {             if (this.id == 0) return;              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM Authorization_Controls WHERE id=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0432\u0441\u0435\u0445 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043e\u0432         \/\/\/ <\/summary>         \/\/\/ <returns><\/returns>         public static PageControl[] GetAllControls()         {             List<PageControl> result = new List<PageControl>();             List<int> controlsIDs = new List<int>();             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT id FROM Authorization_Controls ORDER BY Name", conn))                 {                     try                     {                         conn.Open();                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             controlsIDs.Add(reader.GetInt32(0));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }             for (int i = 0; i < controlsIDs.Count; i++)                 result.Add(new PageControl(controlsIDs[i]));             return result.ToArray();         }      } } <\/code><\/pre>\n
      <\/div>\n<\/div>\n
    \u041a\u043b\u0430\u0441\u0441 '\u0413\u0440\u0443\u043f\u043f\u044b \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043e\u0432'<\/b><\/p>\n
    \n
    using System; using System.Collections.Generic; using System.Linq; using System.Text;  namespace Ekzo.Web.Security.Utilization.Authorization {     \/\/\/ <summary>     \/\/\/ \u041a\u043b\u0430\u0441\u0441 \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u0442 \u0433\u0440\u0443\u043f\u043f\u0443 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043e\u0432     \/\/\/ <\/summary>     public class PageControlsGroup : IEquatable<PageControlsGroup>, IEqualityComparer<PageControlsGroup>     {         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0433\u0440\u0443\u043f\u043f\u044b \u043f\u043e \u0411\u0414 \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f  \u043f\u0440\u0430\u0432\u0434         \/\/\/ <\/summary>         public int id { get; private set; }         \/\/\/ <summary>         \/\/\/ \u0418\u043c\u044f \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         public string Name { get; set; }         \/\/\/ <summary>         \/\/\/ \u0421\u043f\u0438\u0441\u043e\u043a \u0440\u043e\u043b\u0435\u0439, \u043f\u0440\u0438\u043d\u0430\u0434\u043b\u0435\u0436\u0430\u0449\u0438\u0445 \u0433\u0440\u0443\u043f\u043f\u0435         \/\/\/ <\/summary>         public List<ControlsGroupRole> Roles { get; set; }          #region ClassBuilder         public PageControlsGroup(int id)         {             InitClass(id, "");         }         public PageControlsGroup(string Name)         {             this.Name = Name;             InitClass(0, Name);         }         public PageControlsGroup(int id, string Name)         {             this.id = id;             this.Name = Name;             this.Roles = new PageControlsGroup(id).Roles;         }          private void InitClass(int id, string name)         {             \/\/this.Controls = new List<PageControl>();             this.Roles = new List<ControlsGroupRole>();             List<int> pageControls = new List<int>();             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT * FROM Authorization_ControlsGroup WHERE id=@id OR Name=@name", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", id);                         cmd.Parameters.AddWithValue("@name", name);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                         {                             this.id = reader.GetInt32(0);                             this.Name = reader.GetString(1);                         }                         reader.Close();                         cmd.CommandText = @"SELECT Authorization_Controls.id AS ControlID                                             FROM   Authorization_ControlToGroup INNER JOIN                                             Authorization_ControlsGroup ON Authorization_ControlToGroup.GroupID = Authorization_ControlsGroup.id INNER JOIN                                             Authorization_Controls ON Authorization_ControlToGroup.ControlID = Authorization_Controls.id                                             WHERE Authorization_ControlsGroup.id=@id OR Authorization_ControlsGroup.Name=@name";                         reader = cmd.ExecuteReader();                         while (reader.Read())                             pageControls.Add(reader.GetInt32(0));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 \u0433\u0440\u0443\u043f\u043f\u044b \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }               \/\/for(int i=0;i<pageControls.Count;i++)             \/\/    this.Controls.Add(new PageControl(pageControls[i]));              List<int> groupRoles = new List<int>();             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT RoleID FROM Authorization_RoleToControlGroup WHERE GroupID=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             groupRoles.Add(reader.GetInt32(0));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0440\u043e\u043b\u0435\u0439 \u0433\u0440\u0443\u043f\u043f\u044b \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }             for (int i = 0; i < groupRoles.Count; i++)                 this.Roles.Add(new ControlsGroupRole(groupRoles[i], this.id));         }         #endregion          \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438 \u0441\u043f\u0438\u0441\u043a\u0430 \u0432\u0441\u0435\u0445 \u0433\u0440\u0443\u043f\u043f         \/\/\/ <\/summary>         \/\/\/ <returns><\/returns>         public static PageControlsGroup[] GetAllGroups()         {             List<PageControlsGroup> result = new List<PageControlsGroup>();              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT * FROM Authorization_ControlsGroup", conn))                 {                     try                     {                         conn.Open();                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             result.Add(new PageControlsGroup(reader.GetInt32(0), reader.GetString(1)));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0433\u0440\u0443\u043f\u043f \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }              return result.ToArray();         }         \/\/\/ <summary>         \/\/\/ \u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         public void Save()         {              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("IF((SELECT COUNT(*) FROM Authorization_ControlsGroup WHERE Name=@name)=0) INSERT INTO Authorization_ControlsGroup(Name) VALUES(@name)", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@name", this.Name);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u044b \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }              PageControlsGroup newGroup = new PageControlsGroup(this.Name);             this.id = newGroup.id;             this.Roles = newGroup.Roles;             newGroup = null;          }         \/\/\/ <summary>         \/\/\/ \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         public void Delete()         {             if (this.id != 0)                 using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))                 {                     using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM Authorization_ControlsGroup WHERE id=@id", conn))                     {                         try                         {                             conn.Open();                             cmd.Parameters.AddWithValue("@id", this.id);                             cmd.ExecuteNonQuery();                             cmd.CommandText = "DELETE FROM Authorization_RoleToControlGroup WHERE GroupID=@id";                             cmd.ExecuteNonQuery();                         }                         catch (Exception ex)                         {                             if (Configuration.s_log != null)                                 Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0433\u0440\u0443\u043f\u043f\u044b \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                         }                     }                 }         }         \/\/\/ <summary>         \/\/\/ \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430 \u0438\u0437 \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         \/\/\/ <param name="controlID">\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430<\/param>         public void DeleteControl(int controlID)         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM Authorization_ControlToGroup WHERE ControlID=@control AND GroupID=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@control", controlID);                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438         \/\/\/ <\/summary>         \/\/\/ <param name="roleID">\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0440\u043e\u043b\u0438<\/param>         public void DeleteRole(int roleID)         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM Authorization_RoleToControlGroup WHERE RoleID=@role AND GroupID=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.Parameters.AddWithValue("@role", roleID);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }         }         #region InterfaceImplementation         bool IEquatable<PageControlsGroup>.Equals(PageControlsGroup other)         {             return this.id == other.id & this.Name == other.Name;         }         public bool Equals(PageControlsGroup x, PageControlsGroup y)         {             return x.id == y.id & x.Name == y.Name;         }         public int GetHashCode(PageControlsGroup obj)         {             return this.id.GetHashCode() + this.Name.GetHashCode() + this.Roles.GetHashCode();         }         #endregion     } }  <\/code><\/pre>\n
      <\/div>\n<\/div>\n
    \u041a\u043b\u0430\u0441\u0441 '\u0421\u0432\u044f\u0437\u043a\u0430 \u0433\u0440\u0443\u043f\u043f\u044b \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043e\u0432 \u0438 \u0440\u043e\u043b\u0435\u0439'<\/b><\/p>\n
    \n
    using System; using System.Collections.Generic; using System.Linq; using System.Text;  namespace Ekzo.Web.Security.Utilization.Authorization {     \/\/\/ <summary>     \/\/\/ \u041a\u043b\u0430\u0441\u0441 \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u0442 \u043f\u0440\u0438\u0432\u044f\u0437\u043a\u0443 \u0440\u043e\u043b\u0435\u0439 \u043a \u0433\u0440\u0443\u043f\u043f\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043e\u0432     \/\/\/ <\/summary>     public class ControlsGroupRole     {         \/\/\/ <summary>         \/\/\/  \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0440\u043e\u043b\u0438 \u043f\u043e \u0411\u0414 ConsUser         \/\/\/ <\/summary>         public int id { get; private set; }         \/\/\/ <summary>         \/\/\/ \u0418\u043c\u044f \u0440\u043e\u043b\u0438         \/\/\/ <\/summary>         public string Role         {             get             {                 string result = null;                 using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))                 {                     using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT group_name FROM groups WHERE group_id=@id", conn))                     {                         try                         {                             conn.Open();                             cmd.Parameters.AddWithValue("@id", this.RoleID);                             System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                             while (reader.Read())                                 result = reader.GetString(0);                         }                         catch (Exception ex)                         {                             if (Configuration.s_log != null)                                 Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044f \u0433\u0440\u0443\u043f\u043f\u044b \u0434\u043b\u044f \u0440\u043e\u043b\u0438] ", ex);                         }                     }                 }                 return result;             }         }         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0440\u043e\u043b\u0438         \/\/\/ <\/summary>         public int RoleID { get; set; }         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         public int GroupID { get; set; }          public ControlsGroupRole(int id, int groupID)         {             this.id = id;             this.GroupID = groupID;             InitClass(id, groupID);         }          private void InitClass(int id, int groupID)         {             this.RoleID = id;             this.GroupID = groupID;             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT * FROM Authorization_RoleToControlGroup WHERE RoleID=@role AND GroupID=@group", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@role", id);                         cmd.Parameters.AddWithValue("@group", groupID);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             this.id = reader.GetInt32(0);                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 \u0440\u043e\u043b\u0438 \u0433\u0440\u0443\u043f\u043f\u044b \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0432\u044f\u0437\u043a\u0438 \u0440\u043e\u043b\u0438 \u043a \u0433\u0440\u0443\u043f\u043f\u0435         \/\/\/ <\/summary>         public void Save()         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"IF((SELECT COUNT(*) FROM Authorization_RoleToControlGroup WHERE RoleID=@id AND GroupID=@group)=0)                                                                                                          INSERT INTO Authorization_RoleToControlGroup(RoleID,GroupID) VALUES(@id,@group)", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.Parameters.AddWithValue("@group", this.GroupID);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u0433\u0440\u0443\u043f\u043f\u044b \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u043e\u0432 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f] ", ex);                     }                 }             }         }     } }  <\/code><\/pre>\n
      <\/div>\n<\/div>\n
    \u041a\u043b\u0430\u0441\u0441 '\u0421\u0438\u0441\u0442\u0435\u043c\u043d\u0430\u044f \u0440\u043e\u043b\u044c'<\/b><\/p>\n
    \n
    using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Web;  namespace Ekzo.Web.Security.Utilization.Authorization {     \/\/\/ <summary>     \/\/\/ \u041e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u0442 \u0440\u043e\u043b\u0438 \u0438\u0437 \u0411\u0414 ConsUser     \/\/\/ <\/summary>     public class SystemRole     {         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0440\u043e\u043b\u0438 \u0438\u0437 \u0431\u0430\u0437\u044b \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432         \/\/\/ <\/summary>         public int id { get; private set; }         \/\/\/ <summary>         \/\/\/ \u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0440\u043e\u043b\u0438 \u0438\u0437 \u0411\u0414 ConsUser         \/\/\/ <\/summary>         public int baseID { get; private set; }         \/\/\/ <summary>         \/\/\/ \u0418\u043c\u044f \u0440\u043e\u043b\u0438         \/\/\/ <\/summary>         public string Role { get; private set; }         public int ActionGroup { get; private set; }          public SystemRole() { }          public SystemRole(string role)         {             InitClass(role);         }          public SystemRole(int actionGorup, string role)         {             InitClass(role, actionGorup);         }          public SystemRole(int baseID, int actionGroup = 0)         {              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT group_name FROM groups WHERE group_id=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", baseID);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             this.Role = reader.GetString(0);                         this.baseID = baseID;                         this.ActionGroup = actionGroup;                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0440\u043e\u043b\u0438 \u0438\u0437 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a\u0430] ", ex);                     }                 }             }         }          private void InitClass(string role, int actionGroup = -1)         {             this.ActionGroup = actionGroup;             this.Role = role;             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT * FROM Authorization_RoleToActionGroup WHERE ActionGroup=@groupID AND Role=@role", conn))                 {                     try                     {                         if (actionGroup == -1) cmd.CommandText = "SELECT * FROM Authorization_RoleToActionGroup WHERE Role=@role";                         conn.Open();                         cmd.Parameters.AddWithValue("@groupID", actionGroup);                         cmd.Parameters.AddWithValue("@role", role);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                         {                             this.id = reader.GetInt32(0);                             this.Role = reader.GetString(2);                             this.ActionGroup = reader.GetInt32(1);                         }                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0440\u043e\u043b\u0438] ", ex);                     }                 }             }              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT group_id FROM groups WHERE group_name=@name", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@name", this.Role);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             this.baseID = reader.GetInt32(0);                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0418\u043d\u0438\u0446\u0438\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0440\u043e\u043b\u0438. \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u0438\u0437 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a\u0430] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043d\u043e\u0432\u043e\u0439 \u0440\u043e\u043b\u0438         \/\/\/ <\/summary>         \/\/\/ <param name="Name">\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0440\u043e\u043b\u0438<\/param>         \/\/\/ <returns><\/returns>         public static SystemRole CreateRole(string Name)         {             SystemRole role = new SystemRole();             role.Role = Name;              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("INSERT INTO groups(group_id,group_name) SELECT MIN(group_id)-1,@name FROM groups WHERE group_id>-1000", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@name", Name);                         cmd.ExecuteNonQuery();                         cmd.CommandText = "SELECT group_id FROM groups WHERE group_name=@name";                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             role.baseID = reader.GetInt32(0);                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u0432 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a] ", ex);                     }                 }             }              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("INSERT INTO Authorization_RoleToActionGroup(ActionGroup,Role) VALUES(@group,@name)", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@name", role.Role);                         cmd.Parameters.AddWithValue("@group", -1);                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438] ", ex);                     }                 }             }             role.ActionGroup = -1;             return role;         }         \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0430\u0435\u0442 \u0441\u043f\u0438\u0441\u043e\u043a \u0440\u043e\u043b\u0435\u0439 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f         \/\/\/ <\/summary>         \/\/\/ <param name="employeeID">\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430<\/param>         \/\/\/ <returns><\/returns>         public static string[] GetEmployeeRoles(int employeeID)         {             List<string> roles = new List<string>();              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.StringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT group_name FROM employee2group INNER JOIN groups ON intranet_employee2group.group_id = groups.group_id WHERE employee_id=@employeeID ORDER BY group_name", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@employeeID", employeeID);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             roles.Add(reader.GetString(0));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0435\u0439 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0435] ", ex);                     }                 }             }             List<string> roleToDelete = new List<string>();             foreach (string role in roles)                 if (!HttpContext.Current.User.IsInRole(role)) roleToDelete.Add(role);             for (int i = 0; i < roleToDelete.Count; i++)                 roles.Remove(roleToDelete[i]);               return roles.ToArray();         }         \/\/\/ <summary>         \/\/\/ \u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438         \/\/\/ <\/summary>         public void Save()         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(@"                         IF((SELECT COUNT(*) FROM Authorization_RoleToActionGroup WHERE id=@id OR Role=@name AND ActionGroup=@groupID)=0)                              INSERT INTO Authorization_RoleToActionGroup(ActionGroup,Role) VALUES(@groupID, @name)                          ELSE                              UPDATE Authorization_RoleToActionGroup SET ActionGroup=@groupID, Role=@name WHERE id=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.Parameters.AddWithValue("@name", this.Role);                         cmd.Parameters.AddWithValue("@groupID", this.ActionGroup);                         cmd.ExecuteNonQuery();                         cmd.CommandText = "SELECT * FROM Authorization_RoleToActionGroup WHERE Role=@name AND ActionGroup=@groupID";                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                         {                             this.id = reader.GetInt32(0);                             this.ActionGroup = reader.GetInt32(1);                             this.Role = reader.GetString(2);                         }                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0435 \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438] ", ex);                     }                 }             }         }         \/\/\/ <summary>         \/\/\/ \u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438         \/\/\/ <\/summary>         \/\/\/ <remarks>\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0441\u044f \u043a\u0430\u043a \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0431\u0430\u0437\u044b \u0440\u0430\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432, \u0442\u0430\u043a \u0438 \u0438\u0437 ConsUser<\/remarks>         public void Delete()         {             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM Authorization_RoleToActionGroup WHERE id=@id", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@id", this.id);                         cmd.ExecuteNonQuery();                         cmd.CommandText = "DELETE FROM Authorization_RoleToActionGroup WHERE ActionGroup=@id";                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0438 \u0438\u0437 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438] ", ex);                     }                 }             }              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM employee2group WHERE group_id=@groupID", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@groupID", this.baseID);                         cmd.ExecuteNonQuery();                         cmd.Parameters.AddWithValue("@name", this.Role);                         cmd.CommandText = "DELETE FROM groups WHERE group_name=@name";                         cmd.ExecuteNonQuery();                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0432\u044f\u0437\u043a\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u043a \u0440\u043e\u043b\u0438 \u0432 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a\u0435] ", ex);                     }                 }             }         }         #region StaticFields         \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0432\u0441\u0435\u0445 \u0440\u043e\u043b\u0435\u0439 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438         \/\/\/ <\/summary>         \/\/\/ <returns><\/returns>         public static List<string> GetAllRoles()         {             List<string> result = new List<string>();              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT DISTINCT Role FROM Authorization_RoleToActionGroup ORDER BY Role", conn))                 {                     try                     {                         conn.Open();                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             result.Add(reader.GetString(0));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0440\u043e\u043b\u0435\u0439 \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0435 \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438] ", ex);                     }                 }             }             return result;         }         \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0432\u0441\u0435\u0445 \u043f\u043e\u043b\u0435\u0439 \u0438\u043d\u0442\u0440\u0430\u043d\u0435\u0442\u0430         \/\/\/ <\/summary>         \/\/\/ <returns><\/returns>         public static List<string> GetAllIntranetRoles()         {             List<string> result = new List<string>();              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT DISTINCT group_name FROM groups ORDER BY group_name", conn))                 {                     try                     {                         conn.Open();                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             result.Add(reader.GetString(0));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0440\u043e\u043b\u0435\u0439 \u0438\u0437 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a\u0430] ", ex);                     }                 }             }             return result;         }         \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0434\u043b\u044f \u0440\u043e\u043b\u0438         \/\/\/ <\/summary>         \/\/\/ <param name="role">\u0418\u043c\u044f \u0440\u043e\u043b\u0438<\/param>         \/\/\/ <returns><\/returns>         public static List<BaseClasses.Employee> EmployeesInRole(string role)         {             List<BaseClasses.Employee> result = new List<BaseClasses.Employee>();              using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Ekzo.Web.Configuration.StringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT intranet_employee2group.employee_id FROM groups INNER JOIN intranet_employee2group on groups.group_id=intranet_employee2group.group_id WHERE group_name=@groupName", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@groupName", role);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             result.Add(new BaseClasses.Employee(reader.GetInt32(0)));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439, \u0438\u043c\u0435\u044e\u0449\u0438\u0445 \u0440\u043e\u043b\u044c] ", ex);                     }                 }             }             return result;         }         \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0440\u043e\u043b\u0435\u0439 \u0434\u043b\u044f \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         \/\/\/ <param name="GroupName">\u0418\u043c\u044f \u0433\u0440\u0443\u043f\u043f\u044b<\/param>         \/\/\/ <returns><\/returns>         public static SystemRole[] GetGroupRoles(string GroupName)         {             ActionGroup group = new ActionGroup(GroupName);             return GetGroupRoles(group.id);         }         \/\/\/ <summary>         \/\/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0441\u043f\u0438\u0441\u043a\u0430 \u0440\u043e\u043b\u0435\u0439 \u0434\u043b\u044f \u0433\u0440\u0443\u043f\u043f\u044b         \/\/\/ <\/summary>         \/\/\/ <param name="groupID">\u0418\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u0433\u0440\u0443\u043f\u043f\u044b \u043f\u043e \u0411\u0414 \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432\u0434 \u0434\u043e\u0441\u0442\u0443\u043f\u0430<\/param>         \/\/\/ <returns><\/returns>         public static SystemRole[] GetGroupRoles(int groupID)         {             List<SystemRole> rolesList = new List<SystemRole>();             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.ConnectionStringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT * FROM Authorization_RoleToActionGroup WHERE ActionGroup=@groupID", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@groupID", groupID);                         System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();                         while (reader.Read())                             rolesList.Add(new SystemRole(reader.GetInt32(1), reader.GetString(2)));                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0440\u043e\u043b\u0435\u0439 \u0433\u0440\u0443\u043f\u043f\u044b \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439] ", ex);                     }                 }             }             return rolesList.ToArray();         }         public static int? IntranetRoleID(string roleName)         {             int? result = null;             using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[Configuration.StringName].ConnectionString))             {                 using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT group_id FROM groups WHERE group_name=@name", conn))                 {                     try                     {                         conn.Open();                         cmd.Parameters.AddWithValue("@name", roleName);                         using (System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader())                             while (reader.Read())                                 result = reader.GetInt32(0);                     }                     catch (Exception ex)                     {                         Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440\u0430 \u0440\u043e\u043b\u0438]", ex);                     }                 }             }             return result;         }         #endregion     } } <\/code><\/pre>\n
      <\/div>\n<\/div>\n
      \u0410 \u0442\u0435\u043f\u0435\u0440\u044c \u043f\u0435\u0440\u0435\u0439\u0434\u0435\u043c \u043a \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u0430, \u043d\u0430\u0441\u043b\u0435\u0434\u0443\u0435\u043c\u043e\u0433\u043e \u043e\u0442 \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0433\u043e \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u0430 (AuthorizeAttribute), \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0431\u0443\u0434\u0435\u0442 \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u0442\u044c\u0441\u044f \u043a \u043c\u0435\u0442\u043e\u0434\u0430\u043c \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043b\u0435\u0440\u043e\u0432 \u0438 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0442\u044c, \u0438\u043c\u0435\u0435\u0442 \u043b\u0438 \u0442\u0435\u043a\u0443\u0449\u0438\u0439 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043f\u0440\u0430\u0432\u043e \u043d\u0430 \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0435 \u0441\u0430\u0439\u0442\u0430 (\u0442\u0443\u0442 \u0444\u043e\u0440\u043c\u0443\u043b\u0438\u0440\u043e\u0432\u043a\u0430 \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u043d\u0435\u043a\u043e\u0440\u0440\u0435\u043a\u0442\u043d\u0430\u044f, \u043d\u043e \u0434\u043b\u044f \u043f\u0440\u043e\u0441\u0442\u043e\u0442\u044b \u043f\u043e\u043d\u0438\u043c\u0430\u043d\u0438\u044f \u043f\u0443\u0441\u0442\u044c \u043e\u0441\u0442\u0430\u043d\u0435\u0442\u0441\u044f \u0442\u0430\u043a\u043e\u0439<\/i>).<\/p>\n
    \u0410\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u0430\u0442\u0440\u0438\u0431\u0443\u0442<\/b><\/p>\n
    \n
    using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc;  namespace Ekzo.Web.Security.Utilization {     \/\/\/ <summary>     \/\/\/ \u0410\u0442\u0440\u0438\u0431\u0443\u0442 \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044e\u0449\u0438\u0439 \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0430\u0432 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u043c\u0435\u0442\u043e\u0434\u0430\u043c \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043b\u0435\u0440\u043e\u0432     \/\/\/ <\/summary>     [AttributeUsage(AttributeTargets.All, AllowMultiple = false, Inherited = false)]     public class ActionAuthorization : AuthorizeAttribute     {         \/\/\/ <summary>         \/\/\/ \u0418\u043c\u044f \u043c\u0435\u0442\u043e\u0434\u0430 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043b\u0435\u0440\u0430         \/\/\/ <\/summary>         public string ActionName { get; set; }         \/\/\/ <summary>         \/\/\/ \u0412\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0443 \u043d\u0430 \u043f\u0440\u0430\u0432\u043e \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u043c\u0435\u0442\u043e\u0434\u0443         \/\/\/ <\/summary>         \/\/\/ <param name="httpContext">\u041a\u043e\u043d\u0442\u0435\u043a\u0441\u0442<\/param>         \/\/\/ <returns>\u0415\u0441\u043b\u0438 \u043f\u0440\u0430\u0432\u043e \u0435\u0441\u0442\u044c, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u043c\u0435\u0442\u043e\u0434. \u0418\u043d\u0430\u0447\u0435 \u043f\u0435\u0440\u0435\u043d\u0430\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u043d\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0443 \u043e\u0448\u0438\u0431\u043a\u0438.<\/returns>         protected override bool AuthorizeCore(HttpContextBase httpContext)         {             bool result = false;             var isAuthorized = base.AuthorizeCore(httpContext);             if (!isAuthorized) return false;             Authorization.Action currentAction = new Authorization.Action(this.ActionName);              \/\/\u0415\u0441\u043b\u0438 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435 \u043d\u0435 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u043e \u0432 \u0411\u0414, \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0435\u043c.             if (!currentAction.IsExist()) currentAction.Save();              \/\/\u0415\u0441\u043b\u0438 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435 \u0434\u0435\u0430\u043a\u0442\u0438\u0432\u0438\u0440\u043e\u0432\u0430\u043d\u043e, \u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0432\u0441\u0435\u0445.             if (!currentAction.Active) return true;              string[] currentUserRoles = AuthLib.Helpers.RoleProviderHelper.GetUserGroups(httpContext.User.Identity.Name);             foreach (string role in currentUserRoles)             {                 if (currentAction.ActionGroups != null && currentAction.ActionGroups.Where(o => o.Roles.Select(n => n.Role).Contains(role)).Count() != 0) { result = true; break; }             }                          return result;         }     } } <\/code><\/pre>\n
      <\/div>\n<\/div>\n
      \u0412 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u043d\u0438\u0447\u0435\u0433\u043e \u0441\u043b\u043e\u0436\u043d\u043e\u0433\u043e \u043d\u0435\u0442. \u041c\u044b \u043f\u0435\u0440\u0435\u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u043c \u0444\u0443\u043d\u043a\u0446\u0438\u044e AuthorizeCore, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0432\u043e\u0437\u0432\u0440\u0430\u0442\u0438\u0442 true \u0432 \u0441\u043b\u0443\u0447\u0430\u0435, \u0435\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u0430\u0432\u043e \u043d\u0430 \u0434\u043e\u0441\u0442\u0443\u043f \u0438\u043b\u0438 \u0432 \u0441\u043b\u0443\u0447\u0430\u0435, \u0435\u0441\u043b\u0438 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u043e\u0440 \u043e\u0442\u043a\u043b\u044e\u0447\u0438\u043b \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u044e \u0432 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430\u0445. \u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043d\u0435 \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u0430\u0432\u0430 \u043d\u0430 \u0434\u043e\u0441\u0442\u0443\u043f, \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442\u0441\u044f false \u0438 \u043f\u0435\u0440\u0435\u043d\u0430\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442 \u043d\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0443 \u043e\u0448\u0438\u0431\u043a\u0438 401.
      \u0415\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043c\u043e\u043c\u0435\u043d\u0442, \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0445\u043e\u0447\u0443 \u043e\u0431\u0440\u0430\u0442\u0438\u0442\u044c \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435, \u043d\u0430\u0445\u043e\u0434\u0438\u0442\u0441\u044f \u0432 \u044d\u0442\u043e\u0439 \u0441\u0442\u0440\u043e\u0447\u043a\u0435:<\/p>\n
    if (!currentAction.IsExist()) currentAction.Save(); <\/code><\/pre>\n
      \u0417\u0434\u0435\u0441\u044c \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0438\u0435 \u043f\u0440\u0430\u0432\u0438\u043b\u0430 \u0434\u043b\u044f \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c\u043e\u0433\u043e \u043c\u0435\u0442\u043e\u0434\u0430. \u0415\u0441\u043b\u0438 \u043f\u0440\u0430\u0432\u0438\u043b\u0430 \u043d\u0435\u0442, \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0435\u0433\u043e. \u0421\u0434\u0435\u043b\u0430\u043d\u043e \u044d\u0442\u043e \u0434\u043b\u044f \u0442\u043e\u0433\u043e, \u0447\u0442\u043e\u0431\u044b \u043d\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u0440\u0430\u0432\u0438\u043b \u0434\u043b\u044f \u043d\u043e\u0432\u044b\u0445 \u043c\u0435\u0442\u043e\u0434\u043e\u0432, \u0430 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0442\u044c \u0438\u0445 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 (\u0437\u0430\u0431\u0435\u0433\u0430\u044f \u0432\u043f\u0435\u0440\u0435\u0434 \u0441\u043a\u0430\u0436\u0443, \u0447\u0442\u043e \u0432\u043d\u0443\u0442\u0440\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0440\u0430\u0437\u0440\u0435\u0448\u0430\u044e\u0449\u0435\u0433\u043e \u043f\u0440\u0430\u0432\u0438\u043b\u0430 \u0434\u043b\u044f \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u043e\u0440\u043e\u0432, \u0442\u0430\u043a \u0447\u0442\u043e \u0434\u043e\u0441\u0442\u0443\u043f \u043f\u043e\u043b\u0443\u0447\u0430\u0442 \u0432\u0441\u0435, \u043a\u0442\u043e \u0438\u043c\u0435\u0435\u0442 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u0435 \u043f\u0440\u0430\u0432\u0430).<\/p>\n
      \u041e\u0441\u0442\u0430\u043b\u043e\u0441\u044c \u043d\u0430\u043f\u0438\u0441\u0430\u0442\u044c \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0445 \u0442\u0438\u043f\u043e\u0432, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0447\u0430\u0449\u0435 \u0432\u0441\u0435\u0433\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442\u0441\u044f \u0432 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f\u0445 (\u0438 \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e).<\/p>\n
    \u0420\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u044f<\/b><\/p>\n
    \n
    using System; using System.Linq; using System.Web; using System.Web.Mvc;  namespace Ekzo.Web.Security {     \/\/\/ <summary>     \/\/\/ \u0410\u0442\u0442\u0440\u0438\u0431\u0443\u0442 \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0443     \/\/\/ <\/summary>     public class ControlAccesSecurity     {         \/\/\/ <summary>         \/\/\/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430 \u043a \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0443         \/\/\/ <\/summary>         \/\/\/ <param name="controlName">\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430, \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0449\u0435\u0435 \u0435\u0433\u043e<\/param>         \/\/\/ <returns>\u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u0430\u0432\u043e \u0434\u043e\u0441\u0442\u0443\u043f\u0430 - \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 true, \u0438\u043d\u0430\u0447\u0435 false<\/returns>         public static bool HasControlAccess(string controlName)         {             BaseClasses.Employee employee = new BaseClasses.Employee(AuthLib.Helpers.RoleProviderHelper.GetUserId(HttpContext.Current));             Utilization.Authorization.PageControl currentControl = new Utilization.Authorization.PageControl(controlName);             foreach (Utilization.Authorization.PageControlsGroup group in currentControl.Groups)                 if (group.Roles.Where(o => Utilization.Authorization.SystemRole.GetEmployeeRoles(employee.Id).Contains(o.Role)).Count() != 0)                     return true;              return false;         }     } }  namespace Ekzo.Web.Security.SecurityExtensions {     \/\/\/ <summary>     \/\/\/ \u0420\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0431\u0430\u0437\u043e\u0432\u044b\u0445 \u043a\u043b\u0430\u0441\u0441\u043e\u0432, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044e\u0449\u0438\u0435 \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0430\u0432\u0434 \u0434\u043e\u0441\u0442\u0443\u043f\u0430     \/\/\/ <\/summary>     public static class StringExtensions     {         \/\/\/ <summary>         \/\/\/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430 \u043a \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0443         \/\/\/ <\/summary>         \/\/\/ <param name="controlName">\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430, \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0449\u0435\u0435 \u0435\u0433\u043e<\/param>         \/\/\/ <returns>\u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u0430\u0432\u043e \u0434\u043e\u0441\u0442\u0443\u043f\u0430 - \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043a\u043e\u043d\u0442\u0440\u043e, \u0438\u043d\u0430\u0447\u0435 \u043f\u0443\u0441\u0442\u0443\u044e \u0441\u0442\u0440\u043e\u043a\u0443<\/returns>         public static MvcHtmlString HasControlAccess(this MvcHtmlString s, string controlName)         {             BaseClasses.Employee employee = new BaseClasses.Employee(AuthLib.Helpers.RoleProviderHelper.GetUserId(HttpContext.Current));             Utilization.Authorization.PageControl currentControl = new Utilization.Authorization.PageControl(controlName);             foreach (Utilization.Authorization.PageControlsGroup group in currentControl.Groups)                 if (group.Roles.Where(o => Utilization.Authorization.SystemRole.GetEmployeeRoles(employee.Id).Contains(o.Role)).Count() != 0)                     return s;              return MvcHtmlString.Create("");         }          \/\/\/ <summary>         \/\/\/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430 \u043a \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0443         \/\/\/ <\/summary>         \/\/\/ <param name="controlName">\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430, \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0449\u0435\u0435 \u0435\u0433\u043e<\/param>         \/\/\/ <returns>\u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u0430\u0432\u043e \u0434\u043e\u0441\u0442\u0443\u043f\u0430 - \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043a\u043e\u043d\u0442\u0440\u043e, \u0438\u043d\u0430\u0447\u0435 \u043f\u0443\u0441\u0442\u0443\u044e \u0441\u0442\u0440\u043e\u043a\u0443<\/returns>         public static IHtmlString HasControlAccess(this IHtmlString s, string controlName)         {             BaseClasses.Employee employee = new BaseClasses.Employee(AuthLib.Helpers.RoleProviderHelper.GetUserId(HttpContext.Current));             Utilization.Authorization.PageControl currentControl = new Utilization.Authorization.PageControl(controlName);             foreach (Utilization.Authorization.PageControlsGroup group in currentControl.Groups)                 if (group.Roles.Where(o => Utilization.Authorization.SystemRole.GetEmployeeRoles(employee.Id).Contains(o.Role)).Count() != 0)                     return s;              return MvcHtmlString.Create(string.Empty);         }          \/\/\/ <summary>         \/\/\/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430 \u043a \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0443         \/\/\/ <\/summary>         \/\/\/ <param name="controlName">\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430, \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0449\u0435\u0435 \u0435\u0433\u043e<\/param>         \/\/\/ <returns>\u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u0430\u0432\u043e \u0434\u043e\u0441\u0442\u0443\u043f\u0430 - \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043a\u043e\u043d\u0442\u0440\u043e, \u0438\u043d\u0430\u0447\u0435 \u043f\u0443\u0441\u0442\u0443\u044e \u0441\u0442\u0440\u043e\u043a\u0443<\/returns>         public static string HasControlAccess(this string s, string controlName)         {             BaseClasses.Employee employee = new BaseClasses.Employee(AuthLib.Helpers.RoleProviderHelper.GetUserId(HttpContext.Current));             Utilization.Authorization.PageControl currentControl = new Utilization.Authorization.PageControl(controlName);             foreach (Utilization.Authorization.PageControlsGroup group in currentControl.Groups)                 if (group.Roles.Where(o => Utilization.Authorization.SystemRole.GetEmployeeRoles(employee.Id).Contains(o.Role)).Count() != 0)                     return s;              return String.Empty;         }      }     \/\/\/ <summary>     \/\/\/ \u0420\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u044f \u0434\u043b\u044f TagBuilder'a \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044e\u0449\u0438\u0435 \u0440\u0430\u0437\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0430\u0432 \u0434\u043e\u0441\u0442\u0443\u043f\u0430     \/\/\/ <\/summary>     public static class TagBuilderExtensions     {         \/\/\/ <summary>         \/\/\/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0441\u043e\u0442\u0440\u0443\u0434\u043d\u0438\u043a\u0430 \u043a \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0443         \/\/\/ <\/summary>         \/\/\/ <param name="controlName">\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u0430, \u043e\u043f\u0438\u0441\u044b\u0432\u0430\u044e\u0449\u0435\u0435 \u0435\u0433\u043e<\/param>         \/\/\/ <returns>\u0415\u0441\u043b\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u0430\u0432\u043e \u0434\u043e\u0441\u0442\u0443\u043f\u0430 - \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043a\u043e\u043d\u0442\u0440\u043e, \u0438\u043d\u0430\u0447\u0435 \u043f\u0443\u0441\u0442\u0443\u044e \u0441\u0442\u0440\u043e\u043a\u0443<\/returns>         public static  TagBuilder HasControlAccess(this TagBuilder s, string controlName)         {             BaseClasses.Employee employee = new BaseClasses.Employee(AuthLib.Helpers.RoleProviderHelper.GetUserId(HttpContext.Current));             Utilization.Authorization.PageControl currentControl = new Utilization.Authorization.PageControl(controlName);             foreach (Utilization.Authorization.PageControlsGroup group in currentControl.Groups)                 if (group.Roles.Where(o => Utilization.Authorization.SystemRole.GetEmployeeRoles(employee.Id).Contains(o.Role)).Count() != 0)                     return s;              return new TagBuilder("b");         }     } } <\/code><\/pre>\n
      <\/div>\n<\/div>\n
      \u042d\u0442\u043e \u0432\u0441\u0435, \u0447\u0442\u043e \u043f\u043e\u043d\u0430\u0434\u043e\u0431\u0438\u0442\u0441\u044f \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432.<\/p>\n
    \u041f\u0440\u0438\u043c\u0435\u0440 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u0432 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043b\u0435\u0440\u0435<\/b><\/p>\n
    \n
    [ActionAuthorization(ActionName = "\u0417\u0430\u043f\u0440\u043e\u0441\u044b \u0432 \u0440\u0430\u0431\u043e\u0442\u0435")]         public ActionResult RequestsInWork()         {             ViewBag.Title = "\u0417\u0430\u043f\u0440\u043e\u0441\u044b \u0432 \u0440\u0430\u0431\u043e\u0442\u0435";             return View();         } <\/code><\/pre>\n
      <\/div>\n<\/div>\n
    \u041f\u0440\u0438\u043c\u0435\u0440 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u043d\u0430 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0435 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f<\/b><\/p>\n
    \n
    ...       @Html.MainMenu().HasControlAccess("\u0413\u043b\u0430\u0432\u043d\u043e\u0435 \u043c\u0435\u043d\u044e") ... <\/code><\/pre>\n
      <\/div>\n<\/div>\n
    \u041f\u043e\u044f\u0441\u043d\u0435\u043d\u0438\u0435<\/h5>\n
      \u0417\u0434\u0435\u0441\u044c \u044f \u043f\u043e\u0441\u0442\u0430\u0440\u0430\u044e\u0441\u044c \u0440\u0430\u0441\u043a\u0440\u044b\u0442\u044c \u0441\u043c\u044b\u0441\u043b \u0432\u0441\u0435\u0433\u043e \u0431\u0435\u0437\u043e\u0431\u0440\u0430\u0437\u0438\u044f, \u043e\u043f\u0438\u0441\u0430\u043d\u043d\u043e\u0433\u043e \u0440\u0430\u043d\u0435\u0435.
      \u0412\u043e-\u043f\u0435\u0440\u0432\u044b\u0445, \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u0430\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u043c\u0435\u0442\u043e\u0434\u0430\u043c\u0438 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u043b\u0435\u0440\u043e\u0432, \u043d\u043e \u0438 \u00ab\u043b\u044e\u0431\u044b\u043c\u0438\u00bb \u0434\u0440\u0443\u0433\u0438\u043c\u0438 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c\u0438 \u043d\u0430 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\u0445 \u0441\u0430\u0439\u0442\u043e\u0432.
      \u0412\u043e-\u0432\u0442\u043e\u0440\u044b\u0445, \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u0430 \u0438\u043d\u0444\u0440\u0430\u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u043c\u043e\u0434\u0443\u043b\u044f, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0430\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0441\u0432\u044f\u0437\u043a\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c-\u0440\u043e\u043b\u044c-\u00ab\u0433\u0440\u0443\u043f\u043f\u044b \u043e\u0431\u044a\u0435\u043a\u0442\u043e\u0432\u00bb-\u00ab\u0437\u0430\u0449\u0438\u0449\u0430\u0435\u043c\u044b\u0439 \u043e\u0431\u044a\u0435\u043a\u0442\u00bb \u0432 \u043b\u044e\u0431\u043e\u0439 \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u0438. \u0422\u043e \u0435\u0441\u0442\u044c \u041b\u044e\u0431\u043e\u0439 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0432 \u043b\u044e\u0431\u043e\u0439 \u0440\u043e\u043b\u0438. \u0420\u043e\u043b\u044c \u0432 \u0441\u0432\u043e\u044e \u043e\u0447\u0435\u0440\u0435\u0434\u044c \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u0440\u0438\u0432\u044f\u0437\u0430\u043d\u0430 \u043a \u043b\u044e\u0431\u043e\u0439 \u0433\u0440\u0443\u043f\u043f\u0435 \u0437\u0430\u0449\u0438\u0449\u0430\u0435\u043c\u044b\u0445 \u043e\u0431\u044a\u0435\u043a\u0442\u043e\u0432. \u041e\u0431\u044a\u0435\u043a\u0442 \u043c\u043e\u0436\u0435\u0442 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442\u044c\u0441\u044f \u0432 \u043b\u044e\u0431\u043e\u0439 \u0440\u043e\u043b\u0438. 
      \u0422\u0430\u043a\u0430\u044f \u0432\u0438\u0442\u0438\u0435\u0432\u0430\u0442\u0430\u044f \u0441\u0432\u044f\u0437\u043a\u0430 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u043b\u044e\u0431\u043e\u0435 \u0441\u043e\u0447\u0435\u0442\u0430\u043d\u0438\u0435 \u0437\u0430\u0449\u0438\u0449\u0430\u0435\u043c\u044b\u0445 \u043e\u0431\u044a\u0435\u043a\u0442\u043e\u0432 \u0438 \u0440\u043e\u043b\u0435\u0439, \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043e\u043d\u0438 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b. \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u043f\u0440\u0438 \u043f\u043e\u044f\u0432\u043b\u0435\u043d\u0438\u0438 \u043d\u043e\u0432\u043e\u0439 \u0440\u043e\u043b\u0438 \u043c\u044b \u043c\u043e\u0436\u0435\u043c \u043a\u0430\u043a \u0432\u044b\u0434\u0430\u0442\u044c \u043f\u0440\u0430\u0432\u0430 \u0443\u0436\u0435 \u043f\u0440\u0438\u0441\u0432\u043e\u0435\u043d\u043d\u044b\u0435 \u0434\u0440\u0443\u0433\u043e\u0439 \u0440\u043e\u043b\u0438 \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0435, \u0442\u0430\u043a \u0438 \u0432\u044b\u0434\u0430\u0442\u044c \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0439 \u043d\u0430\u0431\u043e\u0440 \u043f\u0440\u0430\u0432. \u0415\u0441\u043b\u0438 \u043f\u0440\u0438\u0434\u0435\u0442 \u0437\u0430\u043a\u0430\u0437\u0447\u0438\u043a \u0438 \u0441\u043a\u0430\u0436\u0435\u0442 \u00ab\u0445\u043e\u0447\u0443 \u043d\u043e\u0432\u0443\u044e \u0440\u043e\u043b\u044c, \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0431\u0443\u0434\u0435\u0442 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e \u0442\u043e-\u0442\u043e \u0438 \u0442\u043e-\u0442\u043e\u00bb \u0432\u0441\u0435 \u0441\u0432\u043e\u0434\u0438\u0442\u0441\u044f \u043a \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044e \u043f\u0440\u043e\u0441\u0442\u044b\u0445 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0439, \u043d\u0435 \u0442\u0440\u0435\u0431\u0443\u044e\u0449\u0438\u0445 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 \u043a\u043e\u0434\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u0430.
      \u0420\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u044f, \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u043c\u043e\u0434\u0443\u043b\u0435, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0442 \u0442\u0430\u043a\u0436\u0435 \u0433\u0438\u0431\u043a\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u0432\u044b\u0432\u043e\u0434\u0438\u043c\u044b\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0432 \u0441\u043e\u0431\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0445 \u043c\u0435\u0442\u043e\u0434\u0430\u0445 HtmlHelper’\u0430.<\/p>\n
      \u041d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0435 \u0434\u0430\u043d\u043d\u044b\u0439 \u043c\u0435\u0442\u043e\u0434 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432 \u043d\u0435\u043f\u043b\u043e\u0445\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0438 \u0441 AJAX \u0437\u0430\u043f\u0440\u043e\u0441\u0430\u043c\u0438. <\/p>\n
    \u041d\u0435\u043c\u043d\u043e\u0433\u043e \u0432\u043a\u0443\u0441\u043d\u044f\u0448\u043a\u0438<\/h6>\n
      \u0414\u043b\u044f \u0431\u043e\u043b\u0435\u0435 \u0443\u0434\u043e\u0431\u043d\u043e\u0433\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043d\u0430\u043f\u0438\u0448\u0435\u043c \u043a\u043b\u0430\u0441\u0441-\u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0442\u043e\u0440<\/p>\n
    \u041a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0442\u043e\u0440<\/b><\/p>\n
    \n
    using System; using System.Collections.Generic; using System.Data.SqlClient; using log4net;  namespace Ekzo.Web {     public static class Configuration     {         \/\/\/ <summary>         \/\/\/ \u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0441\u0442\u0440\u043e\u043a\u0438 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043a \u0411\u0414 \u0432 \u0444\u0430\u0439\u043b\u0435 web.config, \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044e\u0449\u0435\u0439 \u043d\u0430 \u0431\u0430\u0437\u0443 \u0441 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438.         \/\/\/ \u041f\u043e\u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e DataSource         \/\/\/ <\/summary>         public static string ConnectionStringName = "DataSource";         \/\/\/ <summary>         \/\/\/ \u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0441\u0442\u0440\u043e\u043a\u0438 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043a \u0411\u0414 \u0432 \u0444\u0430\u0439\u043b\u0435 web.config, \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044e\u0449\u0435\u0439 \u043d\u0430 \u0431\u0430\u0437\u0443         \/\/\/ \u041f\u043e\u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e         \/\/\/ <\/summary>         public static string StringName = "ConsUser";         \/\/\/ <summary>         \/\/\/ \u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0435\u043a\u0442\u0430         \/\/\/ <\/summary>         public static string ProjectName = "Project Name";          \/\/\/ <summary>         \/\/\/ \u041e\u0431\u044a\u0435\u043a\u0442 \u043b\u043e\u0433\u0430 log4net         \/\/\/ <\/summary>         public static ILog s_log = null;          \/\/\/ <summary>         \/\/\/ \u0421\u043f\u0438\u0441\u043e\u043a \u0442\u0430\u0431\u043b\u0438\u0446 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438         \/\/\/ <\/summary>         private static string[] tables = { "Authorization_ActionGroups",                                             "Authorization_Actions",                                            "Authorization_ActionToGroup",                                            "Authorization_Controls",                                            "Authorization_ControlsGroup",                                            "Authorization_ControlToGroup",                                            "Authorization_RoleToActionGroup",                                            "Authorization_RoleToControlGroup"};          \/\/\/ <summary>         \/\/\/ \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u043d\u0430 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0438\u0435 \u0432\u0441\u0435\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u0432 \u0411\u0414         \/\/\/ <\/summary>         \/\/\/ <returns>\u0415\u0441\u043b\u0438 \u0445\u043e\u0442\u044f \u0431\u044b \u043e\u0434\u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u043d\u0435 \u043d\u0430\u0439\u0434\u0435\u043d\u0430 \u0432 \u0411\u0414, \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0441\u044f \u043b\u043e\u0436\u043d\u044b\u043c<\/returns>         public static bool BaseHasTables()         {             List<string> dbTables = new List<string>();             using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[ConnectionStringName].ConnectionString))             {                 using (SqlCommand cmd = new SqlCommand("select TABLE_NAME from information_schema.tables WHERE TABLE_NAME LIKE 'Authorization_%'", conn))                 {                     try                     {                         conn.Open();                         using (SqlDataReader reader = cmd.ExecuteReader())                         {                             while (reader.Read())                                 dbTables.Add(reader.GetString(0));                         }                         foreach (string securityTable in tables)                             if (dbTables.Contains(securityTable))                                 dbTables.Remove(securityTable);                     }                     catch (Exception ex)                     {                         Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0442\u0430\u0431\u043b\u0438\u0446 \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438] ", ex);                     }                 }             }             if (dbTables.Count == 0) return false; else return true;         }         \/\/\/ <summary>         \/\/\/ \u0412\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438 \u0432 \u0411\u0414         \/\/\/ <\/summary>         \/\/\/ <param name="superAdminGroup">\u0418\u043c\u044f \u0433\u0440\u0443\u043f\u043f\u044b \u0432 \u0441\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a\u0435, \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0438 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0431\u0443\u0434\u0443\u0442 \u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u044b \u0441\u0443\u043f\u0435\u0440\u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u043e\u0440\u0430\u043c\u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u044b<\/param>         [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Security", "CA2100:Review SQL queries for security vulnerabilities")]         public static void CreateSecurityTables(string superAdminGroup = null)         {             List<string> dbTables = new List<string>();             using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[ConnectionStringName].ConnectionString))             {                 using (SqlCommand cmd = new SqlCommand("SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_NAME LIKE 'Authorization_%'", conn))                 {                     try                     {                         conn.Open();                         using (SqlDataReader reader = cmd.ExecuteReader())                         {                             while (reader.Read())                                 dbTables.Add(reader.GetString(0));                         }                         foreach (string securityTable in tables)                             if (dbTables.Contains(securityTable))                                 dbTables.Remove(securityTable);                          cmd.Parameters.AddWithValue("@database", conn.Database);                          if (dbTables.Count == 0)                             foreach (string table in tables)                                 dbTables.Add(table);                          if (dbTables.Count != 0)                              foreach (string table in dbTables)                             {                                 switch (table)                                 {                                     case "Authorization_ControlsGroup":                                         cmd.CommandText = "USE " + conn.Database + @"                                                            SET ANSI_NULLS ON                                                            SET QUOTED_IDENTIFIER ON                                                            SET ANSI_PADDING ON                                                            CREATE TABLE [dbo].[Authorization_ControlsGroup]( \t                                                            [id] [int] IDENTITY(1,1) NOT NULL, \t                                                            [Name] [varchar](500) NOT NULL,                                                              CONSTRAINT [PK_Authorization_ControlsGroup] PRIMARY KEY CLUSTERED                                                              ([id] ASC                                                             )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]                                                             ) ON [PRIMARY]                                                             SET ANSI_PADDING OFF                                                             SET IDENTITY_INSERT [dbo].[Authorization_ControlsGroup] ON                                                             INSERT INTO [dbo].[Authorization_ControlsGroup](id,Name) VALUES(-1,'\u041a\u043e\u043d\u0442\u0440\u043e\u043b\u044b \u0441\u0443\u043f\u0435\u0440\u0430\u0434\u043c\u0438\u043d\u0430')                                                             SET IDENTITY_INSERT [dbo].[Authorization_ControlsGroup] OFF";                                         break;                                     case "Authorization_Actions":                                         cmd.CommandText = "USE " + conn.Database + @"                                                             SET ANSI_NULLS ON                                                             SET QUOTED_IDENTIFIER ON                                                             SET ANSI_PADDING ON                                                             CREATE TABLE [dbo].[Authorization_Actions]( \t                                                            [id] [int] IDENTITY(1,1) NOT NULL, \t                                                            [Name] [varchar](500) NOT NULL, \t                                                            [Active] [bit] NOT NULL,                                                              CONSTRAINT [PK_Authorization_Actions] PRIMARY KEY CLUSTERED                                                              ([id] ASC                                                             )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]                                                             ) ON [PRIMARY]                                                             SET ANSI_PADDING OFF                                                             ALTER TABLE [dbo].[Authorization_Actions] ADD  CONSTRAINT [DF_Authorization_Actions_Active]  DEFAULT ((1)) FOR [Active]";                                         break;                                     case "Authorization_ActionToGroup":                                         cmd.CommandText = "USE " + conn.Database + @"                                                                 SET ANSI_NULLS ON                                                                 SET QUOTED_IDENTIFIER ON                                                                 CREATE TABLE [dbo].[Authorization_ActionToGroup]( \t                                                            [id] [int] IDENTITY(1,1) NOT NULL, \t                                                            [ActionID] [int] NOT NULL, \t                                                            [GroupID] [int] NOT NULL,                                                              CONSTRAINT [PK_Authorization_ActionToGroup] PRIMARY KEY CLUSTERED                                                              ([id] ASC                                                             )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]                                                             ) ON [PRIMARY]";                                         break;                                     case "Authorization_Controls":                                         cmd.CommandText = "USE " + conn.Database + @"                                                                 SET ANSI_NULLS ON                                                                 SET QUOTED_IDENTIFIER ON                                                                 SET ANSI_PADDING ON                                                                 CREATE TABLE [dbo].[Authorization_Controls]( \t                                                            [id] [int] IDENTITY(1,1) NOT NULL, \t                                                            [Name] [varchar](500) NOT NULL,                                                              CONSTRAINT [PK_Authorize_Controls] PRIMARY KEY CLUSTERED                                                              ([id] ASC                                                             )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]                                                             ) ON [PRIMARY]                                                             SET ANSI_PADDING OFF";                                         break;                                     case "Authorization_ControlToGroup":                                         cmd.CommandText = "USE " + conn.Database + @"                                                                SET ANSI_NULLS ON                                                                SET QUOTED_IDENTIFIER ON                                                                CREATE TABLE [dbo].[Authorization_ControlToGroup]( \t                                                            [id] [int] IDENTITY(1,1) NOT NULL, \t                                                            [ControlID] [int] NOT NULL, \t                                                            [GroupID] [int] NOT NULL,                                                              CONSTRAINT [PK_Authorization_ControlToGroup] PRIMARY KEY CLUSTERED                                                              (\t[id] ASC                                                             )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]                                                             ) ON [PRIMARY]";                                         break;                                     case "Authorization_RoleToActionGroup":                                         cmd.CommandText = "USE " + conn.Database + @"                                                              SET ANSI_NULLS ON                                                              SET QUOTED_IDENTIFIER ON                                                              SET ANSI_PADDING ON                                                              CREATE TABLE [dbo].[Authorization_RoleToActionGroup]( \t                                                            [id] [int] IDENTITY(1,1) NOT NULL, \t                                                            [ActionGroup] [int] NOT NULL, \t                                                            [Role] [varchar](500) NOT NULL,                                                              CONSTRAINT [PK_Authorization_RoleToActionGroup] PRIMARY KEY CLUSTERED                                                              ([id] ASC                                                             )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]                                                             ) ON [PRIMARY]                                                             SET ANSI_PADDING OFF                                                             ALTER TABLE [dbo].[Authorization_RoleToActionGroup] ADD  CONSTRAINT [DF_Authorization_RoleToActionGroup_ActionGroup]  DEFAULT ((-1)) FOR [ActionGroup]";                                         break;                                     case "Authorization_RoleToControlGroup":                                         cmd.CommandText = "USE " + conn.Database + @"                                                              SET ANSI_NULLS ON                                                              SET QUOTED_IDENTIFIER ON                                                              CREATE TABLE [dbo].[Authorization_RoleToControlGroup]( \t                                                            [id] [int] IDENTITY(1,1) NOT NULL, \t                                                            [RoleID] [int] NOT NULL, \t                                                            [GroupID] [int] NOT NULL,                                                              CONSTRAINT [PK_Authorization_RoleToControlGroup] PRIMARY KEY CLUSTERED                                                              ([id] ASC                                                             )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]                                                             ) ON [PRIMARY]";                                         break;                                     case "Authorization_ActionGroups":                                         cmd.CommandText = "USE " + conn.Database + @"                                                                SET ANSI_NULLS ON                                                                SET QUOTED_IDENTIFIER ON                                                                SET ANSI_PADDING ON                                                                CREATE TABLE [dbo].[Authorization_ActionGroups]( \t                                                            [id] [int] IDENTITY(1,1) NOT NULL, \t                                                            [Name] [varchar](500) NOT NULL, \t                                                            [active] [bit] NOT NULL,                                                              CONSTRAINT [PK_Authorization_ActionGroups] PRIMARY KEY CLUSTERED                                                              ( \t                                                            [id] ASC                                                             )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]                                                             ) ON [PRIMARY]                                                                SET ANSI_PADDING OFF                                                                ALTER TABLE [dbo].[Authorization_ActionGroups] ADD  CONSTRAINT [DF_Authorization_ActionGroups_active]  DEFAULT ((1)) FOR [active]                                                                SET IDENTITY_INSERT [dbo].[Authorization_ActionGroups] ON                                                                INSERT INTO [dbo].[Authorization_ActionGroups](id,Name) VALUES(0,'\u0412\u0441\u0435 \u0440\u0430\u0437\u0434\u0435\u043b\u044b')                                                                SET IDENTITY_INSERT [dbo].[Authorization_ActionGroups] OFF";                                         break;                                 }                                 cmd.ExecuteNonQuery();                             }                         if (!string.IsNullOrEmpty(superAdminGroup) && Web.Security.Utilization.Authorization.SystemRole.IntranetRoleID(superAdminGroup) != null)                         {                             cmd.CommandText = @"INSERT INTO Authorization_RoleToActionGroup(ActionGroup,Role) VALUES(0,@group)                                                 INSERT INTO Authorization_RoleToControlGroup(RoleID,GroupID) VALUES(@role,-1)";                             cmd.Parameters.Clear();                             cmd.Parameters.AddWithValue("@group", superAdminGroup);                             cmd.Parameters.AddWithValue("@role", Web.Security.Utilization.Authorization.SystemRole.IntranetRoleID(superAdminGroup));                             cmd.ExecuteNonQuery();                         }                                                  }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u0434\u0443\u043b\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438] ", ex);                     }                 }             }         }          public static void RecreateTables(string superAdminGroup = null)         {             string command = "DROP TABLE {0}";             using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[ConnectionStringName].ConnectionString))             {                 using (SqlCommand cmd = new SqlCommand("", conn))                 {                     try                     {                         conn.Open();                         foreach (string table in tables)                         {                             cmd.CommandText = string.Format(command, table);                             cmd.ExecuteNonQuery();                         }                     }                     catch (Exception ex)                     {                         if (Configuration.s_log != null)                             Configuration.s_log.Error("[\u041e\u0448\u0438\u0431\u043a\u0430 \u043c\u043e\u043b\u0443\u0434\u044f \u0430\u0432\u0442\u043e\u0440\u0438\u0437\u0430\u0446\u0438\u0438] [\u041e\u0448\u0438\u0431\u043a\u0430 \u043f\u0435\u0440\u0435\u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446 \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438] ", ex);                     }                 }             }             CreateSecurityTables(superAdminGroup);         }      } } <\/code><\/pre>\n
      <\/div>\n<\/div>\n
      \u042d\u0442\u043e\u0442 \u043a\u043b\u0430\u0441\u0441 \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u0432\u0441\u0435 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0438 \u043a\u0430\u043a \u0431\u043e\u043d\u0443\u0441 \u0444\u0443\u043d\u043a\u0446\u0438\u0438, \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u044b\u0435 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u043c\u043e\u0434\u0443\u043b\u044f.<\/p>\n
      \u041f\u0440\u043e\u0435\u043a\u0442 \u043d\u0430 GitHub<\/a><\/p>\n
    \u0412\u043c\u0435\u0441\u0442\u043e \u0437\u0430\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f<\/h5>\n
      \u041e\u043f\u0438\u0441\u0430\u043d\u043d\u044b\u0439 \u043c\u043d\u043e\u0439 \u043a\u043b\u0430\u0441\u0441 Employee \u0432\u043f\u043e\u043b\u043d\u0435 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043e\u043f\u0443\u0449\u0435\u043d, \u043d\u043e \u0432 \u0441\u0432\u043e\u0438\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445 \u044f \u0447\u0430\u0441\u0442\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e \u0435\u0433\u043e, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u043d\u0435 \u0441\u0442\u0430\u043b \u0443\u0431\u0438\u0440\u0430\u0442\u044c \u0438\u0437 \u043c\u043e\u0434\u0443\u043b\u044f.
      \u0414\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0440\u043e\u043b\u044f\u043c\u0438 \u0431\u044b\u043b \u0441\u043e\u0437\u0434\u0430\u043d \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0438\u0439 \u0431\u044b\u0441\u0442\u0440\u043e \u0438 \u0443\u0434\u043e\u0431\u043d\u043e \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c\/\u0443\u0434\u0430\u043b\u044f\u0442\u044c\/\u043c\u0435\u043d\u044f\u0442\u044c \u0440\u043e\u043b\u0438 \u0438 \u043f\u0440\u0438\u0432\u044f\u0437\u043a\u0438. \u041d\u043e \u043e\u043d \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u043d\u0430 \u0431\u043e\u043b\u0435\u0435 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0440\u0441\u0438\u0438 \u043c\u043e\u0434\u0443\u043b\u044f, \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u0435\u0433\u043e \u044f \u043d\u0435 \u0432\u044b\u043a\u043b\u0430\u0434\u044b\u0432\u0430\u044e.
      \u0415\u0449\u0435 \u0440\u0430\u0437 \u043f\u0440\u043e\u0448\u0443 \u043d\u0435 \u043a\u0438\u0434\u0430\u0442\u044c \u043f\u043e\u043c\u0438\u0434\u043e\u0440\u0430\u043c\u0438. \u0412\u0435\u0441\u044c \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u043d\u044b\u0439 \u043a\u043e\u0434 \u0438 \u043f\u0440\u043e\u0435\u043a\u0442, \u0440\u0430\u0441\u043f\u043e\u043b\u043e\u0436\u0435\u043d\u043d\u044b\u0439 \u043d\u0430 GitHub’\u0435 \u044f\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u043f\u0435\u0440\u0432\u043e\u0439 \u0432\u0435\u0440\u0441\u0438\u0435\u0439 \u0438 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442 \u0431\u043e\u043b\u044c\u0448\u043e\u0435 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0433\u043e\u0432\u043d\u043e\u043a\u043e\u0434\u0430.<\/i>    \t<\/p>\n
    <\/div>\n<\/p><\/div>\n
     \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438  http:\/\/habrahabr.ru\/post\/191218\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
       \t\u041e\u0447\u0435\u043d\u044c \u0447\u0430\u0441\u0442\u043e \u0432 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u044e\u0441\u044c \u0441 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u043e\u0439 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u0440\u0430\u0437\u0434\u0435\u043b\u0430\u043c \u0441\u0430\u0439\u0442\u0430 \u0438 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f.
      \u0421\u043d\u0430\u0447\u0430\u043b\u0430 \u043c\u043d\u0435 \u0445\u0432\u0430\u0442\u0430\u043b\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u043e\u0432, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 ASP MVC \u00ab\u0438\u0437 \u043a\u043e\u0440\u043e\u0431\u043a\u0438\u00bb, \u043d\u043e, \u0441\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u0435\u043c, \u044f \u0441\u0442\u043e\u043b\u043a\u043d\u0443\u043b\u0441\u044f \u0441 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u044c\u044e \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0441\u0432\u043e\u0435\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0430\u0432. \u0415\u0441\u043b\u0438 \u0442\u0435\u0431\u0435, \u0443\u0432\u0430\u0436\u0430\u0435\u043c\u044b\u0439 %habrauser%, \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e \u043a\u0430\u043a \u043c\u043e\u0436\u043d\u043e \u0440\u0435\u0448\u0438\u0442\u044c \u044d\u0442\u0443 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0443, \u0434\u043e\u0431\u0440\u043e \u043f\u043e\u0436\u0430\u043b\u043e\u0432\u0430\u0442\u044c \u043f\u043e\u0434 \u043a\u0430\u0442.  <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-191218","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/191218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=191218"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/191218\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=191218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=191218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=191218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}