public async Task <FileResult> ExportTemplate([FromBody] TicketSource_TicketSourceFilterDTO TicketSource_TicketSourceFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region TicketSource var TicketSourceHeaders = new List <string[]>() { new string[] { "Id", "Name", "OrderNumber", "StatusId", "Used", } }; List <object[]> TicketSourceData = new List <object[]>(); excel.GenerateWorksheet("TicketSource", TicketSourceHeaders, TicketSourceData); #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", "TicketSource.xlsx")); }
public async Task <ActionResult <int> > Count([FromBody] TicketSource_TicketSourceFilterDTO TicketSource_TicketSourceFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketSourceFilter TicketSourceFilter = ConvertFilterDTOToFilterEntity(TicketSource_TicketSourceFilterDTO); TicketSourceFilter = TicketSourceService.ToFilter(TicketSourceFilter); int count = await TicketSourceService.Count(TicketSourceFilter); return(count); }
private TicketSourceFilter ConvertFilterDTOToFilterEntity(TicketSource_TicketSourceFilterDTO TicketSource_TicketSourceFilterDTO) { TicketSourceFilter TicketSourceFilter = new TicketSourceFilter(); TicketSourceFilter.Selects = TicketSourceSelect.ALL; TicketSourceFilter.Skip = TicketSource_TicketSourceFilterDTO.Skip; TicketSourceFilter.Take = TicketSource_TicketSourceFilterDTO.Take; TicketSourceFilter.OrderBy = TicketSource_TicketSourceFilterDTO.OrderBy; TicketSourceFilter.OrderType = TicketSource_TicketSourceFilterDTO.OrderType; TicketSourceFilter.Id = TicketSource_TicketSourceFilterDTO.Id; TicketSourceFilter.Name = TicketSource_TicketSourceFilterDTO.Name; TicketSourceFilter.OrderNumber = TicketSource_TicketSourceFilterDTO.OrderNumber; TicketSourceFilter.StatusId = TicketSource_TicketSourceFilterDTO.StatusId; TicketSourceFilter.CreatedAt = TicketSource_TicketSourceFilterDTO.CreatedAt; TicketSourceFilter.UpdatedAt = TicketSource_TicketSourceFilterDTO.UpdatedAt; return(TicketSourceFilter); }
public async Task <ActionResult <List <TicketSource_TicketSourceDTO> > > List([FromBody] TicketSource_TicketSourceFilterDTO TicketSource_TicketSourceFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketSourceFilter TicketSourceFilter = ConvertFilterDTOToFilterEntity(TicketSource_TicketSourceFilterDTO); TicketSourceFilter = TicketSourceService.ToFilter(TicketSourceFilter); List <TicketSource> TicketSources = await TicketSourceService.List(TicketSourceFilter); List <TicketSource_TicketSourceDTO> TicketSource_TicketSourceDTOs = TicketSources .Select(c => new TicketSource_TicketSourceDTO(c)).ToList(); return(TicketSource_TicketSourceDTOs); }