Esempio n. 1
0
        public async Task <IPagedResults <File> > SelectAsync(IDbDataParameter[] dbParams)
        {
            IPagedResults <File> output = null;

            using (var context = _dbContext)
            {
                output = await context.ExecuteReaderAsync <IPagedResults <File> >(
                    CommandType.StoredProcedure,
                    "SelectFilesPaged",
                    async reader =>
                {
                    if ((reader != null) && (reader.HasRows))
                    {
                        output = new PagedResults <File>();
                        while (await reader.ReadAsync())
                        {
                            var entity = new Models.File();
                            entity.PopulateModel(reader);
                            output.Data.Add(entity);
                        }

                        if (await reader.NextResultAsync())
                        {
                            await reader.ReadAsync();
                            output.PopulateTotal(reader);
                        }
                    }

                    return(output);
                },
                    dbParams);
            }

            return(output);
        }
Esempio n. 2
0
        public async Task <File> SelectByIdAsync(int id)
        {
            Models.File file = null;
            using (var context = _dbContext)
            {
                file = await context.ExecuteReaderAsync <Models.File>(
                    CommandType.StoredProcedure,
                    "SelectFileById",
                    async reader =>
                {
                    if ((reader != null) && reader.HasRows)
                    {
                        await reader.ReadAsync();
                        file = new Models.File();
                        file.PopulateModel(reader);
                    }

                    return(file);
                }, new IDbDataParameter[]
                {
                    new DbParam("Id", DbType.Int32, id)
                });
            }

            return(file);
        }