예제 #1
0
        public byte[] GetAllUsersExcel()
        {
            var applicationUsers = _usersDbSet
                                   .Include(user => user.WorkingHours)
                                   .Include(user => user.JobPosition)
                                   .Where(user => user.OrganizationId == 2)
                                   .ToList();

            using (var printer = new ExcelGenerator("Users"))
            {
                printer.CenterColumns(2, 6);
                printer.AddHeaderRow(HeaderRow());

                foreach (var user in applicationUsers)
                {
                    printer.AddRow(UserToUserRow(user));
                }

                return(printer.Generate());
            }
        }