public async Task <ActionResult <int> > Count([FromBody] MailTemplate_MailTemplateFilterDTO MailTemplate_MailTemplateFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
MailTemplateFilter MailTemplateFilter = ConvertFilterDTOToFilterEntity(MailTemplate_MailTemplateFilterDTO);
MailTemplateFilter = MailTemplateService.ToFilter(MailTemplateFilter);
int count = await MailTemplateService.Count(MailTemplateFilter);
return(count);
}
private MailTemplateFilter ConvertFilterDTOToFilterEntity(MailTemplate_MailTemplateFilterDTO MailTemplate_MailTemplateFilterDTO)
{
MailTemplateFilter MailTemplateFilter = new MailTemplateFilter();
MailTemplateFilter.Selects = MailTemplateSelect.ALL;
MailTemplateFilter.Skip = MailTemplate_MailTemplateFilterDTO.Skip;
MailTemplateFilter.Take = MailTemplate_MailTemplateFilterDTO.Take;
MailTemplateFilter.OrderBy = MailTemplate_MailTemplateFilterDTO.OrderBy;
MailTemplateFilter.OrderType = MailTemplate_MailTemplateFilterDTO.OrderType;
MailTemplateFilter.Id = MailTemplate_MailTemplateFilterDTO.Id;
MailTemplateFilter.Code = MailTemplate_MailTemplateFilterDTO.Code;
MailTemplateFilter.Name = MailTemplate_MailTemplateFilterDTO.Name;
MailTemplateFilter.Content = MailTemplate_MailTemplateFilterDTO.Content;
MailTemplateFilter.StatusId = MailTemplate_MailTemplateFilterDTO.StatusId;
MailTemplateFilter.CreatedAt = MailTemplate_MailTemplateFilterDTO.CreatedAt;
MailTemplateFilter.UpdatedAt = MailTemplate_MailTemplateFilterDTO.UpdatedAt;
return(MailTemplateFilter);
}
public async Task <ActionResult <List <MailTemplate_MailTemplateDTO> > > List([FromBody] MailTemplate_MailTemplateFilterDTO MailTemplate_MailTemplateFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
MailTemplateFilter MailTemplateFilter = ConvertFilterDTOToFilterEntity(MailTemplate_MailTemplateFilterDTO);
MailTemplateFilter = MailTemplateService.ToFilter(MailTemplateFilter);
List <MailTemplate> MailTemplates = await MailTemplateService.List(MailTemplateFilter);
List <MailTemplate_MailTemplateDTO> MailTemplate_MailTemplateDTOs = MailTemplates
.Select(c => new MailTemplate_MailTemplateDTO(c)).ToList();
return(MailTemplate_MailTemplateDTOs);
}
public async Task <ActionResult> ExportTemplate([FromBody] MailTemplate_MailTemplateFilterDTO MailTemplate_MailTemplateFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
MemoryStream memoryStream = new MemoryStream();
using (ExcelPackage excel = new ExcelPackage(memoryStream))
{
#region MailTemplate
var MailTemplateHeaders = new List <string[]>()
{
new string[] {
"Id",
"Code",
"Name",
"Content",
"StatusId",
}
};
List <object[]> MailTemplateData = new List <object[]>();
excel.GenerateWorksheet("MailTemplate", MailTemplateHeaders, MailTemplateData);
#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", "MailTemplate.xlsx"));
}
