private CheckingStatusFilter ConvertFilterDTOToFilterEntity(CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO)
{
CheckingStatusFilter CheckingStatusFilter = new CheckingStatusFilter();
CheckingStatusFilter.Selects = CheckingStatusSelect.ALL;
CheckingStatusFilter.Skip = CheckingStatus_CheckingStatusFilterDTO.Skip;
CheckingStatusFilter.Take = CheckingStatus_CheckingStatusFilterDTO.Take;
CheckingStatusFilter.OrderBy = CheckingStatus_CheckingStatusFilterDTO.OrderBy;
CheckingStatusFilter.OrderType = CheckingStatus_CheckingStatusFilterDTO.OrderType;
CheckingStatusFilter.Id = CheckingStatus_CheckingStatusFilterDTO.Id;
CheckingStatusFilter.Code = CheckingStatus_CheckingStatusFilterDTO.Code;
CheckingStatusFilter.Name = CheckingStatus_CheckingStatusFilterDTO.Name;
return(CheckingStatusFilter);
}
public async Task <ActionResult <int> > Count([FromBody] CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
CheckingStatusFilter CheckingStatusFilter = ConvertFilterDTOToFilterEntity(CheckingStatus_CheckingStatusFilterDTO);
CheckingStatusFilter = await CheckingStatusService.ToFilter(CheckingStatusFilter);
int count = await CheckingStatusService.Count(CheckingStatusFilter);
return(count);
}
public async Task <ActionResult> Export([FromBody] CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
MemoryStream memoryStream = new MemoryStream();
using (ExcelPackage excel = new ExcelPackage(memoryStream))
{
#region CheckingStatus
var CheckingStatusFilter = ConvertFilterDTOToFilterEntity(CheckingStatus_CheckingStatusFilterDTO);
CheckingStatusFilter.Skip = 0;
CheckingStatusFilter.Take = int.MaxValue;
CheckingStatusFilter = await CheckingStatusService.ToFilter(CheckingStatusFilter);
List <CheckingStatus> CheckingStatuses = await CheckingStatusService.List(CheckingStatusFilter);
var CheckingStatusHeaders = new List <string[]>()
{
new string[] {
"Id",
"Code",
"Name",
}
};
List <object[]> CheckingStatusData = new List <object[]>();
for (int i = 0; i < CheckingStatuses.Count; i++)
{
var CheckingStatus = CheckingStatuses[i];
CheckingStatusData.Add(new Object[]
{
CheckingStatus.Id,
CheckingStatus.Code,
CheckingStatus.Name,
});
}
excel.GenerateWorksheet("CheckingStatus", CheckingStatusHeaders, CheckingStatusData);
#endregion
excel.Save();
}
return(File(memoryStream.ToArray(), "application/octet-stream", "CheckingStatus.xlsx"));
}
public async Task <ActionResult> ExportTemplate([FromBody] CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
string path = "Templates/CheckingStatus_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", "CheckingStatus.xlsx"));
}
public async Task <ActionResult <List <CheckingStatus_CheckingStatusDTO> > > List([FromBody] CheckingStatus_CheckingStatusFilterDTO CheckingStatus_CheckingStatusFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
CheckingStatusFilter CheckingStatusFilter = ConvertFilterDTOToFilterEntity(CheckingStatus_CheckingStatusFilterDTO);
CheckingStatusFilter = await CheckingStatusService.ToFilter(CheckingStatusFilter);
List <CheckingStatus> CheckingStatuses = await CheckingStatusService.List(CheckingStatusFilter);
List <CheckingStatus_CheckingStatusDTO> CheckingStatus_CheckingStatusDTOs = CheckingStatuses
.Select(c => new CheckingStatus_CheckingStatusDTO(c)).ToList();
return(CheckingStatus_CheckingStatusDTOs);
}
