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