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