private PhoneTypeFilter ConvertFilterDTOToFilterEntity(PhoneType_PhoneTypeFilterDTO PhoneType_PhoneTypeFilterDTO)
{
PhoneTypeFilter PhoneTypeFilter = new PhoneTypeFilter();
PhoneTypeFilter.Selects = PhoneTypeSelect.ALL;
PhoneTypeFilter.Skip = PhoneType_PhoneTypeFilterDTO.Skip;
PhoneTypeFilter.Take = PhoneType_PhoneTypeFilterDTO.Take;
PhoneTypeFilter.OrderBy = PhoneType_PhoneTypeFilterDTO.OrderBy;
PhoneTypeFilter.OrderType = PhoneType_PhoneTypeFilterDTO.OrderType;
PhoneTypeFilter.Id = PhoneType_PhoneTypeFilterDTO.Id;
PhoneTypeFilter.Code = PhoneType_PhoneTypeFilterDTO.Code;
PhoneTypeFilter.Name = PhoneType_PhoneTypeFilterDTO.Name;
PhoneTypeFilter.StatusId = PhoneType_PhoneTypeFilterDTO.StatusId;
PhoneTypeFilter.RowId = PhoneType_PhoneTypeFilterDTO.RowId;
PhoneTypeFilter.CreatedAt = PhoneType_PhoneTypeFilterDTO.CreatedAt;
PhoneTypeFilter.UpdatedAt = PhoneType_PhoneTypeFilterDTO.UpdatedAt;
return(PhoneTypeFilter);
}
public async Task <ActionResult <int> > Count([FromBody] PhoneType_PhoneTypeFilterDTO PhoneType_PhoneTypeFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
PhoneTypeFilter PhoneTypeFilter = ConvertFilterDTOToFilterEntity(PhoneType_PhoneTypeFilterDTO);
PhoneTypeFilter = await PhoneTypeService.ToFilter(PhoneTypeFilter);
int count = await PhoneTypeService.Count(PhoneTypeFilter);
return(count);
}
public async Task <ActionResult <List <PhoneType_PhoneTypeDTO> > > List([FromBody] PhoneType_PhoneTypeFilterDTO PhoneType_PhoneTypeFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
PhoneTypeFilter PhoneTypeFilter = ConvertFilterDTOToFilterEntity(PhoneType_PhoneTypeFilterDTO);
PhoneTypeFilter = await PhoneTypeService.ToFilter(PhoneTypeFilter);
List <PhoneType> PhoneTypes = await PhoneTypeService.List(PhoneTypeFilter);
List <PhoneType_PhoneTypeDTO> PhoneType_PhoneTypeDTOs = PhoneTypes
.Select(c => new PhoneType_PhoneTypeDTO(c)).ToList();
return(PhoneType_PhoneTypeDTOs);
}
public async Task <ActionResult> ExportTemplate([FromBody] PhoneType_PhoneTypeFilterDTO PhoneType_PhoneTypeFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
string path = "Templates/PhoneType_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", "PhoneType.xlsx"));
}
public async Task <ActionResult> Export([FromBody] PhoneType_PhoneTypeFilterDTO PhoneType_PhoneTypeFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
MemoryStream memoryStream = new MemoryStream();
using (ExcelPackage excel = new ExcelPackage(memoryStream))
{
#region PhoneType
var PhoneTypeFilter = ConvertFilterDTOToFilterEntity(PhoneType_PhoneTypeFilterDTO);
PhoneTypeFilter.Skip = 0;
PhoneTypeFilter.Take = int.MaxValue;
PhoneTypeFilter = await PhoneTypeService.ToFilter(PhoneTypeFilter);
List <PhoneType> PhoneTypes = await PhoneTypeService.List(PhoneTypeFilter);
var PhoneTypeHeaders = new List <string[]>()
{
new string[] {
"Id",
"Code",
"Name",
"StatusId",
"Used",
"RowId",
}
};
List <object[]> PhoneTypeData = new List <object[]>();
for (int i = 0; i < PhoneTypes.Count; i++)
{
var PhoneType = PhoneTypes[i];
PhoneTypeData.Add(new Object[]
{
PhoneType.Id,
PhoneType.Code,
PhoneType.Name,
PhoneType.StatusId,
PhoneType.Used,
PhoneType.RowId,
});
}
excel.GenerateWorksheet("PhoneType", PhoneTypeHeaders, PhoneTypeData);
#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", "PhoneType.xlsx"));
}
