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