public async Task <ActionResult <int> > Count([FromBody] TicketStatus_TicketStatusFilterDTO TicketStatus_TicketStatusFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketStatusFilter TicketStatusFilter = ConvertFilterDTOToFilterEntity(TicketStatus_TicketStatusFilterDTO); TicketStatusFilter = TicketStatusService.ToFilter(TicketStatusFilter); int count = await TicketStatusService.Count(TicketStatusFilter); return(count); }
private TicketStatusFilter ConvertFilterDTOToFilterEntity(TicketStatus_TicketStatusFilterDTO TicketStatus_TicketStatusFilterDTO) { TicketStatusFilter TicketStatusFilter = new TicketStatusFilter(); TicketStatusFilter.Selects = TicketStatusSelect.ALL; TicketStatusFilter.Skip = TicketStatus_TicketStatusFilterDTO.Skip; TicketStatusFilter.Take = TicketStatus_TicketStatusFilterDTO.Take; TicketStatusFilter.OrderBy = TicketStatus_TicketStatusFilterDTO.OrderBy; TicketStatusFilter.OrderType = TicketStatus_TicketStatusFilterDTO.OrderType; TicketStatusFilter.Id = TicketStatus_TicketStatusFilterDTO.Id; TicketStatusFilter.Name = TicketStatus_TicketStatusFilterDTO.Name; TicketStatusFilter.OrderNumber = TicketStatus_TicketStatusFilterDTO.OrderNumber; TicketStatusFilter.ColorCode = TicketStatus_TicketStatusFilterDTO.ColorCode; TicketStatusFilter.StatusId = TicketStatus_TicketStatusFilterDTO.StatusId; TicketStatusFilter.CreatedAt = TicketStatus_TicketStatusFilterDTO.CreatedAt; TicketStatusFilter.UpdatedAt = TicketStatus_TicketStatusFilterDTO.UpdatedAt; return(TicketStatusFilter); }
public async Task <ActionResult <List <TicketStatus_TicketStatusDTO> > > List([FromBody] TicketStatus_TicketStatusFilterDTO TicketStatus_TicketStatusFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketStatusFilter TicketStatusFilter = ConvertFilterDTOToFilterEntity(TicketStatus_TicketStatusFilterDTO); TicketStatusFilter = TicketStatusService.ToFilter(TicketStatusFilter); List <TicketStatus> TicketStatuses = await TicketStatusService.List(TicketStatusFilter); List <TicketStatus_TicketStatusDTO> TicketStatus_TicketStatusDTOs = TicketStatuses .Select(c => new TicketStatus_TicketStatusDTO(c)).ToList(); return(TicketStatus_TicketStatusDTOs); }
public async Task <FileResult> ExportTemplate([FromBody] TicketStatus_TicketStatusFilterDTO TicketStatus_TicketStatusFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region TicketStatus var TicketStatusHeaders = new List <string[]>() { new string[] { "Id", "Name", "OrderNumber", "ColorCode", "StatusId", "Used", } }; List <object[]> TicketStatusData = new List <object[]>(); excel.GenerateWorksheet("TicketStatus", TicketStatusHeaders, TicketStatusData); #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", "TicketStatus.xlsx")); }