public async Task <ActionResult <int> > Count([FromBody] TicketGroup_TicketGroupFilterDTO TicketGroup_TicketGroupFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketGroupFilter TicketGroupFilter = ConvertFilterDTOToFilterEntity(TicketGroup_TicketGroupFilterDTO); TicketGroupFilter = TicketGroupService.ToFilter(TicketGroupFilter); int count = await TicketGroupService.Count(TicketGroupFilter); return(count); }
public async Task <ActionResult <List <TicketGroup_TicketGroupDTO> > > List([FromBody] TicketGroup_TicketGroupFilterDTO TicketGroup_TicketGroupFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } TicketGroupFilter TicketGroupFilter = ConvertFilterDTOToFilterEntity(TicketGroup_TicketGroupFilterDTO); TicketGroupFilter = TicketGroupService.ToFilter(TicketGroupFilter); List <TicketGroup> TicketGroups = await TicketGroupService.List(TicketGroupFilter); List <TicketGroup_TicketGroupDTO> TicketGroup_TicketGroupDTOs = TicketGroups .Select(c => new TicketGroup_TicketGroupDTO(c)).ToList(); return(TicketGroup_TicketGroupDTOs); }
private TicketGroupFilter ConvertFilterDTOToFilterEntity(TicketGroup_TicketGroupFilterDTO TicketGroup_TicketGroupFilterDTO) { TicketGroupFilter TicketGroupFilter = new TicketGroupFilter(); TicketGroupFilter.Selects = TicketGroupSelect.ALL; TicketGroupFilter.Skip = TicketGroup_TicketGroupFilterDTO.Skip; TicketGroupFilter.Take = TicketGroup_TicketGroupFilterDTO.Take; TicketGroupFilter.OrderBy = TicketGroup_TicketGroupFilterDTO.OrderBy; TicketGroupFilter.OrderType = TicketGroup_TicketGroupFilterDTO.OrderType; TicketGroupFilter.Id = TicketGroup_TicketGroupFilterDTO.Id; TicketGroupFilter.Name = TicketGroup_TicketGroupFilterDTO.Name; TicketGroupFilter.OrderNumber = TicketGroup_TicketGroupFilterDTO.OrderNumber; TicketGroupFilter.StatusId = TicketGroup_TicketGroupFilterDTO.StatusId; TicketGroupFilter.TicketTypeId = TicketGroup_TicketGroupFilterDTO.TicketTypeId; TicketGroupFilter.CreatedAt = TicketGroup_TicketGroupFilterDTO.CreatedAt; TicketGroupFilter.UpdatedAt = TicketGroup_TicketGroupFilterDTO.UpdatedAt; return(TicketGroupFilter); }
public async Task <FileResult> ExportTemplate([FromBody] TicketGroup_TicketGroupFilterDTO TicketGroup_TicketGroupFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region TicketGroup var TicketGroupHeaders = new List <string[]>() { new string[] { "Id", "Name", "OrderNumber", "StatusId", "TicketTypeId", "Used", } }; List <object[]> TicketGroupData = new List <object[]>(); excel.GenerateWorksheet("TicketGroup", TicketGroupHeaders, TicketGroupData); #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 #region TicketType var TicketTypeFilter = new TicketTypeFilter(); TicketTypeFilter.Selects = TicketTypeSelect.ALL; TicketTypeFilter.OrderBy = TicketTypeOrder.Id; TicketTypeFilter.OrderType = OrderType.ASC; TicketTypeFilter.Skip = 0; TicketTypeFilter.Take = int.MaxValue; List <TicketType> TicketTypes = await TicketTypeService.List(TicketTypeFilter); var TicketTypeHeaders = new List <string[]>() { new string[] { "Id", "Code", "Name", "ColorCode", "StatusId", "Used", } }; List <object[]> TicketTypeData = new List <object[]>(); for (int i = 0; i < TicketTypes.Count; i++) { var TicketType = TicketTypes[i]; TicketTypeData.Add(new Object[] { TicketType.Id, TicketType.Code, TicketType.Name, TicketType.ColorCode, TicketType.StatusId, TicketType.Used, }); } excel.GenerateWorksheet("TicketType", TicketTypeHeaders, TicketTypeData); #endregion excel.Save(); } return(File(memoryStream.ToArray(), "application/octet-stream", "TicketGroup.xlsx")); }