public async Task <ActionResult <int> > Count([FromBody] TicketPriority_TicketPriorityFilterDTO TicketPriority_TicketPriorityFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
TicketPriorityFilter TicketPriorityFilter = ConvertFilterDTOToFilterEntity(TicketPriority_TicketPriorityFilterDTO);
TicketPriorityFilter = TicketPriorityService.ToFilter(TicketPriorityFilter);
int count = await TicketPriorityService.Count(TicketPriorityFilter);
return(count);
}
private TicketPriorityFilter ConvertFilterDTOToFilterEntity(TicketPriority_TicketPriorityFilterDTO TicketPriority_TicketPriorityFilterDTO)
{
TicketPriorityFilter TicketPriorityFilter = new TicketPriorityFilter();
TicketPriorityFilter.Selects = TicketPrioritySelect.ALL;
TicketPriorityFilter.Skip = TicketPriority_TicketPriorityFilterDTO.Skip;
TicketPriorityFilter.Take = TicketPriority_TicketPriorityFilterDTO.Take;
TicketPriorityFilter.OrderBy = TicketPriority_TicketPriorityFilterDTO.OrderBy;
TicketPriorityFilter.OrderType = TicketPriority_TicketPriorityFilterDTO.OrderType;
TicketPriorityFilter.Id = TicketPriority_TicketPriorityFilterDTO.Id;
TicketPriorityFilter.Name = TicketPriority_TicketPriorityFilterDTO.Name;
TicketPriorityFilter.OrderNumber = TicketPriority_TicketPriorityFilterDTO.OrderNumber;
TicketPriorityFilter.ColorCode = TicketPriority_TicketPriorityFilterDTO.ColorCode;
TicketPriorityFilter.StatusId = TicketPriority_TicketPriorityFilterDTO.StatusId;
TicketPriorityFilter.CreatedAt = TicketPriority_TicketPriorityFilterDTO.CreatedAt;
TicketPriorityFilter.UpdatedAt = TicketPriority_TicketPriorityFilterDTO.UpdatedAt;
return(TicketPriorityFilter);
}
public async Task <ActionResult <List <TicketPriority_TicketPriorityDTO> > > List([FromBody] TicketPriority_TicketPriorityFilterDTO TicketPriority_TicketPriorityFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
TicketPriorityFilter TicketPriorityFilter = ConvertFilterDTOToFilterEntity(TicketPriority_TicketPriorityFilterDTO);
TicketPriorityFilter = TicketPriorityService.ToFilter(TicketPriorityFilter);
List <TicketPriority> TicketPriorities = await TicketPriorityService.List(TicketPriorityFilter);
List <TicketPriority_TicketPriorityDTO> TicketPriority_TicketPriorityDTOs = TicketPriorities
.Select(c => new TicketPriority_TicketPriorityDTO(c)).ToList();
return(TicketPriority_TicketPriorityDTOs);
}
public async Task <FileResult> ExportTemplate([FromBody] TicketPriority_TicketPriorityFilterDTO TicketPriority_TicketPriorityFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
MemoryStream memoryStream = new MemoryStream();
using (ExcelPackage excel = new ExcelPackage(memoryStream))
{
#region TicketPriority
var TicketPriorityHeaders = new List <string[]>()
{
new string[] {
"Id",
"Name",
"OrderNumber",
"ColorCode",
"StatusId",
"Used",
}
};
List <object[]> TicketPriorityData = new List <object[]>();
excel.GenerateWorksheet("TicketPriority", TicketPriorityHeaders, TicketPriorityData);
#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", "TicketPriority.xlsx"));
}
