public async Task <ActionResult> ExportAppUser([FromBody] Organization_AppUserFilterDTO Organization_AppUserFilterDTO) { if (UnAuthorization) { return(Forbid()); } if (!ModelState.IsValid) { throw new BindException(ModelState); } AppUserFilter AppUserFilter = new AppUserFilter(); AppUserFilter.Skip = 0; AppUserFilter.Take = int.MaxValue; AppUserFilter.Selects = AppUserSelect.Id | AppUserSelect.Username | AppUserSelect.Username | AppUserSelect.Address | AppUserSelect.Phone | AppUserSelect.Sex | AppUserSelect.Birthday | AppUserSelect.Organization | AppUserSelect.Status; AppUserFilter.OrganizationId = Organization_AppUserFilterDTO.OrganizationId; AppUserFilter = AppUserService.ToFilter(AppUserFilter); List <AppUser> AppUsers = await AppUserService.List(AppUserFilter); MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { var AppUserHeaders = new List <string[]>() { new string[] { "STT", "Tên đăng nhập", "Tên hiển thị", "Địa chỉ", "Điện thoại", "Email", "Giới tính", "Ngày sinh", "Đơn vị quản lý", "Trạng thái" } }; List <object[]> data = new List <object[]>(); for (int i = 0; i < AppUsers.Count; i++) { var appUser = AppUsers[i]; data.Add(new Object[] { i + 1, appUser.Username, appUser.DisplayName, appUser.Address, appUser.Phone, appUser.Email, appUser.Sex.Name, appUser.Birthday?.ToString("dd-MM-yyyy"), appUser.Organization.Code, appUser.Status.Name, }); } excel.GenerateWorksheet("Tài khoản", AppUserHeaders, data); excel.Save(); } return(File(memoryStream.ToArray(), "application/octet-stream", "Organization_AppUser" + ".xlsx")); }
public async Task <ActionResult <List <Organization_AppUserDTO> > > SingleListAppUser([FromBody] Organization_AppUserFilterDTO Organization_AppUserFilterDTO) { if (UnAuthorization) { return(Forbid()); } AppUserFilter AppUserFilter = new AppUserFilter(); AppUserFilter.Skip = 0; AppUserFilter.Take = 20; AppUserFilter.OrderBy = AppUserOrder.Id; AppUserFilter.OrderType = OrderType.ASC; AppUserFilter.Selects = AppUserSelect.ALL; AppUserFilter.Id = Organization_AppUserFilterDTO.Id; AppUserFilter.Username = Organization_AppUserFilterDTO.Username; AppUserFilter.Password = Organization_AppUserFilterDTO.Password; AppUserFilter.DisplayName = Organization_AppUserFilterDTO.DisplayName; AppUserFilter.Address = Organization_AppUserFilterDTO.Address; AppUserFilter.Email = Organization_AppUserFilterDTO.Email; AppUserFilter.Phone = Organization_AppUserFilterDTO.Phone; AppUserFilter.Department = Organization_AppUserFilterDTO.Department; AppUserFilter.OrganizationId = Organization_AppUserFilterDTO.OrganizationId; AppUserFilter.SexId = Organization_AppUserFilterDTO.SexId; AppUserFilter.StatusId = new IdFilter { Equal = Enums.StatusEnum.ACTIVE.Id }; //if (AppUserFilter.Id == null) AppUserFilter.Id = new IdFilter(); //AppUserFilter.Id.In = await FilterAppUser(AppUserService, OrganizationService, CurrentContext); List <AppUser> AppUsers = await AppUserService.List(AppUserFilter); List <Organization_AppUserDTO> Organization_AppUserDTOs = AppUsers .Select(x => new Organization_AppUserDTO(x)).ToList(); return(Organization_AppUserDTOs); }