private CheckingStatusFilter ConvertFilterDTOToFilterEntity(CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO) { CheckingStatusFilter CheckingStatusFilter = new CheckingStatusFilter(); CheckingStatusFilter.Selects = CheckingStatusSelect.ALL; CheckingStatusFilter.Skip = CheckingStatus_CheckingStatusFilterDTO.Skip; CheckingStatusFilter.Take = CheckingStatus_CheckingStatusFilterDTO.Take; CheckingStatusFilter.OrderBy = CheckingStatus_CheckingStatusFilterDTO.OrderBy; CheckingStatusFilter.OrderType = CheckingStatus_CheckingStatusFilterDTO.OrderType; CheckingStatusFilter.Id = CheckingStatus_CheckingStatusFilterDTO.Id; CheckingStatusFilter.Code = CheckingStatus_CheckingStatusFilterDTO.Code; CheckingStatusFilter.Name = CheckingStatus_CheckingStatusFilterDTO.Name; return(CheckingStatusFilter); }
public async Task <ActionResult <int> > Count([FromBody] CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } CheckingStatusFilter CheckingStatusFilter = ConvertFilterDTOToFilterEntity(CheckingStatus_CheckingStatusFilterDTO); CheckingStatusFilter = await CheckingStatusService.ToFilter(CheckingStatusFilter); int count = await CheckingStatusService.Count(CheckingStatusFilter); return(count); }
public async Task <ActionResult> Export([FromBody] CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region CheckingStatus var CheckingStatusFilter = ConvertFilterDTOToFilterEntity(CheckingStatus_CheckingStatusFilterDTO); CheckingStatusFilter.Skip = 0; CheckingStatusFilter.Take = int.MaxValue; CheckingStatusFilter = await CheckingStatusService.ToFilter(CheckingStatusFilter); List <CheckingStatus> CheckingStatuses = await CheckingStatusService.List(CheckingStatusFilter); var CheckingStatusHeaders = new List <string[]>() { new string[] { "Id", "Code", "Name", } }; List <object[]> CheckingStatusData = new List <object[]>(); for (int i = 0; i < CheckingStatuses.Count; i++) { var CheckingStatus = CheckingStatuses[i]; CheckingStatusData.Add(new Object[] { CheckingStatus.Id, CheckingStatus.Code, CheckingStatus.Name, }); } excel.GenerateWorksheet("CheckingStatus", CheckingStatusHeaders, CheckingStatusData); #endregion excel.Save(); } return(File(memoryStream.ToArray(), "application/octet-stream", "CheckingStatus.xlsx")); }
public async Task <ActionResult> ExportTemplate([FromBody] CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } string path = "Templates/CheckingStatus_Template.xlsx"; byte[] arr = System.IO.File.ReadAllBytes(path); MemoryStream input = new MemoryStream(arr); MemoryStream output = new MemoryStream(); dynamic Data = new ExpandoObject(); using (var document = StaticParams.DocumentFactory.Open(input, output, "xlsx")) { document.Process(Data); }; return(File(output.ToArray(), "application/octet-stream", "CheckingStatus.xlsx")); }
public async Task <ActionResult <List <CheckingStatus_CheckingStatusDTO> > > List([FromBody] CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } CheckingStatusFilter CheckingStatusFilter = ConvertFilterDTOToFilterEntity(CheckingStatus_CheckingStatusFilterDTO); CheckingStatusFilter = await CheckingStatusService.ToFilter(CheckingStatusFilter); List <CheckingStatus> CheckingStatuses = await CheckingStatusService.List(CheckingStatusFilter); List <CheckingStatus_CheckingStatusDTO> CheckingStatus_CheckingStatusDTOs = CheckingStatuses .Select(c => new CheckingStatus_CheckingStatusDTO(c)).ToList(); return(CheckingStatus_CheckingStatusDTOs); }