public async Task <ActionResult <int> > Count([FromBody] TicketIssueLevel_TicketIssueLevelFilterDTO TicketIssueLevel_TicketIssueLevelFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
TicketIssueLevelFilter TicketIssueLevelFilter = ConvertFilterDTOToFilterEntity(TicketIssueLevel_TicketIssueLevelFilterDTO);
TicketIssueLevelFilter = TicketIssueLevelService.ToFilter(TicketIssueLevelFilter);
int count = await TicketIssueLevelService.Count(TicketIssueLevelFilter);
return(count);
}
private TicketIssueLevelFilter ConvertFilterDTOToFilterEntity(TicketIssueLevel_TicketIssueLevelFilterDTO TicketIssueLevel_TicketIssueLevelFilterDTO)
{
TicketIssueLevelFilter TicketIssueLevelFilter = new TicketIssueLevelFilter();
TicketIssueLevelFilter.Selects = TicketIssueLevelSelect.ALL;
TicketIssueLevelFilter.Skip = TicketIssueLevel_TicketIssueLevelFilterDTO.Skip;
TicketIssueLevelFilter.Take = TicketIssueLevel_TicketIssueLevelFilterDTO.Take;
TicketIssueLevelFilter.OrderBy = TicketIssueLevel_TicketIssueLevelFilterDTO.OrderBy;
TicketIssueLevelFilter.OrderType = TicketIssueLevel_TicketIssueLevelFilterDTO.OrderType;
TicketIssueLevelFilter.Id = TicketIssueLevel_TicketIssueLevelFilterDTO.Id;
TicketIssueLevelFilter.Name = TicketIssueLevel_TicketIssueLevelFilterDTO.Name;
TicketIssueLevelFilter.OrderNumber = TicketIssueLevel_TicketIssueLevelFilterDTO.OrderNumber;
TicketIssueLevelFilter.TicketGroupId = TicketIssueLevel_TicketIssueLevelFilterDTO.TicketGroupId;
TicketIssueLevelFilter.TicketTypeId = TicketIssueLevel_TicketIssueLevelFilterDTO.TicketTypeId;
TicketIssueLevelFilter.StatusId = TicketIssueLevel_TicketIssueLevelFilterDTO.StatusId;
TicketIssueLevelFilter.SLA = TicketIssueLevel_TicketIssueLevelFilterDTO.SLA;
TicketIssueLevelFilter.CreatedAt = TicketIssueLevel_TicketIssueLevelFilterDTO.CreatedAt;
TicketIssueLevelFilter.UpdatedAt = TicketIssueLevel_TicketIssueLevelFilterDTO.UpdatedAt;
return(TicketIssueLevelFilter);
}
public async Task <ActionResult <List <TicketIssueLevel_TicketIssueLevelDTO> > > List([FromBody] TicketIssueLevel_TicketIssueLevelFilterDTO TicketIssueLevel_TicketIssueLevelFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
TicketIssueLevelFilter TicketIssueLevelFilter = ConvertFilterDTOToFilterEntity(TicketIssueLevel_TicketIssueLevelFilterDTO);
TicketIssueLevelFilter = TicketIssueLevelService.ToFilter(TicketIssueLevelFilter);
List <TicketIssueLevel> TicketIssueLevels = await TicketIssueLevelService.List(TicketIssueLevelFilter);
List <TicketIssueLevel_TicketIssueLevelDTO> TicketIssueLevel_TicketIssueLevelDTOs = TicketIssueLevels
.Select(c => new TicketIssueLevel_TicketIssueLevelDTO(c)).ToList();
return(TicketIssueLevel_TicketIssueLevelDTOs);
}
public async Task <FileResult> ExportTemplate([FromBody] TicketIssueLevel_TicketIssueLevelFilterDTO TicketIssueLevel_TicketIssueLevelFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
MemoryStream memoryStream = new MemoryStream();
using (ExcelPackage excel = new ExcelPackage(memoryStream))
{
#region TicketIssueLevel
var TicketIssueLevelHeaders = new List <string[]>()
{
new string[] {
"Id",
"Name",
"OrderNumber",
"TicketGroupId",
"StatusId",
"SLA",
"Used",
}
};
List <object[]> TicketIssueLevelData = new List <object[]>();
excel.GenerateWorksheet("TicketIssueLevel", TicketIssueLevelHeaders, TicketIssueLevelData);
#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 TicketGroup
var TicketGroupFilter = new TicketGroupFilter();
TicketGroupFilter.Selects = TicketGroupSelect.ALL;
TicketGroupFilter.OrderBy = TicketGroupOrder.Id;
TicketGroupFilter.OrderType = OrderType.ASC;
TicketGroupFilter.Skip = 0;
TicketGroupFilter.Take = int.MaxValue;
List <TicketGroup> TicketGroups = await TicketGroupService.List(TicketGroupFilter);
var TicketGroupHeaders = new List <string[]>()
{
new string[] {
"Id",
"Name",
"OrderNumber",
"StatusId",
"TicketTypeId",
"Used",
}
};
List <object[]> TicketGroupData = new List <object[]>();
for (int i = 0; i < TicketGroups.Count; i++)
{
var TicketGroup = TicketGroups[i];
TicketGroupData.Add(new Object[]
{
TicketGroup.Id,
TicketGroup.Name,
TicketGroup.OrderNumber,
TicketGroup.StatusId,
TicketGroup.TicketTypeId,
TicketGroup.Used,
});
}
excel.GenerateWorksheet("TicketGroup", TicketGroupHeaders, TicketGroupData);
#endregion
excel.Save();
}
return(File(memoryStream.ToArray(), "application/octet-stream", "TicketIssueLevel.xlsx"));
}
