public async Task <List <PlaceGroup_PlaceGroupDTO> > FilterListPlaceGroup([FromBody] PlaceGroup_PlaceGroupFilterDTO PlaceGroup_PlaceGroupFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } PlaceGroupFilter PlaceGroupFilter = new PlaceGroupFilter(); PlaceGroupFilter.Skip = 0; PlaceGroupFilter.Take = int.MaxValue; PlaceGroupFilter.OrderBy = PlaceGroupOrder.Id; PlaceGroupFilter.OrderType = OrderType.ASC; PlaceGroupFilter.Selects = PlaceGroupSelect.ALL; PlaceGroupFilter.Id = PlaceGroup_PlaceGroupFilterDTO.Id; PlaceGroupFilter.ParentId = PlaceGroup_PlaceGroupFilterDTO.ParentId; PlaceGroupFilter.Name = PlaceGroup_PlaceGroupFilterDTO.Name; PlaceGroupFilter.Code = PlaceGroup_PlaceGroupFilterDTO.Code; List <PlaceGroup> PlaceGroups = await PlaceGroupService.List(PlaceGroupFilter); List <PlaceGroup_PlaceGroupDTO> PlaceGroup_PlaceGroupDTOs = PlaceGroups .Select(x => new PlaceGroup_PlaceGroupDTO(x)).ToList(); return(PlaceGroup_PlaceGroupDTOs); }
public async Task <ActionResult <int> > Count([FromBody] PlaceGroup_PlaceGroupFilterDTO PlaceGroup_PlaceGroupFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } PlaceGroupFilter PlaceGroupFilter = ConvertFilterDTOToFilterEntity(PlaceGroup_PlaceGroupFilterDTO); PlaceGroupFilter = await PlaceGroupService.ToFilter(PlaceGroupFilter); int count = await PlaceGroupService.Count(PlaceGroupFilter); return(count); }
public async Task <ActionResult> Export([FromBody] PlaceGroup_PlaceGroupFilterDTO PlaceGroup_PlaceGroupFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } MemoryStream memoryStream = new MemoryStream(); using (ExcelPackage excel = new ExcelPackage(memoryStream)) { #region PlaceGroup var PlaceGroupFilter = ConvertFilterDTOToFilterEntity(PlaceGroup_PlaceGroupFilterDTO); PlaceGroupFilter.Skip = 0; PlaceGroupFilter.Take = int.MaxValue; PlaceGroupFilter = await PlaceGroupService.ToFilter(PlaceGroupFilter); List <PlaceGroup> PlaceGroups = await PlaceGroupService.List(PlaceGroupFilter); var PlaceGroupHeaders = new List <string[]>() { new string[] { "Id", "ParentId", "Name", "Code", } }; List <object[]> PlaceGroupData = new List <object[]>(); for (int i = 0; i < PlaceGroups.Count; i++) { var PlaceGroup = PlaceGroups[i]; PlaceGroupData.Add(new Object[] { PlaceGroup.Id, PlaceGroup.ParentId, PlaceGroup.Name, PlaceGroup.Code, }); } excel.GenerateWorksheet("PlaceGroup", PlaceGroupHeaders, PlaceGroupData); #endregion excel.Save(); } return(File(memoryStream.ToArray(), "application/octet-stream", "PlaceGroup.xlsx")); }
public async Task <ActionResult <List <PlaceGroup_PlaceGroupDTO> > > List([FromBody] PlaceGroup_PlaceGroupFilterDTO PlaceGroup_PlaceGroupFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } PlaceGroupFilter PlaceGroupFilter = ConvertFilterDTOToFilterEntity(PlaceGroup_PlaceGroupFilterDTO); PlaceGroupFilter = await PlaceGroupService.ToFilter(PlaceGroupFilter); List <PlaceGroup> PlaceGroups = await PlaceGroupService.List(PlaceGroupFilter); List <PlaceGroup_PlaceGroupDTO> PlaceGroup_PlaceGroupDTOs = PlaceGroups .Select(c => new PlaceGroup_PlaceGroupDTO(c)).ToList(); return(PlaceGroup_PlaceGroupDTOs); }
private PlaceGroupFilter ConvertFilterDTOToFilterEntity(PlaceGroup_PlaceGroupFilterDTO PlaceGroup_PlaceGroupFilterDTO) { PlaceGroupFilter PlaceGroupFilter = new PlaceGroupFilter(); PlaceGroupFilter.Selects = PlaceGroupSelect.ALL; PlaceGroupFilter.Skip = 0; PlaceGroupFilter.Take = 99999; PlaceGroupFilter.OrderBy = PlaceGroup_PlaceGroupFilterDTO.OrderBy; PlaceGroupFilter.OrderType = PlaceGroup_PlaceGroupFilterDTO.OrderType; PlaceGroupFilter.Id = PlaceGroup_PlaceGroupFilterDTO.Id; PlaceGroupFilter.ParentId = PlaceGroup_PlaceGroupFilterDTO.ParentId; PlaceGroupFilter.Name = PlaceGroup_PlaceGroupFilterDTO.Name; PlaceGroupFilter.Code = PlaceGroup_PlaceGroupFilterDTO.Code; PlaceGroupFilter.CreatedAt = PlaceGroup_PlaceGroupFilterDTO.CreatedAt; PlaceGroupFilter.UpdatedAt = PlaceGroup_PlaceGroupFilterDTO.UpdatedAt; return(PlaceGroupFilter); }
public async Task <ActionResult> ExportTemplate([FromBody] PlaceGroup_PlaceGroupFilterDTO PlaceGroup_PlaceGroupFilterDTO) { if (!ModelState.IsValid) { throw new BindException(ModelState); } string path = "Templates/PlaceGroup_Template.xlsx"; byte[] arr = System.IO.File.ReadAllBytes(path); MemoryStream input = new MemoryStream(arr); MemoryStream output = new MemoryStream(); dynamic Data = new ExpandoObject(); using (var document = StaticParams.DocumentFactory.Open(input, output, "xlsx")) { document.Process(Data); }; return(File(output.ToArray(), "application/octet-stream", "PlaceGroup.xlsx")); }