public async Task <ActionResult <int> > Count([FromBody] TicketType_TicketTypeFilterDTO TicketType_TicketTypeFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketTypeFilter TicketTypeFilter = ConvertFilterDTOToFilterEntity(TicketType_TicketTypeFilterDTO); TicketTypeFilter = TicketTypeService.ToFilter(TicketTypeFilter); int count = await TicketTypeService.Count(TicketTypeFilter); return(count); }
public async Task <ActionResult <List <TicketType_TicketTypeDTO> > > List([FromBody] TicketType_TicketTypeFilterDTO TicketType_TicketTypeFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketTypeFilter TicketTypeFilter = ConvertFilterDTOToFilterEntity(TicketType_TicketTypeFilterDTO); TicketTypeFilter = TicketTypeService.ToFilter(TicketTypeFilter); List <TicketType> TicketTypes = await TicketTypeService.List(TicketTypeFilter); List <TicketType_TicketTypeDTO> TicketType_TicketTypeDTOs = TicketTypes .Select(c => new TicketType_TicketTypeDTO(c)).ToList(); return(TicketType_TicketTypeDTOs); }
private TicketTypeFilter ConvertFilterDTOToFilterEntity(TicketType_TicketTypeFilterDTO TicketType_TicketTypeFilterDTO) { TicketTypeFilter TicketTypeFilter = new TicketTypeFilter(); TicketTypeFilter.Selects = TicketTypeSelect.ALL; TicketTypeFilter.Skip = TicketType_TicketTypeFilterDTO.Skip; TicketTypeFilter.Take = TicketType_TicketTypeFilterDTO.Take; TicketTypeFilter.OrderBy = TicketType_TicketTypeFilterDTO.OrderBy; TicketTypeFilter.OrderType = TicketType_TicketTypeFilterDTO.OrderType; TicketTypeFilter.Id = TicketType_TicketTypeFilterDTO.Id; TicketTypeFilter.Code = TicketType_TicketTypeFilterDTO.Code; TicketTypeFilter.Name = TicketType_TicketTypeFilterDTO.Name; TicketTypeFilter.ColorCode = TicketType_TicketTypeFilterDTO.ColorCode; TicketTypeFilter.StatusId = TicketType_TicketTypeFilterDTO.StatusId; TicketTypeFilter.CreatedAt = TicketType_TicketTypeFilterDTO.CreatedAt; TicketTypeFilter.UpdatedAt = TicketType_TicketTypeFilterDTO.UpdatedAt; return(TicketTypeFilter); }
public async Task <FileResult> ExportTemplate([FromBody] TicketType_TicketTypeFilterDTO TicketType_TicketTypeFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region TicketType var TicketTypeHeaders = new List <string[]>() { new string[] { "Id", "Code", "Name", "ColorCode", "StatusId", "Used", } }; List <object[]> TicketTypeData = new List <object[]>(); excel.GenerateWorksheet("TicketType", TicketTypeHeaders, TicketTypeData); #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", "TicketType.xlsx")); }