Ejemplo n.º 1
0
        async Task _getReadersTestAsync()
        {
            using (FileLogger l = new FileLogger("MdbContextTest", new FileLogSettings()
            {
                DateFolderMask = "yyyy-MM-dd"
            }))
            {
                MdbContextOptions.GetOptions().CommandTimeout = 120;
                using (var ctx = new MdbContext(_cn))
                {
                    l.Debug("Test 1 Start ");
                    int i   = 0;
                    var drs = await ctx.GetReadersAsync(@"
						Select * From PayDocs Where Handle = @handle;
						Select * From PayDocs Where Handle = @handle1
						Select * From PayDocs Where Handle = @handle1+1"                        ,
                                                        new MdbParameter("@handle", 3999750),
                                                        new MdbParameter("@handle1", 3999751)
                                                        );

                    foreach (var dr in drs)
                    {
                        using (dr)
                        {
                            for (; dr.Read(); i++)
                            {
                                l.Debug(dr.GetRowJSON());
                            }
                        }
                    }
                    l.Debug($"Test 1 Finish rows result {i}");
                }
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Null - if login not found no catalog
        /// </summary>
        /// <param name="login"></param>
        /// <returns></returns>
        public virtual async Task <UserInfo> GetUserInfoAsync(string login)
        {
            var dr = await mdb.GetReadersAsync(_sql_get_user_info_2.ToFormat(login));

            UserInfo ui = null;

            if (dr[0].Read())
            {
                ui = JsonSerializer.DeserializeObject <UserInfo>((string)dr[0]["JData"]);
                ui.StructuralUnitID = (int)dr[0]["StructuralUnitID"];
                ui.AccessLevelID    = (int)dr[0]["AccessLevelID"];
                ui.PersonID         = dr[0]["PersonID"].CastAs <int>();
                ui.DomainName       = (string)dr[0]["DomainName"];
                ui.Name             = (string)dr[0]["Name"];
                ui.Roles.Clear();
                ui.UserPermissions.Clear();

                if (dr[1].Read())
                {
                    ui.Roles.Add((string)dr[1]["RoleName"]);
                }

                for (; dr[2].Read();)
                {
                    ui.UserPermissions.Add(new Permission()
                    {
                        ActionID   = (string)dr[2]["ActionID"],
                        ObjectName = (string)dr[2]["ObjectName"],
                        RoleID     = (string)dr[2]["RoleID"],
                        IsGranted  = (bool)dr[2]["IsGranted"]
                    });
                }
            }
            dr[0].Dispose();
            dr[1].Dispose();
            dr[2].Dispose();
            return(ui);
        }