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