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