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"));
}
