private KnowledgeArticleFilter ConvertFilterDTOToFilterEntity(KnowledgeArticle_KnowledgeArticleFilterDTO KnowledgeArticle_KnowledgeArticleFilterDTO)
{
KnowledgeArticleFilter KnowledgeArticleFilter = new KnowledgeArticleFilter();
KnowledgeArticleFilter.Selects = KnowledgeArticleSelect.ALL;
KnowledgeArticleFilter.Skip = KnowledgeArticle_KnowledgeArticleFilterDTO.Skip;
KnowledgeArticleFilter.Take = KnowledgeArticle_KnowledgeArticleFilterDTO.Take;
KnowledgeArticleFilter.OrderBy = KnowledgeArticle_KnowledgeArticleFilterDTO.OrderBy;
KnowledgeArticleFilter.OrderType = KnowledgeArticle_KnowledgeArticleFilterDTO.OrderType;
KnowledgeArticleFilter.Id = KnowledgeArticle_KnowledgeArticleFilterDTO.Id;
KnowledgeArticleFilter.Title = KnowledgeArticle_KnowledgeArticleFilterDTO.Title;
KnowledgeArticleFilter.Detail = KnowledgeArticle_KnowledgeArticleFilterDTO.Detail;
KnowledgeArticleFilter.StatusId = KnowledgeArticle_KnowledgeArticleFilterDTO.StatusId;
KnowledgeArticleFilter.GroupId = KnowledgeArticle_KnowledgeArticleFilterDTO.GroupId;
KnowledgeArticleFilter.CreatorId = KnowledgeArticle_KnowledgeArticleFilterDTO.CreatorId;
KnowledgeArticleFilter.DisplayOrder = KnowledgeArticle_KnowledgeArticleFilterDTO.DisplayOrder;
KnowledgeArticleFilter.CreatedAt = KnowledgeArticle_KnowledgeArticleFilterDTO.CreatedAt;
KnowledgeArticleFilter.UpdatedAt = KnowledgeArticle_KnowledgeArticleFilterDTO.UpdatedAt;
KnowledgeArticleFilter.FromDate = KnowledgeArticle_KnowledgeArticleFilterDTO.FromDate;
KnowledgeArticleFilter.ToDate = KnowledgeArticle_KnowledgeArticleFilterDTO.ToDate;
KnowledgeArticleFilter.ItemId = KnowledgeArticle_KnowledgeArticleFilterDTO.ItemId;
KnowledgeArticleFilter.KMSStatusId = KnowledgeArticle_KnowledgeArticleFilterDTO.KMSStatusId;
KnowledgeArticleFilter.OrganizationId = KnowledgeArticle_KnowledgeArticleFilterDTO.OrganizationId;
return(KnowledgeArticleFilter);
}
public async Task <ActionResult <int> > Count([FromBody] KnowledgeArticle_KnowledgeArticleFilterDTO KnowledgeArticle_KnowledgeArticleFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
KnowledgeArticleFilter KnowledgeArticleFilter = ConvertFilterDTOToFilterEntity(KnowledgeArticle_KnowledgeArticleFilterDTO);
KnowledgeArticleFilter = await KnowledgeArticleService.ToFilter(KnowledgeArticleFilter);
int count = await KnowledgeArticleService.Count(KnowledgeArticleFilter);
return(count);
}
public async Task <ActionResult <List <KnowledgeArticle_KnowledgeArticleDTO> > > List([FromBody] KnowledgeArticle_KnowledgeArticleFilterDTO KnowledgeArticle_KnowledgeArticleFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
KnowledgeArticleFilter KnowledgeArticleFilter = ConvertFilterDTOToFilterEntity(KnowledgeArticle_KnowledgeArticleFilterDTO);
KnowledgeArticleFilter = await KnowledgeArticleService.ToFilter(KnowledgeArticleFilter);
List <KnowledgeArticle> KnowledgeArticles = await KnowledgeArticleService.List(KnowledgeArticleFilter);
List <KnowledgeArticle_KnowledgeArticleDTO> KnowledgeArticle_KnowledgeArticleDTOs = KnowledgeArticles
.Select(c => new KnowledgeArticle_KnowledgeArticleDTO(c)).ToList();
return(KnowledgeArticle_KnowledgeArticleDTOs);
}
public async Task <ActionResult> ExportTemplate([FromBody] KnowledgeArticle_KnowledgeArticleFilterDTO KnowledgeArticle_KnowledgeArticleFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
MemoryStream memoryStream = new MemoryStream();
using (ExcelPackage excel = new ExcelPackage(memoryStream))
{
#region KnowledgeArticle
var KnowledgeArticleHeaders = new List <string[]>()
{
new string[] {
"Id",
"Title",
"Detail",
"StatusId",
"GroupId",
"CreatorId",
"DisplayOrder",
}
};
List <object[]> KnowledgeArticleData = new List <object[]>();
excel.GenerateWorksheet("KnowledgeArticle", KnowledgeArticleHeaders, KnowledgeArticleData);
#endregion
#region AppUser
var AppUserFilter = new AppUserFilter();
AppUserFilter.Selects = AppUserSelect.ALL;
AppUserFilter.OrderBy = AppUserOrder.Id;
AppUserFilter.OrderType = OrderType.ASC;
AppUserFilter.Skip = 0;
AppUserFilter.Take = int.MaxValue;
List <AppUser> AppUsers = await AppUserService.List(AppUserFilter);
var AppUserHeaders = new List <string[]>()
{
new string[] {
"Id",
"Username",
"DisplayName",
"Address",
"Email",
"Phone",
"SexId",
"Birthday",
"Avatar",
"PositionId",
"Department",
"OrganizationId",
"ProvinceId",
"Longitude",
"Latitude",
"StatusId",
}
};
List <object[]> AppUserData = new List <object[]>();
for (int i = 0; i < AppUsers.Count; i++)
{
var AppUser = AppUsers[i];
AppUserData.Add(new Object[]
{
AppUser.Id,
AppUser.Username,
AppUser.DisplayName,
AppUser.Address,
AppUser.Email,
AppUser.Phone,
AppUser.SexId,
AppUser.Birthday,
AppUser.Avatar,
AppUser.PositionId,
AppUser.Department,
AppUser.OrganizationId,
AppUser.ProvinceId,
AppUser.Longitude,
AppUser.Latitude,
AppUser.StatusId,
});
}
excel.GenerateWorksheet("AppUser", AppUserHeaders, AppUserData);
#endregion
#region KnowledgeGroup
var KnowledgeGroupFilter = new KnowledgeGroupFilter();
KnowledgeGroupFilter.Selects = KnowledgeGroupSelect.ALL;
KnowledgeGroupFilter.OrderBy = KnowledgeGroupOrder.Id;
KnowledgeGroupFilter.OrderType = OrderType.ASC;
KnowledgeGroupFilter.Skip = 0;
KnowledgeGroupFilter.Take = int.MaxValue;
List <KnowledgeGroup> KnowledgeGroups = await KnowledgeGroupService.List(KnowledgeGroupFilter);
var KnowledgeGroupHeaders = new List <string[]>()
{
new string[] {
"Id",
"Name",
"Code",
"StatusId",
"DisplayOrder",
"Description",
}
};
List <object[]> KnowledgeGroupData = new List <object[]>();
for (int i = 0; i < KnowledgeGroups.Count; i++)
{
var KnowledgeGroup = KnowledgeGroups[i];
KnowledgeGroupData.Add(new Object[]
{
KnowledgeGroup.Id,
KnowledgeGroup.Name,
KnowledgeGroup.Code,
KnowledgeGroup.StatusId,
KnowledgeGroup.DisplayOrder,
KnowledgeGroup.Description,
});
}
excel.GenerateWorksheet("KnowledgeGroup", KnowledgeGroupHeaders, KnowledgeGroupData);
#endregion
#region Status
var StatusFilter = new StatusFilter();
StatusFilter.Selects = StatusSelect.ALL;
StatusFilter.OrderBy = StatusOrder.Id;
StatusFilter.OrderType = OrderType.ASC;
StatusFilter.Skip = 0;
StatusFilter.Take = int.MaxValue;
List <Status> Statuses = await StatusService.List(StatusFilter);
var StatusHeaders = new List <string[]>()
{
new string[] {
"Id",
"Code",
"Name",
}
};
List <object[]> StatusData = new List <object[]>();
for (int i = 0; i < Statuses.Count; i++)
{
var Status = Statuses[i];
StatusData.Add(new Object[]
{
Status.Id,
Status.Code,
Status.Name,
});
}
excel.GenerateWorksheet("Status", StatusHeaders, StatusData);
#endregion
excel.Save();
}
return(File(memoryStream.ToArray(), "application/octet-stream", "KnowledgeArticle.xlsx"));
}
