public async Task <ActionResult <int> > Count([FromBody] KnowledgeGroup_KnowledgeGroupFilterDTO KnowledgeGroup_KnowledgeGroupFilterDTO) { if (UnAuthorization) { return(Forbid()); } if (!ModelState.IsValid) { throw new BindException(ModelState); } KnowledgeGroupFilter KnowledgeGroupFilter = ConvertFilterDTOToFilterEntity(KnowledgeGroup_KnowledgeGroupFilterDTO); KnowledgeGroupFilter = KnowledgeGroupService.ToFilter(KnowledgeGroupFilter); int count = await KnowledgeGroupService.Count(KnowledgeGroupFilter); return(count); }
private KnowledgeGroupFilter ConvertFilterDTOToFilterEntity(KnowledgeGroup_KnowledgeGroupFilterDTO KnowledgeGroup_KnowledgeGroupFilterDTO) { KnowledgeGroupFilter KnowledgeGroupFilter = new KnowledgeGroupFilter(); KnowledgeGroupFilter.Selects = KnowledgeGroupSelect.ALL; KnowledgeGroupFilter.Skip = KnowledgeGroup_KnowledgeGroupFilterDTO.Skip; KnowledgeGroupFilter.Take = KnowledgeGroup_KnowledgeGroupFilterDTO.Take; KnowledgeGroupFilter.OrderBy = KnowledgeGroup_KnowledgeGroupFilterDTO.OrderBy; KnowledgeGroupFilter.OrderType = KnowledgeGroup_KnowledgeGroupFilterDTO.OrderType; KnowledgeGroupFilter.Id = KnowledgeGroup_KnowledgeGroupFilterDTO.Id; KnowledgeGroupFilter.Name = KnowledgeGroup_KnowledgeGroupFilterDTO.Name; KnowledgeGroupFilter.Code = KnowledgeGroup_KnowledgeGroupFilterDTO.Code; KnowledgeGroupFilter.StatusId = KnowledgeGroup_KnowledgeGroupFilterDTO.StatusId; KnowledgeGroupFilter.DisplayOrder = KnowledgeGroup_KnowledgeGroupFilterDTO.DisplayOrder; KnowledgeGroupFilter.Description = KnowledgeGroup_KnowledgeGroupFilterDTO.Description; KnowledgeGroupFilter.CreatedAt = KnowledgeGroup_KnowledgeGroupFilterDTO.CreatedAt; KnowledgeGroupFilter.UpdatedAt = KnowledgeGroup_KnowledgeGroupFilterDTO.UpdatedAt; return(KnowledgeGroupFilter); }
public async Task <ActionResult <List <KnowledgeGroup_KnowledgeGroupDTO> > > List([FromBody] KnowledgeGroup_KnowledgeGroupFilterDTO KnowledgeGroup_KnowledgeGroupFilterDTO) { if (UnAuthorization) { return(Forbid()); } if (!ModelState.IsValid) { throw new BindException(ModelState); } KnowledgeGroupFilter KnowledgeGroupFilter = ConvertFilterDTOToFilterEntity(KnowledgeGroup_KnowledgeGroupFilterDTO); KnowledgeGroupFilter = KnowledgeGroupService.ToFilter(KnowledgeGroupFilter); List <KnowledgeGroup> KnowledgeGroups = await KnowledgeGroupService.List(KnowledgeGroupFilter); List <KnowledgeGroup_KnowledgeGroupDTO> KnowledgeGroup_KnowledgeGroupDTOs = KnowledgeGroups .Select(c => new KnowledgeGroup_KnowledgeGroupDTO(c)).ToList(); return(KnowledgeGroup_KnowledgeGroupDTOs); }
public async Task <FileResult> ExportTemplate([FromBody] KnowledgeGroup_KnowledgeGroupFilterDTO KnowledgeGroup_KnowledgeGroupFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region KnowledgeGroup var KnowledgeGroupHeaders = new List <string[]>() { new string[] { "Id", "Name", "Code", "StatusId", "DisplayOrder", "Description", } }; List <object[]> KnowledgeGroupData = new List <object[]>(); 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", "KnowledgeGroup.xlsx")); }