private AppUserFilter ConvertFilterDTOToFilterEntity(AppUser_AppUserFilterDTO AppUser_AppUserFilterDTO)
{
AppUserFilter AppUserFilter = new AppUserFilter();
AppUserFilter.Selects = AppUserSelect.ALL;
AppUserFilter.Skip = AppUser_AppUserFilterDTO.Skip;
AppUserFilter.Take = AppUser_AppUserFilterDTO.Take;
AppUserFilter.OrderBy = AppUser_AppUserFilterDTO.OrderBy;
AppUserFilter.OrderType = AppUser_AppUserFilterDTO.OrderType;
AppUserFilter.Id = AppUser_AppUserFilterDTO.Id;
AppUserFilter.Username = AppUser_AppUserFilterDTO.Username;
AppUserFilter.Password = AppUser_AppUserFilterDTO.Password;
AppUserFilter.DisplayName = AppUser_AppUserFilterDTO.DisplayName;
AppUserFilter.Address = AppUser_AppUserFilterDTO.Address;
AppUserFilter.Email = AppUser_AppUserFilterDTO.Email;
AppUserFilter.Phone = AppUser_AppUserFilterDTO.Phone;
AppUserFilter.PositionId = AppUser_AppUserFilterDTO.PositionId;
AppUserFilter.Department = AppUser_AppUserFilterDTO.Department;
AppUserFilter.OrganizationId = AppUser_AppUserFilterDTO.OrganizationId;
AppUserFilter.ERouteScopeId = AppUser_AppUserFilterDTO.ERouteScopeId;
AppUserFilter.SexId = AppUser_AppUserFilterDTO.SexId;
AppUserFilter.StatusId = AppUser_AppUserFilterDTO.StatusId;
AppUserFilter.ProvinceId = AppUser_AppUserFilterDTO.ProvinceId;
return(AppUserFilter);
}
public async Task <ActionResult <int> > Count([FromBody] AppUser_AppUserFilterDTO AppUser_AppUserFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
AppUserFilter AppUserFilter = ConvertFilterDTOToFilterEntity(AppUser_AppUserFilterDTO);
AppUserFilter = AppUserService.ToFilter(AppUserFilter);
int count = await AppUserService.Count(AppUserFilter);
return(count);
}
public async Task <ActionResult <List <AppUser_AppUserDTO> > > List([FromBody] AppUser_AppUserFilterDTO AppUser_AppUserFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
AppUserFilter AppUserFilter = ConvertFilterDTOToFilterEntity(AppUser_AppUserFilterDTO);
AppUserFilter = AppUserService.ToFilter(AppUserFilter);
List <AppUser> AppUsers = await AppUserService.List(AppUserFilter);
List <AppUser_AppUserDTO> AppUser_AppUserDTOs = AppUsers
.Select(c => new AppUser_AppUserDTO(c)).ToList();
return(AppUser_AppUserDTOs);
}
public async Task <FileResult> Export([FromBody] AppUser_AppUserFilterDTO AppUser_AppUserFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
var AppUserFilter = ConvertFilterDTOToFilterEntity(AppUser_AppUserFilterDTO);
AppUserFilter.Skip = 0;
AppUserFilter.Take = int.MaxValue;
AppUserFilter.Selects = AppUserSelect.ALL;
AppUserFilter = AppUserService.ToFilter(AppUserFilter);
List <AppUser> AppUsers = await AppUserService.List(AppUserFilter);
List <Organization> Organizations = await OrganizationService.List(new OrganizationFilter
{
Skip = 0,
Take = int.MaxValue,
Selects = OrganizationSelect.Code | OrganizationSelect.Name,
OrderType = OrderType.ASC,
OrderBy = OrganizationOrder.Id,
});
List <Sex> Sexes = await SexService.List(new SexFilter
{
Skip = 0,
Take = int.MaxValue,
Selects = SexSelect.ALL
});
List <Role> Roles = await RoleService.List(new RoleFilter
{
Skip = 0,
Take = int.MaxValue,
Selects = RoleSelect.Code | RoleSelect.Name
});
MemoryStream memoryStream = new MemoryStream();
using (ExcelPackage excel = new ExcelPackage(memoryStream))
{
#region Appuser sheet
var AppUserHeaders = new List <string[]>()
{
new string[] { "STT", "Mã nhân viên", "Tên nhân viên", "Địa chỉ", "Điện thọi", "Email", "Giới tính", "Chức vụ", "Phòng ban", "Bộ phận quản lý" }
};
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.Position,
appUser.Department,
appUser.Organization.Code
});
}
excel.GenerateWorksheet("AppUser", AppUserHeaders, data);
#endregion
#region Org sheet
data.Clear();
var OrganizationHeader = new List <string[]>()
{
new string[]
{
"Mã",
"Tên"
}
};
foreach (var Organization in Organizations)
{
data.Add(new object[]
{
Organization.Code,
Organization.Name,
});
}
excel.GenerateWorksheet("Organization", OrganizationHeader, data);
#endregion
#region Sex sheet
data.Clear();
var SexHeader = new List <string[]>()
{
new string[]
{
"Mã",
"Tên"
}
};
foreach (var Sex in Sexes)
{
data.Add(new object[]
{
Sex.Code,
Sex.Name,
});
}
excel.GenerateWorksheet("Sex", SexHeader, data);
#endregion
#region Role sheet
data.Clear();
var RoleHeader = new List <string[]>()
{
new string[]
{
"Mã",
"Tên"
}
};
foreach (var Role in Roles)
{
data.Add(new object[]
{
Role.Code,
Role.Name,
});
}
excel.GenerateWorksheet("Role", RoleHeader, data);
#endregion
excel.Save();
}
return(File(memoryStream.ToArray(), "application/octet-stream", "AppUser.xlsx"));
}
